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/suite/sql_sequence | |
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/suite/sql_sequence')
-rw-r--r-- | mysql-test/suite/sql_sequence/gtid.result | 2 | ||||
-rw-r--r-- | mysql-test/suite/sql_sequence/gtid.test | 2 | ||||
-rw-r--r-- | mysql-test/suite/sql_sequence/replication.result | 2 | ||||
-rw-r--r-- | mysql-test/suite/sql_sequence/replication.test | 2 |
4 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/suite/sql_sequence/gtid.result b/mysql-test/suite/sql_sequence/gtid.result index 495e4b806b7..34d6ee90598 100644 --- a/mysql-test/suite/sql_sequence/gtid.result +++ b/mysql-test/suite/sql_sequence/gtid.result @@ -68,7 +68,7 @@ connection master; create sequence s2; alter table s2 add id int; ERROR HY000: Sequence 's_db.s2' table structure is invalid (Wrong number of columns) -alter table s2 add index ind_x(start); +alter table s2 add index ind_x(start_value); ERROR HY000: Sequence 's_db.s2' table structure is invalid (Sequence tables cannot have any keys) drop sequence s2; ########################################### diff --git a/mysql-test/suite/sql_sequence/gtid.test b/mysql-test/suite/sql_sequence/gtid.test index 63ed7ec5264..4a096246108 100644 --- a/mysql-test/suite/sql_sequence/gtid.test +++ b/mysql-test/suite/sql_sequence/gtid.test @@ -70,7 +70,7 @@ create sequence s2; alter table s2 add id int; --error ER_SEQUENCE_INVALID_TABLE_STRUCTURE -alter table s2 add index ind_x(start); +alter table s2 add index ind_x(start_value); drop sequence s2; --echo ########################################### diff --git a/mysql-test/suite/sql_sequence/replication.result b/mysql-test/suite/sql_sequence/replication.result index c429b74b4cd..8d8aee5080c 100644 --- a/mysql-test/suite/sql_sequence/replication.result +++ b/mysql-test/suite/sql_sequence/replication.result @@ -64,7 +64,7 @@ connection master; create sequence s2; alter table s2 add id int; ERROR HY000: Sequence 's_db.s2' table structure is invalid (Wrong number of columns) -alter table s2 add index ind_x(start); +alter table s2 add index ind_x(start_value); ERROR HY000: Sequence 's_db.s2' table structure is invalid (Sequence tables cannot have any keys) drop sequence s2; ########################################### diff --git a/mysql-test/suite/sql_sequence/replication.test b/mysql-test/suite/sql_sequence/replication.test index e26fde8a329..0354737788f 100644 --- a/mysql-test/suite/sql_sequence/replication.test +++ b/mysql-test/suite/sql_sequence/replication.test @@ -70,7 +70,7 @@ create sequence s2; alter table s2 add id int; --error ER_SEQUENCE_INVALID_TABLE_STRUCTURE -alter table s2 add index ind_x(start); +alter table s2 add index ind_x(start_value); drop sequence s2; --echo ########################################### |