Changeset: 24c99d5d81ea for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=24c99d5d81ea Modified Files: sql/test/BugTracker-2014/Tests/indices.Bug-3428.sql Branch: Jan2014 Log Message:
simplified test case Unterschiede (32 Zeilen): diff --git a/sql/test/BugTracker-2014/Tests/indices.Bug-3428.sql b/sql/test/BugTracker-2014/Tests/indices.Bug-3428.sql --- a/sql/test/BugTracker-2014/Tests/indices.Bug-3428.sql +++ b/sql/test/BugTracker-2014/Tests/indices.Bug-3428.sql @@ -1,13 +1,19 @@ START TRANSACTION; -CREATE TABLE TEST1 ( one VARCHAR(10) , two INT ) ; -CREATE TABLE TEST2 ( one VARCHAR(10) , two INT ) ; -INSERT INTO TEST1 VALUES ( 'a' , 1 ) ; -INSERT INTO TEST2 VALUES ( 'a' , 1 ) ; +CREATE TABLE TEST1 (ONE int, TWO INT) ; +CREATE TABLE TEST2 (ONE int, TWO INT) ; +INSERT INTO TEST1 VALUES (1, 1) ; +INSERT INTO TEST2 VALUES (1, 1) ; -SELECT count(*) FROM ( SELECT one , two FROM TEST1 ) AS a INNER JOIN ( SELECT one , two FROM TEST2 ) AS B on A.one = B.one AND A.two = B.two ; +-- all is well +SELECT COUNT(*) FROM TEST1 JOIN TEST2 USING(ONE, TWO); -CREATE INDEX onedex ON TEST1 ( one , two ) ; +CREATE INDEX ONEDEX ON TEST1 (ONE, TWO); +-- no results? +SELECT COUNT(*) FROM TEST1 JOIN TEST2 USING(ONE, TWO); -SELECT count(*) FROM ( SELECT one , two FROM TEST1 ) AS a INNER JOIN ( SELECT one , two FROM TEST2 ) AS B on A.one = B.one AND A.two = B.two ; -ROLLBACK; \ No newline at end of file +DROP INDEX ONEDEX; +-- all is well again +SELECT COUNT(*) FROM TEST1 JOIN TEST2 USING(ONE, TWO); + +ROLLBACK; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list