CREATE TABLE COMPLEXTEST1_BASE_NO_ABS (ID BIGINT NOT NULL UNIQUE, DTYPE VARCHAR(31), GUID text, UUID VARCHAR NOT NULL UNIQUE, PRIMARY KEY (ID)); CREATE TABLE COMPLEXTEST1_CLASS_B1 (ID BIGINT NOT NULL, A_ID BIGINT, PRIMARY KEY (ID)); CREATE TABLE COMPLEXTEST1_CLASS_A1 (ID BIGINT NOT NULL, PRIMARY KEY (ID)); ALTER TABLE COMPLEXTEST1_CLASS_B1 ADD CONSTRAINT FK_COMPLEXTEST1_CLASS_B1_A_ID FOREIGN KEY (A_ID) REFERENCES COMPLEXTEST1_BASE_NO_ABS (ID); ALTER TABLE COMPLEXTEST1_CLASS_B1 ADD CONSTRAINT FK_COMPLEXTEST1_CLASS_B1_ID FOREIGN KEY (ID) REFERENCES COMPLEXTEST1_BASE_NO_ABS (ID); ALTER TABLE COMPLEXTEST1_CLASS_A1 ADD CONSTRAINT FK_COMPLEXTEST1_CLASS_A1_ID FOREIGN KEY (ID) REFERENCES COMPLEXTEST1_BASE_NO_ABS (ID); CREATE SEQUENCE COMPLEXTEST1_BASE_NO_ABS_SEQ INCREMENT BY 50 START WITH 50; INSERT INTO COMPLEXTEST1_BASE_NO_ABS(ID, DTYPE, GUID, UUID) VALUES (1, 'Complextest1ClassA1', '6e05c875-734c-4dfd-867f-a903ba7ddd4a', '1aedabd9-0cf6-4d7f-ab36-6ec136b114ac'); INSERT INTO COMPLEXTEST1_BASE_NO_ABS(ID, DTYPE, GUID, UUID) VALUES (2, 'Complextest1ClassB1', 'cb197305-15d7-41b2-87a9-f4cf9cc7a70a', '927d0b8f-e298-4368-af8a-388b752701a3'); INSERT INTO COMPLEXTEST1_CLASS_A1(ID) VALUES (1); INSERT INTO COMPLEXTEST1_CLASS_B1(ID, A_ID) VALUES (2,1); SELECT t0.ID, t0.DTYPE, t0.GUID, t0.UUID, t1.ID, t1.A_ID FROM COMPLEXTEST1_BASE_NO_ABS t2 LEFT OUTER JOIN (COMPLEXTEST1_BASE_NO_ABS t0 JOIN COMPLEXTEST1_CLASS_B1 t1 ON (t1.ID = t0.ID)) ON (t1.A_ID = t2.ID), COMPLEXTEST1_CLASS_A1 t3 WHERE ((t2.ID = 1) AND ((t3.ID = t2.ID) AND (t2.DTYPE = 'Complextest1ClassA1')));
Thank you. I tested without data too, the exception is same. I tested with 1.4.186, 1.4.188, 1.3.176 and none of them is OK. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
