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

Improve Type Checking of SQL types in planning #446

Open
jacksonrnewhouse opened this issue Dec 8, 2023 · 0 comments
Open

Improve Type Checking of SQL types in planning #446

jacksonrnewhouse opened this issue Dec 8, 2023 · 0 comments
Labels
bug Something isn't working compilation-error

Comments

@jacksonrnewhouse
Copy link
Contributor

jacksonrnewhouse commented Dec 8, 2023

#439 raised the issue of subtraction producing incorrect generated code, leading to a compile time failure. This is partially addressed in #441, which will return a planning error if a projection calculation returns an unsupported type, including a Duration. However, there are still issues if there are problematic expressions nested within calculations. For instance, the following query plans successfully but produces the same compilation error:

select CAST(bid.datetime - DATE '2023-12-03' as string)
from nexmark
group by 1;
@mwylde mwylde added bug Something isn't working compilation-error labels Dec 9, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working compilation-error
Projects
None yet
Development

No branches or pull requests

2 participants