From c2383412b243e05ec01434b8667aafa3559225b3 Mon Sep 17 00:00:00 2001 From: unknown Date: Fri, 28 Jan 2005 17:18:35 -0800 Subject: Fix error in string comparisons with CHAR(31) against the space-padding of strings of unequal length. (Bug #8134) mysql-test/t/compare.test: Add new regression test strings/ctype-simple.c: Fix value used for swapping negative/positive values using XOR mysql-test/r/compare.result: Add new test result --- mysql-test/t/compare.test | 3 +++ 1 file changed, 3 insertions(+) (limited to 'mysql-test/t') diff --git a/mysql-test/t/compare.test b/mysql-test/t/compare.test index b0cef48dd3f..e3c042e608a 100644 --- a/mysql-test/t/compare.test +++ b/mysql-test/t/compare.test @@ -30,3 +30,6 @@ CREATE TABLE t1 (a char(10) not null); INSERT INTO t1 VALUES ('a'),('a\0'),('a\t'),('a '); SELECT hex(a),STRCMP(a,'a'), STRCMP(a,'a ') FROM t1; DROP TABLE t1; + +# Bug #8134: Comparison against CHAR(31) at end of string +SELECT CHAR(31) = '', '' = CHAR(31); -- cgit v1.2.1