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/r | |
| 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/r')
| -rw-r--r-- | mysql-test/r/func_test.result | 42 |
1 files changed, 42 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 +# |