diff options
| author | unknown <evgen@moonbone.local> | 2005-09-28 21:30:10 +0400 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2005-09-28 21:30:10 +0400 |
| commit | 0fda286a415777e755d4bc076d4d35f27c071219 (patch) | |
| tree | d6e6e7c59877611c8c167faf23427d988f0d249f /mysql-test | |
| parent | fd6cc878e46310b19c8ec8f642aadfea941da9ac (diff) | |
| download | mariadb-git-0fda286a415777e755d4bc076d4d35f27c071219.tar.gz | |
select.result, item.cc:
After merge fix for bug#13356
sql/item.cc:
After merge fix for bug#13356
mysql-test/r/select.result:
After merge fix for bug#13356
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/select.result | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index e9cfd900531..43a8f7f7615 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -2620,6 +2620,15 @@ select found_rows(); found_rows() 1 DROP TABLE t1; +create table t1(f1 int, f2 int); +create table t2(f3 int); +select f1 from t1,t2 where f1=f2 and (f1,f2) = ((1,1)); +f1 +select f1 from t1,t2 where f1=f2 and (f1,NULL) = ((1,1)); +f1 +select f1 from t1,t2 where f1=f2 and (f1,f2) = ((1,NULL)); +f1 +drop table t1,t2; CREATE TABLE t1 ( city char(30) ); INSERT INTO t1 VALUES ('London'); INSERT INTO t1 VALUES ('Paris'); @@ -3029,12 +3038,3 @@ id 102 drop table t1, t2; drop view v1, v2, v3; -create table t1(f1 int, f2 int); -create table t2(f3 int); -select f1 from t1,t2 where f1=f2 and (f1,f2) = ((1,1)); -f1 -select f1 from t1,t2 where f1=f2 and (f1,NULL) = ((1,1)); -f1 -select f1 from t1,t2 where f1=f2 and (f1,f2) = ((1,NULL)); -f1 -drop table t1,t2; |