Changeset: a66e4659af96 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a66e4659af96 Added Files: sql/test/copy/Tests/aapnootmies.csv sql/test/copy/Tests/select-from-file.test.in Modified Files: sql/test/copy/Tests/All Branch: Dec2023 Log Message:
Add some tests for SELECT FROM file diffs (81 lines): diff --git a/sql/test/copy/Tests/All b/sql/test/copy/Tests/All --- a/sql/test/copy/Tests/All +++ b/sql/test/copy/Tests/All @@ -16,3 +16,4 @@ columns no_escape no_escape2 crlf_normalization +select-from-file diff --git a/sql/test/copy/Tests/aapnootmies.csv b/sql/test/copy/Tests/aapnootmies.csv new file mode 100644 --- /dev/null +++ b/sql/test/copy/Tests/aapnootmies.csv @@ -0,0 +1,3 @@ +1|aap +2|noot +3|mies diff --git a/sql/test/copy/Tests/select-from-file.test.in b/sql/test/copy/Tests/select-from-file.test.in new file mode 100644 --- /dev/null +++ b/sql/test/copy/Tests/select-from-file.test.in @@ -0,0 +1,60 @@ +query IT rowsort +SELECT * FROM R'$TSTSRCDIR/aapnootmies.csv'; +---- +1 +aap +2 +noot +3 +mies + +statement ok +DROP TABLE IF EXISTS foo; + +statement ok +CREATE TABLE foo(i INT, t TEXT); + +statement ok +INSERT INTO foo SELECT * FROM R'$TSTSRCDIR/aapnootmies.csv'; + +query IT rowsort +SELECT * FROM foo; +---- +1 +aap +2 +noot +3 +mies + +query IT nosort +SELECT * FROM R'$TSTSRCDIR/aapnootmies.csv' ORDER BY name_1; +---- +1 +aap +3 +mies +2 +noot + +query IT nosort +SELECT * FROM R'$TSTSRCDIR/aapnootmies.csv' WHERE name_1 = 'aap'; +---- +1 +aap + +query IT rowsort +SELECT * FROM R'$TSTSRCDIR/aapnootmies.csv' GROUP BY name_1; +---- +1 +aap +3 +mies +2 +noot + +query IT nosort +SELECT * FROM R'$TSTSRCDIR/aapnootmies.csv' a WHERE a.name_1 = 'aap'; +---- +1 +aap _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
