diff options
| author | vva@eagle.mysql.r18.ru <> | 2004-02-12 23:45:39 +0400 |
|---|---|---|
| committer | vva@eagle.mysql.r18.ru <> | 2004-02-12 23:45:39 +0400 |
| commit | 5b369431f1a458f960155d71be457474f6f05eea (patch) | |
| tree | 0a47cf1aff09fd3a9edbdf22c979a4bb09aeec45 /mysql-test/r/select_found.result | |
| parent | 650580698f7f473b1ccb5a520a17fc8b269c7c9f (diff) | |
| download | mariadb-git-5b369431f1a458f960155d71be457474f6f05eea.tar.gz | |
fixed copying of color in SEL_ARG::clone (fixed bug #2968)
Diffstat (limited to 'mysql-test/r/select_found.result')
| -rw-r--r-- | mysql-test/r/select_found.result | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/r/select_found.result b/mysql-test/r/select_found.result index 419ffb73d59..367bdd798b4 100644 --- a/mysql-test/r/select_found.result +++ b/mysql-test/r/select_found.result @@ -188,3 +188,21 @@ select FOUND_ROWS(); FOUND_ROWS() 0 drop table t1; +CREATE TABLE t1 ( a int not null, b int not null, KEY ab(a,b) ); +INSERT INTO t1 VALUES ( 47, 1 ); +INSERT INTO t1 VALUES ( 70, 1 ); +SELECT * FROM t1 +WHERE +( +( b =1 AND a BETWEEN 14 AND 21 ) OR +( b =2 AND a BETWEEN 16 AND 18 ) OR +( b =3 AND a BETWEEN 15 AND 19 ) +); +a b +DROP TABLE t1; +CREATE TABLE t1 ( a integer, u varchar(15), r integer, key uao_idx( r, a, u)); +DELETE FROM t1 +WHERE ( r = 1 AND a IN ( 1, 2 ) AND ( u = 'w' OR u LIKE 'w/%' ) ) +OR ( r = 1 AND a IN ( 3 ) AND ( u = 'w/U' OR u LIKE 'w/U/%' ) ) +OR ( r = 1 AND a IN ( 1, 2, 3 ) AND ( u = 'w' ) ); +drop table t1; |