diff options
| author | unknown <igor@rurik.mysql.com> | 2005-03-13 01:07:01 -0800 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2005-03-13 01:07:01 -0800 |
| commit | d83bb4ed22c105412b4f3bc34b5ddf54353a9e0e (patch) | |
| tree | 221d77af5f463031bfff6443a93df5f2cbe81f00 /mysql-test/t/join_outer.test | |
| parent | 9c892564b2ee5c7245a5961c56654d71ec28547b (diff) | |
| download | mariadb-git-d83bb4ed22c105412b4f3bc34b5ddf54353a9e0e.tar.gz | |
join_outer.test:
Correction after manual merge.
mysql-test/t/join_outer.test:
Correction after manual merge.
Diffstat (limited to 'mysql-test/t/join_outer.test')
| -rw-r--r-- | mysql-test/t/join_outer.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/join_outer.test b/mysql-test/t/join_outer.test index 87e31d7affc..f87233bff12 100644 --- a/mysql-test/t/join_outer.test +++ b/mysql-test/t/join_outer.test @@ -588,6 +588,12 @@ INSERT INTO t2 VALUES("0", "SV", "0-SV"); INSERT INTO t2 VALUES("10", "EN", "10-EN"); INSERT INTO t2 VALUES("10", "SV", "10-SV"); +SELECT t1.id, t1.text_id, t2.text_data + FROM t1 LEFT JOIN t2 + ON t1.text_id = t2.text_id + AND t2.language_id = 'SV' + WHERE (t1.id LIKE '%' OR t2.text_data LIKE '%'); + DROP TABLE t1, t2; # Test for bug #5896 |