1. Jack Vox
  2. Report Editor
  3. 土, 6月 20 2015, 09:29 PM
  4.  メールで購読
I'm using the free version of Vstudio. I think there is a bug in the studio with mysql 5.7 version. With older versions things are OK. Also have to mention, if I connect with every other IDE, i don't receive this error which is..

Error( 1055 ) 42000: "Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'information_schema.STATISTICS.COLUMN_NAME' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by"

This error appears when I roll the mouse cursor over some table name. And this error also appears on every database I tested. event the system mysql database
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
In both hotfix and next 6.0 beta.
コメント
There are no comments made yet.
Ruslan Zasukhin 承諾済みの回答
Sergey, in the next build in hotfix? OR in the next 6.0 beta ?
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Default behavior of GROUP BY was changed in MySQL 5.7, so there was need to adjust some queries to be compliant with it. Although it is still possible to return to an old mode, using appropriate value in sql_mode variable.

Fix will be available in the next build.
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Hello, Jack
Thanks for the report, we'll check it with the latest RC available.
コメント
There are no comments made yet.
  • ページ :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories