[Commits] Rev 3866: mdev-4942: Add another testcase after merging with other fixes. in file:///data0/psergey/dev2/5.5-r2/

Sergey Petrunya psergey at askmonty.org
Wed Aug 28 20:21:13 EEST 2013


At file:///data0/psergey/dev2/5.5-r2/

------------------------------------------------------------
revno: 3866
revision-id: psergey at askmonty.org-20130828172112-3uxhv71xmilynmg4
parent: psergey at askmonty.org-20130828163123-d21u7cx29eou7pop
committer: Sergey Petrunya <psergey at askmonty.org>
branch nick: 5.5-r2
timestamp: Wed 2013-08-28 21:21:12 +0400
message:
  mdev-4942: Add another testcase after merging with other fixes.
=== modified file 'mysql-test/r/join_outer.result'
--- a/mysql-test/r/join_outer.result	2013-08-28 16:31:23 +0000
+++ b/mysql-test/r/join_outer.result	2013-08-28 17:21:12 +0000
@@ -2158,6 +2158,18 @@ SELECT * FROM t1 LEFT JOIN t2 ON i1 = j2
 i1	d1	i2	j2
 2	0000-00-00	NULL	NULL
 DROP TABLE t1,t2;
+# Another testcase
+CREATE TABLE t1 (i1 INT) ENGINE=MyISAM;
+INSERT INTO t1 VALUES (NULL);
+CREATE TABLE t2 (i2 INT, a INT, b INT) ENGINE=MyISAM;
+CREATE ALGORITHM=TEMPTABLE VIEW v2 AS SELECT * FROM t2;
+INSERT INTO t2 VALUES (NULL,1,2),(NULL,2,3);
+SELECT * FROM t1 LEFT JOIN v2 ON i1 = i2 WHERE a < b;
+i1	i2	a	b
+SELECT * FROM t1 LEFT JOIN t2 ON i1 = i2 WHERE a < b;
+i1	i2	a	b
+drop view v2;
+drop table t1,t2;
 #
 # Bug mdev-4942: LEFT JOIN with conjunctive 
 #                <non-nullable datetime field> IS NULL in WHERE 

=== modified file 'mysql-test/r/join_outer_jcl6.result'
--- a/mysql-test/r/join_outer_jcl6.result	2013-08-28 16:31:23 +0000
+++ b/mysql-test/r/join_outer_jcl6.result	2013-08-28 17:21:12 +0000
@@ -2169,6 +2169,18 @@ SELECT * FROM t1 LEFT JOIN t2 ON i1 = j2
 i1	d1	i2	j2
 2	0000-00-00	NULL	NULL
 DROP TABLE t1,t2;
+# Another testcase
+CREATE TABLE t1 (i1 INT) ENGINE=MyISAM;
+INSERT INTO t1 VALUES (NULL);
+CREATE TABLE t2 (i2 INT, a INT, b INT) ENGINE=MyISAM;
+CREATE ALGORITHM=TEMPTABLE VIEW v2 AS SELECT * FROM t2;
+INSERT INTO t2 VALUES (NULL,1,2),(NULL,2,3);
+SELECT * FROM t1 LEFT JOIN v2 ON i1 = i2 WHERE a < b;
+i1	i2	a	b
+SELECT * FROM t1 LEFT JOIN t2 ON i1 = i2 WHERE a < b;
+i1	i2	a	b
+drop view v2;
+drop table t1,t2;
 #
 # Bug mdev-4942: LEFT JOIN with conjunctive 
 #                <non-nullable datetime field> IS NULL in WHERE 

=== modified file 'mysql-test/t/join_outer.test'
--- a/mysql-test/t/join_outer.test	2013-08-28 16:31:23 +0000
+++ b/mysql-test/t/join_outer.test	2013-08-28 17:21:12 +0000
@@ -1706,6 +1706,19 @@ INSERT INTO t2 VALUES (1,10),(2,20);
 SELECT * FROM t1 LEFT JOIN t2 ON i1 = j2 WHERE d1 IS NULL AND 1 OR i1 = i2;
 DROP TABLE t1,t2;
 
+--echo # Another testcase
+CREATE TABLE t1 (i1 INT) ENGINE=MyISAM;
+INSERT INTO t1 VALUES (NULL);
+
+CREATE TABLE t2 (i2 INT, a INT, b INT) ENGINE=MyISAM;
+CREATE ALGORITHM=TEMPTABLE VIEW v2 AS SELECT * FROM t2;
+
+INSERT INTO t2 VALUES (NULL,1,2),(NULL,2,3);
+SELECT * FROM t1 LEFT JOIN v2 ON i1 = i2 WHERE a < b;
+SELECT * FROM t1 LEFT JOIN t2 ON i1 = i2 WHERE a < b;
+
+drop view v2;
+drop table t1,t2;
 
 --echo #
 --echo # Bug mdev-4942: LEFT JOIN with conjunctive 



More information about the commits mailing list