db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4001) Sequence comparison with "ALL" does not yield correct results
Date Tue, 21 Apr 2009 13:31:49 GMT

     [ https://issues.apache.org/jira/browse/DERBY-4001?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Knut Anders Hatlen updated DERBY-4001:
--------------------------------------

    Attachment: d4001-2a-code.diff

This patch (d4001-2a-code.diff) is the same as dontFlatten.diff, only that it adds comments
and also enables SubqueryFlatteningTest as part of the regression test suite. Derbyall and
suites.All ran cleanly with the dontFlatten.diff patch, but I'm rerunning the tests now in
case I accidentally changed something I didn't mean to change.

> Sequence comparison with "ALL" does not yield correct results
> -------------------------------------------------------------
>
>                 Key: DERBY-4001
>                 URL: https://issues.apache.org/jira/browse/DERBY-4001
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.3.2.1
>         Environment: Windows
>            Reporter: Venkateswaran Iyer
>            Assignee: Knut Anders Hatlen
>            Priority: Minor
>         Attachments: d4001-1a-test.diff, d4001-2a-code.diff, dontFlatten.diff
>
>
> A query involving "< ALL" does not yield the right results for decimal datatype. "<
ANY" works, though.
> To reproduce the issue:
> % create table t1(col1 decimal(10,5));
> % insert into t1 values (-21483.64800);
> % insert into t1 values (74837.00000);
> % select col1 from t1 where col1 < ALL (select 0.0 from t1);
> The above yields no results whereas it should return the first row.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message