[Groonga-mysql-commit] mroonga/mroonga at 5584266 [master] test: show only a colum info

Back to archive index

Kouhei Sutou null+****@clear*****
Fri Jun 21 15:18:12 JST 2013


Kouhei Sutou	2013-06-21 15:18:12 +0900 (Fri, 21 Jun 2013)

  New Revision: 55842666dead8723b0a73aa7fd9ca7850d060d2e
  https://github.com/mroonga/mroonga/commit/55842666dead8723b0a73aa7fd9ca7850d060d2e

  Message:
    test: show only a colum info
    
    Because we want to check column's comment.

  Modified files:
    test/sql/suite/mroonga/storage/column/groonga/scalar/r/with_not_for_mroonga_comment.result
    test/sql/suite/mroonga/storage/column/groonga/scalar/t/with_not_for_mroonga_comment.test

  Modified: test/sql/suite/mroonga/storage/column/groonga/scalar/r/with_not_for_mroonga_comment.result (+3 -7)
===================================================================
--- test/sql/suite/mroonga/storage/column/groonga/scalar/r/with_not_for_mroonga_comment.result    2013-06-21 15:09:22 +0900 (a6a23bb)
+++ test/sql/suite/mroonga/storage/column/groonga/scalar/r/with_not_for_mroonga_comment.result    2013-06-21 15:18:12 +0900 (a9b0955)
@@ -7,13 +7,9 @@ CREATE TABLE Bugs (
 id INT UNSIGNED PRIMARY KEY,
 tag TEXT COMMENT 'It references to Tags.name, type "Tags"'
 ) DEFAULT CHARSET=utf8;
-SHOW CREATE TABLE Bugs;
-Table	Create Table
-Bugs	CREATE TABLE `Bugs` (
-  `id` int(10) unsigned NOT NULL,
-  `tag` text COMMENT 'It references to Tags.name, type "Tags"',
-  PRIMARY KEY (`id`)
-) ENGINE=mroonga DEFAULT CHARSET=utf8
+SHOW FULL COLUMNS FROM Bugs LIKE 'tag';
+Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
+tag	text	utf8_general_ci	YES		NULL		select,insert,update,references	It references to Tags.name, type "Tags"
 INSERT INTO Bugs (id, tag) VALUES (1, "Linux");
 INSERT INTO Bugs (id, tag) VALUES (2, "MySQL");
 INSERT INTO Bugs (id, tag) VALUES (3, "groonga");

  Modified: test/sql/suite/mroonga/storage/column/groonga/scalar/t/with_not_for_mroonga_comment.test (+1 -1)
===================================================================
--- test/sql/suite/mroonga/storage/column/groonga/scalar/t/with_not_for_mroonga_comment.test    2013-06-21 15:09:22 +0900 (d6091d2)
+++ test/sql/suite/mroonga/storage/column/groonga/scalar/t/with_not_for_mroonga_comment.test    2013-06-21 15:18:12 +0900 (a3a55ba)
@@ -31,7 +31,7 @@ CREATE TABLE Bugs (
   tag TEXT COMMENT 'It references to Tags.name, type "Tags"'
 ) DEFAULT CHARSET=utf8;
 
-SHOW CREATE TABLE Bugs;
+SHOW FULL COLUMNS FROM Bugs LIKE 'tag';
 
 INSERT INTO Bugs (id, tag) VALUES (1, "Linux");
 INSERT INTO Bugs (id, tag) VALUES (2, "MySQL");
-------------- next part --------------
HTML����������������������������...
下载 



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