Bugs item #2633544, was opened at 2009-02-24 13:23 Message generated for change (Settings changed) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2633544&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: Invalid Priority: 5 Private: Yes Submitted By: Jens Oehlschlägel (jens_oehl) Assigned to: Niels Nes (nielsnes) Summary: String constant in view converted to uppercase Initial Comment: 'kg' in view finally becomes 'KG' which messes up all sorts of things. 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 16:48 Message: added original query as test StringConstantToUppercase.SF-2633544.sql added modified query as test StringConstantToUppercase.SF-2633544_OK.sql ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2009-02-24 16:13 Message: The problem with this one is an ambiguous column name: the view creates a column "DT_UOM", while a columns with the same name already exists in the undelying t_base_sales table. Niels will add a check that detects and reports such ambiguity. Renaming the respective column in the view to, say, "DT_UOM_V" yields the expected result: sql>CREATE VIEW voc.q_sourceoverview_eur_kg_test 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_curr, dt_uom_v from voc.q_sourceoverview_eur_kg_test limit 1; +---------+----------+ | dt_curr | dt_uom_v | +=========+==========+ | EUR | kg | +---------+----------+ 1 tuple sql>select dt_curr, dt_uom_v from voc.q_sourceoverview_eur_kg_test where dt_uom_v='kg' limit 1; +---------+----------+ | dt_curr | dt_uom_v | +=========+==========+ | EUR | kg | +---------+----------+ 1 tuple sql>select dt_curr, dt_uom_v from voc.q_sourceoverview_eur_kg_test where dt_uom_v='KG' limit 1; 0 tuples sql>DROP VIEW voc.q_sourceoverview_eur_kg_test; 0 tuples ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2633544&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
