db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Wouter (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4583) TRUE by itself is not accepted in WHERE
Date Mon, 15 Mar 2010 15:32:27 GMT
TRUE by itself is not accepted in WHERE
---------------------------------------

                 Key: DERBY-4583
                 URL: https://issues.apache.org/jira/browse/DERBY-4583
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.5.3.0
         Environment: n/a
            Reporter: Wouter


A SELECT query with a literal boolean value in its WHERE clause results in a syntax error.

How to reproduce:

CREATE TABLE list (value VARCHAR(10));

Given this table, the following queries result in a syntax error.

SELECT * FROM list WHERE TRUE;
SELECT * FROM list WHERE FALSE;
SELECT * FROM list WHERE value='A' OR TRUE;

Why is TRUE/FALSE not a boolean expression?


-- 
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