Changeset: b0ac6b2b2506 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b0ac6b2b2506
Added Files:
sql/test/pg_regress/Tests/oid.stable.err.32bit
sql/test/pg_regress/Tests/oid.stable.err.int128
Modified Files:
sql/test/pg_regress/Tests/oid.stable.err
Branch: Jul2015
Log Message:
Approve special outputs.
diffs (194 lines):
diff --git a/sql/test/pg_regress/Tests/oid.stable.err
b/sql/test/pg_regress/Tests/oid.stable.err
--- a/sql/test/pg_regress/Tests/oid.stable.err
+++ b/sql/test/pg_regress/Tests/oid.stable.err
@@ -1,11 +1,11 @@
stderr of test 'oid` in directory 'sql/test/pg_regress` itself:
-# 17:11:18 >
-# 17:11:18 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=38959" "--set"
"mapi_usock=/var/tmp/mtest-1142/.s.monetdb.38959" "--set" "monet_prompt="
"--forcemito" "--set" "mal_listing=2"
"--dbpath=/ufs/dinther/INSTALL/var/MonetDB/mTests_sql_test_pg_regress" "--set"
"mal_listing=0"
-# 17:11:18 >
+# 13:47:46 >
+# 13:47:46 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=38887" "--set"
"mapi_usock=/var/tmp/mtest-7019/.s.monetdb.38887" "--set" "monet_prompt="
"--forcemito" "--set" "mal_listing=2"
"--dbpath=/ufs/sjoerd/Monet-stable/var/MonetDB/mTests_sql_test_pg_regress"
"--set" "mal_listing=0" "--set" "embedded_r=yes"
+# 13:47:46 >
-# builtin opt gdk_dbpath = /ufs/dinther/INSTALL/var/monetdb5/dbfarm/demo
+# builtin opt gdk_dbpath = /ufs/sjoerd/Monet-stable/var/monetdb5/dbfarm/demo
# builtin opt gdk_debug = 0
# builtin opt gdk_vmtrim = no
# builtin opt monet_prompt = >
@@ -17,59 +17,62 @@ stderr of test 'oid` in directory 'sql/t
# builtin opt sql_debug = 0
# cmdline opt gdk_nr_threads = 0
# cmdline opt mapi_open = true
-# cmdline opt mapi_port = 38959
-# cmdline opt mapi_usock = /var/tmp/mtest-1142/.s.monetdb.38959
+# cmdline opt mapi_port = 38887
+# cmdline opt mapi_usock = /var/tmp/mtest-7019/.s.monetdb.38887
# cmdline opt monet_prompt =
# cmdline opt mal_listing = 2
-# cmdline opt gdk_dbpath =
/ufs/dinther/INSTALL/var/MonetDB/mTests_sql_test_pg_regress
+# cmdline opt gdk_dbpath =
/ufs/sjoerd/Monet-stable/var/MonetDB/mTests_sql_test_pg_regress
# cmdline opt mal_listing = 0
+# cmdline opt embedded_r = yes
# cmdline opt gdk_debug = 536870922
-# 15:18:43 >
-# 15:18:43 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-7372" "--port=31804"
-# 15:18:43 >
+# 13:47:46 >
+# 13:47:46 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-7019" "--port=38887"
+# 13:47:46 >
-MAPI = (monetdb) /var/tmp/mtest-17898/.s.monetdb.31237
+MAPI = (monetdb) /var/tmp/mtest-7019/.s.monetdb.38887
QUERY = INSERT INTO OID_TBL(f1) VALUES ('asdfasd');
ERROR = !conversion of string 'asdfasd' to type oid failed.
-MAPI = (monetdb) /var/tmp/mtest-17898/.s.monetdb.31237
+MAPI = (monetdb) /var/tmp/mtest-7019/.s.monetdb.38887
QUERY = INSERT INTO OID_TBL(f1) VALUES ('99asdfasd');
ERROR = !conversion of string '99asdfasd' to type oid failed.
-MAPI = (monetdb) /var/tmp/mtest-17898/.s.monetdb.31237
+MAPI = (monetdb) /var/tmp/mtest-7019/.s.monetdb.38887
QUERY = INSERT INTO OID_TBL(f1) VALUES ('5 d');
ERROR = !conversion of string '5 d' to type oid failed.
-MAPI = (monetdb) /var/tmp/mtest-17898/.s.monetdb.31237
+MAPI = (monetdb) /var/tmp/mtest-7019/.s.monetdb.38887
QUERY = INSERT INTO OID_TBL(f1) VALUES (' 5d');
ERROR = !conversion of string ' 5d' to type oid failed.
-MAPI = (monetdb) /var/tmp/mtest-17898/.s.monetdb.31237
+MAPI = (monetdb) /var/tmp/mtest-7019/.s.monetdb.38887
QUERY = INSERT INTO OID_TBL(f1) VALUES ('5 5');
ERROR = !conversion of string '5 5' to type oid failed.
-MAPI = (monetdb) /var/tmp/mtest-17898/.s.monetdb.31237
+MAPI = (monetdb) /var/tmp/mtest-7019/.s.monetdb.38887
QUERY = INSERT INTO OID_TBL(f1) VALUES (-10); -- negative oids are not
allowed in MonetDB, so this should fail
ERROR = !overflow in conversion of -10 to oid.
-MAPI = (monetdb) /var/tmp/mtest-17898/.s.monetdb.31237
+MAPI = (monetdb) /var/tmp/mtest-7019/.s.monetdb.38887
QUERY = INSERT INTO OID_TBL(f1) VALUES (-1040); -- negative oids are not
allowed in MonetDB, so this should fail
ERROR = !overflow in conversion of -1040 to oid.
-MAPI = (monetdb) /var/tmp/mtest-17898/.s.monetdb.31237
+MAPI = (monetdb) /var/tmp/mtest-7019/.s.monetdb.38887
QUERY = INSERT INTO OID_TBL(f1) VALUES ('-1040'); -- negative oids are not
allowed in MonetDB, so this should fail
ERROR = !conversion of string '-1040' to type oid failed.
-MAPI = (monetdb) /var/tmp/mtest-17898/.s.monetdb.31237
+MAPI = (monetdb) /var/tmp/mtest-7019/.s.monetdb.38887
QUERY = INSERT INTO OID_TBL(f1) VALUES (' - 500');
ERROR = !conversion of string ' - 500' to type oid failed.
-MAPI = (monetdb) /var/tmp/mtest-17898/.s.monetdb.31237
+MAPI = (monetdb) /var/tmp/mtest-7019/.s.monetdb.38887
QUERY = INSERT INTO OID_TBL(f1) VALUES ('32958209582039852935');
ERROR = !conversion of string '32958209582039852935' to type oid failed.
-MAPI = (monetdb) /var/tmp/mtest-17898/.s.monetdb.31237
+MAPI = (monetdb) /var/tmp/mtest-7019/.s.monetdb.38887
QUERY = INSERT INTO OID_TBL(f1) VALUES (32958209582039852935);
-ERROR = !overflow in conversion of 32958209582039851008 to lng.
-MAPI = (monetdb) /var/tmp/mtest-17898/.s.monetdb.31237
+ERROR = !integer value too large or not a number (32958209582039852935) in:
"insert into oid_tbl(f1) values (32958209582039852935"
+ !syntax error, unexpected ')' in: ")"
+MAPI = (monetdb) /var/tmp/mtest-7019/.s.monetdb.38887
QUERY = INSERT INTO OID_TBL(f1) VALUES ('-23582358720398502385');
ERROR = !conversion of string '-23582358720398502385' to type oid failed.
-MAPI = (monetdb) /var/tmp/mtest-17898/.s.monetdb.31237
+MAPI = (monetdb) /var/tmp/mtest-7019/.s.monetdb.38887
QUERY = INSERT INTO OID_TBL(f1) VALUES (-23582358720398502385);
-ERROR = !overflow in conversion of -23582358720398503936 to lng.
+ERROR = !integer value too large or not a number (23582358720398502385) in:
"insert into oid_tbl(f1) values (-23582358720398502385"
+ !syntax error, unexpected ')' in: ")"
-# 16:41:57 >
-# 16:41:57 > "Done."
-# 16:41:57 >
+# 13:47:46 >
+# 13:47:46 > "Done."
+# 13:47:46 >
diff --git a/sql/test/pg_regress/Tests/oid.stable.err.32bit
b/sql/test/pg_regress/Tests/oid.stable.err.32bit
new file mode 100644
--- /dev/null
+++ b/sql/test/pg_regress/Tests/oid.stable.err.32bit
@@ -0,0 +1,80 @@
+stderr of test 'oid` in directory 'sql/test/pg_regress` itself:
+
+
+# 17:11:18 >
+# 17:11:18 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=38959" "--set"
"mapi_usock=/var/tmp/mtest-1142/.s.monetdb.38959" "--set" "monet_prompt="
"--forcemito" "--set" "mal_listing=2"
"--dbpath=/ufs/dinther/INSTALL/var/MonetDB/mTests_sql_test_pg_regress" "--set"
"mal_listing=0"
+# 17:11:18 >
+
+# builtin opt gdk_dbpath = /ufs/dinther/INSTALL/var/monetdb5/dbfarm/demo
+# builtin opt gdk_debug = 0
+# builtin opt gdk_vmtrim = no
+# builtin opt monet_prompt = >
+# builtin opt monet_daemon = no
+# builtin opt mapi_port = 50000
+# builtin opt mapi_open = false
+# builtin opt mapi_autosense = false
+# builtin opt sql_optimizer = default_pipe
+# builtin opt sql_debug = 0
+# cmdline opt gdk_nr_threads = 0
+# cmdline opt mapi_open = true
+# cmdline opt mapi_port = 38959
+# cmdline opt mapi_usock = /var/tmp/mtest-1142/.s.monetdb.38959
+# cmdline opt monet_prompt =
+# cmdline opt mal_listing = 2
+# cmdline opt gdk_dbpath =
/ufs/dinther/INSTALL/var/MonetDB/mTests_sql_test_pg_regress
+# cmdline opt mal_listing = 0
+# cmdline opt gdk_debug = 536870922
+
+# 15:18:43 >
+# 15:18:43 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-7372" "--port=31804"
+# 15:18:43 >
+
+MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+QUERY = INSERT INTO OID_TBL(f1) VALUES (12345678901);
+ERROR = !overflow in conversion of 12345678901 to oid.
+MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+QUERY = INSERT INTO OID_TBL(f1) VALUES ('asdfasd');
+ERROR = !conversion of string 'asdfasd' to type oid failed.
+MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+QUERY = INSERT INTO OID_TBL(f1) VALUES ('99asdfasd');
+ERROR = !conversion of string '99asdfasd' to type oid failed.
+MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+QUERY = INSERT INTO OID_TBL(f1) VALUES ('5 d');
+ERROR = !conversion of string '5 d' to type oid failed.
+MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+QUERY = INSERT INTO OID_TBL(f1) VALUES (' 5d');
+ERROR = !conversion of string ' 5d' to type oid failed.
+MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+QUERY = INSERT INTO OID_TBL(f1) VALUES ('5 5');
+ERROR = !conversion of string '5 5' to type oid failed.
+MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+QUERY = INSERT INTO OID_TBL(f1) VALUES (-10); -- negative oids are not
allowed in MonetDB, so this should fail
+ERROR = !overflow in conversion of -10 to oid.
+MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+QUERY = INSERT INTO OID_TBL(f1) VALUES (-1040); -- negative oids are not
allowed in MonetDB, so this should fail
+ERROR = !overflow in conversion of -1040 to oid.
+MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+QUERY = INSERT INTO OID_TBL(f1) VALUES ('-1040'); -- negative oids are not
allowed in MonetDB, so this should fail
+ERROR = !conversion of string '-1040' to type oid failed.
+MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+QUERY = INSERT INTO OID_TBL(f1) VALUES (' - 500');
+ERROR = !conversion of string ' - 500' to type oid failed.
+MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+QUERY = INSERT INTO OID_TBL(f1) VALUES ('32958209582039852935');
+ERROR = !conversion of string '32958209582039852935' to type oid failed.
+MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+QUERY = INSERT INTO OID_TBL(f1) VALUES (32958209582039852935);
+ERROR = !integer value too large or not a number (32958209582039852935) in:
"insert into oid_tbl(f1) values (32958209582039852935"
+ !syntax error, unexpected ')' in: ")"
+MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+QUERY = INSERT INTO OID_TBL(f1) VALUES ('-23582358720398502385');
+ERROR = !conversion of string '-23582358720398502385' to type oid failed.
+MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+QUERY = INSERT INTO OID_TBL(f1) VALUES (-23582358720398502385);
+ERROR = !integer value too large or not a number (23582358720398502385) in:
"insert into oid_tbl(f1) values (-23582358720398502385"
+ !syntax error, unexpected ')' in: ")"
+
+# 16:41:57 >
+# 16:41:57 > "Done."
+# 16:41:57 >
+
diff --git a/sql/test/pg_regress/Tests/oid.stable.err
b/sql/test/pg_regress/Tests/oid.stable.err.int128
copy from sql/test/pg_regress/Tests/oid.stable.err
copy to sql/test/pg_regress/Tests/oid.stable.err.int128
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
