Comments (1)
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}] │
└───────────┴──────────────────────────────┘
I am closing this, as it has already been fixed.
from duckdb.
Related Issues (20)
- Performance difference with `read_csv` between a file and stdin HOT 1
- Query on Arrow views fail with specific order of filters HOT 2
- Review patches from duckdb-r HOT 1
- READ_CSV doesn't release memory in between files it imports HOT 3
- Double inserts HOT 1
- make parameter handling orthogonal, please HOT 2
- TPC-H extension generates identical values on WASM client
- read parquet file from s3 1.0.0 slower than 0.9.2 HOT 5
- terminate called after throwing an instance of 'duckdb::InvalidInputException' when read parquet from minio HOT 4
- Incorrect file type when writing files to google cloud bucket via httpfs
- BETWEEN incorrectly pushed into ASOF JOIN HOT 4
- cmake target exports use fixed paths (not relocatable)
- .lint fkey-indexes terminates cli HOT 1
- Regression in 1.0 for representation of SQLNULL in Python API HOT 1
- INTERNAL Error reading from CSV file HOT 3
- C++ API crashes when running in debug mode with release mode dll.
- Invalid Input Error: CSV Error on Line: 729 HOT 1
- Silent exit after 31 x 2 GB GZIP-ed CSV imports
- No granular progress bar when importing a single 2 GB, GZIP-ed CSV
- Importing 2 GB GZIP'ed CSVs into DuckDB table take longer after each insert
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from duckdb.