Kouhei Sutou
null+****@clear*****
Mon Oct 16 15:49:09 JST 2017
Kouhei Sutou 2017-10-16 15:49:09 +0900 (Mon, 16 Oct 2017) New Revision: 61791bad56dc3bae0b734771f1b6088a0634b047 https://github.com/mroonga/mroonga/commit/61791bad56dc3bae0b734771f1b6088a0634b047 Message: test: revert unexpected removing Modified files: mysql-test/mroonga/storage/foreign_key/r/alter_add.result mysql-test/mroonga/storage/foreign_key/r/alter_drop.result mysql-test/mroonga/storage/foreign_key/r/create.result Modified: mysql-test/mroonga/storage/foreign_key/r/alter_add.result (+3 -0) =================================================================== --- mysql-test/mroonga/storage/foreign_key/r/alter_add.result 2017-10-15 23:23:25 +0900 (bfb263f1) +++ mysql-test/mroonga/storage/foreign_key/r/alter_add.result 2017-10-16 15:49:09 +0900 (e2e712af) @@ -17,5 +17,8 @@ articles CREATE TABLE `articles` ( KEY `comment` (`comment`), CONSTRAINT `comment` FOREIGN KEY (`comment`) REFERENCES `test`.`comments` (`comment`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE=Mroonga DEFAULT CHARSET=latin1 +SELECT * FROM information_schema.referential_constraints; +CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME UNIQUE_CONSTRAINT_CATALOG UNIQUE_CONSTRAINT_SCHEMA UNIQUE_CONSTRAINT_NAME MATCH_OPTION UPDATE_RULE DELETE_RULE TABLE_NAME REFERENCED_TABLE_NAME +def test comment def test PRIMARY NONE RESTRICT RESTRICT articles comments DROP TABLE articles; DROP TABLE comments; Modified: mysql-test/mroonga/storage/foreign_key/r/alter_drop.result (+2 -0) =================================================================== --- mysql-test/mroonga/storage/foreign_key/r/alter_drop.result 2017-10-15 23:23:25 +0900 (101a4a3d) +++ mysql-test/mroonga/storage/foreign_key/r/alter_drop.result 2017-10-16 15:49:09 +0900 (fc3cda00) @@ -17,5 +17,7 @@ articles CREATE TABLE `articles` ( `comment` int(10) unsigned DEFAULT NULL, KEY `comment` (`comment`) ) ENGINE=Mroonga DEFAULT CHARSET=latin1 +SELECT * FROM information_schema.referential_constraints; +CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME UNIQUE_CONSTRAINT_CATALOG UNIQUE_CONSTRAINT_SCHEMA UNIQUE_CONSTRAINT_NAME MATCH_OPTION UPDATE_RULE DELETE_RULE TABLE_NAME REFERENCED_TABLE_NAME DROP TABLE articles; DROP TABLE comments; Modified: mysql-test/mroonga/storage/foreign_key/r/create.result (+2 -0) =================================================================== --- mysql-test/mroonga/storage/foreign_key/r/create.result 2017-10-15 23:23:25 +0900 (c17780c0) +++ mysql-test/mroonga/storage/foreign_key/r/create.result 2017-10-16 15:49:09 +0900 (d76fba58) @@ -18,5 +18,7 @@ articles CREATE TABLE `articles` ( CONSTRAINT `comment` FOREIGN KEY (`comment`) REFERENCES `test`.`comments` (`comment`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE=Mroonga DEFAULT CHARSET=latin1 SELECT * FROM information_schema.referential_constraints; +CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME UNIQUE_CONSTRAINT_CATALOG UNIQUE_CONSTRAINT_SCHEMA UNIQUE_CONSTRAINT_NAME MATCH_OPTION UPDATE_RULE DELETE_RULE TABLE_NAME REFERENCED_TABLE_NAME +def test comment def test PRIMARY NONE RESTRICT RESTRICT articles comments DROP TABLE articles; DROP TABLE comments; -------------- next part -------------- HTML����������������������������... URL: https://lists.osdn.me/mailman/archives/groonga-mysql-commit/attachments/20171016/8fb37113/attachment.htm
