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

Prevent quill from wrapping raw sql into subquery #3149

Open
amz opened this issue Dec 13, 2024 · 0 comments
Open

Prevent quill from wrapping raw sql into subquery #3149

amz opened this issue Dec 13, 2024 · 0 comments

Comments

@amz
Copy link

amz commented Dec 13, 2024

Quill insists of wrapping the query into a subquery
val result = run(sql"Select p.name, p.age FROM Person p use INDEX(player_custom_idx)".as[Query[Person]])

Version: 4.8.5
Module: quill-core
Database: mysql

Expected behavior

Select p.name, p.age FROM Person p use INDEX(player_custom_idx)

Actual behavior

SELECT x.name, x.age FROM (Select p.name, p.age FROM Person p use INDEX(player_custom_idx)) x

Workaround

@getquill/maintainers

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