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

specifying correct type in MySQL #3700

Open
omid9h opened this issue Nov 10, 2024 · 0 comments
Open

specifying correct type in MySQL #3700

omid9h opened this issue Nov 10, 2024 · 0 comments
Labels
📚 mysql bug Something isn't working 💻 linux

Comments

@omid9h
Copy link

omid9h commented Nov 10, 2024

Version

1.27.0

What happened?

in this playground I have a where clause like:

AND (sqlc.arg(deleted_at) = true OR `users`.`deleted_at` IS NULL)
AND (sqlc.arg(first_name) = "" OR aes_decrypt(from_base64(first_name), sqlc.arg(aes_key)) LIKE CONCAT('%', sqlc.arg(first_name), '%'))
AND (sqlc.arg(last_name) = "" OR aes_decrypt(from_base64(last_name), sqlc.arg(aes_key)) LIKE CONCAT('%', sqlc.arg(last_name), '%'))

and I expect deleted_at to infer as bool and first_name, last_name, and phone as string but the output for all of them is interface{}. any idea how to fix this?

Relevant log output

No response

Database schema

No response

SQL queries

No response

Configuration

No response

Playground URL

https://play.sqlc.dev/p/beeafdcaa14bcb7ff7afd0ddf6a204b787f831155deb4fbc5c9502f76021c88b

What operating system are you using?

Linux

What database engines are you using?

MySQL

What type of code are you generating?

Go

@omid9h omid9h added the bug Something isn't working label Nov 10, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
📚 mysql bug Something isn't working 💻 linux
Projects
None yet
Development

No branches or pull requests

1 participant