[CASSANDRA-6227] Add 'WHERE 0=1', 'WHERE false', in SQL-compatible manner

• Type: Improvement
• Status: Resolved
• Priority: Low
• Resolution: Won't Fix
• Labels: cql3

Environment

Yii2 PHP framework database abstarction level

• Assignee: Unassigned
• Reporter: Sergey Nagaytsev
• Created: 22/Oct/13 10:37
• Updated: 16/Apr/19 09:32
• Resolved: 01/Nov/13 12:59

Description

Then DBAL thinks query result must be empty, it's deep inner method returns something like '0=1', 'FALSE' etc. for inclusion into WHERE condition, to make result set empty.

Nothing of this is recognised by Cassandra - instead, error is returned.

Please, implement 'false', 'null', constant comparison etc. as valid parts of WHERE with logic