[Groonga-mysql-commit] mroonga/mroonga [master] test: use lower case for type name and character set name

Back to archive index

Kouhei Sutou null+****@clear*****
Sat Nov 17 13:19:46 JST 2012


Kouhei Sutou	2012-11-17 13:19:46 +0900 (Sat, 17 Nov 2012)

  New Revision: 819facdcc2c8f7a941da2cbf33aee97018d5a092
  https://github.com/mroonga/mroonga/commit/819facdcc2c8f7a941da2cbf33aee97018d5a092

  Log:
    test: use lower case for type name and character set name
    
    Because they are not SQL keywords.

  Modified files:
    test/sql/suite/mroonga/storage/index/primary/char/r/short.result
    test/sql/suite/mroonga/storage/index/primary/char/t/short.test
    test/sql/suite/mroonga/storage/index/primary/t/char.test

  Modified: test/sql/suite/mroonga/storage/index/primary/char/r/short.result (+1 -1)
===================================================================
--- test/sql/suite/mroonga/storage/index/primary/char/r/short.result    2012-11-17 13:18:08 +0900 (386edf0)
+++ test/sql/suite/mroonga/storage/index/primary/char/r/short.result    2012-11-17 13:19:46 +0900 (fb08c66)
@@ -1,6 +1,6 @@
 DROP TABLE IF EXISTS ids;
 CREATE TABLE ids (
-id CHAR(6) CHARACTER SET LATIN1 PRIMARY KEY
+id char(6) CHARACTER SET latin1 PRIMARY KEY
 );
 INSERT INTO ids VALUES("abcdef");
 INSERT INTO ids VALUES(  "cdef");

  Modified: test/sql/suite/mroonga/storage/index/primary/char/t/short.test (+1 -1)
===================================================================
--- test/sql/suite/mroonga/storage/index/primary/char/t/short.test    2012-11-17 13:18:08 +0900 (b7bb40d)
+++ test/sql/suite/mroonga/storage/index/primary/char/t/short.test    2012-11-17 13:19:46 +0900 (a6ae0ad)
@@ -21,7 +21,7 @@ DROP TABLE IF EXISTS ids;
 --enable_warnings
 
 CREATE TABLE ids (
-  id CHAR(6) CHARACTER SET LATIN1 PRIMARY KEY
+  id char(6) CHARACTER SET latin1 PRIMARY KEY
 );
 
 INSERT INTO ids VALUES("abcdef");

  Modified: test/sql/suite/mroonga/storage/index/primary/t/char.test (+5 -4)
===================================================================
--- test/sql/suite/mroonga/storage/index/primary/t/char.test    2012-11-17 13:18:08 +0900 (fcec696)
+++ test/sql/suite/mroonga/storage/index/primary/t/char.test    2012-11-17 13:19:46 +0900 (2bfd140)
@@ -1,4 +1,5 @@
 # Copyright(C) 2012 Kentoku SHIBA
+# Copyright(C) 2012 Kouhei Sutou <kou �� clear-code.com>
 #
 # This library is free software; you can redistribute it and/or
 # modify it under the terms of the GNU Lesser General Public
@@ -20,11 +21,11 @@
 drop table if exists t1;
 --enable_warnings
 
-create table t1 (c1 char(10) primary key);
+create table t1 (c1 char(10) primary key) engine=myisam;
 insert into t1 values('abcdefghij');
-insert into t1 values('klmnopqrst');
-insert into t1 values('uvwxyz0123');
-select c1 from t1 force index(PRIMARY) where c1 = 'abcdefghij';
+insert into t1 values(  'cdefghij');
+insert into t1 values(    'efghij');
+select c1 from t1 force index(PRIMARY) where c1 = 'cdefghij';
 drop table t1;
 
 --source include/have_mroonga_deinit.inc
-------------- next part --------------
HTML����������������������������...
Download 



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