1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
# name: test/sql/function/operator/test_in_empty_table.test
# description: Issue #11063 - IN operator throws a Conversion Error when checking INTEGER column for 5 or more VARCHAR elements
# group: [operator]
statement ok
CREATE OR REPLACE TABLE test (a INTEGER)
query I
SELECT * FROM test WHERE a IN ('a', 'b', 'c', 'd', 'e')
----
statement ok
INSERT INTO test VALUES (42)
statement error
SELECT * FROM test WHERE a IN ('a', 'b', 'c', 'd', 'e')
----
Could not convert string
|
