You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Wail Y. Alkowaileet (Jira)" <ji...@apache.org> on 2020/09/04 18:30:00 UTC
[jira] [Updated] (ASTERIXDB-2774) Comparing double with float does
not apply proper cast
[ https://issues.apache.org/jira/browse/ASTERIXDB-2774?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Wail Y. Alkowaileet updated ASTERIXDB-2774:
-------------------------------------------
Description:
This is from the BOSS demo ShopALot dataset:
{code:java}
USE ShopALot;
SELECT o1.*
FROM Orders o1
WHERE o1.total_price = 716.8;{code}
returns empty result (total_price is float)
{code:java}
USE ShopALot;
SELECT o1.*
FROM Orders o1
WHERE o1.total_price = float("716.8");{code}
returns the correct result
was:
This is from the BOSS demo ShopALot dataset:
{code:java}
USE ShopALot;
SELECT o1.*
FROM Orders o1
WHERE o1.total_price = 716.8;{code}
returns empty result
{code:java}
USE ShopALot;
SELECT o1.*
FROM Orders o1
WHERE o1.total_price = float("716.8");{code}
returns the correct result
> Comparing double with float does not apply proper cast
> ------------------------------------------------------
>
> Key: ASTERIXDB-2774
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2774
> Project: Apache AsterixDB
> Issue Type: Bug
> Reporter: Wail Y. Alkowaileet
> Priority: Major
>
> This is from the BOSS demo ShopALot dataset:
> {code:java}
> USE ShopALot;
> SELECT o1.*
> FROM Orders o1
> WHERE o1.total_price = 716.8;{code}
> returns empty result (total_price is float)
> {code:java}
> USE ShopALot;
> SELECT o1.*
> FROM Orders o1
> WHERE o1.total_price = float("716.8");{code}
> returns the correct result
--
This message was sent by Atlassian Jira
(v8.3.4#803005)