Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.3(EOL), 10.4(EOL)
-
None
Description
--source include/master-slave.inc
|
--source include/have_binlog_format_row.inc
|
|
SET SQL_MODE= 'EMPTY_STRING_IS_NULL'; |
|
CREATE TABLE t1 AS SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE 1 = 0; |
|
--sync_slave_with_master
|
|
SHOW CREATE TABLE t1; |
|
# Cleanup
|
--connection master
|
DROP TABLE t1; |
--source include/rpl_end.inc |
10.3 f010c908 |
Last_Errno 1067
|
Last_Error Error 'Invalid default value for 'TABLE_NAME'' on query. Default database: 'test'. Query: 'CREATE TABLE `t1` (
|
`TABLE_NAME` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT ''
|
)'
|
Technically the error isn't wrong, so I have no idea what should be done about it; but I guess it shouldn't just be allowed to fail.
Attachments
Issue Links
- is duplicated by
-
MDEV-20254 Problems with EMPTY_STRING_IS_NULL and I_S tables
- Closed
- relates to
-
MDEV-20254 Problems with EMPTY_STRING_IS_NULL and I_S tables
- Closed
-
MDEV-20253 DEFAULT is erroneously copied in `CREATE..SELECT column`
- Confirmed