1. Jack Vox
  2. Report Editor
  3. Saturday, June 20 2015, 09:29 PM
  4.  Subscribe via email
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
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
In both hotfix and next 6.0 beta.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 1
Ruslan Zasukhin Accepted Answer
Sergey, in the next build in hotfix? OR in the next 6.0 beta ?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 2
Sergey Pashkov Accepted Answer
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.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 3
Sergey Pashkov Accepted Answer
Hello, Jack
Thanks for the report, we'll check it with the latest RC available.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 4
  • Page :
  • 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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories