Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv29659
Modified Files:
All
Added Files:
coalesce_equal_coalesce.SF-1907905.sql
decl_sec_tab_in_func_body.SF-1907858.sql
huge_math_expre.SF-1907048.sql
join_table_with_floats.SF-1907060.sql like_perl.SF-1907051.sql
ms_round.SF-1907063.sql range_select.SF-1907006.sql
sql_prepare_prob.SF-1909638.sql
Log Message:
Add tests for the bugs found in skyserver queires logs...
range_select.SF-1907006
huge_math_expre.SF-1907048
join_table_with_floats.SF-1907060
ms_round.SF-1907063
decl_sec_tab_in_func_body.SF-1907858
coalesce_equal_coalesce.SF-1907905
like_perl.SF-1907051
sql_prepare_prob.SF-1909638
--- NEW FILE: huge_math_expre.SF-1907048.sql ---
create table t1 (z real);
create table t2 (name string, dered_g real, dered_r real);
SELECT p.name FROM t1 as s, t2 as p WHERE
(-0.399*(dered_g-4.79*LOG10(s.z/0.03)-3.65*(dered_g-dered_r)-39.55))> 10.7
LIMIT 100000;
drop table t2;
drop table t1;
--- NEW FILE: coalesce_equal_coalesce.SF-1907905.sql ---
CREATE TABLE syscolumns(
id int,
length int,
uid int,
nme char(100),
xtype char(100)
);
CREATE TABLE spt_datatype_info(
length int,
ss_dtype varchar(100),
"AUTO_INCREMENT" varchar(100)
);
CREATE FUNCTION fDocColumnsWithRank(TableName varchar(400))
RETURNS float
BEGIN
return table ( SELECT c.nme as nme
FROM
spt_datatype_info d,
syscolumns c
WHERE
coalesce(d."AUTO_INCREMENT",0) =
coalesce(ColumnProperty (c.id, c.nme,'IsIdentity'),0) );
END;
drop function fDocColumnsWithRank;
drop table syscolumns;
drop table spt_datatype_info;
--- NEW FILE: decl_sec_tab_in_func_body.SF-1907858.sql ---
CREATE FUNCTION fR(x float, types float)
RETURNS float
BEGIN
DECLARE TABLE typesTable(
type varchar(16)
);
INSERT into typesTable (type) values ('asdasd');
DECLARE TABLE region(
regionid bigint,
type varchar(16)
);
Return x;
END;
drop function fR;
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.83
retrieving revision 1.84
diff -u -d -r1.83 -r1.84
--- All 22 Feb 2008 12:45:21 -0000 1.83
+++ All 7 Mar 2008 16:03:37 -0000 1.84
@@ -103,3 +103,11 @@
case_with_aggr.SF-1876779
with_row_number.SF-1898089
savepoint-SF.1898533
+range_select.SF-1907006
+huge_math_expre.SF-1907048
+join_table_with_floats.SF-1907060
+ms_round.SF-1907063
+decl_sec_tab_in_func_body.SF-1907858
+coalesce_equal_coalesce.SF-1907905
+like_perl.SF-1907051
+sql_prepare_prob.SF-1909638
--- NEW FILE: range_select.SF-1907006.sql ---
select name from tables where 0<id>10;
--- NEW FILE: join_table_with_floats.SF-1907060.sql ---
create table t2 (id float);
create table t1 (age float);
select age from t1, t2 where id < 0.0 limit 10;
drop table t1;
drop table t2;
--- NEW FILE: sql_prepare_prob.SF-1909638.sql ---
CREATE FUNCTION fEq (ra float, decim float, r float)
RETURNS int
BEGIN
return 0;
END;
SELECT fEq(212.82496,1.27536,0.167);
SELECT fEq(134.44708,-0.2,0.167);
SELECT fEq(261,-90,0.167);
drop function fEq;
--- NEW FILE: like_perl.SF-1907051.sql ---
select name from tables where name LIKE '%????%';
--- NEW FILE: ms_round.SF-1907063.sql ---
create table t23(id float);
select round(id,8) from t23;
drop table t23;
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
