Update of /cvsroot/monetdb/sql/src/test/pg_regress/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv19168/Tests
Modified Files:
char.stable.err char.stable.out
Log Message:
per bug #2830905, we don't (want to) support selects from tables without
FROM-clause
U char.stable.out
Index: char.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/pg_regress/Tests/char.stable.out,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- char.stable.out 1 Aug 2009 20:19:26 -0000 1.1
+++ char.stable.out 3 Aug 2009 09:08:13 -0000 1.2
@@ -51,8 +51,17 @@
#-- try char's of greater than 1 length
#INSERT INTO CHAR_TBL (f1) VALUES ('cd');
#INSERT INTO CHAR_TBL (f1) VALUES ('c ');
-#SELECT '' AS seven, CHAR_TBL.*;
-[ output needs to go here ]
+#SELECT '' AS seven, CHAR_TBL.* FROM CHAR_TBL;
+% ., sys.char_tbl # table_name
+% seven, f1 # name
+% char, char # type
+% 0, 1 # length
+[ "", "a" ]
+[ "", "A" ]
+[ "", "1" ]
+[ "", "2" ]
+[ "", "3" ]
+[ "", "" ]
#SELECT '' AS six, c.*
% ., sys.c # table_name
% six, f1 # name
@@ -111,8 +120,14 @@
[ 1 ]
#INSERT INTO CHAR_TBL (f1) VALUES ('abcde');
#INSERT INTO CHAR_TBL (f1) VALUES ('abcd ');
-#SELECT '' AS four, CHAR_TBL.*;
-[ output should go here ]
+#SELECT '' AS four, CHAR_TBL.* FROM CHAR_TBL;
+% ., sys.char_tbl # table_name
+% four, f1 # name
+% char, char # type
+% 0, 4 # length
+[ "", "a" ]
+[ "", "ab" ]
+[ "", "abcd" ]
# 22:08:26 >
# 22:08:26 > Done.
U char.stable.err
Index: char.stable.err
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/pg_regress/Tests/char.stable.err,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- char.stable.err 1 Aug 2009 20:19:26 -0000 1.1
+++ char.stable.err 3 Aug 2009 09:08:13 -0000 1.2
@@ -74,19 +74,19 @@
# 22:08:26 > Mtimeout -timeout 60 mclient -lsql -umonetdb -Pmonetdb
--host=pegasus --port=38104 -e <
../../../../../../../../../../mirror/fabian/monetdb/current/sql/src/test/pg_regress/Tests/../monetdb/char.sql
# 22:08:26 >
-MAPI = mone...@pegasus:38104
+MAPI = mone...@pegasus:36360
QUERY = SELECT char 'c' = char 'c' AS true;
ERROR = !syntax error, unexpected CHARACTER in: "select char"
-MAPI = mone...@pegasus:38104
+MAPI = mone...@pegasus:36360
QUERY = INSERT INTO CHAR_TBL (f1) VALUES ('cd');
ERROR = !SQLException:str_cast:value too long for type (var)char(1)
-MAPI = mone...@pegasus:38104
+MAPI = mone...@pegasus:36360
QUERY = INSERT INTO CHAR_TBL (f1) VALUES ('c ');
ERROR = !SQLException:str_cast:value too long for type (var)char(1)
-MAPI = mone...@pegasus:38104
+MAPI = mone...@pegasus:36360
QUERY = INSERT INTO CHAR_TBL (f1) VALUES ('abcde');
ERROR = !SQLException:str_cast:value too long for type (var)char(4)
-MAPI = mone...@pegasus:38104
+MAPI = mone...@pegasus:36360
QUERY = INSERT INTO CHAR_TBL (f1) VALUES ('abcd ');
ERROR = !SQLException:str_cast:value too long for type (var)char(4)
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
