Bugs item #2633634, was opened at 2009-02-24 14:48 Message generated for change (Comment added) made by stmane You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2633634&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: Invalid Priority: 5 Private: Yes Submitted By: Jens Oehlschlägel (jens_oehl) Assigned to: Niels Nes (nielsnes) Summary: !TypeException:user.s0_1[97]:'bat.append' undefined Initial Comment: Niels: the attached SQL causes an exception Stefan: please put view voc.q_sourceoverview_eur_kg permanently to our test data. Please put the SQL as autotest #91. D:\MonetDB\MonetDB5>m5server --version 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 17:50 Message: added original query as test BatAppendUndefined.SF-2633634.sql added modified query as test BatAppendUndefined.SF-2633634_OK.sql ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2009-02-24 17:22 Message: Same column name ambiguity problem as [ 2633544 ] String constant in view converted to uppercase https://sourceforge.net/tracker/index.php?func=detail&aid=2633544&group_id=56967&atid=482468 Works fine with non-ambiguous column name in view: sql>CREATE VIEW voc.q_sourceoverview_eur_kg_OK AS more>SELECT t_base_sales.* more>, 'EUR' AS DT_CURR more>, 'kg' AS DT_UOM_V more>FROM voc.t_base_sales more>; 0 tuples sql>SELECT DT_Country as key01 more>, DT_Customer_Attrib1 as key02 more>, SUM( (CASE WHEN PostingYear=2005 THEN 1 ELSE 0 END) *DT_D00) as UD00_P1 more>, SUM( (CASE WHEN PostingYear=2006 THEN 1 ELSE 0 END) *DT_D00) as UD00_P2 more>, SUM( (CASE WHEN PostingYear=2005 THEN 1 ELSE 0 END) *DT_VOLUME) as VV2_P1 more>, SUM( (CASE WHEN PostingYear=2006 THEN 1 ELSE 0 END) *DT_VOLUME) as VV2_P2 more>, SUM( (CASE WHEN PostingYear=2005 THEN 1 ELSE 0 END) *DT_D01) as UD01_P1 more>, SUM( (CASE WHEN PostingYear=2006 THEN 1 ELSE 0 END) *DT_D01) as UD01_P2 more>, SUM( (CASE WHEN PostingYear=2005 THEN 1 ELSE 0 END) *DT_VOLUME) as VV4_P1 more>, SUM( (CASE WHEN PostingYear=2006 THEN 1 ELSE 0 END) *DT_VOLUME) as VV4_P2 more>, SUM( (CASE WHEN PostingYear=2005 THEN 1 ELSE 0 END) *DT_D05) as SD05_P1 more>, SUM( (CASE WHEN PostingYear=2006 THEN 1 ELSE 0 END) *DT_D05) as SD05_P2 more>, SUM( (CASE WHEN PostingYear=2005 THEN 1 ELSE 0 END) *DT_VOLUME) as volume1_P1 more>, SUM( (CASE WHEN PostingYear=2006 THEN 1 ELSE 0 END) *DT_VOLUME) as volume1_P2 more>, sum(DT_D00)/SUM(DT_VOLUME) as aField1 more>FROM voc.q_SourceOverview_eur_kg_OK more>WHERE (DT_UOM_V='kg') more> AND (DT_CURR='EUR') more> AND (( (PostingYear=2005)) or ( (PostingYear=2006))) more>GROUP BY DT_Country, DT_Customer_Attrib1 more>HAVING sum (DT_VOLUME) <> 0 more>ORDER BY aField1 DESC more>; [...] 96 tuples ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2633634&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
