Changeset: 327fd2fb02d5 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/327fd2fb02d5
Added Files:
sql/test/bincopy/Tests/be123.bin
sql/test/bincopy/Tests/be456.bin
sql/test/bincopy/Tests/bincopy_decimal_range.test.in
sql/test/bincopy/Tests/bincopy_string_width.test.in
sql/test/bincopy/Tests/bincopycollist-prepare.py
sql/test/bincopy/Tests/bincopycollist.reqtests
sql/test/bincopy/Tests/bincopycollist.test.in
sql/test/bincopy/Tests/maxint.bin
sql/test/bincopy/Tests/strings.bin
Removed Files:
sql/test/Tests/bincopycollist-prepare.py
sql/test/Tests/bincopycollist.reqtests
sql/test/Tests/bincopycollist.test.in
Modified Files:
sql/test/Tests/All
sql/test/bincopy/Tests/All
Branch: copyintobinary
Log Message:
COPY BINARY tests
diffs (truncated from 375 to 300 lines):
diff --git a/sql/test/Tests/All b/sql/test/Tests/All
--- a/sql/test/Tests/All
+++ b/sql/test/Tests/All
@@ -6,9 +6,6 @@ comment-on
comment-auth-1
USER=user_a&PASSWD=user_a?comment-auth-2
-bincopycollist-prepare
-bincopycollist
-
example
#example-queries
#example-drop
diff --git a/sql/test/Tests/bincopycollist.test.in
b/sql/test/Tests/bincopycollist.test.in
deleted file mode 100644
--- a/sql/test/Tests/bincopycollist.test.in
+++ /dev/null
@@ -1,47 +0,0 @@
-statement ok
-START TRANSACTION
-
-statement ok
-CREATE TABLE intvals (x INTEGER, y INTEGER, z INTEGER)
-
-statement ok
-COPY BINARY INTO intvals (x, y, z) FROM (E'$QTSTTRGDIR/bincopyint.bin',
E'$QTSTTRGDIR/bincopyint.bin', E'$QTSTTRGDIR/bincopyint.bin')
-
-statement ok
-COPY BINARY INTO intvals (z) FROM (E'$QTSTTRGDIR/bincopyint.bin')
-
-statement ok
-COPY BINARY INTO intvals (z, y) FROM (E'$QTSTTRGDIR/bincopyint.bin',
E'$QTSTTRGDIR/bincopyint.bin')
-
-query I nosort
-SELECT count(*) FROM intvals
-----
-30
-
-statement ok
-ROLLBACK
-
-statement ok
-START TRANSACTION
-
-statement ok
-CREATE TABLE intvals (x INTEGER, y INTEGER, z INTEGER)
-
-statement error
-COPY BINARY INTO intvals (x, x) FROM (E'$QTSTTRGDIR/bincopyint.bin',
E'$QTSTTRGDIR/bincopyint.bin')
-
-statement ok
-ROLLBACK
-
-statement ok
-START TRANSACTION
-
-statement ok
-CREATE TABLE intvals (x INTEGER, y INTEGER, z INTEGER)
-
-statement error
-COPY BINARY INTO intvals (a) FROM (E'$QTSTTRGDIR/bincopyint.bin')
-
-statement ok
-ROLLBACK
-
diff --git a/sql/test/bincopy/Tests/All b/sql/test/bincopy/Tests/All
--- a/sql/test/bincopy/Tests/All
+++ b/sql/test/bincopy/Tests/All
@@ -40,13 +40,17 @@ bincopy_json_objects_on_client
bincopy_json_objects_on_server
bincopy_uuids_on_client
bincopy_uuids_on_server
-
-bincopy_invalid_json
-bincopy_default_values
-
bincopy_little_endians_on_client
bincopy_little_endians_on_server
bincopy_big_endians_on_client
bincopy_big_endians_on_server
bincopy_native_endians_on_client
bincopy_native_endians_on_server
+
+bincopy_invalid_json
+bincopy_default_values
+bincopy_decimal_range
+bincopy_string_width
+
+bincopycollist-prepare
+bincopycollist
diff --git a/sql/test/bincopy/Tests/be123.bin b/sql/test/bincopy/Tests/be123.bin
new file mode 100644
index
0000000000000000000000000000000000000000..fce373f3a050d46ffd46722d2e0084ae6eb0cf79
GIT binary patch
literal 12
Rc${NkU|?imU|<4bW&i*p00#g7
diff --git a/sql/test/bincopy/Tests/be456.bin b/sql/test/bincopy/Tests/be456.bin
new file mode 100644
index
0000000000000000000000000000000000000000..9b34b1c4d9ae801754425898f971d35faa6d3a0e
GIT binary patch
literal 12
Rc${NkU|?ZjU|<DeHUI!m01yBG
diff --git a/sql/test/bincopy/Tests/bincopy_decimal_range.test.in
b/sql/test/bincopy/Tests/bincopy_decimal_range.test.in
new file mode 100644
--- /dev/null
+++ b/sql/test/bincopy/Tests/bincopy_decimal_range.test.in
@@ -0,0 +1,47 @@
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE foo(i INT)
+
+statement ok
+COPY BIG ENDIAN BINARY INTO foo FROM E'$QTSTSRCDIR/be123.bin'
+
+statement ok
+COPY BIG ENDIAN BINARY INTO foo FROM E'$QTSTSRCDIR/maxint.bin'
+
+query I nosort
+SELECT i FROM foo
+----
+1
+2
+3
+2147483647
+2147483647
+2147483647
+
+statement ok
+ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE foo(d DECIMAL(8,2))
+
+statement ok
+COPY BIG ENDIAN BINARY INTO foo FROM E'$QTSTSRCDIR/be123.bin'
+
+query T nosort
+SELECT CAST(d AS TEXT) FROM foo
+----
+0.01
+0.02
+0.03
+
+statement error
+COPY BIG ENDIAN BINARY INTO foo FROM E'$QTSTSRCDIR/maxint.bin'
+
+statement ok
+ROLLBACK
+
diff --git a/sql/test/bincopy/Tests/bincopy_string_width.test.in
b/sql/test/bincopy/Tests/bincopy_string_width.test.in
new file mode 100644
--- /dev/null
+++ b/sql/test/bincopy/Tests/bincopy_string_width.test.in
@@ -0,0 +1,49 @@
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE foo(t TEXT);
+
+statement ok
+COPY BIG ENDIAN BINARY INTO foo(t) FROM E'$QTSTSRCDIR/strings.bin'
+
+query T nosort
+SELECT t FROM foo
+----
+one
+two
+three
+
+statement ok
+ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE foo(t VARCHAR(5));
+
+statement ok
+COPY BIG ENDIAN BINARY INTO foo(t) FROM E'$QTSTSRCDIR/strings.bin'
+
+query T nosort
+SELECT t FROM foo
+----
+one
+two
+three
+
+statement ok
+ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE foo(t VARCHAR(4));
+
+statement error
+COPY BIG ENDIAN BINARY INTO foo(t) FROM E'$QTSTSRCDIR/strings.bin'
+
+statement ok
+ROLLBACK
diff --git a/sql/test/Tests/bincopycollist-prepare.py
b/sql/test/bincopy/Tests/bincopycollist-prepare.py
rename from sql/test/Tests/bincopycollist-prepare.py
rename to sql/test/bincopy/Tests/bincopycollist-prepare.py
diff --git a/sql/test/Tests/bincopycollist.reqtests
b/sql/test/bincopy/Tests/bincopycollist.reqtests
rename from sql/test/Tests/bincopycollist.reqtests
rename to sql/test/bincopy/Tests/bincopycollist.reqtests
diff --git a/sql/test/bincopy/Tests/bincopycollist.test.in
b/sql/test/bincopy/Tests/bincopycollist.test.in
new file mode 100644
--- /dev/null
+++ b/sql/test/bincopy/Tests/bincopycollist.test.in
@@ -0,0 +1,140 @@
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE intvals (x INTEGER, y INTEGER, z INTEGER)
+
+statement ok
+COPY BINARY INTO intvals (x, y, z) FROM (E'$QTSTTRGDIR/bincopyint.bin',
E'$QTSTTRGDIR/bincopyint.bin', E'$QTSTTRGDIR/bincopyint.bin')
+
+statement ok
+COPY BINARY INTO intvals (z) FROM (E'$QTSTTRGDIR/bincopyint.bin')
+
+statement ok
+COPY BINARY INTO intvals (z, y) FROM (E'$QTSTTRGDIR/bincopyint.bin',
E'$QTSTTRGDIR/bincopyint.bin')
+
+query I nosort
+SELECT count(*) FROM intvals
+----
+30
+
+statement ok
+ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE intvals(x INTEGER, y INTEGER);
+
+statement ok
+COPY BIG ENDIAN BINARY INTO intvals FROM (E'$QTSTSRCDIR/be123.bin',
E'$QTSTSRCDIR/be456.bin')
+
+statement ok
+COPY BIG ENDIAN BINARY INTO intvals(y, x) FROM (E'$QTSTSRCDIR/be123.bin',
E'$QTSTSRCDIR/be456.bin')
+
+query II nosort
+SELECT x, y FROM intvals
+----
+1
+4
+2
+5
+3
+6
+4
+1
+5
+2
+6
+3
+
+statement ok
+ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE intvals (x INTEGER, y INTEGER, z INTEGER)
+
+statement error
+COPY BINARY INTO intvals (x, x) FROM (E'$QTSTTRGDIR/bincopyint.bin',
E'$QTSTTRGDIR/bincopyint.bin')
+
+statement ok
+ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE intvals (x INTEGER, y INTEGER, z INTEGER)
+
+statement error
+COPY BINARY INTO intvals (a) FROM (E'$QTSTTRGDIR/bincopyint.bin')
+
+statement ok
+ROLLBACK
+
+
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
