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
unsupported type NULL
sqlx::query_file!("src/queries/leaderboard.sql") this has error:
sqlx::query_file!("src/queries/leaderboard.sql")
unsupported type NULL of column #1 ("user")
the leaderboard.sql in question is:
select `user`, count( distinct date(`joined`, '+09:00') ) as days, coalesce( sum(unixepoch(coalesce(`left`, 'now')) - unixepoch(`joined`)), 0) as `total_duration` from `vc_activities` group by `user` order by `total_duration` desc limit 5
but this error does not happen on my friend's pc.
https://github.com/tmvkrpxl0/sqlx-report I used sqlx-cli to setup database like this:
sqlx database create sqlx migrate run
Then ran cargo build and got the same error
cargo build
rustc --version
The text was updated successfully, but these errors were encountered:
No branches or pull requests
Bug Description
sqlx::query_file!("src/queries/leaderboard.sql")
this has error:the leaderboard.sql in question is:
but this error does not happen on my friend's pc.
Minimal Reproduction
https://github.com/tmvkrpxl0/sqlx-report
I used sqlx-cli to setup database like this:
Then ran
cargo build
and got the same errorInfo
rustc --version
: rustc 1.81.0The text was updated successfully, but these errors were encountered: