Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add List-type literal and parameter #557

Closed
andyfengHKU opened this issue Apr 21, 2022 · 2 comments
Closed

Add List-type literal and parameter #557

andyfengHKU opened this issue Apr 21, 2022 · 2 comments

Comments

@andyfengHKU
Copy link
Contributor

Once list type and related functions are properly supported in the system, we should also add list literal and parameter for the prepared statement.

@acquamarin
Copy link
Collaborator

We don't plan to support list parameter at this stage.
Duckdb's c++ api doesn't support list parameter, however their python api supports list parameter:
Example:

import duckdb

cursor = duckdb.connect()
cursor.execute("""
    prepare v1 as 
        select list_concat(?, [2])""")
print(cursor.execute("execute v1([1,5,3])").fetchall())

@andyfengHKU
Copy link
Contributor Author

We also now support list type as parameter on the python side.

C++ is hard to support. I would try to support with cypher statement instead

PREPARE RETURN $1 AS p_statement
EXECUTE p_statement([1,2,3])

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants