diff options
| author | unknown <evgen@moonbone.local> | 2006-01-13 16:27:38 +0300 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2006-01-13 16:27:38 +0300 |
| commit | d48a3e12622606148d281da7ea0cebb2e3618ea9 (patch) | |
| tree | 3062fb6d2e69a8d993d959081f04a1a1209e6abe /mysql-test/t/select.test | |
| parent | 76a1e157c0818babb0318804b9f38434ba6ed3e4 (diff) | |
| parent | 511078bf2e58fc9e3f4ebde706bac7f6d6e46a40 (diff) | |
| download | mariadb-git-d48a3e12622606148d281da7ea0cebb2e3618ea9.tar.gz | |
Merge
sql/sql_select.cc:
Auto merged
mysql-test/r/select.result:
SCCS merged
mysql-test/t/select.test:
SCCS merged
Diffstat (limited to 'mysql-test/t/select.test')
| -rw-r--r-- | mysql-test/t/select.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/select.test b/mysql-test/t/select.test index 826f1c205c1..01d5f2eb4d1 100644 --- a/mysql-test/t/select.test +++ b/mysql-test/t/select.test @@ -2807,6 +2807,19 @@ EXPLAIN SELECT t2.key_a,foo DROP TABLE t1,t2,t3; # +# Bug#15347 Wrong result of subselect when records cache and set functions +# are involved +# +create table t1 (f1 int); +insert into t1 values(1),(2); +create table t2 (f2 int, f3 int, key(f2)); +insert into t2 values(1,1),(2,2); +create table t3 (f4 int not null); +insert into t3 values (2),(2),(2); +select f1,(select count(*) from t2,t3 where f2=f1 and f3=f4) as count from t1; +drop table t1,t2,t3; + +# # Bug #15633 Evaluation of Item_equal for non-const table caused wrong # select result # |