asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael J. Carey (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (ASTERIXDB-1960) Possible error in SQL++ boolean WHERE handling?
Date Wed, 28 Jun 2017 14:07:00 GMT

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

Michael J. Carey updated ASTERIXDB-1960:
----------------------------------------
    Component/s: SQL - Translator SQL++
                 *DB - AsterixDB

> Possible error in SQL++ boolean WHERE handling?
> -----------------------------------------------
>
>                 Key: ASTERIXDB-1960
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1960
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: *DB - AsterixDB, SQL - Translator SQL++
>         Environment: Current *DB master (SQL++)
>            Reporter: Michael J. Carey
>            Assignee: Yingyi Bu
>
> I'm wondering if:
>     SELECT VALUE user
>     FROM GleambookUsers user
>     WHERE user.userSince;
> should work as a lazy shorthand for:
>     SELECT VALUE user
>     FROM GleambookUsers user
>     WHERE user.userSince = TRUE;
> Because if it should, it doesn’t, in current *DB.
> The first form yields a runtime error:
> "Runtime error: the select condition should be of the boolean type! [IllegalStateException]"
> The fact that it gets this far syntactically suggests that maybe it's indeed a bug?



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message