Bugs item #2581617, was opened at 2009-02-09 13:51
Message generated for change (Comment added) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2581617&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: SQL "stable"
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Romulo Goncalves (romulog)
Assigned to: Niels Nes (nielsnes)
Summary: cardinality of expression is wrong
Initial Comment:
The following sql crashes M5-SQL
create table t1 (id int, age int);
insert into t1 values(1, 1);
insert into t1 values(1, 1);
insert into t1 values(2, 1);
insert into t1 values(3, 1);
insert into t1 values(4, 1);
create view v2 as (select id, age from t1 group by id, age);
select id from v2 where id = 2;
drop view v2;
drop table t1;
mserver debug:
Program received signal SIGABRT, Aborted.
[Switching to Thread 0x7fffe1728950 (LWP 13769)]
0x0000003830832f05 in raise () from /lib64/libc.so.6
Missing separate debuginfos, use: debuginfo-install
bzip2-libs-1.0.5-3.fc10.x86_64 e2fsprogs-libs-1.41.3-2.fc10.x86_64
glibc-2.9-3.x86_64 keyutils-libs-1.2-3.fc9.x86_64
krb5-libs-1.6.3-16.fc10.x86_64 libselinux-2.0.73-1.fc10.x86_64
ncurses-libs-5.6-20.20080927.fc10.x86_64 openssl-0.9.8g-12.fc10.x86_64
pcre-7.8-1.fc10.x86_64 readline-5.2-13.fc9.x86_64
zlib-1.2.3-18.fc9.x86_64
(gdb) up
#1 0x0000003830834a73 in abort () from /lib64/libc.so.6
(gdb) up
#2 0x000000383082bef9 in __assert_fail () from /lib64/libc.so.6
(gdb) up
#3 0x00007fffe2816472 in rel_project (l=0x7fffd41d1d98,
e=0x7fffe0ce7cb8) at
/ufs/goncalve/MonetDB/current/sql/src/server/rel_select.mx:556
556 assert (exps_card(rel->exps) <= rel->card);
(gdb) p rel
$1 = (sql_rel *) 0x7fffec155f58
(gdb) p rel->exps
$2 = (list *) 0x7fffe0ce7cb8
(gdb) p rel->card
$3 = 2 '\002'
The bug is the card of rel isn't really 2(aggr) but 3 (relation).
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2009-02-11 19:45
Message:
When optimizing we sometimes have to fixup the cardinality of
expressions
----------------------------------------------------------------------
Comment By: Romulo Goncalves (romulog)
Date: 2009-02-09 14:56
Message:
Test added at:
sql/src/test/BugTracker-2009/Tests/Attic/cardinality_of_expression_is_wrong.SF-2581617.sql
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2581617&group_id=56967
------------------------------------------------------------------------------
Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
