Kouhei Sutou
null+****@clear*****
Sat Nov 17 13:27:34 JST 2012
Kouhei Sutou 2012-11-17 13:27:34 +0900 (Sat, 17 Nov 2012) New Revision: f31f93c84062078f391939ecf0739d19ee22660e https://github.com/mroonga/mroonga/commit/f31f93c84062078f391939ecf0739d19ee22660e Log: Use UPPER CASE for SQL keywords refs #1530 Modified files: test/sql/suite/mroonga/storage/index/primary/char/r/exact_length.result test/sql/suite/mroonga/storage/index/primary/char/t/exact_length.test Modified: test/sql/suite/mroonga/storage/index/primary/char/r/exact_length.result (+15 -8) =================================================================== --- test/sql/suite/mroonga/storage/index/primary/char/r/exact_length.result 2012-11-17 13:24:44 +0900 (5b895ad) +++ test/sql/suite/mroonga/storage/index/primary/char/r/exact_length.result 2012-11-17 13:27:34 +0900 (95d7c78) @@ -1,9 +1,16 @@ -drop table if exists t1; -create table t1 (c1 char(10) primary key); -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'; -c1 +DROP TABLE IF EXISTS ids; +CREATE TABLE ids ( +id char(10) CHARACTER SET latin1 PRIMARY KEY +); +INSERT INTO ids VALUES('abcdefghij'); +INSERT INTO ids VALUES('klmnopqrst'); +INSERT INTO ids VALUES('uvwxyz0123'); +SELECT * FROM ids FORCE INDEX(PRIMARY) ORDER BY id; +id abcdefghij -drop table t1; +klmnopqrst +uvwxyz0123 +SELECT * FROM ids FORCE INDEX(PRIMARY) WHERE id = 'abcdefghij'; +id +abcdefghij +DROP TABLE ids; Modified: test/sql/suite/mroonga/storage/index/primary/char/t/exact_length.test (+15 -7) =================================================================== --- test/sql/suite/mroonga/storage/index/primary/char/t/exact_length.test 2012-11-17 13:24:44 +0900 (fcec696) +++ test/sql/suite/mroonga/storage/index/primary/char/t/exact_length.test 2012-11-17 13:27:34 +0900 (5fd6c9a) @@ -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 @@ -17,14 +18,21 @@ --source include/have_mroonga.inc --disable_warnings -drop table if exists t1; +DROP TABLE IF EXISTS ids; --enable_warnings -create table t1 (c1 char(10) primary key); -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'; -drop table t1; +CREATE TABLE ids ( + id char(10) CHARACTER SET latin1 PRIMARY KEY +); + +INSERT INTO ids VALUES('abcdefghij'); +INSERT INTO ids VALUES('klmnopqrst'); +INSERT INTO ids VALUES('uvwxyz0123'); + +SELECT * FROM ids FORCE INDEX(PRIMARY) ORDER BY id; + +SELECT * FROM ids FORCE INDEX(PRIMARY) WHERE id = 'abcdefghij'; + +DROP TABLE ids; --source include/have_mroonga_deinit.inc -------------- next part -------------- HTML����������������������������...Download
