[Monetdb-sql-checkins] sql/src/test/BugTracker/Tests infinite_loop.SF-1714809.sql, NONE, 1.1 view_creation_using_func.SF-1714814.sql, NONE, 1.1 All, 1.47, 1.48 create_column.SF-1643542.sql, 1.2, 1.3

[Romulo Goncalves]

Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16:/tmp/cvs-serv23652

Modified Files:
        All create_column.SF-1643542.sql 
Added Files:
        infinite_loop.SF-1714809.sql 
        view_creation_using_func.SF-1714814.sql 
Log Message:
Tests for the bugs:

infinite_loop.SF-1714809
view_creation_using_func.SF-1714814

NOTE: These bugs are not fixed, they will be soon


--- NEW FILE: view_creation_using_func.SF-1714814.sql ---
create table t1(id int, name varchar(1024), age int);

create function f1()
returns int
BEGIN
        return 1;
END;

create view v1 as select * from t1 where id = f(1);

drop view v1;
drop table t1;
drop function f1(); 

Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.47
retrieving revision 1.48
diff -u -d -r1.47 -r1.48
--- All 6 May 2007 08:59:25 -0000       1.47
+++ All 8 May 2007 11:21:54 -0000       1.48
@@ -56,3 +56,5 @@
 variable_stack_crash.SF-1711251
 variable_stack_crash.SF-1711251-2
 variable_stack_crash_drop.SF-1711251
+infinite_loop.SF-1714809
+view_creation_using_func.SF-1714814

Index: create_column.SF-1643542.sql
===================================================================
RCS file: 
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/create_column.SF-1643542.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- create_column.SF-1643542.sql        29 Jan 2007 21:51:20 -0000      1.2
+++ create_column.SF-1643542.sql        8 May 2007 11:21:54 -0000       1.3
@@ -6,5 +6,3 @@
 select * from t1;
 
 drop table t1;
-
-

--- NEW FILE: infinite_loop.SF-1714809.sql ---
create table t1(id int, name varchar(1024), age int);
create table t2(id int, age int);

create PROCEDURE p1(id int, age int)
BEGIN
        insert into t2 values(id, age);
END;

create PROCEDURE p1()
BEGIN
        declare id int, age int;
        set id = 1;
        set age = 23;
        call p1(id, age);
END;

create trigger test_0 after insert on t2
BEGIN ATOMIC
        insert into t1 values(1, 'monetdb', 24);
        call p1();
END;

insert into t2 values(0, 24);

DROP table t2 CASCADE;
DROP Table t1;


-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Monetdb-sql-checkins mailing list
Monetdb-sql-checkins@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins