Changeset: 1dfda8113e6e for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1dfda8113e6e Added Files: sql/test/mergetables/Tests/mergekey.sql Modified Files: sql/test/mergetables/Tests/All Branch: default Log Message:
Another mergetable crash diffs (46 lines): diff --git a/sql/test/mergetables/Tests/All b/sql/test/mergetables/Tests/All --- a/sql/test/mergetables/Tests/All +++ b/sql/test/mergetables/Tests/All @@ -2,9 +2,10 @@ mergeinit mergeload mergequery emptymergequery -altertable +alter types forex #mergedrop corrupts the database +#mergekey crashes based on select #crash0 crashes the server diff --git a/sql/test/mergetables/Tests/mergekey.sql b/sql/test/mergetables/Tests/mergekey.sql new file mode 100644 --- /dev/null +++ b/sql/test/mergetables/Tests/mergekey.sql @@ -0,0 +1,26 @@ +CREATE TABLE part1 ( x double, y double, z double); +ALTER TABLE part1 ADD PRIMARY KEY (x,y,z); +COPY 4 RECORDS INTO part1 FROM stdin USING DELIMITERS ' ','\n'; +0.0 0.0 0.0 +1.0 0.0 0.0 +0.0 1.0 0.0 +1.0 1.0 0.0 + +CREATE TABLE part2 ( x double, y double, z double); +COPY 4 RECORDS INTO part2 FROM stdin USING DELIMITERS ' ','\n'; +2.0 0.0 0.0 +3.0 0.0 0.0 +2.0 1.0 0.0 +3.0 1.0 0.0 + +CREATE MERGE TABLE complete ( x double, y double, z double); + +ALTER TABLE complete ADD PRIMARY KEY (x,y,z); +ALTER TABLE complete ADD TABLE part1; +ALTER TABLE complete ADD TABLE part2; + +SELECT * FROM COMPLETE; + +DROP TABLE complete; +DROP TABLE part1; +DROP TABLE part2; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
