List:Commits« Previous MessageNext Message »
From:lars-erik.bjork Date:January 13 2009 7:14pm
Subject:bzr commit into mysql-6.0-falcon-team branch (lars-erik.bjork:2957) Bug#36186
View as plain text  
#At file:///home/lb200670/devel/mysql/jumper/ based on revid:olav@stripped

 2957 lars-erik.bjork@stripped	2009-01-13
      This is a test for bug#36186 Falcon: searches fail if value < 'a',
      length>1, index, utf32
      
      The bug is no longer reproducible.
      
      
      Added file 'mysql-test/suite/falcon/t/falcon_bug_36186.test'
      ------------------------------------------------------------
      A test testing that the bug is no longer reproducible
      
      Added file 'mysql-test/suite/falcon/r/falcon_bug_36186.result'
      --------------------------------------------------------------
      The expected output of the test
added:
  mysql-test/suite/falcon/r/falcon_bug_36186.result
  mysql-test/suite/falcon/t/falcon_bug_36186.test

=== added file 'mysql-test/suite/falcon/r/falcon_bug_36186.result'
--- a/mysql-test/suite/falcon/r/falcon_bug_36186.result	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/falcon/r/falcon_bug_36186.result	2009-01-13 19:14:09 +0000
@@ -0,0 +1,15 @@
+*** Bug #36186 ***
+SET @@storage_engine = 'Falcon';
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1 (s1 varchar(2) character set utf32);
+CREATE INDEX i ON t1 (s1);
+INSERT INTO t1 VALUES ('$$'),('00'),('>>');
+SELECT * FROM t1 WHERE s1 < 'a';
+s1
+$$
+00
+>>
+SELECT count(*) FROM t1;
+count(*)
+3
+DROP TABLE t1;

=== added file 'mysql-test/suite/falcon/t/falcon_bug_36186.test'
--- a/mysql-test/suite/falcon/t/falcon_bug_36186.test	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/falcon/t/falcon_bug_36186.test	2009-01-13 19:14:09 +0000
@@ -0,0 +1,35 @@
+--source include/have_falcon.inc
+--source include/have_utf32.inc
+
+#
+# Bug #36186: Falcon: searches fail if value < 'a', length>1, index, utf32
+#
+--echo *** Bug #36186 ***
+
+# ----------------------------------------------------- #
+# --- Initialisation                                --- #
+# ----------------------------------------------------- #
+let $engine = 'Falcon';
+eval SET @@storage_engine = $engine;
+
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+--enable_warnings
+
+# ----------------------------------------------------- #
+# --- Test                                          --- #
+# ----------------------------------------------------- #
+CREATE TABLE t1 (s1 varchar(2) character set utf32);
+CREATE INDEX i ON t1 (s1);
+INSERT INTO t1 VALUES ('$$'),('00'),('>>');
+SELECT * FROM t1 WHERE s1 < 'a';
+
+# ----------------------------------------------------- #
+# --- Check                                         --- #
+# ----------------------------------------------------- #
+SELECT count(*) FROM t1;
+
+# ----------------------------------------------------- #
+# --- Final cleanup                                 --- #
+# ----------------------------------------------------- #
+DROP TABLE t1;

Thread
bzr commit into mysql-6.0-falcon-team branch (lars-erik.bjork:2957) Bug#36186lars-erik.bjork13 Jan