Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv23820/src/test/BugTracker/Tests
Modified Files:
Tag: SQL_2-18
All
Added Files:
Tag: SQL_2-18
convert_dec2varchar.SF-1774312.sql
convert_dec2varchar_crash.SF-1775550.sql
limit_timestampz.SF-1774217.sql
Log Message:
added new test scripts for recent bugs
--- NEW FILE: convert_dec2varchar.SF-1774312.sql ---
select tr, cast(tr as varchar(10)) from (select 11.34555 as tr) as foo;
--- NEW FILE: convert_dec2varchar_crash.SF-1775550.sql ---
select 11.456;
select 11.456 || 'hi';
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.58.2.6
retrieving revision 1.58.2.7
diff -u -d -r1.58.2.6 -r1.58.2.7
--- All 21 Jun 2007 17:09:55 -0000 1.58.2.6
+++ All 16 Aug 2007 21:30:11 -0000 1.58.2.7
@@ -76,3 +76,6 @@
alter_table_add_fkey.SF-1737668
select_id_not_in_another_select.SF-1737777
crash_on_concurrent_use.SF-1411926
+limit_timestampz.SF-1774217
+convert_dec2varchar.SF-1774312
+convert_dec2varchar_crash.SF-1775550
--- NEW FILE: limit_timestampz.SF-1774217.sql ---
create table t1 (
tr_time timestamp(3) with time zone
)
;
insert into t1
select *
from
(
select timestamp with time zone '2005-04-12 06:30-07:00' as tr_time
union
select timestamp with time zone '2005-04-12 07:30-07:00' as tr_time
union
select timestamp with time zone '2005-04-12 05:30-07:00' as tr_time
union
select timestamp with time zone '2005-04-12 05:35-07:00' as tr_time
union
select timestamp with time zone '2005-04-12 07:15-07:00' as tr_time
) as foo
;
-- this will crash server
select tr_time from t1
order by tr_time
limit 3
;
-------------------------------------------------------------------------
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
