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

Support Array overflow returning null as Trino #52592

Open
LZGH opened this issue Nov 4, 2024 · 0 comments
Open

Support Array overflow returning null as Trino #52592

LZGH opened this issue Nov 4, 2024 · 0 comments

Comments

@LZGH
Copy link

LZGH commented Nov 4, 2024

Feature request

Is your feature request related to a problem? Please describe.

select try(split('aa-bb', '-') [3]) as name; starrocks report error:Array subscript start at 1
select try(split('aa-bb', '-') [cast(null as int)]) as name;starrocks report error: Array subscript must be less than or equal to array length: 3 > 2

Describe the solution you'd like

The above two sql will return null in trino, and will report an error in starrocks.After turning on the trino dialect, hope that the semantics will remain consistent.

Describe alternatives you've considered

Additional context

@LZGH LZGH changed the title Support Array overflow supports returning null as Trino Support Array overflow returning null as Trino Nov 4, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant