From c94789c3d38831fb7ad0781b97b28abb8a17a165 Mon Sep 17 00:00:00 2001 From: Alexander Barkov Date: Tue, 9 Jun 2015 15:35:25 +0400 Subject: Adding a test for: MDEV-8167 XOR returns bad results for an indexed column The bug itself was earlier fixed by one of the earlier changes. --- mysql-test/r/func_test.result | 42 ++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 42 insertions(+) (limited to 'mysql-test/r/func_test.result') diff --git a/mysql-test/r/func_test.result b/mysql-test/r/func_test.result index 97ef61047a5..af52a2b9149 100644 --- a/mysql-test/r/func_test.result +++ b/mysql-test/r/func_test.result @@ -337,3 +337,45 @@ Note 1003 select (strcmp('a','b') <> 0) AS `NOT NOT strcmp('a','b')` # # End of 10.0 tests # +# +# Start of 10.1 tests +# +# +# MDEV-8167 XOR returns bad results for an indexed column +# +CREATE TABLE t1 ( +id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, +k INTEGER UNSIGNED DEFAULT '0' NOT NULL, +c CHAR(120) DEFAULT '' NOT NULL, +pad CHAR(60) DEFAULT '' NOT NULL, +PRIMARY KEY (id) +) ENGINE=MyISAM; +INSERT INTO t1 (k, c, pad) VALUES (10, 'a', 'xxx'); +INSERT INTO t1 (k, c, pad) VALUES (11, 'a', 'xxx'); +INSERT INTO t1 (k, c, pad) VALUES (12, 'a', 'xxx'); +INSERT INTO t1 (k, c, pad) VALUES (13, 'a', 'xxx'); +INSERT INTO t1 (k, c, pad) VALUES (14, 'a', 'xxx'); +INSERT INTO t1 (k, c, pad) VALUES (15, 'a', 'xxx'); +INSERT INTO t1 (k, c, pad) VALUES (16, 'a', 'xxx'); +SELECT * FROM t1 WHERE id XOR 0; +id k c pad +1 10 a xxx +2 11 a xxx +3 12 a xxx +4 13 a xxx +5 14 a xxx +6 15 a xxx +7 16 a xxx +SELECT * FROM t1 IGNORE KEY(PRIMARY) WHERE id XOR 0; +id k c pad +1 10 a xxx +2 11 a xxx +3 12 a xxx +4 13 a xxx +5 14 a xxx +6 15 a xxx +7 16 a xxx +DROP TABLE t1; +# +# End of 10.1 tests +# -- cgit v1.2.1