diff options
Diffstat (limited to 'mysql-test/r/select.result')
| -rw-r--r-- | mysql-test/r/select.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index 9f1ff2cd835..4381220eacc 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -2681,6 +2681,15 @@ SELECT COUNT(*) FROM t1 WHERE AND FK_firma_id = 2; COUNT(*) 0 +CREATE TABLE `t1` ( `gid` int(11) default NULL, `uid` int(11) default NULL); +CREATE TABLE `t2` ( `ident` int(11) default NULL, `level` char(16) default NULL); +INSERT INTO `t2` VALUES (0,'READ'); +CREATE TABLE `t3` ( `id` int(11) default NULL, `name` char(16) default NULL); +INSERT INTO `t3` VALUES (1,'fs'); +select * from t3 left join t1 on t3.id = t1.uid, t2 where t2.ident in (0, t1.gid, t3.id, 0); +id name gid uid ident level +1 fs NULL NULL 0 READ +drop table t1,t2,t3; drop table t1; CREATE TABLE t1 (a int); CREATE TABLE t2 (a int); |