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

[BUG][async-query] named_struct is considered as UDF and raise validation error #3237

Open
ykmr1224 opened this issue Jan 9, 2025 · 1 comment
Labels
bug Something isn't working

Comments

@ykmr1224
Copy link
Collaborator

ykmr1224 commented Jan 9, 2025

What is the bug?
When named_struct function is used in SQL query for async-query, it is considered as UDF and raise validation error "
User Defined functions is not allowed."

How can one reproduce the bug?
Execute "SELECT named_struct("a", 1)" for async-query.

What is the expected behavior?
It should allow the execution.

What is your host/environment?

  • OS: [e.g. iOS]
  • Version [e.g. 22]
  • Plugins

Do you have any screenshots?
If applicable, add screenshots to help explain your problem.

Do you have any additional context?
We should check if there is any other uncovered function.

@ykmr1224 ykmr1224 added bug Something isn't working untriaged labels Jan 9, 2025
@ykmr1224 ykmr1224 changed the title [BUG][async-query] named_struct is considered as UDF and [BUG][async-query] named_struct is considered as UDF and raise validation error Jan 9, 2025
@ykmr1224 ykmr1224 removed the untriaged label Jan 9, 2025
@ykmr1224
Copy link
Collaborator Author

ykmr1224 commented Jan 9, 2025

Found following functions are listed in Built-in functions but not in categolized functions and thus we haven't allow-listed.

aggregate, array_size, array_sort, cardinality, crc32, exists, filter, forall, hash, ilike, in, like, map_filter, map_zip_with, md5, mod, named_struct, parse_url, raise_error, reduce, reverse, sha, sha1, sha2, size, struct, transform, transform_keys, transform_values, url_decode, url_encode, xpath, xpath_boolean, xpath_double, xpath_float, xpath_int, xpath_long, xpath_number, xpath_short, xpath_string, xxhash64, zip_with

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant