Update of /cvsroot/monetdb/sql/src/test/bugs/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv7368/src/test/bugs/Tests
Added Files:
create_insert_select_aggr-bug-00001.stable.err.Algebra
except-union-intersect-bug-sf-1146079.stable.out.Algebra
foreignkey_leftjoin-bug-sf-854312.stable.err.Algebra
groupby_having-bug-sf-947600.stable.out.Algebra
select_constant_from_where_1=1-bug-sf-1019529.stable.err.Algebra
Log Message:
adding special output for algebra version
changed sql.trace() into sql.logfile(filename:string), which can be called
from sql too.
fixed handling of dependency problem on views (one remains)
--- NEW FILE: groupby_having-bug-sf-947600.stable.out.Algebra ---
stdout of test 'groupby_having-bug-sf-947600` in directory 'src/test/bugs`
itself:
# 12:30:55 >
# 12:30:55 > Mtimeout -timeout 180 mserver5
"--config=/ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf" --debug=10
--set
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/dbfarm"
--set "sql_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/sql_logs"
--set
"xquery_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/xquery_logs"
--set mapi_port=30086 --set xrpc_port=44187 --set monet_prompt= --trace
"--dbname=mTests_src_test_bugs" --dbinit='include sql;' ; echo ; echo Over..
# 12:30:55 >
# 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_bugs
# Visit http://monetdb.cwi.nl/ for further information
Ready.
Over..
# 11:55:31 >
# 11:55:31 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35185 < groupby_having-bug-sf-947600.sql
# 11:55:31 >
% sys.a, sys.b, sys.b # table_name
% name, name, L4 # name
% varchar, varchar, int # type
% 10, 10, 2 # length
[ "args", "columns", 6 ]
[ "args", "idxs", 6 ]
[ "args", "keycolumns", 2 ]
[ "args", "keys", 6 ]
[ "args", "sequences", 2 ]
[ "functions", "args", 2 ]
[ "functions", "columns", 2 ]
[ "functions", "idxs", 4 ]
[ "functions", "keycolumns", 2 ]
[ "functions", "keys", 4 ]
[ "functions", "sequences", 3 ]
[ "idxs", "columns", 8 ]
[ "idxs", "idxs", 4 ]
[ "idxs", "keycolumns", 3 ]
[ "idxs", "keys", 4 ]
[ "keycolumns", "columns", 2 ]
[ "keycolumns", "idxs", 1 ]
[ "keycolumns", "keycolumns", 4 ]
[ "keycolumns", "keys", 1 ]
[ "keys", "columns", 8 ]
[ "keys", "idxs", 12 ]
[ "keys", "keycolumns", 3 ]
[ "keys", "keys", 6 ]
[ "sequences", "columns", 2 ]
[ "sequences", "idxs", 4 ]
[ "sequences", "keycolumns", 2 ]
[ "sequences", "keys", 4 ]
% sys.tables # table_name
% name # name
% varchar # type
% 10 # length
[ "args" ]
[ "functions" ]
[ "idxs" ]
[ "idxs" ]
[ "keycolumns" ]
[ "keycolumns" ]
[ "keys" ]
[ "keys" ]
[ "sequences" ]
% sys.tables # table_name
% name # name
% varchar # type
% 0 # length
% sys.tables # table_name
% name # name
% varchar # type
% 10 # length
[ "args" ]
[ "functions" ]
[ "idxs" ]
[ "keycolumns" ]
[ "keys" ]
[ "sequences" ]
% sys.tables # table_name
% name # name
% varchar # type
% 0 # length
# 11:55:31 >
# 11:55:31 > Done.
# 11:55:31 >
--- NEW FILE: foreignkey_leftjoin-bug-sf-854312.stable.err.Algebra ---
stderr of test 'foreignkey_leftjoin-bug-sf-854312` in directory 'src/test/bugs`
itself:
# 21:30:23 >
# 21:30:23 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/data/Linux-i686/etc/monet.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/data/Linux-i686/lib/MonetDB" --set
"gdk_dbfarm=/ufs/niels/data/Linux-i686/var/MonetDB/dbfarm" --set
"sql_logdir=/ufs/niels/data/Linux-i686/var/MonetDB/log" --set mapi_port=49068
--set sql_port=52668 --set monet_prompt= --trace
"--dbname=mTests_src_test_bugs"
"/net/stem.ins.cwi.nl/export/scratch1/niels/Linux-i686/build-sql/src/backends/monet4/sql_server.mil"
; echo ; echo Over..
# 21:30:23 >
MAPI = [EMAIL PROTECTED]:34235
QUERY = SELECT * FROM a LEFT JOIN b ON a.var1 = b.id WHERE var1 = 'aJan';
ERROR = !SELECT: identifier 'var1' unknown or ambiguous
MAPI = [EMAIL PROTECTED]:34235
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('1', 'aaab',
1877611059, 2136665433, 'Bibliotheek', 'U');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
MAPI = [EMAIL PROTECTED]:34235
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('2', 'aaab',
1181479988, NULL, 'hier', 'verwachten');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
MAPI = [EMAIL PROTECTED]:34235
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('3', 'aaab',
1906079357, 1955202416, 'tot', 'van');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
MAPI = [EMAIL PROTECTED]:34235
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('4', 'aaac',
676937782, NULL, 'als zijn', 'z');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
MAPI = [EMAIL PROTECTED]:34235
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('5', 'aaac',
429573099, 1767983525, 'o', 'het');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
MAPI = [EMAIL PROTECTED]:34235
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('6', 'aaad',
1173429043, 216615742, 'Welk', 'nieuwe boeken');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
MAPI = [EMAIL PROTECTED]:34235
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('7', 'aaad',
1722898798, 412510482, 'onlangs', 'oege');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
MAPI = [EMAIL PROTECTED]:34235
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('8', 'aaad',
1111774637, 2025755091, 'Er is', 'lijst met');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
MAPI = [EMAIL PROTECTED]:34235
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('9', 'aaad',
2106443074, 500880029, 'be', 'schikb');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
MAPI = [EMAIL PROTECTED]:34235
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('10', 'aaae',
1862088833, 1636412274, '', 'Klik');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
MAPI = [EMAIL PROTECTED]:34235
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('11', 'aaae',
740103512, 1959552303, 'om een gratis', 'te');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
MAPI = [EMAIL PROTECTED]:34235
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('12', 'aaae',
615168073, 1166551474, 'Doo', 'met de rechter');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
MAPI = [EMAIL PROTECTED]:34235
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('13', 'aaae',
1714170141, 1144940450, 'is', 'op');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
MAPI = [EMAIL PROTECTED]:34235
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('14', 'aaaf',
293281126, 1101721875, 'klikken', 'kunt u');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
MAPI = [EMAIL PROTECTED]:34235
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('15', 'aaaf',
1371008872, 1420507527, 'bestan', 'naar uw');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
MAPI = [EMAIL PROTECTED]:34235
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('16', 'aaaf',
1238690311, 2013589728, 'overhalen', 'en');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
MAPI = [EMAIL PROTECTED]:34235
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('17', 'aaaf',
1598516811, 1682499981, 'opslaan. U', 'op');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
MAPI = [EMAIL PROTECTED]:34235
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('18', 'aaag',
1551706168, 1147370461, 'reide', 'en');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
MAPI = [EMAIL PROTECTED]:34235
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('19', 'aaag',
1178314077, 670110160, '', 'boek');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
MAPI = [EMAIL PROTECTED]:34235
QUERY = SELECT * FROM a LEFT JOIN b ON a.var1 = b.id WHERE var1 = 'aJan';
ERROR = !SELECT: identifier 'var1' unknown or ambiguous
# 21:30:24 >
# 21:30:24 > Done.
# 21:30:24 >
--- NEW FILE: create_insert_select_aggr-bug-00001.stable.err.Algebra ---
stderr of test 'create_insert_select_aggr-bug-00001` in directory
'src/test/bugs` itself:
# 21:23:43 >
# 21:23:43 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/data/Linux-i686/etc/monet.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/data/Linux-i686/lib/MonetDB" --set
"gdk_dbfarm=/ufs/niels/data/Linux-i686/var/MonetDB/dbfarm" --set
"sql_logdir=/ufs/niels/data/Linux-i686/var/MonetDB/log" --set mapi_port=49514
--set sql_port=51365 --set monet_prompt= --trace
"--dbname=mTests_src_test_bugs"
"/net/stem.ins.cwi.nl/export/scratch1/niels/Linux-i686/build-sql/src/backends/monet4/sql_server.mil"
; echo ; echo Over..
# 21:23:43 >
MAPI = [EMAIL PROTECTED]:34235
QUERY = select name, count(*) from _tables;
ERROR = !cannot use non GROUP BY column 'name' in query results without an
aggregate function
# 21:23:44 >
# 21:23:44 > Done.
# 21:23:44 >
--- NEW FILE: except-union-intersect-bug-sf-1146079.stable.out.Algebra ---
stdout of test 'except-union-intersect-bug-sf-1146079` in directory
'src/test/bugs` itself:
# 20:14:43 >
# 20:14:43 > Mtimeout -timeout 300 Mserver
"--config=/ufs/fabian/scratch/monetdb/current/program-x86_64/etc/MonetDB.conf"
--debug=10 --set
"monet_mod_path=/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/MonetDB:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/bin"
--set
"gdk_dbfarm=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/dbfarm"
--set
"sql_logdir=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/log"
--set mapi_port=36933 --set sql_port=44855 --set xquery_port=59461 --set
monet_prompt= --trace "--dbname=mTests_src_test_bugs"
--dbinit="module(sql_server); sql_server_start();" ; echo ; echo Over..
# 20:14:43 >
# Monet Database Server V4.9.3
# Copyright (c) 1993-2005, 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.
Ready.
Over..
# 20:14:43 >
# 20:14:43 > Mtimeout -timeout 180 ./except-union-intersect-bug-sf-1146079.SQL
except-union-intersect-bug-sf-1146079
# 20:14:43 >
# 20:14:43 >
# 20:14:43 > Mtimeout -timeout 60 java -jar
/net/pegasus.ins.cwi.nl/export/scratch1/fabian/monetdb/current/build-pegasus.ins.cwi.nl/sql/src/jdbc/jdbcclient-1.2.jar
-h localhost -p 44855 -e -f
../../../../..//current/sql/src/test/bugs/Tests/../except-union-intersect-bug-sf-1146079.sql
# 20:14:43 >
START TRANSACTION;
Operation successful
CREATE TABLE "a" (
"property" int NOT NULL,
"class" int NOT NULL,
CONSTRAINT "a_property_class_pkey" PRIMARY KEY ("class", "property")
);
Operation successful
INSERT INTO "a" VALUES (1, 17);
1 affected row
INSERT INTO "a" VALUES (21, 17);
1 affected row
INSERT INTO "a" VALUES (22, 17);
1 affected row
INSERT INTO "a" VALUES (20, 2);
1 affected row
INSERT INTO "a" VALUES (19, 17);
1 affected row
INSERT INTO "a" VALUES (4, 16);
1 affected row
INSERT INTO "a" VALUES (5, 16);
1 affected row
INSERT INTO "a" VALUES (6, 16);
1 affected row
INSERT INTO "a" VALUES (29, 16);
1 affected row
INSERT INTO "a" VALUES (12, 16);
1 affected row
INSERT INTO "a" VALUES (13, 11);
1 affected row
INSERT INTO "a" VALUES (26, 16);
1 affected row
INSERT INTO "a" VALUES (25, 16);
1 affected row
INSERT INTO "a" VALUES (23, 18);
1 affected row
INSERT INTO "a" VALUES (24, 18);
1 affected row
INSERT INTO "a" VALUES (15, 16);
1 affected row
-- table b differs from a that 50% of the values are decreased by 1 (last part)
CREATE TABLE "b" (
"property" int NOT NULL,
"class" int NOT NULL,
CONSTRAINT "b_property_class_pkey" PRIMARY KEY ("class", "property")
);
Operation successful
INSERT INTO "b" VALUES (1, 17);
1 affected row
INSERT INTO "b" VALUES (21, 17);
1 affected row
INSERT INTO "b" VALUES (22, 17);
1 affected row
INSERT INTO "b" VALUES (20, 2);
1 affected row
INSERT INTO "b" VALUES (19, 17);
1 affected row
INSERT INTO "b" VALUES (4, 16);
1 affected row
INSERT INTO "b" VALUES (5, 16);
1 affected row
INSERT INTO "b" VALUES (6, 16);
1 affected row
INSERT INTO "b" VALUES (28, 15);
1 affected row
INSERT INTO "b" VALUES (11, 15);
1 affected row
INSERT INTO "b" VALUES (12, 10);
1 affected row
INSERT INTO "b" VALUES (25, 15);
1 affected row
INSERT INTO "b" VALUES (24, 15);
1 affected row
INSERT INTO "b" VALUES (23, 17);
1 affected row
INSERT INTO "b" VALUES (14, 15);
1 affected row
-- make it permanent
COMMIT;
Operation successful
-- simple check whether everything is there
START TRANSACTION;
Operation successful
SELECT * FROM a;
+----------+-------+
| property | class |
+==========+=======+
| 1 | 17 |
| 21 | 17 |
| 22 | 17 |
| 20 | 2 |
| 19 | 17 |
| 4 | 16 |
| 5 | 16 |
| 6 | 16 |
| 29 | 16 |
| 12 | 16 |
| 13 | 11 |
| 26 | 16 |
| 25 | 16 |
| 23 | 18 |
| 24 | 18 |
| 15 | 16 |
+----------+-------+
16 rows
SELECT * FROM b;
+----------+-------+
| property | class |
+==========+=======+
| 1 | 17 |
| 21 | 17 |
| 22 | 17 |
| 20 | 2 |
| 19 | 17 |
| 4 | 16 |
| 5 | 16 |
| 6 | 16 |
| 28 | 15 |
| 11 | 15 |
| 12 | 10 |
| 25 | 15 |
| 24 | 15 |
| 23 | 17 |
| 14 | 15 |
+----------+-------+
15 rows
ROLLBACK;
Operation successful
-- require an upcast from sht to int
START TRANSACTION;
Operation successful
SELECT class FROM a EXCEPT SELECT 16; -- all but 16
+-------+
| class |
+=======+
| 17 |
| 2 |
| 11 |
| 18 |
+-------+
4 rows
SELECT class FROM a UNION SELECT 16; -- all with 16 (distinct so invisible)
+-------+
| class |
+=======+
| 17 |
| 2 |
| 16 |
| 11 |
| 18 |
+-------+
5 rows
SELECT class FROM a INTERSECT SELECT 16; -- just 16
+-------+
| class |
+=======+
| 16 |
+-------+
1 row
ROLLBACK;
Operation successful
-- do the same with a real table
START TRANSACTION;
Operation successful
SELECT * FROM a EXCEPT SELECT * FROM b; -- should be last 50% of a
+----------+-------+
| property | class |
+==========+=======+
| 29 | 16 |
| 12 | 16 |
| 13 | 11 |
| 26 | 16 |
| 25 | 16 |
| 23 | 18 |
| 24 | 18 |
| 15 | 16 |
+----------+-------+
8 rows
SELECT * FROM a UNION SELECT * FROM b; -- should be a + last 50% of b
+----------+-------+
| property | class |
+==========+=======+
| 1 | 17 |
| 21 | 17 |
| 22 | 17 |
| 20 | 2 |
| 19 | 17 |
| 4 | 16 |
| 5 | 16 |
| 6 | 16 |
| 29 | 16 |
| 12 | 16 |
| 13 | 11 |
| 26 | 16 |
| 25 | 16 |
| 23 | 18 |
| 24 | 18 |
| 15 | 16 |
| 28 | 15 |
| 11 | 15 |
| 12 | 10 |
| 25 | 15 |
| 24 | 15 |
| 23 | 17 |
| 14 | 15 |
+----------+-------+
23 rows
SELECT * FROM a INTERSECT SELECT * FROM b; -- should be first 50% of a
+----------+-------+
| property | class |
+==========+=======+
| 1 | 17 |
| 21 | 17 |
| 22 | 17 |
| 20 | 2 |
| 19 | 17 |
| 4 | 16 |
| 5 | 16 |
| 6 | 16 |
+----------+-------+
8 rows
ROLLBACK;
Operation successful
-- now check the non-duplicate removing versions
-- (they are very tricky, so be on your marks!)
START TRANSACTION;
Operation successful
SELECT class FROM a EXCEPT ALL SELECT 16; -- all but one 16 (will have 16 in
output!)
+-------+
| class |
+=======+
| 17 |
| 17 |
| 17 |
| 17 |
| 2 |
| 11 |
| 18 |
| 18 |
| 16 |
| 16 |
| 16 |
| 16 |
| 16 |
| 16 |
| 16 |
+-------+
15 rows
SELECT class FROM a UNION ALL SELECT 16; -- all plus 16
+-------+
| class |
+=======+
| 17 |
| 17 |
| 17 |
| 2 |
| 17 |
| 16 |
| 16 |
| 16 |
| 16 |
| 16 |
| 11 |
| 16 |
| 16 |
| 18 |
| 18 |
| 16 |
| 16 |
+-------+
17 rows
SELECT class FROM a INTERSECT ALL SELECT 16; -- just one 16 (!)
+-------+
| class |
+=======+
| 16 |
+-------+
1 row
ROLLBACK;
Operation successful
-- do the same with a real table (because our tables have a key on both
-- columns we also use only the first column here, as otherwise the ALL
-- would never be tested for tables)
START TRANSACTION;
Operation successful
SELECT * FROM a EXCEPT ALL SELECT * FROM b; -- last 50% of a
+----------+-------+
| property | class |
+==========+=======+
| 29 | 16 |
| 12 | 16 |
| 13 | 11 |
| 26 | 16 |
| 25 | 16 |
| 23 | 18 |
| 24 | 18 |
| 15 | 16 |
+----------+-------+
8 rows
SELECT class FROM a EXCEPT ALL SELECT class FROM b; -- a minus the elements
from b that are in a (if count(x) in a > count(x) in b, x will appear in output)
+-------+
| class |
+=======+
| 11 |
| 18 |
| 18 |
| 16 |
| 16 |
| 16 |
| 16 |
| 16 |
+-------+
8 rows
SELECT * FROM a UNION ALL SELECT * FROM b; -- a + b
+----------+-------+
| property | class |
+==========+=======+
| 1 | 17 |
| 21 | 17 |
| 22 | 17 |
| 20 | 2 |
| 19 | 17 |
| 4 | 16 |
| 5 | 16 |
| 6 | 16 |
| 29 | 16 |
| 12 | 16 |
| 13 | 11 |
| 26 | 16 |
| 25 | 16 |
| 23 | 18 |
| 24 | 18 |
| 15 | 16 |
| 1 | 17 |
| 21 | 17 |
| 22 | 17 |
| 20 | 2 |
| 19 | 17 |
| 4 | 16 |
| 5 | 16 |
| 6 | 16 |
| 28 | 15 |
| 11 | 15 |
| 12 | 10 |
| 25 | 15 |
| 24 | 15 |
| 23 | 17 |
| 14 | 15 |
+----------+-------+
31 rows
SELECT * FROM a INTERSECT ALL SELECT * FROM b; -- first 50% of a
+----------+-------+
| property | class |
+==========+=======+
| 1 | 17 |
| 21 | 17 |
| 22 | 17 |
| 20 | 2 |
| 19 | 17 |
| 4 | 16 |
| 5 | 16 |
| 6 | 16 |
+----------+-------+
8 rows
SELECT class FROM a INTERSECT ALL SELECT class FROM b; -- only those that are
both in a and b (min(count(a, x), count(b, x)) !!!
+-------+
| class |
+=======+
| 17 |
| 17 |
| 17 |
| 17 |
| 2 |
| 16 |
| 16 |
| 16 |
+-------+
8 rows
ROLLBACK;
Operation successful
-- cleanup! (also should cascade into dropping the index)
START TRANSACTION;
Operation successful
DROP TABLE "a";
Operation successful
DROP TABLE "b";
Operation successful
COMMIT;
Operation successful
# 20:14:43 >
# 20:14:43 > Done.
# 20:14:43 >
--- NEW FILE: select_constant_from_where_1=1-bug-sf-1019529.stable.err.Algebra
---
stderr of test 'select_constant_from_where_1=1-bug-sf-1019529` in directory
'src/test/bugs` itself:
# 13:45:14 >
# 13:45:14 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/data/Linux-i686/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/data/Linux-i686/lib/MonetDB" --set
"gdk_dbfarm=/ufs/niels/data/Linux-i686/var/MonetDB/dbfarm" --set
"sql_logdir=/ufs/niels/data/Linux-i686/var/MonetDB/log" --set mapi_port=47399
--set sql_port=57322 --set monet_prompt= --trace
"--dbname=mTests_src_test_bugs"
"/net/stem.ins.cwi.nl/export/scratch1/niels/Linux-i686/build-sql/src/backends/monet4/sql_server.mil"
; echo ; echo Over..
# 13:45:14 >
MAPI = [EMAIL PROTECTED]:34235
QUERY = select name, count(*) from t1019529; -- should fail
ERROR = !cannot use non GROUP BY column 'name' in query results without an
aggregate function
# 13:45:16 >
# 13:45:16 > Done.
# 13:45:16 >
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
