Changeset: 42640f89cfeb for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=42640f89cfeb
Added Files:
sql/test/pg_regress/Tests/oid.stable.err.oid32
sql/test/pg_regress/Tests/oid.stable.out.oid32
sql/test/pg_regress/Tests/oid.stable.out.oid64
Branch: default
Log Message:
Adding oid32 and oid64 specific outputs
diffs (truncated from 586 to 300 lines):
diff --git a/sql/test/pg_regress/Tests/oid.stable.err.oid32
b/sql/test/pg_regress/Tests/oid.stable.err.oid32
new file mode 100644
--- /dev/null
+++ b/sql/test/pg_regress/Tests/oid.stable.err.oid32
@@ -0,0 +1,78 @@
+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-21793/.s.monetdb.32589
+QUERY = INSERT INTO OID_TBL(f1) VALUES (12345678901);
+ERROR = !overflow in conversion of 12345678901 to oid.
+MAPI = (monetdb) /var/tmp/mtest-17898/.s.monetdb.31237
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+QUERY = INSERT INTO OID_TBL(f1) VALUES (-23582358720398502385);
+ERROR = !overflow in conversion of -23582358720398503936 to lng.
+
+# 16:41:57 >
+# 16:41:57 > "Done."
+# 16:41:57 >
+
diff --git a/sql/test/pg_regress/Tests/oid.stable.out.oid32
b/sql/test/pg_regress/Tests/oid.stable.out.oid32
new file mode 100644
--- /dev/null
+++ b/sql/test/pg_regress/Tests/oid.stable.out.oid32
@@ -0,0 +1,243 @@
+stdout 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 >
+
+# MonetDB 5 server v11.18.0
+# This is an unreleased version
+# Serving database 'mTests_sql_test_pg_regress', using 8 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Found 15.356 GiB available main-memory.
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved
+# Visit http://www.monetdb.org/ for further information
+# Listening for connection requests on mapi:monetdb://uwakai.da.cwi.nl:38959/
+# Listening for UNIX domain connection requests on
mapi:monetdb:///var/tmp/mtest-1142/.s.monetdb.38959
+# MonetDB/GIS module loaded
+# MonetDB/SQL module loaded
+
+Ready.
+
+# 17:11:19 >
+# 17:11:19 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-1142" "--port=38959"
+# 17:11:19 >
+
+#--
+#-- OID
+#--
+#CREATE TABLE OID_TBL(f1 oid);
+#INSERT INTO OID_TBL(f1) VALUES ('1234');
+[ 1 ]
+#INSERT INTO OID_TBL(f1) VALUES ('1235');
+[ 1 ]
+#INSERT INTO OID_TBL(f1) VALUES ('987');
+[ 1 ]
+#INSERT INTO OID_TBL(f1) VALUES ('000');
+[ 1 ]
+#INSERT INTO OID_TBL(f1) VALUES (' '); -- in MonetDB this one is accepted
+[ 1 ]
+#INSERT INTO OID_TBL(f1) VALUES ('5 ');
+[ 1 ]
+#INSERT INTO OID_TBL(f1) VALUES (' 10 ');
+[ 1 ]
+#INSERT INTO OID_TBL(f1) VALUES (' 15 ');
+[ 1 ]
+#INSERT INTO OID_TBL(f1) VALUES (null);
+[ 1 ]
+#SELECT '' AS nine, OID_TBL.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL;
+% .L, sys.oid_tbl, sys.L1 # table_name
+% ten, f1, oid2str # name
+% char, oid, varchar # type
+% 0, 6, 6 # length
+[ "", 1234@0, "1234@0" ]
+[ "", 1235@0, "1235@0" ]
+[ "", 987@0, "987@0" ]
+[ "", 0@0, "0@0" ]
+[ "", NULL, NULL ]
+[ "", 5@0, "5@0" ]
+[ "", 10@0, "10@0" ]
+[ "", 15@0, "15@0" ]
+[ "", NULL, NULL ]
+#SELECT '' AS ten, OID_TBL.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL
ORDER BY f1;
+% .L, sys.oid_tbl, sys.L1 # table_name
+% ten, f1, oid2str # name
+% char, oid, varchar # type
+% 0, 6, 6 # length
+[ "", NULL, NULL ]
+[ "", NULL, NULL ]
+[ "", 0@0, "0@0" ]
+[ "", 5@0, "5@0" ]
+[ "", 10@0, "10@0" ]
+[ "", 15@0, "15@0" ]
+[ "", 987@0, "987@0" ]
+[ "", 1234@0, "1234@0" ]
+[ "", 1235@0, "1235@0" ]
+#DELETE FROM OID_TBL WHERE f1 < '0';
+[ 0 ]
+#SELECT '' AS one, o.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL o
WHERE o.f1 = cast(1234 as oid);
+% .L1, sys.o, sys.L2 # table_name
+% one, f1, oid2str # name
+% char, oid, varchar # type
+% 0, 6, 6 # length
+[ "", 1234@0, "1234@0" ]
+#SELECT '' AS one, o.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL o
WHERE o.f1 = 1234@0;
+% .L, sys.o, sys.L1 # table_name
+% one, f1, oid2str # name
+% char, oid, varchar # type
+% 0, 6, 6 # length
+[ "", 1234@0, "1234@0" ]
+#SELECT '' AS one, o.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL o
WHERE o.f1 = '1234';
+% .L, sys.o, sys.L1 # table_name
+% one, f1, oid2str # name
+% char, oid, varchar # type
+% 0, 6, 6 # length
+[ "", 1234@0, "1234@0" ]
+#SELECT '' AS seven, o.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL o
WHERE o.f1 <> cast(1234 as oid);
+% .L1, sys.o, sys.L2 # table_name
+% seven, f1, oid2str # name
+% char, oid, varchar # type
+% 0, 6, 6 # length
+[ "", 1235@0, "1235@0" ]
+[ "", 987@0, "987@0" ]
+[ "", 0@0, "0@0" ]
+[ "", 5@0, "5@0" ]
+[ "", 10@0, "10@0" ]
+[ "", 15@0, "15@0" ]
+#SELECT '' AS seven, o.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL o
WHERE o.f1 <> 1234@0;
+% .L, sys.o, sys.L1 # table_name
+% seven, f1, oid2str # name
+% char, oid, varchar # type
+% 0, 6, 6 # length
+[ "", 1235@0, "1235@0" ]
+[ "", 987@0, "987@0" ]
+[ "", 0@0, "0@0" ]
+[ "", 5@0, "5@0" ]
+[ "", 10@0, "10@0" ]
+[ "", 15@0, "15@0" ]
+#SELECT '' AS six, o.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL o
WHERE o.f1 <= '1234';
+% .L, sys.o, sys.L1 # table_name
+% seven, f1, oid2str # name
+% char, oid, varchar # type
+% 0, 6, 6 # length
+[ "", 1235@0, "1235@0" ]
+[ "", 987@0, "987@0" ]
+[ "", 0@0, "0@0" ]
+[ "", 5@0, "5@0" ]
+[ "", 10@0, "10@0" ]
+[ "", 15@0, "15@0" ]
+#SELECT '' AS six, o.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL o
WHERE o.f1 <= cast(1234 as oid);
+% .L1, sys.o, sys.L2 # table_name
+% six, f1, oid2str # name
+% char, oid, varchar # type
+% 0, 6, 6 # length
+[ "", 1234@0, "1234@0" ]
+[ "", 987@0, "987@0" ]
+[ "", 0@0, "0@0" ]
+[ "", 5@0, "5@0" ]
+[ "", 10@0, "10@0" ]
+[ "", 15@0, "15@0" ]
+#SELECT '' AS six, o.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL o
WHERE o.f1 <= 1234@0;
+% .L, sys.o, sys.L1 # table_name
+% six, f1, oid2str # name
+% char, oid, varchar # type
+% 0, 6, 6 # length
+[ "", 1234@0, "1234@0" ]
+[ "", 987@0, "987@0" ]
+[ "", 0@0, "0@0" ]
+[ "", 5@0, "5@0" ]
+[ "", 10@0, "10@0" ]
+[ "", 15@0, "15@0" ]
+#SELECT '' AS six, o.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL o
WHERE o.f1 <= '1234';
+% .L, sys.o, sys.L1 # table_name
+% six, f1, oid2str # name
+% char, oid, varchar # type
+% 0, 6, 6 # length
+[ "", 1234@0, "1234@0" ]
+[ "", 987@0, "987@0" ]
+[ "", 0@0, "0@0" ]
+[ "", 5@0, "5@0" ]
+[ "", 10@0, "10@0" ]
+[ "", 15@0, "15@0" ]
+#SELECT '' AS five, o.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL o
WHERE o.f1 < cast(1234 as oid);
+% .L1, sys.o, sys.L2 # table_name
+% five, f1, oid2str # name
+% char, oid, varchar # type
+% 0, 5, 5 # length
+[ "", 987@0, "987@0" ]
+[ "", 0@0, "0@0" ]
+[ "", 5@0, "5@0" ]
+[ "", 10@0, "10@0" ]
+[ "", 15@0, "15@0" ]
+#SELECT '' AS five, o.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL o
WHERE o.f1 < 1234@0;
+% .L, sys.o, sys.L1 # table_name
+% five, f1, oid2str # name
+% char, oid, varchar # type
+% 0, 5, 5 # length
+[ "", 987@0, "987@0" ]
+[ "", 0@0, "0@0" ]
+[ "", 5@0, "5@0" ]
+[ "", 10@0, "10@0" ]
+[ "", 15@0, "15@0" ]
+#SELECT '' AS five, o.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL o
WHERE o.f1 < '1234';
+% .L, sys.o, sys.L1 # table_name
+% five, f1, oid2str # name
+% char, oid, varchar # type
+% 0, 5, 5 # length
+[ "", 987@0, "987@0" ]
+[ "", 0@0, "0@0" ]
+[ "", 5@0, "5@0" ]
+[ "", 10@0, "10@0" ]
+[ "", 15@0, "15@0" ]
+#SELECT '' AS three, o.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL o
WHERE o.f1 >= cast(1234 as oid);
+% .L1, sys.o, sys.L2 # table_name
+% three, f1, oid2str # name
+% char, oid, varchar # type
+% 0, 13, 13 # length
+[ "", 1234@0, "1234@0" ]
+[ "", 1235@0, "1235@0" ]
+[ "", 12345678901@0, "12345678901@0" ]
+#SELECT '' AS three, o.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL o
WHERE o.f1 >= 1234@0;
+% .L, sys.o, sys.L1 # table_name
+% three, f1, oid2str # name
+% char, oid, varchar # type
+% 0, 13, 13 # length
+[ "", 1234@0, "1234@0" ]
+[ "", 1235@0, "1235@0" ]
+[ "", 12345678901@0, "12345678901@0" ]
+#SELECT '' AS three, o.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL o
WHERE o.f1 >= '1234';
+% .L, sys.o, sys.L1 # table_name
+% three, f1, oid2str # name
+% char, oid, varchar # type
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
