Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv23981
Modified Files:
Tag: SQL_2-24
proc_insert_into.SF-1958572.sql
proc_insert_into.SF-1958572.stable.out
Log Message:
make test independend of other tests
U proc_insert_into.SF-1958572.sql
Index: proc_insert_into.SF-1958572.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/proc_insert_into.SF-1958572.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
--- proc_insert_into.SF-1958572.sql 4 Jun 2008 20:16:59 -0000 1.1.2.1
+++ proc_insert_into.SF-1958572.sql 6 Jun 2008 07:46:48 -0000 1.1.2.2
@@ -1,31 +1,31 @@
create sequence "ff" as integer start with 1;
-CREATE TABLE t1(timeid INT DEFAULT NEXT VALUE FOR "ff" PRIMARY KEY, a INT, b
INT, c INT, d INT, e INT, f VARCHAR(20), g VARCHAR(20), h INT, i VARCHAR(10), j
VARCHAR(10), k VARCHAR(10), l INT, m INT, n VARCHAR(10), o VARCHAR(10), p
VARCHAR(10), q VARCHAR(15), r INT);
+CREATE TABLE proc_insert_into_t1(timeid INT DEFAULT NEXT VALUE FOR "ff"
PRIMARY KEY, a INT, b INT, c INT, d INT, e INT, f VARCHAR(20), g VARCHAR(20), h
INT, i VARCHAR(10), j VARCHAR(10), k VARCHAR(10), l INT, m INT, n VARCHAR(10),
o VARCHAR(10), p VARCHAR(10), q VARCHAR(15), r INT);
-insert into t1(a, b, c, d, e, f, g, h, i, j, k, l, m, n, o, p, q, r) values(1,
1, 1, 1, 1, 'first row', 'first row',1, 'first row', 'first row', 'first
row',1,1, 'first row', 'first row', 'first row', 'first row', 1);
+insert into proc_insert_into_t1(a, b, c, d, e, f, g, h, i, j, k, l, m, n, o,
p, q, r) values(1, 1, 1, 1, 1, 'first row', 'first row',1, 'first row', 'first
row', 'first row',1,1, 'first row', 'first row', 'first row', 'first row', 1);
-select * from t1;
+select * from proc_insert_into_t1;
-insert into t1(a, b, c, d, e, f, g, h) select a, b, c, d, e, f, g, h from t1
where timeid = 1;
+insert into proc_insert_into_t1(a, b, c, d, e, f, g, h) select a, b, c, d, e,
f, g, h from proc_insert_into_t1 where timeid = 1;
-select * from t1;
+select * from proc_insert_into_t1;
-create procedure tt()
+create procedure proc_insert_into_tt()
begin
- insert into t1(a, b, c, d, e, f, g, h) select a, b, c, d, e, f, g, h
from t1 where timeid = 1;
+ insert into proc_insert_into_t1(a, b, c, d, e, f, g, h) select a, b, c,
d, e, f, g, h from proc_insert_into_t1 where timeid = 1;
end;
-call tt();
-call tt();
-call tt();
-call tt();
+call proc_insert_into_tt();
+call proc_insert_into_tt();
+call proc_insert_into_tt();
+call proc_insert_into_tt();
-select * from t1;
+select * from proc_insert_into_t1;
-select count(*) from t1;
-select timeid from t1;
-select * from t1;
+select count(*) from proc_insert_into_t1;
+select timeid from proc_insert_into_t1;
+select * from proc_insert_into_t1;
-drop procedure tt;
-drop table t1;
+drop procedure proc_insert_into_tt;
+drop table proc_insert_into_t1;
drop sequence ff;
U proc_insert_into.SF-1958572.stable.out
Index: proc_insert_into.SF-1958572.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/proc_insert_into.SF-1958572.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
--- proc_insert_into.SF-1958572.stable.out 4 Jun 2008 20:17:00 -0000
1.1.2.1
+++ proc_insert_into.SF-1958572.stable.out 6 Jun 2008 07:46:48 -0000
1.1.2.2
@@ -25,13 +25,13 @@
# 22:15:00 >
[ 1 ]
-% sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1,
sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1
# table_name
+% sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1 # table_name
% timeid, a, b, c, d, e, f, g, h,
i, j, k, l, m, n, o, p, q, r # name
% int, int, int, int, int, int, varchar, varchar,
int, varchar, varchar, varchar, int, int,
varchar, varchar, varchar, varchar, int # type
% 1, 1, 1, 1, 1, 1, 9, 9, 1, 9,
9, 9, 1, 1, 9, 9, 9, 9, 1 # length
[ 1, 1, 1, 1, 1, 1, "first row", "first row",
1, "first row", "first row", "first row", 1, 1, "first
row", "first row", "first row", "first row", 1 ]
[ 1 ]
-% sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1,
sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1
# table_name
+% sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1 # table_name
% timeid, a, b, c, d, e, f, g, h,
i, j, k, l, m, n, o, p, q, r # name
% int, int, int, int, int, int, varchar, varchar,
int, varchar, varchar, varchar, int, int,
varchar, varchar, varchar, varchar, int # type
% 1, 1, 1, 1, 1, 1, 9, 9, 1, 9,
9, 9, 1, 1, 9, 9, 9, 9, 1 # length
@@ -41,7 +41,7 @@
[ 1 ]
[ 1 ]
[ 1 ]
-% sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1,
sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1
# table_name
+% sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1 # table_name
% timeid, a, b, c, d, e, f, g, h,
i, j, k, l, m, n, o, p, q, r # name
% int, int, int, int, int, int, varchar, varchar,
int, varchar, varchar, varchar, int, int,
varchar, varchar, varchar, varchar, int # type
% 1, 1, 1, 1, 1, 1, 9, 9, 1, 9,
9, 9, 1, 1, 9, 9, 9, 9, 1 # length
@@ -56,7 +56,7 @@
% int # type
% 1 # length
[ 6 ]
-% sys.t1 # table_name
+% sys.proc_insert_into_t1 # table_name
% timeid # name
% int # type
% 1 # length
@@ -66,7 +66,7 @@
[ 4 ]
[ 5 ]
[ 6 ]
-% sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1,
sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1
# table_name
+% sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1 # table_name
% timeid, a, b, c, d, e, f, g, h,
i, j, k, l, m, n, o, p, q, r # name
% int, int, int, int, int, int, varchar, varchar,
int, varchar, varchar, varchar, int, int,
varchar, varchar, varchar, varchar, int # type
% 1, 1, 1, 1, 1, 1, 9, 9, 1, 9,
9, 9, 1, 1, 9, 9, 9, 9, 1 # length
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
