| Showing 1-30 of 40 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 23233 | 2006-10-12 22:28 | 2007-04-04 4:03 | MySQL Server | Closed (6231 days) | S3 | 5.1.11-beta and 5.0.26/5.0BK/5.1BK | Windows (WINDOWS) | Any | NO_AUTO_VALUE_ON_ZERO and INSERT...ON DUPLICATE cause insertion failure |
| 24633 | 2006-11-27 21:54 | 2007-04-11 3:21 | MySQL Server: Partitions | Closed (6224 days) | S2 | 5.1.14 | Linux (Linux) | Any | SQL MODE "NO_DIR_IN_CREATE" does not work with partitioned tables |
| 27886 | 2007-04-17 15:26 | 2021-05-02 20:45 | MySQL Cluster: Disk Data | Verified (5986 days) | S2 | mysql-5.1 | Any | Any | ALTER TABLESPACE ADD DATAFILE does not honor NO_ENGINE_SUBSTITUTION |
| 27156 | 2007-03-14 23:33 | 2018-09-09 20:45 | MySQL Server: Data Types | Verified (4919 days) | S3 | 5.0, 5.1, 5.6.99 | Linux (Linux) | Any | Not even if strict mode will halt on warnings |
| 29373 | 2007-06-26 20:11 | 2007-06-26 20:22 | MySQL Server: Errors | Can't repeat (6148 days) | S3 | 5.1.16/6.0 | Any | Any | ERROR 1289 (HY000): The 'UNKNOWN' feature is disabled; |
| 29188 | 2007-06-18 23:23 | 2007-06-19 1:39 | MySQL Server: Command-line Clients | Not a Bug (6155 days) | S3 | MySQL version 5.0.41 | Windows (2000 SP4) | Any | sql_mode=STRICT_ALL_TABLES, "invalid data" still got imported using mysqlimport |
| 32757 | 2007-11-27 8:51 | 2008-03-31 19:47 | MySQL Server: General | Closed (5869 days) | S3 | 5.1.23-debug | Any | Any | hang with sql_mode set when setting some global variables |
| 37114 | 2008-05-31 1:59 | 2020-04-24 14:53 | MySQL Server: General | Closed (5671 days) | S3 | 5.0, 5.1, 6.0 | Any | Any | sql_mode NO_BACKSLASH_ESCAPES does not work properly with LOAD DATA INFILE |
| 39837 | 2008-10-03 12:04 | 2008-10-03 19:56 | MySQL Server: Data Types | Not a Bug (5683 days) | S3 | 5.1.28-rc-community | Any | Any | SQL_MODE=TRADITIONAL and LOAD DATA LOCAL INFILE does not error |
| 43938 | 2009-03-29 9:11 | 2022-12-04 20:45 | MySQL Server: Security: Privileges | Verified (5506 days) | S3 | 5.1.32 | Any | Any | Weird error when NO_AUTO_CREATE_USER sql mode is active, creating user w/o pass |
| 42034 | 2009-01-11 22:02 | 2011-02-16 23:43 | MySQL Server: General | Verified (5581 days) | S2 | 5.1,5.0,4.1 | Any | Any | SET sql_mode should be a privileged action |
| 47799 | 2009-10-02 16:54 | 2009-10-07 14:06 | MySQL Server: Stored Routines | Not a Bug (5314 days) | S3 | 5.1.34 | Linux (RH4U6) | Any | Could not modify sql_mode within stored procedure |
| 54208 | 2010-06-03 16:14 | 2010-06-07 6:58 | MySQL Server | Not a Bug (5071 days) | S3 | 5.1.39 | MacOS | Any | NO_AUTO_CREATE_USER bypassed with CREATE USER |
| 54783 | 2010-06-24 15:33 | 2011-02-16 23:44 | MySQL Server: DDL | Closed (5018 days) | S1 | 5.5.5 | Any | Any | optimize table crashes with invalid timestamp default value and NO_ZERO_DATE |
| 68489 | 2013-02-25 20:14 | 2013-05-26 17:07 | MySQL Workbench: Modeling | Duplicate (3987 days) | S3 | 5.2.44 revision 9933, 5.2.47 revision 10398 | Windows (Windows 7 x64) | Any | Error synchronizing model with table having rows with date set to 0000-00-00 00: |
| 70062 | 2013-08-16 18:38 | 2013-08-19 14:47 | MySQL Server: Options | Closed (3902 days) | S3 | 5.6.11-log | Linux (CentOS 5.7) | Any | sql_mode option file cannot set to null |
| 69310 | 2013-05-23 11:47 | 2018-03-14 20:45 | MySQL Server: DML | Verified (3990 days) | S3 | 5.6, 5.0.97, 5.1.70, 5.5.32, 5.6.12, 5.7.2 | Any | Any | Valid SQL statement rejected in ONLY_FULL_GROUP_BY |
| 72583 | 2014-05-08 18:32 | 2014-05-08 19:03 | MySQL Server: Options | Verified (3640 days) | S3 | 5.6.17 | Any | Any | SQL Mode shows deprecated settings even when not used |
| 71386 | 2014-01-15 6:52 | 2020-03-09 12:03 | MySQL Server: Data Types | Closed (1729 days) | S3 | 5.6.13, 5.6.17, 5.5.36, 5.7.4 | Any (Mac OS X, Linux) | Any | STR_TO_DATE in TRADITIONAL sql_mode fails to parse time-only field |
| 42910 | 2009-02-17 6:31 | 2014-09-25 15:33 | MySQL Server: Stored Routines | Closed (3500 days) | S3 | 5.0.67 & 5.1.30, 5.0, 5.1, 6.0 bzr | Any | Any | Triggers override strict sql_mode |
| 74947 | 2014-11-21 4:51 | 2016-10-13 16:30 | MySQL Server: Information schema | Closed (2751 days) | S3 | 5.6.21, 5.6.23, 5.7.6 | Linux (CentOS 6.5) | Any | Error while loading events from mysql.event. |
| 76270 | 2015-03-11 22:56 | 2016-06-18 21:24 | MySQL Server: Options | Verified (3332 days) | S3 | 5.7.6, 8.0.0 | Any | Any | Consider improving startup mysql startup NO_AUTO_CREATE_USER warning message |
| 77436 | 2015-06-22 14:55 | 2015-06-23 10:44 | MySQL Server: Options | Verified (3229 days) | S2 | 5.6.23, 5.6.26 | Linux | Any | procs_priv table not restored with sql_mode traditional and only_full_group_by |
| 78053 | 2015-08-13 8:10 | 2015-08-13 9:24 | MySQL Enterprise Monitor: Agent | Verified (3178 days) | S3 | 3.0.23 | Linux (OEL 6.7) | Any | MySQL Enterprise Monitor agent report different sql_mode than expected |
| 75551 | 2015-01-19 10:12 | 2015-02-13 6:13 | MySQL Server: Options | Closed (3377 days) | S3 | 5.6.15 | Any | Any | sql_mode not respected properly in 5.6.15 |
| 69142 | 2013-05-03 23:38 | 2015-02-24 14:21 | MySQL Server: Documentation | Closed (3348 days) | S3 | 5.6,5.7 | Any | Any | FAQ about SQL Mode is outdated |
| 80075 | 2016-01-20 13:26 | 2016-01-21 5:52 | MySQL Server: Charsets | Verified (3017 days) | S3 | 5.5.47, 5.6.28, 5.7.10 | Any | Any | "SET sql_mode=..." generates an error when @@character_set_connection=ucs2 |
| 81171 | 2016-04-21 14:15 | 2017-10-29 23:35 | MySQL Server: Documentation | Closed (2370 days) | S3 | 5.7 | Any | Any | Improve documentation related to sql_mode NO_AUTO_CREATE_USER |
| 81774 | 2016-06-08 9:21 | 2016-06-08 9:55 | MySQL Server | Not a Bug (2878 days) | S3 | all versions | Linux | Any | sql like 'update table set col1=3 and col2='aa' where id=1' should throw an err |
| 80455 | 2016-02-20 23:21 | 2016-02-21 22:05 | MySQL Server: Optimizer | Verified (2986 days) | S3 | 5.5, 5.6 | Linux | Any | Non-grouping field error with tables that have the same column names |
| Showing 1-30 of 40 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
