What happens? A query like <div class="snippet-clipboard-conte

This should be fixed as a side result of <a class="issue-link js-issue-link" data-erro

Misleading binder error about duckdb HOT 1 CLOSED

eaubin commented on June 10, 2024

Misleading binder error

from duckdb.

Comments (1)

taniabogatsch commented on June 10, 2024

This should be fixed as a side result of #10150. I get the following output on the current main branch.

Error: Binder Error: failed to bind function, either: Invalid LIST argument during lambda function binding!
 or: Referenced column "x" not found in FROM clause!

Basically, we try to bind this query twice, and both attempts fail. The error message now includes the failure-reason of the first attempt, which is Invalid LIST argument during lambda function binding!. This is the expected error message, as ::JSON AS xs is not a LIST.

tania@motorbook duckdb % build/release/duckdb        
v0.9.3-dev3936 b92cb1ae39
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
D SELECT '[{"x":1}]'::JSON AS xs, list_transform(xs, x -> x);
Error: Binder Error: failed to bind function, either: Invalid LIST argument during lambda function binding!
 or: Referenced column "x" not found in FROM clause!
D SELECT '[{"x":1}]'::JSON;
┌─────────────────────────────┐
│ CAST('[{"x":1}]' AS "JSON") │
│            json             │
├─────────────────────────────┤
│ [{"x":1}]                   │
└─────────────────────────────┘
D SELECT '[{"x":1}]'::JSON AS xs, list_transform(xs::JSON[], x -> x);
┌───────────┬────────────────────────────────────────────────┐
│    xs     │ list_transform(CAST(xs AS "JSON"[]), (x -> x)) │
│   json    │                     json[]                     │
├───────────┼────────────────────────────────────────────────┤
│ [{"x":1}] │ [{"x":1}]                                      │
└───────────┴────────────────────────────────────────────────┘
D SELECT '[{"x":1}]'::JSON[] AS xs, list_transform(xs, x -> x);
┌───────────┬──────────────────────────────┐
│    xs     │ list_transform(xs, (x -> x)) │
│  json[]   │            json[]            │
├───────────┼──────────────────────────────┤
│ [{"x":1}] │ [{"x":1}]                    │
└───────────┴──────────────────────────────┘