diff options
Diffstat (limited to 'mysql-test/r/null_key.result')
| -rw-r--r-- | mysql-test/r/null_key.result | 14 |
1 files changed, 9 insertions, 5 deletions
diff --git a/mysql-test/r/null_key.result b/mysql-test/r/null_key.result index 7f746a3dbd8..5c2141befa6 100644 --- a/mysql-test/r/null_key.result +++ b/mysql-test/r/null_key.result @@ -313,12 +313,16 @@ INSERT INTO t1 (order_id, product_id, product_type) VALUES ('9d9aad7764b5b2c53004348ef8d34500',2315652, 3); INSERT INTO t2 (order_id, product_id, product_type) VALUES ('9d9aad7764b5b2c53004348ef8d34500',2315652, 3); -select t1.* from t1 -left join t2 using(order_id, product_id, product_type) -where t2.order_id=NULL; +select t1.* from t1 left join t2 +on (t1.order_id = t2.order_id and +t1.product_id = t2.product_id and +t1.product_type = t2.product_type) +where t2.order_id = NULL; order_id product_id product_type -select t1.* from t1 -left join t2 using(order_id, product_id, product_type) +select t1.* from t1 left join t2 +on (t1.order_id = t2.order_id and +t1.product_id = t2.product_id and +t1.product_type = t2.product_type) where t2.order_id is NULL; order_id product_id product_type 3d7ce39b5d4b3e3d22aaafe9b633de51 1206029 3 |