Changeset: 47206a616d1d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=47206a616d1d Modified Files: sql/test/copy/Tests/columns.test Branch: mtest Log Message:
corrected test diffs (87 lines): diff --git a/sql/test/copy/Tests/columns.test b/sql/test/copy/Tests/columns.test --- a/sql/test/copy/Tests/columns.test +++ b/sql/test/copy/Tests/columns.test @@ -2,36 +2,71 @@ statement ok create table tbl (i int, s string, d decimal(5, 2)) statement error -copy 3 records into tbl (i, d) from stdin delimiters ',',E'\n' +copy 3 records into tbl (i, d) from stdin using delimiters ',',E'\n' <COPY_INTO_DATA> 1,2.0 2,2.1 3,2.2 -select * from tbl; -drop table tbl; + -statement error -create table tbl (i int, s string, d decimal(5, 2)) +query ITT nosort +select * from tbl; +---- statement ok -copy 3 records into tbl (i, d) from stdin delimiters ',',E'\n' -<COPY_INTO_DATA> -1,"test",2.0 -2,"test1",2.1 -3,"test",2.2 -select * from tbl; drop table tbl; statement ok create table tbl (i int, s string, d decimal(5, 2)) statement ok -copy 3 records into tbl (i, d) from stdin (i, d) delimiters ',',E'\n' +copy 3 records into tbl (i, d) from stdin using delimiters ',',E'\n' +<COPY_INTO_DATA> +1,"test",2.0 +2,"test1",2.1 +3,"test",2.2 + + +query ITT nosort +select * from tbl; +---- +1 +NULL +2.00 +2 +NULL +2.10 +3 +NULL +2.20 + +statement ok +drop table tbl; + +statement ok +create table tbl (i int, s string, d decimal(5, 2)) + +statement ok +copy 3 records into tbl (i, d) from stdin (i, d) using delimiters ',',E'\n' <COPY_INTO_DATA> 1,2.0 2,2.1 3,2.2 + +query ITT nosort select * from tbl; +---- +1 +NULL +2.00 +2 +NULL +2.10 +3 +NULL +2.20 + +statement ok drop table tbl; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
