1. Jack Vox
  2. Report Editor
  3. Samstag, Juni 20 2015, 09:29 PM
  4.  Abonnieren via E-Mail
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
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello, Jack
Thanks for the report, we'll check it with the latest RC available.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
Sergey, in the next build in hotfix? OR in the next 6.0 beta ?
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
In both hotfix and next 6.0 beta.
Kommentar
There are no comments made yet.
  • Seite :
  • 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