1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
# name: test/sql/optimizer/expression/test_in_clause_simplification.test
# description: Test InClauseSimplificationRule
# group: [expression]
statement ok
PRAGMA enable_verification
# Removing the TIMESTAMP => DATE cast only works if the
# IN clause has TIMESTAMPs.
statement ok
CREATE TABLE issue13380(c0 TIMESTAMP);
statement ok
INSERT INTO issue13380(c0) VALUES ('2024-08-09 14:48:00');
query I
SELECT c0::DATE IN ('2024-08-09') d FROM issue13380;
----
true
query I
SELECT NOT (c0::DATE IN ('2024-08-09')) FROM issue13380;
----
false
query I
SELECT c0::DATE NOT IN ('2024-08-09') FROM issue13380;
----
false
|
