1. Jack Vox
  2. Report Editor
  3. Суббота, Июнь 20 2015, 09:29 PM
  4.  Подписаться через 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
Комментарий
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