Bugs item #2581617, was opened at 2009-02-09 14:51 Message generated for change (Comment added) made by romulog 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: Open Resolution: None 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: Romulo Goncalves (romulog) Date: 2009-02-09 15: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
