Bugs item #2630881, was opened at 2009-02-23 18:32 Message generated for change (Comment added) made by stmane You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2630881&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 CVS Head Status: Closed Resolution: Fixed Priority: 5 Private: Yes Submitted By: Jens Oehlschlägel (jens_oehl) Assigned to: Niels Nes (nielsnes) Summary: SELECT expression with IN in CASE statement causes '0 tuples Initial Comment: Niels: replication attached Stefan: please put first SQL into autotest cases as #90 Observed with 150k rows under Win32: MonetDB server v5.10.0 (32-bit), based on kernel v1.28.0 (32-bit oids) Copyright (c) 1993-July 2008 CWI Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved Visit http://monetdb.cwi.nl/ for further information Configured for prefix: C:\Documents and Settings\sjoerd\My Documents\src\stable\vs32\NT32 Libraries: libpcre: 7.7 2008-05-07 libxml2: 2.6.32 Compiled by: sjo...@gans Compilation: cl -GF -W3 -WX -wd4273 -wd4102 -MD -nologo -Ox Linking : cl -GF -W3 -WX -wd4273 -wd4102 -MD -nologo -Ox ---------------------------------------------------------------------- >Comment By: Stefan Manegold (stmane) Date: 2009-02-24 18:19 Message: added test autotest_90 ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2009-02-24 17:02 Message: Fixed in Feb2009 branch by Niels. ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2009-02-23 19:46 Message: Also this one triggers an assertion: could not find L6.L5 q_sourceoverview.dt_country q_sourceoverview.dt_customer_attrib1 q_sourceoverview.dt_product_attrib2 q_sourceoverview.dt_customer_group q_sourceoverview.postingyear q_sourceoverview.postingquarter q_sourceoverview.dt_d00 q_sourceoverview.dt_d01 q_sourceoverview.dt_volume q_sourceoverview.dt_price_categ q_sourceoverview.dt_uom q_sourceoverview.dt_curr tbl_uom.%TID% t_base_sales.%TID% tbl_exchange_rates.%TID% q_sourceoverview.dt_country q_sourceoverview.dt_customer_attrib1 q_sourceoverview.dt_customer_group q_sourceoverview.dt_product_attrib2 q_sourceoverview.dt_price_categ q_sourceoverview.L1 q_sourceoverview.L2 q_sourceoverview.L3 q_sourceoverview.L4 mserver5: /ufs/manegold/_/scratch0/Monet/Testing/Stable/source/sql/src/server/rel_bin.mx:1538: rel2bin_groupby: Assertion `0' failed. Program received signal SIGABRT, Aborted. [Switching to Thread 0x7fffe1c93950 (LWP 19838)] 0x0000003675232f05 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 0x0000003675234a73 in abort () from /lib64/libc.so.6 (gdb) #2 0x000000367522bef9 in __assert_fail () from /lib64/libc.so.6 (gdb) #3 0x00007fffe276095f in rel2bin_groupby (sql=0x13c92f8, rel=0x14af798, refs=0x1404648) at /ufs/manegold/_/scratch0/Monet/Testing/Stable/source/sql/src/server/rel_bin.mx:1538 1538 assert(0); (gdb) li 1533 therefor we pass the group by columns too 1534 */ 1535 if (!aggrstmt) 1536 aggrstmt = exp_bin(sql, aggrexp, sub, cursub, groupby, NULL); 1537 if (!aggrstmt) { 1538 assert(0); 1539 stmt_destroy(cursub); 1540 stmt_destroy(sub); 1541 if (groupby) grp_destroy(groupby); 1542 return NULL; (gdb) bt #0 0x0000003675232f05 in raise () from /lib64/libc.so.6 #1 0x0000003675234a73 in abort () from /lib64/libc.so.6 #2 0x000000367522bef9 in __assert_fail () from /lib64/libc.so.6 #3 0x00007fffe276095f in rel2bin_groupby (sql=0x13c92f8, rel=0x14af798, refs=0x1404648) at /ufs/manegold/_/scratch0/Monet/Testing/Stable/source/sql/src/server/rel_bin.mx:1538 #4 0x00007fffe276644d in subrel_bin (sql=0x13c92f8, rel=0x14af798, refs=0x1404648) at /ufs/manegold/_/scratch0/Monet/Testing/Stable/source/sql/src/server/rel_bin.mx:3230 #5 0x00007fffe2760374 in rel2bin_select (sql=0x13c92f8, rel=0x14b2948, refs=0x1404648) at /ufs/manegold/_/scratch0/Monet/Testing/Stable/source/sql/src/server/rel_bin.mx:1395 #6 0x00007fffe2766425 in subrel_bin (sql=0x13c92f8, rel=0x14b2948, refs=0x1404648) at /ufs/manegold/_/scratch0/Monet/Testing/Stable/source/sql/src/server/rel_bin.mx:3226 #7 0x00007fffe275fd7a in rel2bin_project (sql=0x13c92f8, rel=0x14af958, refs=0x1404648) at /ufs/manegold/_/scratch0/Monet/Testing/Stable/source/sql/src/server/rel_bin.mx:1279 #8 0x00007fffe27663fd in subrel_bin (sql=0x13c92f8, rel=0x14af958, refs=0x1404648) at /ufs/manegold/_/scratch0/Monet/Testing/Stable/source/sql/src/server/rel_bin.mx:3222 #9 0x00007fffe27665f9 in output_rel_bin (sql=0x13c92f8, rel=0x14af958) at /ufs/manegold/_/scratch0/Monet/Testing/Stable/source/sql/src/server/rel_bin.mx:3275 #10 0x00007fffe26b9275 in sql_symbol2stmt (c=0x13c92f8, sym=0x13ce158) at /ufs/manegold/_/scratch0/Monet/Testing/Stable/source/sql/src/backends/monet5/sql.mx:1102 #11 0x00007fffe26f3f42 in SQLparser (c=0x604a00) at /ufs/manegold/_/scratch0/Monet/Testing/Stable/source/sql/src/backends/monet5/sql_scenario.mx:1013 #12 0x00007ffff7d336cb in runPhase (c=0x604a00, phase=1) at /ufs/manegold/_/scratch0/Monet/Testing/Stable/source/MonetDB5/src/mal/mal_scenario.mx:591 #13 0x00007ffff7d337c2 in runScenarioBody (c=0x604a00) at /ufs/manegold/_/scratch0/Monet/Testing/Stable/source/MonetDB5/src/mal/mal_scenario.mx:627 #14 0x00007ffff7d339ef in runScenario (c=0x604a00) at /ufs/manegold/_/scratch0/Monet/Testing/Stable/source/MonetDB5/src/mal/mal_scenario.mx:661 #15 0x00007ffff7cf15aa in MSserveClient (dummy=0x604a00) at /ufs/manegold/_/scratch0/Monet/Testing/Stable/source/MonetDB5/src/mal/mal_session.mx:460 #16 0x0000003675e073da in start_thread () from /lib64/libpthread.so.0 #17 0x00000036752e62bd in clone () from /lib64/libc.so.6 (gdb) ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2009-02-23 19:14 Message: added test as IN_CASE_ZERO_TUPLES.SF-2630881.* SQL compiler fails with " could not find L6.L5 q_sourceoverview.dt_country q_sourceoverview.dt_customer_attrib1 q_sourceoverview.dt_product_attrib2 q_sourceoverview.dt_customer_group q_sourceoverview.postingyear q_sourceoverview.postingquarter q_sourceoverview.dt_d00 q_sourceoverview.dt_d01 q_sourceoverview.dt_volume q_sourceoverview.dt_price_categ q_sourceoverview.dt_uom q_sourceoverview.dt_curr tbl_uom.%TID% t_base_sales.%TID% tbl_exchange_rates.%TID% q_sourceoverview.dt_country q_sourceoverview.dt_customer_attrib1 q_sourceoverview.dt_customer_group q_sourceoverview.dt_product_attrib2 q_sourceoverview.dt_price_categ q_sourceoverview.L1 q_sourceoverview.L2 q_sourceoverview.L3 q_sourceoverview.L4 " detailed analysis pending ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2630881&group_id=56967 ------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
