Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv23123/src/test/BugTracker/Tests
Modified Files:
All cardinality_violation.SF-1240701.stable.err
cardinality_violation.SF-1240701.stable.err.Five
Added Files:
bind_with_cast.SF-1720934.stable.err.Five
Log Message:
added another column in the catalog for function side effect administration
Functions which have side effects (such as rand and next_value (sequences)),
are now called once per row, even if the function doesn't have arguments.
The last case expects functions/procs to be available with one argument
which isn't used (needed for the multiplex call).
order by needs selection columns (ie no relaxed semantics if there are
group by's)
this fixes bugs
[ 1723863 ] SQL Query Crashes Server - CRITICAL
[ 1723791 ] rand() is not executed for every row
--- NEW FILE: bind_with_cast.SF-1720934.stable.err.Five ---
stderr of test 'bind_with_cast.SF-1720934` in directory 'src/test/BugTracker`
itself:
# 14:16:53 >
# 14:16:53 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/MonetDB.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_port=32953 --set xrpc_port=47402 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 14:16:53 >
# 14:16:53 >
# 14:16:53 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=32953
# 14:16:53 >
MAPI = [EMAIL PROTECTED]:30617
QUERY = exec 0('100');
ERROR = !MALException:(unknown):wrong argument for prepared statement (expected
int instead of char)
# 14:16:53 >
# 14:16:53 > Done.
# 14:16:53 >
Index: cardinality_violation.SF-1240701.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/cardinality_violation.SF-1240701.stable.err,v
retrieving revision 1.15
retrieving revision 1.16
diff -u -d -r1.15 -r1.16
--- cardinality_violation.SF-1240701.stable.err 1 May 2007 18:16:40 -0000
1.15
+++ cardinality_violation.SF-1240701.stable.err 23 May 2007 22:06:01 -0000
1.16
@@ -68,13 +68,13 @@
# 23:24:25 > Mtimeout -timeout 60 MapiClient -lsql -u monetdb -P monetdb
--host=localhost --port=45948 < cardinality_violation.SF-1240701.sql
# 23:24:25 >
-MAPI = [EMAIL PROTECTED]:31442
+MAPI = [EMAIL PROTECTED]:37461
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.
-MAPI = [EMAIL PROTECTED]:31442
+MAPI = [EMAIL PROTECTED]:37461
QUERY = select * from columns where name = (select columns.name from _tables,
columns where _tables.id = columns.table_id);
-ERROR = !ERROR: zero_or_one: cardinality violation (170>1)
+ERROR = !ERROR: zero_or_one: cardinality violation (171>1)
!ERROR: zero_or_one: operation failed.
# 23:24:25 >
Index: cardinality_violation.SF-1240701.stable.err.Five
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/cardinality_violation.SF-1240701.stable.err.Five,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -d -r1.10 -r1.11
--- cardinality_violation.SF-1240701.stable.err.Five 18 May 2007 20:18:59
-0000 1.10
+++ cardinality_violation.SF-1240701.stable.err.Five 23 May 2007 22:06:01
-0000 1.11
@@ -10,7 +10,7 @@
ERROR = !SQLException:zero_or_one:cardinality violation (41>1)
MAPI = [EMAIL PROTECTED]:37200
QUERY = select * from columns where name = (select columns.name from _tables,
columns where _tables.id = columns.table_id);
-ERROR = !SQLException:zero_or_one:cardinality violation (170>1)
+ERROR = !SQLException:zero_or_one:cardinality violation (171>1)
# 23:24:25 >
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.55
retrieving revision 1.56
diff -u -d -r1.55 -r1.56
--- All 19 May 2007 12:18:15 -0000 1.55
+++ All 23 May 2007 22:06:01 -0000 1.56
@@ -69,3 +69,5 @@
alter-default.SF-1695290
with_only_once.SF-1720293
bind_with_cast.SF-1720934
+groupby_orderby_nonselected.SF-1723863
+rand_not_executed_for_every_row.SF-1723791
-------------------------------------------------------------------------
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
