diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2022-07-29 12:39:37 +0200 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2022-08-10 15:02:56 +0200 |
| commit | 4ce1470a700809c7b62ade40ddb95063a0e47402 (patch) | |
| tree | aa384d4b82ecd6407043a73c661a02e1640bc13b /mysql-test/main/alter_table.test | |
| parent | 1c192843f2619f528aaf334d0346cf14976b3845 (diff) | |
| download | mariadb-git-4ce1470a700809c7b62ade40ddb95063a0e47402.tar.gz | |
cleanup: tests
sequence tests verify that one cannot change the structure
of the table. for that they need a valid alter table that
adds an index over an existing column. there's no column 'start'
in the table
Diffstat (limited to 'mysql-test/main/alter_table.test')
| -rw-r--r-- | mysql-test/main/alter_table.test | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/main/alter_table.test b/mysql-test/main/alter_table.test index 05e04f11f9e..eda820abdfb 100644 --- a/mysql-test/main/alter_table.test +++ b/mysql-test/main/alter_table.test @@ -647,11 +647,11 @@ set sql_mode="no_zero_date"; create table t1(f1 int); alter table t1 add column f2 datetime not null, add column f21 date not null; insert into t1 values(1,'2000-01-01','2000-01-01'); ---error 1292 +--error ER_TRUNCATED_WRONG_VALUE alter table t1 add column f3 datetime not null; ---error 1292 +--error ER_TRUNCATED_WRONG_VALUE alter table t1 add column f3 date not null; ---error 1292 +--error ER_TRUNCATED_WRONG_VALUE alter table t1 add column f4 datetime not null default '2002-02-02', add column f41 date not null; alter table t1 add column f4 datetime not null default '2002-02-02', |