Bugs item #2562264, was opened at 2009-02-03 23:14 Message generated for change (Comment added) made by stmane You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2562264&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: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: Jens Oehlschlägel (jens_oehl) >Assigned to: Martin Kersten (mlkersten) Summary: <= (LE) in CASE interpreted as >= (GE) Initial Comment: sql>select x, case when x<=12 then 1 else 0 end as log from (select 10 as x union select 11 as x union select 12 as x un ion select 13 as x) sub; +----+----+ | x |log | +====+====+ | 10 | 0 | | 11 | 0 | | 12 | 1 | | 13 | 1 | +----+----+ MonetDB June2008 Win32 select x , case when x<=12 then 1 else 0 end as log from ( select 10 as x union select 11 as x union select 12 as x union select 13 as x ) sub ; ---------------------------------------------------------------------- >Comment By: Stefan Manegold (stmane) Date: 2009-02-04 00:23 Message: [ SF is not ACID ] Indeed fixed in the Feb2009 branch by 2009/02/03 - mlkersten: MonetDB5/src/modules/kernel/batcalc.mx,1.173.2.1 A rather stupid typo in some of the special cases for constant comparison. ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2009-02-04 00:19 Message: test added in the Feb2009 release branch as sql/src/test/BugTracker-2009/Tests/LE_vs_GE_in_CASE.SF-2562264.* With all three releases, Jun2008, Nov2008 & Feb2009, "<=" seems to be incorrectly interpreted as ">=", as reported, while "<", "=", ">=", ">" seem to work fine with all releases. ---------------------------------------------------------------------- Comment By: Martin Kersten (mlkersten) Date: 2009-02-04 00:10 Message: A rather stupid typo in the special case of comparison of cst and bat. A test file has been added 'caselessthen.sql' ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2562264&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
