--disable_abort_on_error DROP TABLE IF EXISTS JNULL1, JNULL2; CREATE TABLE JNULL1 (C1 INT, C2 INT); CREATE TABLE JNULL2 (C2 INT); CREATE VIEW JNULL4 AS SELECT C2 FROM JNULL2; CREATE VIEW JNULL6 AS SELECT C1 FROM JNULL1 LEFT OUTER JOIN JNULL4 USING (C2); # This command crashes the server SELECT * FROM JNULL6; # The original NIST test case DROP VIEW JNULL4, JNULL6; DROP TABLE JNULL1, JNULL2; CREATE TABLE JNULL1 (C1 INT, C2 INT); CREATE TABLE JNULL2 (D1 INT, D2 INT); INSERT INTO JNULL1 VALUES (NULL, NULL); INSERT INTO JNULL1 VALUES (1, NULL); INSERT INTO JNULL1 VALUES (NULL, 1); INSERT INTO JNULL1 VALUES (1, 1); INSERT INTO JNULL1 VALUES (2, 2); CREATE VIEW JNULL4 AS SELECT D1, D2 AS C2 FROM JNULL2; CREATE VIEW JNULL6 AS SELECT JNULL1.C2,C1,D1 FROM JNULL1 LEFT OUTER JOIN JNULL4 USING (C2); # This command crashes the server SELECT COUNT(*) FROM JNULL6 WHERE C2 IS NOT NULL; # NIST expects COUNT(*)= 3