diff options
Diffstat (limited to 'mysql-test/suite/innodb/r/innodb-index-online-fk.result')
| -rw-r--r-- | mysql-test/suite/innodb/r/innodb-index-online-fk.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/innodb-index-online-fk.result b/mysql-test/suite/innodb/r/innodb-index-online-fk.result index 4bd4b060ab3..854afd95aaf 100644 --- a/mysql-test/suite/innodb/r/innodb-index-online-fk.result +++ b/mysql-test/suite/innodb/r/innodb-index-online-fk.result @@ -127,6 +127,7 @@ SYS_TABLESPACES SYS_VIRTUAL mysql/innodb_index_stats mysql/innodb_table_stats +mysql/transaction_registry test/child test/parent INSERT INTO child VALUES(5,4); @@ -318,12 +319,15 @@ SYS_TABLESPACES SYS_VIRTUAL mysql/innodb_index_stats mysql/innodb_table_stats +mysql/transaction_registry test/child test/parent ALTER TABLE child ADD PRIMARY KEY idx (a3), CHANGE a1 a3 INT, ADD CONSTRAINT fk_1 FOREIGN KEY (a2) REFERENCES parent(b) ON DELETE SET NULL ON UPDATE CASCADE, ALGORITHM = INPLACE; +Warnings: +Warning 1280 Name 'idx' ignored for PRIMARY key. SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN; ID FOR_NAME REF_NAME N_COLS TYPE test/fk_1 test/child test/parent 1 6 @@ -343,6 +347,7 @@ SYS_TABLESPACES SYS_VIRTUAL mysql/innodb_index_stats mysql/innodb_table_stats +mysql/transaction_registry test/child test/parent SHOW CREATE TABLE child; @@ -360,6 +365,8 @@ ALTER TABLE child ADD PRIMARY KEY idx (a1), ADD CONSTRAINT fk_1 FOREIGN KEY (a2) REFERENCES parent(b) ON DELETE SET NULL ON UPDATE CASCADE, ALGORITHM = INPLACE; +Warnings: +Warning 1280 Name 'idx' ignored for PRIMARY key. SELECT * from information_schema.INNODB_SYS_FOREIGN; ID FOR_NAME REF_NAME N_COLS TYPE test/fk_1 test/child test/parent 1 6 @@ -379,6 +386,7 @@ SYS_TABLESPACES SYS_VIRTUAL mysql/innodb_index_stats mysql/innodb_table_stats +mysql/transaction_registry test/child test/parent SHOW CREATE TABLE child; @@ -415,6 +423,7 @@ SYS_TABLESPACES SYS_VIRTUAL mysql/innodb_index_stats mysql/innodb_table_stats +mysql/transaction_registry test/child test/parent SHOW CREATE TABLE child; @@ -551,6 +560,8 @@ ADD CONSTRAINT fk_new_1 FOREIGN KEY (a1) REFERENCES parent(b), ADD CONSTRAINT fk_new_2 FOREIGN KEY (a2) REFERENCES parent(a), ADD CONSTRAINT fk_new_3 FOREIGN KEY (a3) REFERENCES parent(a), ALGORITHM = INPLACE; +Warnings: +Warning 1280 Name 'idx' ignored for PRIMARY key. SHOW CREATE TABLE child; Table Create Table child CREATE TABLE `child` ( |