Update of /cvsroot/monetdb/sql/src/test/snodgrass/Tests
In directory
sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv8727/src/test/snodgrass/Tests
Modified Files:
cast_select.stable.out
Log Message:
propagated changes of Tuesday Feb 02 2010 - Wednesday Feb 03 2010
from the Feb2010 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2010/02/02 - stmane: src/test/snodgrass/Tests/cast_select.stable.out,1.3.26.2
removed M4-specific error message from M5-only output
and the related (now obsolete) rule from Mfilter
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2010/02/03 - stmane: src/test/snodgrass/Tests/cast_select.stable.out,1.3.26.3
approved new error message
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Index: cast_select.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/snodgrass/Tests/cast_select.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- cast_select.stable.out 2 Feb 2010 15:54:15 -0000 1.4
+++ cast_select.stable.out 3 Feb 2010 10:38:03 -0000 1.5
@@ -43,7 +43,7 @@
1 row
SELECT CAST(TIME '12:34:56' AS TIMESTAMP WITH TIME ZONE) = TIMESTAMP
'1997-07-23 12:34:56-07:00';
-Error on line 5: CAST: cannot cast type 'time' to type 'timestamptz'
+Error on line 5: types time(1,0) (daytime) and timestamptz(7,0) (timestamp)
are not equal
--rollback;
SELECT CAST( TIME '12:34:56.123' AS TIME(6) ) = TIME '12:34:56.123000';
+----------------+
@@ -134,7 +134,7 @@
1 row
SELECT CAST('12:34' AS INTERVAL DAY TO MINUTE ); -- err: works not
-Error on line 21: ERROR: second_interval_str: operation failed.
+Error on line 21: SQLException:calc.second_interval:wrong format (12:34)
SELECT CAST( INTERVAL'86 00:00:00' DAY TO SECOND AS INTERVAL HOUR TO SECOND )
= INTERVAL '2064:00:00' HOUR TO SECOND;
+----------------+
| =_single_value |
@@ -144,7 +144,7 @@
1 row
SELECT CAST('86 00:00:00' AS INTERVAL HOUR(3) TO SECOND ); -- err: overflow
exception
-Error on line 23: ERROR: second_interval_str: operation failed.
+Error on line 23: SQLException:calc.second_interval:wrong format (86 00:00:00)
SELECT CAST( CAST( 7430400 AS INTERVAL SECOND ) AS INTERVAL DAY TO SECOND ) =
INTERVAL '86 00:00:00' DAY TO SECOND;
+----------------+
| =_single_value |
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
