Bug #107930 Facing error in the MySQL Workbench
Submitted: 21 Jul 2022 5:58 Modified: 26 Jul 2022 10:38
Reporter: vidyasagar gajula Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.29 OS:MacOS (macOS 12.x Monterey x86_64)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[21 Jul 2022 5:58] vidyasagar gajula 
Description:
----[For better reports, please attach the log file after submitting. You can find it in /Users/gajulavidyasagar/Library/Application Support/MySQL/Workbench/log/wb.log]
11:24:09	select payment_date,count(payment_id),lag(count(payment_id),1)  over (order by date (payment_date)) PreviousCount, count(payment_id)-lag(count(payment_id),1)over (order by date(payment_date))  CountDifference from payment group by date(payment_date) order by date(payment_date)	Error Code: 1055. Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sakila.payment.payment_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by	0.0070 sec

How to repeat:
.
[26 Jul 2022 10:38] MySQL Verification Team 
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php 

If you can provide more information, feel free to add it to this bug.
 
Thank you for your interest in MySQL.