Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv4885/src/test/BugTracker/Tests
Modified Files:
All proc_insert_into.SF-1958572.sql
proc_insert_into.SF-1958572.stable.out
schema_from_declared_table.SF-1983341.sql
schema_from_declared_table.SF-1983341.stable.out
set_a_new_user_password.SF-1844050.py
set_sql_debug_64__breaking_the_DB.SF-1906287.py
set_sql_debug_64__breaking_the_DB.SF-1906287_drop.sql
Log Message:
propagated changes of Thursday Jun 05 2008 - Friday Jun 06 2008
from the SQL_2-24 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/06/05 - romulog:
src/test/BugTracker/Tests/schema_from_declared_table.SF-1983341.sql,1.1.2.2
Improve test to cover another bug...
With one select the mserver does not crash; However, if I repeat the select
again I get a crash:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/06/05 - stmane: src/storage/bat/bat_logger.mx,1.47.2.1
src/storage/bpm/bpm_logger.mx,1.4.2.1
src/storage/restrict/restrict_logger.mx,1.2.2.1
Step 0 of my (not yet finished/successful) attempt to fix
[ 1976341 ] XQ: leftovers after deleting document
https://sourceforge.net/tracker/index.php?func=detail&aid=1976341&group_id=56967&atid=482468
0.a)
Changes the logger's internal "changes" counter
from type "unsigned int" to "size_t",
maily because that seems more natural for "changes"
counter that basically counts affected BUNs/tuples;
moreover, it simplifies part (b) below.
The logger's internal "logger_changes()" function
now also returns a "size_t" instead of an "unsigned int".
However, all it's wrapper functions (in MIL, in MAL,
and the "bl_changes()" & "ro_changes()" functions for the
"logger_functions" in SQL) still return an int ---
now properly casted and with "overflow protection".
0.b)
Made "logger_add_bat()" and "logger_del_bat()" increase
the "changes" by the BATcount() of the respective BAT
(plus 1 to handle empty BATs) to make sure that
BATs that hold shredded documents in Pathfinder are
(eventually) handled properly.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/06/06 - nielsnes:
src/test/BugTracker/Tests/set_a_new_user_password.SF-1844050.py,1.1.2.3
src/test/BugTracker/Tests/set_sql_debug_64__breaking_the_DB.SF-1906287.py,1.1.2.3
src/test/BugTracker/Tests/set_sql_debug_64__breaking_the_DB.SF-1906287_drop.sql,1.1.2.2
added sleep in server.stop. This makes sure the server is really gone before
we start the next
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/06/06 - nielsnes:
src/test/BugTracker/Tests/proc_insert_into.SF-1958572.sql,1.1.2.2
src/test/BugTracker/Tests/proc_insert_into.SF-1958572.stable.out,1.1.2.2
make test independend of other tests
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/06/06 - nielsnes: src/test/Skyserver/Skyserver_import.sql,1.1.2.2
src/test/Skyserver/Tests/Skyserver.stable.out,1.1.14.2
made test less dependend on architecture. (0 vs -0 diffs)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/06/06 - nielsnes: src/test/BugTracker/Tests/All,1.93.2.10
python_escape depends on MonetSQLdb, ie we need PYTHON and SWIG
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/06/06 - nielsnes:
src/test/BugTracker/Tests/schema_from_declared_table.SF-1983341.stable.out,1.1.2.2
new output
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/06/06 - nielsnes: src/storage/sql_storage.h,1.46.4.3
fixing the schema declared table problem
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Index: schema_from_declared_table.SF-1983341.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/schema_from_declared_table.SF-1983341.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- schema_from_declared_table.SF-1983341.sql 5 Jun 2008 09:24:09 -0000
1.2
+++ schema_from_declared_table.SF-1983341.sql 6 Jun 2008 11:54:51 -0000
1.3
@@ -16,6 +16,7 @@
END;
select * from f1() n;
+select * from f1() n;
drop function f1;
drop table t1;
Index: set_sql_debug_64__breaking_the_DB.SF-1906287.py
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/set_sql_debug_64__breaking_the_DB.SF-1906287.py,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- set_sql_debug_64__breaking_the_DB.SF-1906287.py 30 May 2008 09:33:04
-0000 1.3
+++ set_sql_debug_64__breaking_the_DB.SF-1906287.py 6 Jun 2008 11:54:56
-0000 1.4
@@ -13,11 +13,12 @@
sys.stderr.write('#mserver: "%s"\n' % (srvcmd))
sys.stderr.flush()
srv = os.popen(srvcmd, 'w')
- time.sleep(5) # give server time to start
+ time.sleep(2) # give server time to start
return srv
def server_stop(srv):
srv.close()
+ time.sleep(2) # give server time to stop
def client_load_file(clt, port, file):
f = open(file, 'r')
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.97
retrieving revision 1.98
diff -u -d -r1.97 -r1.98
--- All 5 Jun 2008 09:23:59 -0000 1.97
+++ All 6 Jun 2008 11:54:42 -0000 1.98
@@ -124,7 +124,7 @@
set_sql_debug_64__breaking_the_DB.SF-1906287
select_multiple_not_null_constraints.SF-1926074
auto_increment.SF-1834820
-python_escape.SF-1916844
+HAVE_PYTHON_SWIG?python_escape.SF-1916844
set_a_new_user_password.SF-1844050
select_crashes_in_the_optimization.SF-1848553
schema_from_declared_table.SF-1983341
Index: set_a_new_user_password.SF-1844050.py
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/set_a_new_user_password.SF-1844050.py,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- set_a_new_user_password.SF-1844050.py 2 Jun 2008 13:48:18 -0000
1.3
+++ set_a_new_user_password.SF-1844050.py 6 Jun 2008 11:54:53 -0000
1.4
@@ -18,11 +18,12 @@
sys.stderr.write('#mserver: "%s"\n' % (srvcmd))
sys.stderr.flush()
srv = os.popen(srvcmd, 'w')
- time.sleep(5) # give server time to start
+ time.sleep(2) # give server time to start
return srv
def server_stop(srv):
srv.close()
+ time.sleep(2) # give server time to stop
def client_load_file(clt, port, file):
f = open(file, 'r')
Index: set_sql_debug_64__breaking_the_DB.SF-1906287_drop.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/set_sql_debug_64__breaking_the_DB.SF-1906287_drop.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- set_sql_debug_64__breaking_the_DB.SF-1906287_drop.sql 27 May 2008
14:59:13 -0000 1.2
+++ set_sql_debug_64__breaking_the_DB.SF-1906287_drop.sql 6 Jun 2008
11:54:57 -0000 1.3
@@ -1,6 +1,5 @@
select * from users where name like '%skyserver%';
-
---alter user "skyserver" set schema "sys";
+alter user "skyserver" set schema "sys";
drop schema sky;
drop user skyserver;
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.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- proc_insert_into.SF-1958572.sql 5 Jun 2008 09:24:06 -0000 1.2
+++ proc_insert_into.SF-1958572.sql 6 Jun 2008 11:54:45 -0000 1.3
@@ -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;
Index: schema_from_declared_table.SF-1983341.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/schema_from_declared_table.SF-1983341.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- schema_from_declared_table.SF-1983341.stable.out 5 Jun 2008 09:24:10
-0000 1.2
+++ schema_from_declared_table.SF-1983341.stable.out 6 Jun 2008 11:54:53
-0000 1.3
@@ -29,6 +29,11 @@
% idd, aage # name
% int, int # type
% 1, 1 # length
+[ 0 ]
+% .n, .n # table_name
+% idd, aage # name
+% int, int # type
+% 1, 1 # length
# 20:40:19 >
# 20:40:19 > Done.
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.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- proc_insert_into.SF-1958572.stable.out 5 Jun 2008 09:24:09 -0000
1.2
+++ proc_insert_into.SF-1958572.stable.out 6 Jun 2008 11:54:50 -0000
1.3
@@ -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
