Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv2472
Modified Files:
Tag: SQL_2-18
limit_timestampz.SF-1774217.sql
limit_timestampz.SF-1774217.stable.out
Log Message:
hopefully made output independend of timezone
Index: limit_timestampz.SF-1774217.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/Attic/limit_timestampz.SF-1774217.sql,v
retrieving revision 1.1.2.1
retrieving revision 1.1.2.2
diff -u -d -r1.1.2.1 -r1.1.2.2
--- limit_timestampz.SF-1774217.sql 16 Aug 2007 21:30:15 -0000 1.1.2.1
+++ limit_timestampz.SF-1774217.sql 17 Aug 2007 07:09:35 -0000 1.1.2.2
@@ -1,8 +1,9 @@
create table t1 (
+nr integer auto_increment,
tr_time timestamp(3) with time zone
)
;
-insert into t1
+insert into t1 (tr_time)
select *
from
(
@@ -18,7 +19,7 @@
) as foo
;
-- this will crash server
-select tr_time from t1
+select nr from t1
order by tr_time
limit 3
;
Index: limit_timestampz.SF-1774217.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/Attic/limit_timestampz.SF-1774217.stable.out,v
retrieving revision 1.1.2.1
retrieving revision 1.1.2.2
diff -u -d -r1.1.2.1 -r1.1.2.2
--- limit_timestampz.SF-1774217.stable.out 16 Aug 2007 21:41:11 -0000
1.1.2.1
+++ limit_timestampz.SF-1774217.stable.out 17 Aug 2007 07:09:35 -0000
1.1.2.2
@@ -23,14 +23,14 @@
[ 5 ]
% sys.t1 # table_name
-% tr_time # name
-% timestamptz # type
-% 23 # length
-[ 2005-04-12 12:30:00.000+00:00 ]
-[ 2005-04-12 12:35:00.000+00:00 ]
-[ 2005-04-12 13:30:00.000+00:00 ]
+% nr # name
+% int # type
+% 1 # length
+[ 3 ]
+[ 4 ]
+[ 1 ]
-# 23:35:36 >
-# 23:35:36 > Done.
-# 23:35:36 >
+# 09:08:26 >
+# 09:08:26 > Done.
+# 09:08:26 >
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
