Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv27889/src/test/BugTracker/Tests
Added Files:
groupby_orderby_nonselected.SF-1723863.sql
groupby_orderby_nonselected.SF-1723863.stable.err
groupby_orderby_nonselected.SF-1723863.stable.out
rand_not_executed_for_every_row.SF-1723791.sql
rand_not_executed_for_every_row.SF-1723791.stable.err
rand_not_executed_for_every_row.SF-1723791.stable.out
Log Message:
tests for the fixed bugs.
--- NEW FILE: groupby_orderby_nonselected.SF-1723863.sql ---
CREATE TABLE data_1to10 (
id INTEGER NOT NULL,
col1 INTEGER NOT NULL,
col2 VARCHAR(10) NOT NULL
) ;
select count(*)
from (
select col2, count(*) as row_count
from data_1to10
group by col2
order by row_count desc, col1
) sq;
drop table data_1to10;
--- NEW FILE: groupby_orderby_nonselected.SF-1723863.stable.err ---
stderr of test 'groupby_orderby_nonselected.SF-1723863` in directory
'src/test/BugTracker` itself:
# 23:24:26 >
# 23:24:26 > 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=35962 --set xrpc_port=41949 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 23:24:26 >
# 23:24:26 >
# 23:24:26 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35962
# 23:24:26 >
MAPI = [EMAIL PROTECTED]:35962
QUERY = select count(*)
ERROR = !ORDER BY: no such column 'col1'
# 23:24:26 >
# 23:24:26 > Done.
# 23:24:26 >
--- NEW FILE: rand_not_executed_for_every_row.SF-1723791.sql ---
create table nr (nr int);
insert into nr values (1);
insert into nr values (2);
insert into nr values (3);
insert into nr values (4);
insert into nr values (5);
insert into nr values (6);
insert into nr values (7);
insert into nr values (8);
insert into nr values (9);
insert into nr values (10);
select count (*) from
(select rand() as r, nr from nr) a,
(select rand() as r, nr from nr) b
where a.r = b.r;
drop table nr;
--- NEW FILE: rand_not_executed_for_every_row.SF-1723791.stable.out ---
stdout of test 'rand_not_executed_for_every_row.SF-1723791` in directory
'src/test/BugTracker` itself:
# 23:56:26 >
# 23:56:26 > Mtimeout -timeout 180 mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/xquery_logs"
--set mapi_port=35185 --set xrpc_port=44020 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=' include sql;' ; echo ; echo
Over..
# 23:56:26 >
# MonetDB Server v5.0.0_beta2_1
# Copyright (c) 1993-2007 CWI, all rights reserved
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked
# dbname:mTests_src_test_BugTracker
# Visit http://monetdb.cwi.nl/ for further information
Ready.
Over..
# 23:24:26 >
# 23:24:26 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35962
# 23:24:26 >
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
% . # table_name
% count_ # name
% int # type
% 1 # length
[ 0 ]
# 23:24:26 >
# 23:24:26 > Done.
# 23:24:26 >
--- NEW FILE: rand_not_executed_for_every_row.SF-1723791.stable.err ---
stderr of test 'rand_not_executed_for_every_row.SF-1723791` in directory
'src/test/BugTracker` itself:
# 23:24:26 >
# 23:24:26 > 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=35962 --set xrpc_port=41949 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 23:24:26 >
# 23:24:26 >
# 23:24:26 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35962
# 23:24:26 >
# 23:24:26 >
# 23:24:26 > Done.
# 23:24:26 >
--- NEW FILE: groupby_orderby_nonselected.SF-1723863.stable.out ---
stdout of test 'groupby_orderby_nonselected.SF-1723863` in directory
'src/test/BugTracker` itself:
# 23:24:26 >
# 23:24:26 > 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=35962 --set xrpc_port=41949 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 23:24:26 >
# Monet Database Server V4.17.1
# Copyright (c) 1993-2007, CWI. All rights reserved.
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
# Visit http://monetdb.cwi.nl/ for further information.
printf("\nReady.\n");
Ready.
quit();
Over..
# 23:24:26 >
# 23:24:26 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35962
# 23:24:26 >
# 23:24:26 >
# 23:24:26 > Done.
# 23:24:26 >
-------------------------------------------------------------------------
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
