[Groonga-mysql-commit] mroonga/mroonga at 97819f7 [master] mariadb10.3 test: don't use text without DEFAULT

Back to archive index

Kouhei Sutou null+****@clear*****
Sun Dec 24 22:01:44 JST 2017


Kouhei Sutou	2017-12-24 22:01:44 +0900 (Sun, 24 Dec 2017)

  New Revision: 97819f7fe492a84184d40d01c92627c2f43c0dd0
  https://github.com/mroonga/mroonga/commit/97819f7fe492a84184d40d01c92627c2f43c0dd0

  Message:
    mariadb10.3 test: don't use text without DEFAULT
    
    It causes "SHOW CREATE TABLE" result difference between MySQL and
    MariaDB versions.

  Modified files:
    mysql-test/mroonga/storage/alter_table/change_engine/r/failed.result
    mysql-test/mroonga/storage/alter_table/change_engine/t/failed.test

  Modified: mysql-test/mroonga/storage/alter_table/change_engine/r/failed.result (+2 -2)
===================================================================
--- mysql-test/mroonga/storage/alter_table/change_engine/r/failed.result    2017-12-24 21:55:08 +0900 (6db76bb6)
+++ mysql-test/mroonga/storage/alter_table/change_engine/r/failed.result    2017-12-24 22:01:44 +0900 (6d24db5e)
@@ -1,7 +1,7 @@
 SET NAMES big5;
 DROP TABLE IF EXISTS diaries;
 CREATE TABLE diaries (
-title TEXT
+title varchar(256) DEFAULT ''
 ) ENGINE=InnoDB DEFAULT CHARSET=big5;
 INSERT INTO diaries VALUES ('アzヲn');
 ALTER TABLE diaries ENGINE=Mroonga;
@@ -9,6 +9,6 @@ ERROR HY000: The character set 'big5_chinese_ci[big5]' is not supported by Groon
 SHOW CREATE TABLE diaries;
 Table	Create Table
 diaries	CREATE TABLE `diaries` (
-  `title` text
+  `title` varchar(256) DEFAULT ''
 ) ENGINE=InnoDB DEFAULT CHARSET=big5
 DROP TABLE diaries;

  Modified: mysql-test/mroonga/storage/alter_table/change_engine/t/failed.test (+1 -1)
===================================================================
--- mysql-test/mroonga/storage/alter_table/change_engine/t/failed.test    2017-12-24 21:55:08 +0900 (9e20c1e0)
+++ mysql-test/mroonga/storage/alter_table/change_engine/t/failed.test    2017-12-24 22:01:44 +0900 (c7bf3efc)
@@ -27,7 +27,7 @@ DROP TABLE IF EXISTS diaries;
 --enable_warnings
 
 CREATE TABLE diaries (
-  title TEXT
+  title varchar(256) DEFAULT ''
 ) ENGINE=InnoDB DEFAULT CHARSET=big5;
 
 INSERT INTO diaries VALUES ('アzヲn');
-------------- next part --------------
HTML����������������������������...
URL: https://lists.osdn.me/mailman/archives/groonga-mysql-commit/attachments/20171224/dbc2c2a0/attachment-0001.htm 



More information about the Groonga-mysql-commit mailing list
Back to archive index