Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv11979
Modified Files:
All
Added Files:
between_having_problem.SF-1959391.sql
between_with_column.SF-1959410.sql
is_not_null_syntax_error.SF-1959456.sql
order_by_over_table_from_another_function.SF-1959822.sql
Log Message:
Add tests for the bugs which were opened yesterday....
--- NEW FILE: between_having_problem.SF-1959391.sql ---
create table t3 (id float);
select id from t3 where (id between 0 and 62) having (id = id+.1 or id = id
- .1);
drop table t3;
U All
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.90
retrieving revision 1.91
diff -u -d -r1.90 -r1.91
--- All 21 Mar 2008 09:39:35 -0000 1.90
+++ All 8 May 2008 08:49:14 -0000 1.91
@@ -115,3 +115,7 @@
count_crash.SF-1918780
table_function_column_crash.SF-1913572
drop_function.SF-1910396
+between_having_problem.SF-1959391
+between_with_column.SF-1959410
+is_not_null_syntax_error.SF-1959456
+order_by_over_table_from_another_function.SF-1959822
--- NEW FILE: is_not_null_syntax_error.SF-1959456.sql ---
create function f1()
RETURNS int
BEGIN
return 0;
END;
create table t1 (id int);
select id from t1 where f1() IS NOT NULL;
drop function f1;
drop table t1;
--- NEW FILE: between_with_column.SF-1959410.sql ---
create table t4 (id int);
create table t5 (age float, yea int);
select yea from t4, t5 where age between 0.03 and id < 30 ;
drop table t4;
drop table t5;
--- NEW FILE: order_by_over_table_from_another_function.SF-1959822.sql ---
CREATE FUNCTION f2 ()
RETURNS TABLE (
fieldID bigint,
distance bigint
)
BEGIN
DECLARE TABLE cover(
htmidStart bigint, htmidEnd bigint
);
INSERT into cover
SELECT 1, 2;
RETURN TABLE (
SELECT htmidStart, 1 as distance
FROM cover H);
END;
CREATE FUNCTION f3 ()
RETURNS TABLE (
fieldID bigint
)
BEGIN
RETURN TABLE (
SELECT fieldID
FROM f2 () n
ORDER BY fieldID ASC LIMIT 1);
END;
drop function f2();
drop function f3();
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
