Sure: setup: CREATE TABLE PUBLIC.VECTORS (ID INTEGER NOT NULL, GEOM GEOMETRY, S INTEGER); INSERT INTO PUBLIC.VECTORS(ID, GEOM, S) VALUES(0, 'POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))', 1);
working test case: select * from PUBLIC.VECTORS WHERE S=1 AND GEOM && 'POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))'; also working: select * from (select * from PUBLIC.VECTORS) WHERE GEOM && 'POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))'; also: select * from (select * from PUBLIC.VECTORS) WHERE S=1 and the NPE: select * from (select * from PUBLIC.VECTORS) WHERE S=1 AND GEOM && 'POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))'; Dne petek, 25. marec 2016 14.40.33 UTC+1 je oseba Noel Grandin napisala: > > can you create a standalone test case that triggers the bug? > > something like > > CREATE TABLE... > INSERT... > SELECT... > > then we can add a unit test and look at your proposed change. > > -- 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 https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
