Changeset: eed2975df8f9 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=eed2975df8f9 Added Files: sql/test/BugTracker-2014/Tests/indices.Bug-3428.sql Branch: Jan2014 Log Message:
Test for bug 3435 Unterschiede (19 Zeilen): diff --git a/sql/test/BugTracker-2014/Tests/indices.Bug-3428.sql b/sql/test/BugTracker-2014/Tests/indices.Bug-3428.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2014/Tests/indices.Bug-3428.sql @@ -0,0 +1,13 @@ +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 ) ; + +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 ; + +CREATE INDEX onedex ON TEST1 ( 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 _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list