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

Remove old_implicit_casting setting; use types in queries #41

Open
elefeint opened this issue May 15, 2024 · 0 comments
Open

Remove old_implicit_casting setting; use types in queries #41

elefeint opened this issue May 15, 2024 · 0 comments

Comments

@elefeint
Copy link
Contributor

old_implicit_casting works to restore the old lenient behavior in DuckDB 0.10, but we should update the queries to cast instead.

I tested that using casting in the ELSE clause of CASE works:

update books1391973803
SET title = CASE 
  WHEN books_all_varchar.title = 'DONOTUPDATE' 
  THEN books1391973803.title 
  ELSE books_all_varchar.title END,
magic_number = CASE
  WHEN books_all_varchar.magic_number = 'DONOTUPDATE' 
  THEN books1391973803.magic_number 
  ELSE books_all_varchar.magic_number::INTEGER END,
FROM books_all_varchar 
WHERE books_all_varchar.id = books1391973803.id
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

1 participant