Update of /cvsroot/monetdb/sql/src/test/BugDay_2005-12-19_2.9.3/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv23009/src/test/BugDay_2005-12-19_2.9.3/Tests
Modified Files:
NULL_in_CASE.SF-1211335.stable.out
multiple_servers_2.SF-1385247.stable.out
prepare-where.SF-1238867.1238959.1238965.1240124.stable.out
select_from_env.SF-1240701.1242164.stable.err
weird_reponse_on_limit.SF-1314643.stable.out
Log Message:
Many fixes
changed how we handle selections over multiple columns of a single table
(should solve the preformance problem reported by Venks)
added a way to bulk request sequence numbers. When loading (copying) data
into tables which have a auto_increment (or alike) column lots of time
was spend in the many calls to get all the sequence numbers (observed a
performance in crease of about 10x when loading pieces of 100K rows)
added support for TINYINT (we map this too 'bte')
improved mapping functions onto the same signature too improve cached
function reuse
Index: prepare-where.SF-1238867.1238959.1238965.1240124.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-12-19_2.9.3/Tests/prepare-where.SF-1238867.1238959.1238965.1240124.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- prepare-where.SF-1238867.1238959.1238965.1240124.stable.out 24 Oct 2006
16:02:53 -0000 1.3
+++ prepare-where.SF-1238867.1238959.1238965.1240124.stable.out 29 Jun 2007
11:29:22 -0000 1.4
@@ -25,7 +25,7 @@
% type, digits, scale # name
% varchar, int, int # type
% 0, 0, 0 # length
-[ "smallint", 16, 0 ]
+[ "tinyint", 8, 0 ]
% prepare, prepare, prepare # table_name
% type, digits, scale # name
% varchar, int, int # type
Index: multiple_servers_2.SF-1385247.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-12-19_2.9.3/Tests/multiple_servers_2.SF-1385247.stable.out,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -d -r1.8 -r1.9
--- multiple_servers_2.SF-1385247.stable.out 9 Nov 2006 22:41:17 -0000
1.8
+++ multiple_servers_2.SF-1385247.stable.out 29 Jun 2007 11:29:22 -0000
1.9
@@ -15,14 +15,14 @@
server 11 : "module(mapi); mil_start(); module(sql_server);", client 1: SQL
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 111 ]
server 11 : "module(mapi); mil_start(); module(sql_server);", client 2: (SQL)
SQL
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 112 ]
@@ -42,7 +42,7 @@
server 12 : "module(mapi); mil_start(); module(sql_server);", client 1: SQL
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 121 ]
@@ -52,7 +52,7 @@
server 12 : "module(mapi); mil_start(); module(sql_server);", client 3: (SQL)
(MAPI) SQL
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 123 ]
Index: select_from_env.SF-1240701.1242164.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-12-19_2.9.3/Tests/select_from_env.SF-1240701.1242164.stable.err,v
retrieving revision 1.12
retrieving revision 1.13
diff -u -d -r1.12 -r1.13
--- select_from_env.SF-1240701.1242164.stable.err 1 May 2007 18:16:40
-0000 1.12
+++ select_from_env.SF-1240701.1242164.stable.err 29 Jun 2007 11:29:22
-0000 1.13
@@ -68,7 +68,7 @@
# 13:22:15 > Mtimeout -timeout 60 MapiClient -lsql -u monetdb -P monetdb
--host=localhost --port=47090 < select_from_env.SF-1240701.1242164.sql
# 13:22:15 >
-MAPI = [EMAIL PROTECTED]:39216
+MAPI = [EMAIL PROTECTED]:32999
QUERY = select * from env() as env where name = ( select 'prefix' from env()
as env );
ERROR = !ERROR: zero_or_one: cardinality violation (44>1)
!ERROR: zero_or_one: operation failed.
Index: NULL_in_CASE.SF-1211335.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-12-19_2.9.3/Tests/NULL_in_CASE.SF-1211335.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- NULL_in_CASE.SF-1211335.stable.out 24 Oct 2006 16:02:52 -0000 1.4
+++ NULL_in_CASE.SF-1211335.stable.out 29 Jun 2007 11:29:19 -0000 1.5
@@ -23,23 +23,23 @@
% . # table_name
% ifthenelse_=_single_value # name
-% smallint # type
+% tinyint # type
% 1 # length
[ 1 ]
% . # table_name
% ifthenelse_=_single_value # name
-% smallint # type
-% 6 # length
+% tinyint # type
+% 4 # length
[ NULL ]
% . # table_name
% ifthenelse_=_single_value # name
-% smallint # type
+% tinyint # type
% 1 # length
[ 2 ]
% . # table_name
% ifthenelse_=_single_value # name
-% smallint # type
-% 6 # length
+% tinyint # type
+% 4 # length
[ NULL ]
% . # table_name
% ifthenelse_=_single_value # name
Index: weird_reponse_on_limit.SF-1314643.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-12-19_2.9.3/Tests/weird_reponse_on_limit.SF-1314643.stable.out,v
retrieving revision 1.15
retrieving revision 1.16
diff -u -d -r1.15 -r1.16
--- weird_reponse_on_limit.SF-1314643.stable.out 13 Dec 2006 03:03:56
-0000 1.15
+++ weird_reponse_on_limit.SF-1314643.stable.out 29 Jun 2007 11:29:23
-0000 1.16
@@ -23,12 +23,12 @@
% sys.tables, sys.tables, sys.tables, sys.tables, sys.tables,
sys.tables # table_name
% name, query, type, system, commit_action, temporary # name
-% varchar, varchar, smallint, boolean, smallint,
smallint # type
+% varchar, varchar, smallint, boolean, smallint,
tinyint # type
% 7, 1, 1, 5, 1, 1 # length
[ "schemas", NULL, 0, true, 0, 0 ]
% sys.tables, sys.tables, sys.tables, sys.tables, sys.tables,
sys.tables # table_name
% name, query, type, system, commit_action, temporary # name
-% varchar, varchar, smallint, boolean, smallint,
smallint # type
+% varchar, varchar, smallint, boolean, smallint,
tinyint # type
% 7, 1, 1, 5, 1, 1 # length
[ "schemas", NULL, 0, true, 0, 0 ]
[ "types", NULL, 0, true, 0, 0 ]
-------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
