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.
