Update of /cvsroot/monetdb/sql/src/test/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv23651/test/Tests
Modified Files:
load_with_offset.sql load_with_offset.stable.out
Log Message:
sql_result - upgrade the handling of value parsing to align with gdk.
various tests added that call for our attention, i.e. to properly handle
varchar size bounds and typing errors.
U load_with_offset.sql
Index: load_with_offset.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/load_with_offset.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- load_with_offset.sql 18 Feb 2008 10:52:10 -0000 1.3
+++ load_with_offset.sql 28 Dec 2008 09:58:47 -0000 1.4
@@ -7,28 +7,28 @@
) ;
COPY 5 OFFSET 5 RECORDS INTO my_test FROM stdin USING DELIMITERS '|','\n' NULL
as '';
-123|1.01||aaa|bbb
-553|.02||aaa|bbb
-223|2.03||aaa|bbb
-123|.04||aaa|bbb
-823|3.05||aaa|bbb
-123|0.06||aaa|bbb
-590|0.07||aaa|bbb
-239|.08||aaa|bbb
-445|28.09||aaa|bbb
+123|1||a|b
+553|0||a|b
+223|2||a|b
+123|0||a|b
+823|3||a|b
+123|0||a|b
+590|0||a|b
+239|0||a|b
+445|28||a|b
select * from my_test;
COPY 9 RECORDS INTO my_test FROM stdin USING DELIMITERS '|','\n' NULL as '';
-123|1.01||aaa|bbb
-553|.02||aaa|bbb
-223|2.03||aaa|bbb
-123|.04||aaa|bbb
-823|3.05||aaa|bbb
-123|0.06||aaa|bbb
-590|0.07||aaa|bbb
-239|.08||aaa|bbb
-445|28.09||aaa|bbb
+123|1||a|b
+553|0||a|b
+223|2||a|b
+123|0||a|b
+823|3||a|b
+123|0||a|b
+590|0||a|b
+239|0||a|b
+445|28||a|b
select * from my_test;
U load_with_offset.stable.out
Index: load_with_offset.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/load_with_offset.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- load_with_offset.stable.out 7 Dec 2008 17:31:30 -0000 1.2
+++ load_with_offset.stable.out 28 Dec 2008 09:58:47 -0000 1.3
@@ -33,33 +33,33 @@
% sys.my_test, sys.my_test, sys.my_test, sys.my_test, sys.my_test #
table_name
% col1, col2, col3, col4, col5 # name
% int, int, int, varchar, varchar # type
-% 3, 2, 1, 3, 3 # length
-[ 823, 3, NULL, "aaa", "bbb" ]
-[ 123, 0, NULL, "aaa", "bbb" ]
-[ 590, 0, NULL, "aaa", "bbb" ]
-[ 239, 0, NULL, "aaa", "bbb" ]
-[ 445, 28, NULL, "aaa", "bbb" ]
+% 3, 2, 1, 1, 1 # length
+[ 823, 3, NULL, "a", "b" ]
+[ 123, 0, NULL, "a", "b" ]
+[ 590, 0, NULL, "a", "b" ]
+[ 239, 0, NULL, "a", "b" ]
+[ 445, 28, NULL, "a", "b" ]
[ 9 ]
% sys.my_test, sys.my_test, sys.my_test, sys.my_test, sys.my_test #
table_name
% col1, col2, col3, col4, col5 # name
% int, int, int, varchar, varchar # type
-% 3, 2, 1, 3, 3 # length
-[ 823, 3, NULL, "aaa", "bbb" ]
-[ 123, 0, NULL, "aaa", "bbb" ]
-[ 590, 0, NULL, "aaa", "bbb" ]
-[ 239, 0, NULL, "aaa", "bbb" ]
-[ 445, 28, NULL, "aaa", "bbb" ]
-[ 123, 1, NULL, "aaa", "bbb" ]
-[ 553, 0, NULL, "aaa", "bbb" ]
-[ 223, 2, NULL, "aaa", "bbb" ]
-[ 123, 0, NULL, "aaa", "bbb" ]
-[ 823, 3, NULL, "aaa", "bbb" ]
-[ 123, 0, NULL, "aaa", "bbb" ]
-[ 590, 0, NULL, "aaa", "bbb" ]
-[ 239, 0, NULL, "aaa", "bbb" ]
-[ 445, 28, NULL, "aaa", "bbb" ]
+% 3, 2, 1, 1, 1 # length
+[ 823, 3, NULL, "a", "b" ]
+[ 123, 0, NULL, "a", "b" ]
+[ 590, 0, NULL, "a", "b" ]
+[ 239, 0, NULL, "a", "b" ]
+[ 445, 28, NULL, "a", "b" ]
+[ 123, 1, NULL, "a", "b" ]
+[ 553, 0, NULL, "a", "b" ]
+[ 223, 2, NULL, "a", "b" ]
+[ 123, 0, NULL, "a", "b" ]
+[ 823, 3, NULL, "a", "b" ]
+[ 123, 0, NULL, "a", "b" ]
+[ 590, 0, NULL, "a", "b" ]
+[ 239, 0, NULL, "a", "b" ]
+[ 445, 28, NULL, "a", "b" ]
-# 12:49:45 >
-# 12:49:45 > Done.
-# 12:49:45 >
+# 08:57:36 >
+# 08:57:36 > Done.
+# 08:57:36 >
------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
