We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
1.11.0
When compiling the subquery alias compiles to the interface{} type instead of int64. See playground: https://play.sqlc.dev/p/1f6e668fb3015032c9e28259e03ef5a8d0a045a543d6b367f23642c424116a44
Here is the example with postgres working just fine: https://play.sqlc.dev/p/460a9eedb3b1fa2649415cb09eeb9e7a30b8c35512ea47312e1fd8f12d58f2d5
No response
create table one ( id int primary key, otherfield varchar(255), name varchar(255) );
-- name: Test :many select otherfield, (select COUNT(*) from one o where one.id = 5 limit 1) as cnt from one;
{ "version": "1", "packages": [ { "path": "db", "engine": "mysql", "schema": "query.sql", "queries": "query.sql" } ] }
https://play.sqlc.dev/p/1f6e668fb3015032c9e28259e03ef5a8d0a045a543d6b367f23642c424116a44
Linux
MySQL
Go
The text was updated successfully, but these errors were encountered:
Fix return type for subqueries in MySQL (sqlc-dev#1383)
f834122
Fix return type for subqueries in MySQL (#1383) (#1404)
495be9d
Successfully merging a pull request may close this issue.
Version
1.11.0
What happened?
When compiling the subquery alias compiles to the interface{} type instead of int64. See playground: https://play.sqlc.dev/p/1f6e668fb3015032c9e28259e03ef5a8d0a045a543d6b367f23642c424116a44
Here is the example with postgres working just fine: https://play.sqlc.dev/p/460a9eedb3b1fa2649415cb09eeb9e7a30b8c35512ea47312e1fd8f12d58f2d5
Relevant log output
No response
Database schema
SQL queries
Configuration
Playground URL
https://play.sqlc.dev/p/1f6e668fb3015032c9e28259e03ef5a8d0a045a543d6b367f23642c424116a44
What operating system are you using?
Linux
What database engines are you using?
MySQL
What type of code are you generating?
Go
The text was updated successfully, but these errors were encountered: