ID,Entered,Modified,Type,Status,Severity,Version,OS,Summary 27886,2007-04-17 15:26:55,2007-12-05 18:56:08,Server: ClusterDD,Verified,S2,"mysql-5.1","Any","ALTER TABLESPACE ADD DATAFILE does not honor NO_ENGINE_SUBSTITUTION" 27156,2007-03-14 23:33:35,2010-11-06 17:37:35,Server: Types,Verified,S3,"5.0, 5.1, 5.6.99","Linux (Linux)","Not even if strict mode will halt on warnings" 43938,2009-03-29 09:11:48,2009-03-29 09:13:59,Server: Privileges,Verified,S3,"5.1.32","Any","Weird error when NO_AUTO_CREATE_USER sql mode is active, creating user w/o pass" 42034,2009-01-11 22:02:36,2009-01-13 22:08:51,Server: General,Verified,S2,"5.1,5.0,4.1","Any","SET sql_mode should be a privileged action" 69310,2013-05-23 11:47:26,2013-05-23 12:25:31,Server: DML,Verified,S3,"5.6, 5.0.97, 5.1.70, 5.5.32, 5.6.12, 5.7.2","Any","Valid SQL statement rejected in ONLY_FULL_GROUP_BY" 72583,2014-05-08 18:32:38,2014-05-08 19:02:42,Server: Options,Verified,S3,"5.6.17","Any","SQL Mode shows deprecated settings even when not used" 76270,2015-03-11 22:56:08,2015-03-12 06:15:56,Server: Options,Verified,S3,"5.7.6, 8.0.0","Any","Consider improving startup mysql startup NO_AUTO_CREATE_USER warning message" 77436,2015-06-22 14:55:40,2015-06-23 10:42:22,Server: Options,Verified,S2,"5.6.23, 5.6.26","Linux","procs_priv table not restored with sql_mode traditional and only_full_group_by" 78053,2015-08-13 08:10:36,2015-08-13 09:19:50,Monitoring: Agent,Verified,S3,"3.0.23","Linux (OEL 6.7)","MySQL Enterprise Monitor agent report different sql_mode than expected" 80075,2016-01-20 13:26:50,2016-01-21 05:52:27,Server: Charsets,Verified,S3,"5.5.47, 5.6.28, 5.7.10","Any","""SET sql_mode=..."" generates an error when @@character_set_connection=ucs2" 80455,2016-02-20 23:21:16,2016-02-21 21:58:18,Server: Optimizer,Verified,S3,"5.5, 5.6","Linux","Non-grouping field error with tables that have the same column names" 84933,2017-02-10 03:22:13,2017-02-10 09:25:30,Server: DML,Verified,S3,"5.6 5.7, 5.6.35, 5.5.54","Any","same sql mode in 5.6 and 5.7 results in difference results" 85940,2017-04-13 22:16:07,2017-05-07 01:15:14,Server: Options,Verified,S3,"5.6.36","Debian","MySQL 5.6.36 changes default sql_mode" 89002,2017-12-21 09:41:11,2017-12-21 11:18:52,Server: DDL,Verified,S3,"5.7.20","Linux","Index on JSON virtual column with default sql_mode is evaluated badly" 89003,2017-12-21 09:45:08,2017-12-21 11:22:29,Server: DDL,Verified,S3,"5.7.20","Linux","Dropping Index on JSON virtual column with default sql_mode is not working" 92958,2018-10-26 09:21:26,2018-11-16 16:26:07,Server: Options,Verified,S3,"5.7.22","Debian","Event Creation not respecting SQL_MODE settings" 104035,2021-06-16 10:50:27,2021-06-16 20:21:45,Server: DML,Verified,S3," 8.0/5.7","Ubuntu (20)","Strict SQLMode not honored in SP's based on DB charset " 114315,2024-03-12 09:16:30,2024-03-12 09:54:49,Server: I_S,Verified,S2,"8.0.25 8.0.30","Any","Field_name has one more space when using ignore_space"