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: Open Resolution: None 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-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
