MariaDB

  1. Bug #779885
  2. Comment #2

Comment 2 for bug 779885

Revision history for this message
Philip Stoev (pstoev-askmonty) wrote :

Also reproducible with comma-style join:

CREATE TABLE t1 ( f1 int );
INSERT INTO t1 VALUES (19), (20);

CREATE TABLE t3 ( f10 varchar(32) );
INSERT INTO t3 VALUES ('a'),('b');

CREATE TABLE t4 ( f10 varchar(32) );
INSERT INTO t4 VALUES ('c'),('d');

SELECT *
FROM t1
WHERE
( 't' ) IN (
        SELECT t3.f10
        FROM t3,t4
        WHERE t4.f10 = t3.f10
);