diff options
| author | Alexander Barkov <bar@mariadb.org> | 2015-06-09 15:35:25 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2015-06-09 15:35:25 +0400 |
| commit | c94789c3d38831fb7ad0781b97b28abb8a17a165 (patch) | |
| tree | 4eca48bf49ee12be604e329555344e7c73668377 /mysql-test | |
| parent | b0928711e048a164fcc0e7bf64a4190a82f09b57 (diff) | |
| download | mariadb-git-c94789c3d38831fb7ad0781b97b28abb8a17a165.tar.gz | |
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.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/func_test.result | 42 | ||||
| -rw-r--r-- | mysql-test/t/func_test.test | 29 |
2 files changed, 71 insertions, 0 deletions
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 +# diff --git a/mysql-test/t/func_test.test b/mysql-test/t/func_test.test index d3703de26c5..82e421dcb6b 100644 --- a/mysql-test/t/func_test.test +++ b/mysql-test/t/func_test.test @@ -194,3 +194,32 @@ EXPLAIN EXTENDED SELECT NOT NOT strcmp('a','b'); --echo # --echo # End of 10.0 tests --echo # + +--echo # +--echo # Start of 10.1 tests +--echo # + +--echo # +--echo # MDEV-8167 XOR returns bad results for an indexed column +--echo # +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; +SELECT * FROM t1 IGNORE KEY(PRIMARY) WHERE id XOR 0; +DROP TABLE t1; + +--echo # +--echo # End of 10.1 tests +--echo # |