Kouhei Sutou
null+****@clear*****
Wed Aug 24 17:24:49 JST 2016
Kouhei Sutou 2016-08-24 17:24:49 +0900 (Wed, 24 Aug 2016) New Revision: 60f089a509c003d599eca9b810e940f50f710aa6 https://github.com/mroonga/mroonga/commit/60f089a509c003d599eca9b810e940f50f710aa6 Message: test: use varchar for SHOW CREATE TABLE portability Modified files: mysql-test/mroonga/storage/alter_table/r/spatial.result mysql-test/mroonga/storage/alter_table/t/spatial.test Modified: mysql-test/mroonga/storage/alter_table/r/spatial.result (+2 -2) =================================================================== --- mysql-test/mroonga/storage/alter_table/r/spatial.result 2016-08-24 16:56:42 +0900 (ed36927) +++ mysql-test/mroonga/storage/alter_table/r/spatial.result 2016-08-24 17:24:49 +0900 (ac1a096) @@ -1,7 +1,7 @@ DROP TABLE IF EXISTS shops; CREATE TABLE shops ( id INT PRIMARY KEY AUTO_INCREMENT, -name TEXT, +name VARCHAR(40), location GEOMETRY NOT NULL ); INSERT INTO shops (name, location) @@ -124,7 +124,7 @@ SHOW CREATE TABLE shops; Table Create Table shops CREATE TABLE `shops` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `name` text, + `name` varchar(40) DEFAULT NULL, `location` geometry NOT NULL, PRIMARY KEY (`id`), SPATIAL KEY `location_index` (`location`) Modified: mysql-test/mroonga/storage/alter_table/t/spatial.test (+1 -1) =================================================================== --- mysql-test/mroonga/storage/alter_table/t/spatial.test 2016-08-24 16:56:42 +0900 (02dc3d5) +++ mysql-test/mroonga/storage/alter_table/t/spatial.test 2016-08-24 17:24:49 +0900 (d41206d) @@ -25,7 +25,7 @@ DROP TABLE IF EXISTS shops; CREATE TABLE shops ( id INT PRIMARY KEY AUTO_INCREMENT, - name TEXT, + name VARCHAR(40), location GEOMETRY NOT NULL ); -------------- next part -------------- HTML����������������������������...Télécharger
