mirror of
https://github.com/MariaDB/server.git
synced 2025-11-04 04:46:15 +01:00
33 lines
923 B
Text
33 lines
923 B
Text
--source include/have_debug.inc
|
|
|
|
--echo #
|
|
--echo # Start of 10.5 tests
|
|
--echo #
|
|
|
|
--echo #
|
|
--echo # MDEV-19612 Split ALTER related data type specific code in sql_table.cc to Type_handler
|
|
--echo #
|
|
|
|
SET sql_mode='STRICT_ALL_TABLES,STRICT_TRANS_TABLES,NO_ZERO_DATE';
|
|
CREATE TABLE t1 (a INT);
|
|
ALTER TABLE t1 ALGORITHM=COPY, ADD b INT NOT NULL;
|
|
DROP TABLE t1;
|
|
|
|
SET sql_mode='STRICT_ALL_TABLES,STRICT_TRANS_TABLES,NO_ZERO_DATE';
|
|
CREATE TABLE t1 (a INT);
|
|
INSERT INTO t1 VALUES (0);
|
|
ALTER TABLE t1 ALGORITHM=COPY, ADD b INT NOT NULL;
|
|
DROP TABLE t1;
|
|
|
|
SET sql_mode='STRICT_ALL_TABLES,STRICT_TRANS_TABLES,NO_ZERO_DATE';
|
|
CREATE TABLE t1 (a INT);
|
|
INSERT INTO t1 VALUES (0);
|
|
SET debug_dbug='+d,validate_implicit_default_value_error';
|
|
--error ER_TRUNCATED_WRONG_VALUE
|
|
ALTER TABLE t1 ALGORITHM=COPY, ADD b INT NOT NULL;
|
|
SET debug_dbug='-d,validate_implicit_default_value_error';
|
|
DROP TABLE t1;
|
|
|
|
--echo #
|
|
--echo # End of 10.5 tests
|
|
--echo #
|