bzr push into mysql-6.0-falcon-team branch (lars-erik.bjork:2956 to 2957) Bug#36186

[lars-erik.bjork]

 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

 2956 Olav Sandstaa	2009-01-13 [merge]
      Merge, just ignore.
removed:
  mysql-test/t/rpl_slave_exec_mode_basic.test
added:
  config/ac-macros/libmemcached.m4
  config/ac-macros/search_for_lib.m4
  mysql-test/r/innodb_bug34053.result
  mysql-test/t/innodb_bug34053.test
  mysql-test/t/rpl_slave_exec_mode_basic.test
modified:
  BUILD/compile-dist
  BUILD/compile-pentium-gcov
  BUILD/compile-solaris-amd64
  Makefile.am
  client/mysqltest.c
  configure.in
  libmysqld/examples/test-run
  mysql-test/create-test-result
  mysql-test/include/restart_mysqld.inc
  mysql-test/mysql-test-run.pl
  mysql-test/r/func_math.result
  mysql-test/r/group_by.result
  mysql-test/r/subselect.result
  mysql-test/r/subselect2.result
  mysql-test/r/subselect3.result
  mysql-test/r/subselect3_jcl6.result
  mysql-test/r/subselect_mat.result
  mysql-test/r/subselect_no_mat.result
  mysql-test/r/subselect_no_opts.result
  mysql-test/r/subselect_no_semijoin.result
  mysql-test/r/subselect_sj.result
  mysql-test/r/subselect_sj2.result
  mysql-test/r/subselect_sj2_jcl6.result
  mysql-test/r/subselect_sj_jcl6.result
  mysql-test/r/type_varchar.result
  mysql-test/suite/falcon/r/falcon_bug_32833.result
  mysql-test/suite/falcon/t/disabled.def
  mysql-test/suite/falcon/t/falcon_bug.template
  mysql-test/suite/falcon/t/falcon_bug_22180.test
  mysql-test/suite/falcon/t/falcon_bug_23689.test
  mysql-test/suite/falcon/t/falcon_bug_24511.test
  mysql-test/suite/falcon/t/falcon_bug_24858.test
  mysql-test/suite/falcon/t/falcon_bug_24921.test
  mysql-test/suite/falcon/t/falcon_bug_25555.test
  mysql-test/suite/falcon/t/falcon_bug_26057.test
  mysql-test/suite/falcon/t/falcon_bug_27697.test
  mysql-test/suite/falcon/t/falcon_bug_30480_A.test
  mysql-test/suite/falcon/t/falcon_bug_30480_B.test
  mysql-test/suite/falcon/t/falcon_bug_32833.test
  mysql-test/suite/falcon/t/falcon_bug_38304.test
  mysql-test/suite/falcon/t/falcon_bug_39708.test
  mysql-test/suite/falcon/t/falcon_bugs.test
  mysql-test/suite/falcon/t/falcon_bugs2.test
  mysql-test/suite/falcon/t/falcon_select.test
  mysql-test/suite/falcon/t/falcon_unicode-big.test
  mysql-test/suite/falcon_team/t/falcon_bug_34174.test
  mysql-test/t/func_math.test
  mysql-test/t/partition_not_windows.test
  mysql-test/t/subselect.test
  mysql-test/t/subselect3.test
  mysql-test/t/subselect_mat.test
  netware/BUILD/nwbootstrap
  scripts/make_win_bin_dist
  sql/CMakeLists.txt
  sql/handler.h
  sql/item_cmpfunc.h
  sql/item_func.cc
  sql/item_subselect.cc
  sql/item_subselect.h
  sql/mysql_priv.h
  sql/mysqld.cc
  sql/opt_range.cc
  sql/opt_range.h
  sql/records.h
  sql/sql_base.cc
  sql/sql_class.h
  sql/sql_join_cache.cc
  sql/sql_lex.h
  sql/sql_select.cc
  sql/sql_select.h
  sql/sql_test.cc
  sql/sql_union.cc
  sql/table.h
  storage/archive/support/archive_read_test.slap
  storage/falcon/Database.cpp
  storage/falcon/Database.h
  storage/falcon/Interlock.h
  storage/falcon/MemMgr.cpp
  storage/falcon/MemMgr.h
  storage/falcon/Record.cpp
  storage/falcon/Record.h
  storage/falcon/RecordGroup.cpp
  storage/falcon/RecordGroup.h
  storage/falcon/RecordLeaf.cpp
  storage/falcon/RecordLeaf.h
  storage/falcon/RecordScavenge.cpp
  storage/falcon/RecordScavenge.h
  storage/falcon/RecordSection.cpp
  storage/falcon/RecordSection.h
  storage/falcon/RecordVersion.cpp
  storage/falcon/RecordVersion.h
  storage/falcon/Scavenger.cpp
  storage/falcon/StorageDatabase.cpp
  storage/falcon/StorageDatabase.h
  storage/falcon/StorageTableShare.cpp
  storage/falcon/SyncObject.cpp
  storage/falcon/SyncObject.h
  storage/falcon/Table.cpp
  storage/falcon/Table.h
  storage/falcon/TableSpaceManager.cpp
  storage/falcon/Transaction.cpp
  storage/falcon/Transaction.h
  storage/falcon/TransactionManager.cpp
  storage/falcon/TransactionManager.h
  storage/innobase/pars/make_bison.sh
  storage/innobase/pars/make_flex.sh
  storage/maria/ma_test_big.sh
  storage/myisam/mi_test_all.sh
  storage/myisam/myisam_backup_engine.cc
  storage/ndb/demos/run_demo1-PS.sh
  storage/ndb/demos/run_demo1-SS.sh
  support-files/my-small.cnf.sh
  support-files/mysql.spec.sh

=== 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;