diff options
| author | Monty <monty@mariadb.org> | 2020-03-18 12:00:38 +0200 |
|---|---|---|
| committer | Monty <monty@mariadb.org> | 2020-03-18 12:00:38 +0200 |
| commit | 305cffebaba7a81fcc12f0c7511ffe639cb9b0d2 (patch) | |
| tree | bc3047413379f91841457b449f84a3ac6c40678e /mysql-test/main/range.test | |
| parent | 36b0b302f26f59770ae12ad528e6f56c78083f4c (diff) | |
| parent | 517f659e6d5eeb7e01bf19ef8b782bc2619831d4 (diff) | |
| download | mariadb-git-305cffebaba7a81fcc12f0c7511ffe639cb9b0d2.tar.gz | |
merge 10.4 to 10.5
Diffstat (limited to 'mysql-test/main/range.test')
| -rw-r--r-- | mysql-test/main/range.test | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/mysql-test/main/range.test b/mysql-test/main/range.test index 11212fb0d18..d097a071335 100644 --- a/mysql-test/main/range.test +++ b/mysql-test/main/range.test @@ -960,6 +960,7 @@ CREATE TABLE t1 ( INSERT INTO t1 VALUES ('B'), ('A'), ('A'), ('C'), ('B'), ('A'), ('A'), ('C'), ('A'); +INSERT INTO t1 VALUES ('X'),('Y'),('Z'),('X1'),('Y1'),('Z1'),('X1'),('Y1'),('Z1'); SELECT a FROM t1 WHERE a='b' OR a='B'; EXPLAIN SELECT a FROM t1 WHERE a='b' OR a='B'; @@ -1077,7 +1078,7 @@ INSERT INTO t3 VALUES # To make range scan compelling to the optimizer INSERT INTO t3 SELECT * FROM t3 WHERE a = 10; INSERT INTO t3 SELECT * FROM t3 WHERE a = 10; - +insert into t1 select -a,b from t1; # # Problem#1 Test queries. Will give missing results unless Problem#1 is fixed. |