Changeset: 1b0dd20a2329 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1b0dd20a2329
Added Files:
sql/test/Tests/bincopy_ints_on_client.SQL.py
sql/test/Tests/bincopy_ints_on_client.stable.err
sql/test/Tests/bincopy_ints_on_client.stable.out
sql/test/Tests/bincopy_ints_on_server.SQL.py
sql/test/Tests/bincopy_ints_on_server.stable.err
sql/test/Tests/bincopy_ints_on_server.stable.out
sql/test/Tests/bincopy_large_strings_on_client.SQL.py
sql/test/Tests/bincopy_large_strings_on_client.stable.err
sql/test/Tests/bincopy_large_strings_on_client.stable.out
sql/test/Tests/bincopy_large_strings_on_server.SQL.py
sql/test/Tests/bincopy_large_strings_on_server.stable.err
sql/test/Tests/bincopy_large_strings_on_server.stable.out
sql/test/Tests/bincopy_more_ints_on_client.SQL.py
sql/test/Tests/bincopy_more_ints_on_client.stable.err
sql/test/Tests/bincopy_more_ints_on_client.stable.out
sql/test/Tests/bincopy_more_ints_on_server.SQL.py
sql/test/Tests/bincopy_more_ints_on_server.stable.err
sql/test/Tests/bincopy_more_ints_on_server.stable.out
sql/test/Tests/bincopy_null_ints_on_client.SQL.py
sql/test/Tests/bincopy_null_ints_on_client.stable.err
sql/test/Tests/bincopy_null_ints_on_client.stable.out
sql/test/Tests/bincopy_null_ints_on_server.SQL.py
sql/test/Tests/bincopy_null_ints_on_server.stable.err
sql/test/Tests/bincopy_null_ints_on_server.stable.out
sql/test/Tests/bincopy_strings_on_client.SQL.py
sql/test/Tests/bincopy_strings_on_client.stable.err
sql/test/Tests/bincopy_strings_on_client.stable.out
sql/test/Tests/bincopy_strings_on_server.SQL.py
sql/test/Tests/bincopy_strings_on_server.stable.err
sql/test/Tests/bincopy_strings_on_server.stable.out
sql/test/Tests/bincopy_support.py
Modified Files:
sql/test/Tests/All
Branch: copybinary
Log Message:
Add some tests
diffs (truncated from 797 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
@@ -129,3 +129,13 @@ HAVE_PYMONETDB&HAVE_LIBLZMA?hot_snapshot
HAVE_PYTHON_LZ4&HAVE_PYMONETDB&HAVE_LIBLZ4?hot_snapshot_lz4
!HAVE_PYTHON_LZ4&HAVE_PYMONETDB&HAVE_LIBLZ4?hot_snapshot_lz4_lite
+bincopy_ints_on_client
+bincopy_ints_on_server
+bincopy_more_ints_on_client
+bincopy_more_ints_on_server
+bincopy_strings_on_client
+bincopy_strings_on_server
+bincopy_null_ints_on_client
+bincopy_null_ints_on_server
+bincopy_large_strings_on_client
+bincopy_large_strings_on_server
diff --git a/sql/test/Tests/bincopy_ints_on_client.SQL.py
b/sql/test/Tests/bincopy_ints_on_client.SQL.py
new file mode 100644
--- /dev/null
+++ b/sql/test/Tests/bincopy_ints_on_client.SQL.py
@@ -0,0 +1,6 @@
+#!/usr/bin/env python3
+
+from bincopy_support import run_test
+from bincopy_support import INTS as testcode
+
+run_test('client', testcode)
diff --git a/sql/test/Tests/bincopy_ints_on_client.stable.err
b/sql/test/Tests/bincopy_ints_on_client.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/test/Tests/bincopy_ints_on_client.stable.err
@@ -0,0 +1,17 @@
+stderr of test 'bincopy_ints_on_client` in directory 'sql/test` itself:
+
+
+# 14:42:27 >
+# 14:42:27 > "/usr/bin/python3.7" "bincopy_ints_on_client.SQL.py"
"bincopy_ints_on_client"
+# 14:42:27 >
+
+
+# 14:42:27 >
+# 14:42:27 > mclient -lsql -ftest -tnone -Eutf-8 -i -e
--host=/var/tmp/mtest-3583 --port=38888 --database=mTests_sql_test
+# 14:42:27 >
+
+
+# 14:42:27 >
+# 14:42:27 > "Done."
+# 14:42:27 >
+
diff --git a/sql/test/Tests/bincopy_ints_on_client.stable.out
b/sql/test/Tests/bincopy_ints_on_client.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/test/Tests/bincopy_ints_on_client.stable.out
@@ -0,0 +1,28 @@
+stdout of test 'bincopy_ints_on_client` in directory 'sql/test` itself:
+
+
+# 14:42:27 >
+# 14:42:27 > "/usr/bin/python3.7" "bincopy_ints_on_client.SQL.py"
"bincopy_ints_on_client"
+# 14:42:27 >
+
+
+# 14:46:09 >
+# 14:46:09 > mclient -lsql -ftest -tnone -Eutf-8 -i -e
--host=/var/tmp/mtest-5052 --port=30365 --database=mTests_sql_test
+# 14:46:09 >
+
+#START TRANSACTION;
+#CREATE TABLE foo(id INT NOT NULL);
+#COPY BINARY INTO foo(id) FROM
R'/home/jvr/monets/copybinary/inst/mTests/sql/test/bincopy_ints.bin' ON CLIENT;
+[ 1000000 ]
+#SELECT COUNT(DISTINCT id) FROM foo;
+% sys.%1 # table_name
+% %1 # name
+% bigint # type
+% 7 # length
+[ 1000000 ]
+#ROLLBACK;
+
+# 14:42:27 >
+# 14:42:27 > "Done."
+# 14:42:27 >
+
diff --git a/sql/test/Tests/bincopy_ints_on_server.SQL.py
b/sql/test/Tests/bincopy_ints_on_server.SQL.py
new file mode 100644
--- /dev/null
+++ b/sql/test/Tests/bincopy_ints_on_server.SQL.py
@@ -0,0 +1,6 @@
+#!/usr/bin/env python3
+
+from bincopy_support import run_test
+from bincopy_support import INTS as testcode
+
+run_test('server', testcode)
diff --git a/sql/test/Tests/bincopy_ints_on_server.stable.err
b/sql/test/Tests/bincopy_ints_on_server.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/test/Tests/bincopy_ints_on_server.stable.err
@@ -0,0 +1,17 @@
+stderr of test 'bincopy_ints_on_server` in directory 'sql/test` itself:
+
+
+# 14:48:58 >
+# 14:48:58 > "/usr/bin/python3.7" "bincopy_ints_on_server.SQL.py"
"bincopy_ints_on_server"
+# 14:48:58 >
+
+
+# 14:48:58 >
+# 14:48:58 > mclient -lsql -ftest -tnone -Eutf-8 -i -e
--host=/var/tmp/mtest-6576 --port=34193 --database=mTests_sql_test
+# 14:48:58 >
+
+
+# 14:48:59 >
+# 14:48:59 > "Done."
+# 14:48:59 >
+
diff --git a/sql/test/Tests/bincopy_ints_on_server.stable.out
b/sql/test/Tests/bincopy_ints_on_server.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/test/Tests/bincopy_ints_on_server.stable.out
@@ -0,0 +1,28 @@
+stdout of test 'bincopy_ints_on_server` in directory 'sql/test` itself:
+
+
+# 14:48:58 >
+# 14:48:58 > "/usr/bin/python3.7" "bincopy_ints_on_server.SQL.py"
"bincopy_ints_on_server"
+# 14:48:58 >
+
+
+# 14:48:58 >
+# 14:48:58 > mclient -lsql -ftest -tnone -Eutf-8 -i -e
--host=/var/tmp/mtest-6576 --port=34193 --database=mTests_sql_test
+# 14:48:58 >
+
+#START TRANSACTION;
+#CREATE TABLE foo(id INT NOT NULL);
+#COPY BINARY INTO foo(id) FROM
R'/home/jvr/monets/copybinary/inst/mTests/sql/test/bincopy_ints.bin' ON SERVER;
+[ 1000000 ]
+#SELECT COUNT(DISTINCT id) FROM foo;
+% sys.%1 # table_name
+% %1 # name
+% bigint # type
+% 7 # length
+[ 1000000 ]
+#ROLLBACK;
+
+# 14:48:59 >
+# 14:48:59 > "Done."
+# 14:48:59 >
+
diff --git a/sql/test/Tests/bincopy_large_strings_on_client.SQL.py
b/sql/test/Tests/bincopy_large_strings_on_client.SQL.py
new file mode 100644
--- /dev/null
+++ b/sql/test/Tests/bincopy_large_strings_on_client.SQL.py
@@ -0,0 +1,6 @@
+#!/usr/bin/env python3
+
+from bincopy_support import run_test
+from bincopy_support import LARGE_STRINGS as testcode
+
+run_test('client', testcode)
diff --git a/sql/test/Tests/bincopy_large_strings_on_client.stable.err
b/sql/test/Tests/bincopy_large_strings_on_client.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/test/Tests/bincopy_large_strings_on_client.stable.err
@@ -0,0 +1,12 @@
+stderr of test 'bincopy_large_strings_on_client` in directory 'sql/test`
itself:
+
+
+# 15:49:34 >
+# 15:49:34 > "/usr/bin/python3.7" "bincopy_large_strings_on_client.SQL.py"
"bincopy_large_strings_on_client"
+# 15:49:34 >
+
+
+# 15:49:34 >
+# 15:49:34 > "Done."
+# 15:49:34 >
+
diff --git a/sql/test/Tests/bincopy_large_strings_on_client.stable.out
b/sql/test/Tests/bincopy_large_strings_on_client.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/test/Tests/bincopy_large_strings_on_client.stable.out
@@ -0,0 +1,30 @@
+stdout of test 'bincopy_large_strings_on_client` in directory 'sql/test`
itself:
+
+
+# 15:49:34 >
+# 15:49:34 > "/usr/bin/python3.7" "bincopy_large_strings_on_client.SQL.py"
"bincopy_large_strings_on_client"
+# 15:49:34 >
+
+
+# 16:32:51 >
+# 16:32:51 > mclient -lsql -ftest -tnone -Eutf-8 -i -e
--host=/var/tmp/mtest-29127 --port=39795 --database=mTests_sql_test
+# 16:32:51 >
+
+#START TRANSACTION;
+#CREATE TABLE foo(id INT NOT NULL, s TEXT);
+#COPY BINARY INTO foo(id, s) FROM
R'/home/jvr/monets/copybinary/inst/mTests/sql/test/bincopy_ints.bin',
R'/home/jvr/monets/copybinary/inst/mTests/sql/test/bincopy_large_strings.bin'
ON CLIENT;
+[ 1000000 ]
+#SELECT COUNT(id) FROM foo
+#WHERE (id % 10000 <> 0 AND LENGTH(s) = 9)
+#OR (id % 10000 = 0 AND LENGTH(s) = 280000 + 9);
+% sys.%1 # table_name
+% %1 # name
+% bigint # type
+% 7 # length
+[ 1000000 ]
+#ROLLBACK;
+
+# 16:32:52 >
+# 16:32:52 > "Done."
+# 16:32:52 >
+
diff --git a/sql/test/Tests/bincopy_large_strings_on_server.SQL.py
b/sql/test/Tests/bincopy_large_strings_on_server.SQL.py
new file mode 100644
--- /dev/null
+++ b/sql/test/Tests/bincopy_large_strings_on_server.SQL.py
@@ -0,0 +1,6 @@
+#!/usr/bin/env python3
+
+from bincopy_support import run_test
+from bincopy_support import LARGE_STRINGS as testcode
+
+run_test('server', testcode)
diff --git a/sql/test/Tests/bincopy_large_strings_on_server.stable.err
b/sql/test/Tests/bincopy_large_strings_on_server.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/test/Tests/bincopy_large_strings_on_server.stable.err
@@ -0,0 +1,17 @@
+stderr of test 'bincopy_large_strings_on_server` in directory 'sql/test`
itself:
+
+
+# 16:33:55 >
+# 16:33:55 > "/usr/bin/python3.7" "bincopy_large_strings_on_server.SQL.py"
"bincopy_large_strings_on_server"
+# 16:33:55 >
+
+
+# 16:33:56 >
+# 16:33:56 > mclient -lsql -ftest -tnone -Eutf-8 -i -e
--host=/var/tmp/mtest-30104 --port=35185 --database=mTests_sql_test
+# 16:33:56 >
+
+
+# 16:33:57 >
+# 16:33:57 > "Done."
+# 16:33:57 >
+
diff --git a/sql/test/Tests/bincopy_large_strings_on_server.stable.out
b/sql/test/Tests/bincopy_large_strings_on_server.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/test/Tests/bincopy_large_strings_on_server.stable.out
@@ -0,0 +1,30 @@
+stdout of test 'bincopy_large_strings_on_server` in directory 'sql/test`
itself:
+
+
+# 16:33:55 >
+# 16:33:55 > "/usr/bin/python3.7" "bincopy_large_strings_on_server.SQL.py"
"bincopy_large_strings_on_server"
+# 16:33:55 >
+
+
+# 16:33:56 >
+# 16:33:56 > mclient -lsql -ftest -tnone -Eutf-8 -i -e
--host=/var/tmp/mtest-30104 --port=35185 --database=mTests_sql_test
+# 16:33:56 >
+
+#START TRANSACTION;
+#CREATE TABLE foo(id INT NOT NULL, s TEXT);
+#COPY BINARY INTO foo(id, s) FROM
R'/home/jvr/monets/copybinary/inst/mTests/sql/test/bincopy_ints.bin',
R'/home/jvr/monets/copybinary/inst/mTests/sql/test/bincopy_large_strings.bin'
ON SERVER;
+[ 1000000 ]
+#SELECT COUNT(id) FROM foo
+#WHERE (id % 10000 <> 0 AND LENGTH(s) = 9)
+#OR (id % 10000 = 0 AND LENGTH(s) = 280000 + 9);
+% sys.%1 # table_name
+% %1 # name
+% bigint # type
+% 7 # length
+[ 1000000 ]
+#ROLLBACK;
+
+# 16:33:57 >
+# 16:33:57 > "Done."
+# 16:33:57 >
+
diff --git a/sql/test/Tests/bincopy_more_ints_on_client.SQL.py
b/sql/test/Tests/bincopy_more_ints_on_client.SQL.py
new file mode 100644
--- /dev/null
+++ b/sql/test/Tests/bincopy_more_ints_on_client.SQL.py
@@ -0,0 +1,6 @@
+#!/usr/bin/env python3
+
+from bincopy_support import run_test
+from bincopy_support import MORE_INTS as testcode
+
+run_test('client', testcode)
diff --git a/sql/test/Tests/bincopy_more_ints_on_client.stable.err
b/sql/test/Tests/bincopy_more_ints_on_client.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/test/Tests/bincopy_more_ints_on_client.stable.err
@@ -0,0 +1,17 @@
+stderr of test 'bincopy_more_ints_on_client` in directory 'sql/test` itself:
+
+
+# 15:16:53 >
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
