[DERBY-4583] TRUE by itself is not accepted in WHERE

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.5.3.0
• Fix Version/s: 10.7.1.1
• Component/s: SQL
• Environment: n/a
• Bug behavior facts: Deviation from standard
• Assignee: Richard N. Hillegas
• Reporter: Wouter
• Created: 15/Mar/10 15:30
• Updated: 17/Jun/13 09:19
• Resolved: 07/Jun/10 17:49

Description

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?

Issue Links

• is part of: DERBY-499 Expose BOOLEAN datatype to end users
• is related to: DERBY-4692 Unions between BOOLEAN and non-BOOLEAN datatypes should be rejected
• is related to: DERBY-4651 Hidden assumptions in FromVTI.makeRestriction()