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

Sqlite3 does not accept SELECT * UNION (SELECT *) #79

Closed
hellupline opened this issue Jun 6, 2019 · 2 comments
Closed

Sqlite3 does not accept SELECT * UNION (SELECT *) #79

hellupline opened this issue Jun 6, 2019 · 2 comments

Comments

@hellupline
Copy link

Sqlite3 does not accept SELECT * UNION (SELECT *)

the correct syntax should be SELECT * UNION SELECT *

the same happens to INTERSECT and EXCEPT

@hellupline
Copy link
Author

I could not found where it add ( and ), if you point me there, I could create a patch @doug-martin

@doug-martin
Copy link
Owner

Take a look at https://github.com/doug-martin/goqu/blob/master/default_adapter.go#L1084

You will most likely need to override that method for the sqlite adapter similar to how the mysql adapter creates its own adapter.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants