specifying correct type in MySQL

[omid9h]

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

[ResulCelik0]

I have the same problem when using CONCAT

[ResulCelik0]

problem solved temporarily using PIPES_AS_CONCAT mode
I used '||' operator instead of CONCAT method and sqlc determined the type correctly.
Example
CONCAT ('%' , sqlc.arg(arg), '%') => arg type interface{}
('%' || sqlc.arg(arg) || '%') => arg type correct (string, int, etc..)
ref: https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
ref: https://stackoverflow.com/questions/8212192/can-mysql-concatenate-strings-with