Details
-
Bug
-
Status: Stalled (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.0.13, 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
None
-
10.0.20, 10.0.24
Description
CREATE TABLE t1 (a VARCHAR(3)) ENGINE=MyISAM; |
INSERT INTO t1 VALUES ('foo'),('bar'); |
|
|
CREATE TABLE t2 (i INT, b VARCHAR(3)) ENGINE=MyISAM; |
CREATE ALGORITHM=MERGE VIEW v2 AS SELECT * FROM t2; |
INSERT INTO t2 VALUES (4,'foo'),(5,'baz'); |
|
|
PREPARE stmt FROM "SELECT * FROM t1 WHERE NOT EXISTS ( SELECT i FROM v2 WHERE b = a )"; |
EXECUTE stmt; |
EXECUTE stmt; |
Actual result:
EXECUTE stmt; |
a
|
bar
|
EXECUTE stmt; |
a
|
foo
|
bar
|
Expected result:
EXECUTE stmt; |
a
|
bar
|
EXECUTE stmt; |
a
|
bar
|
revision-id: knielsen@knielsen-hq.org-20140902120701-txesdmkczel84qgf
|
revno: 4369
|
branch-nick: 10.0
|
Attachments
Issue Links
- is blocked by
-
-
- Stalled
-