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

Custom queries are ignored if they begin with select rather than SELECT #1

Closed
rjp opened this issue Jan 11, 2016 · 1 comment
Closed

Comments

@rjp
Copy link

rjp commented Jan 11, 2016

Given

const sqlFindTweets = "select tweets.* from tweets left join sent using (id) where sent.id is null"
err = db.Read(&tweets, sqlFindTweets)                                   

With select -

{ "time":"2016-01-11 16:29:33.806763777 +0100 CET", "package":"crud", "level":"INFO", "msg":"SELECT * FROM tweets select tweets.* from tweets left join sent using (id) where sent.id is null" }

With SELECT -

{ "time":"2016-01-11 16:29:17.760972918 +0100 CET", "package":"crud", "level":"INFO", "msg":"SELECT tweets.* from tweets left join sent using (id) where sent.id is null" }

I can live with this but it might be worth calling out specifically in the documentation.

@azer
Copy link
Owner

azer commented Jan 11, 2016

thanks for the first issue! fixed by 58741a8

@azer azer closed this as completed Jan 11, 2016
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

2 participants