2023-05-03 11:06:20 +02:00
|
|
|
== Why is this an issue?
|
|
|
|
|
|
2021-01-27 13:42:22 +01:00
|
|
|
Queries with contradictory ``++WHERE++`` clauses will always return empty result sets. This is clearly a bug.
|
2020-06-30 12:48:39 +02:00
|
|
|
|
|
|
|
|
|
2023-05-03 11:06:20 +02:00
|
|
|
=== Noncompliant code example
|
2020-06-30 12:48:39 +02:00
|
|
|
|
2022-02-04 17:28:24 +01:00
|
|
|
[source,text]
|
2020-06-30 12:48:39 +02:00
|
|
|
----
|
|
|
|
|
SELECT *
|
|
|
|
|
FROM fruit
|
|
|
|
|
WHERE type='apple' AND type='orange' -- Noncompliant
|
|
|
|
|
----
|
|
|
|
|
|
