Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.11.14, 11.8.3
-
None
-
Not for Release Notes
Description
CREATE TABLE t10(a int); |
CREATE TABLE t20(c0 REAL UNSIGNED, PRIMARY KEY(c0)); |
|
|
insert into t10 values (1); |
insert into t20 values (0); |
|
|
SELECT 1 FROM t10 JOIN t20 ON (t20.c0 = '-1'); |
SELECT 1 FROM t10 STRAIGHT_JOIN t20 ON (t20.c0 = '-1'); |
|
|
DROP TABLE t10, t20; |
Attachments
Issue Links
- duplicates
-
MDEV-36249 Equivalent straight-join queries return different results
-
- Confirmed
-