{"action":"created","issue":{"url":"https://api.github.com/repos/balderdashy/sails/issues/4482","repository_url":"https://api.github.com/repos/balderdashy/sails","labels_url":"https://api.github.com/repos/balderdashy/sails/issues/4482/labels{/name}","comments_url":"https://api.github.com/repos/balderdashy/sails/issues/4482/comments","events_url":"https://api.github.com/repos/balderdashy/sails/issues/4482/events","html_url":"https://github.com/balderdashy/sails/issues/4482","id":346266498,"node_id":"MDU6SXNzdWUzNDYyNjY0OTg=","number":4482,"title":"Simple Waterline Query fails with MySQL","user":{"login":"github1337","id":11570263,"node_id":"MDQ6VXNlcjExNTcwMjYz","avatar_url":"https://avatars2.githubusercontent.com/u/11570263?v=4","gravatar_id":"","url":"https://api.github.com/users/github1337","html_url":"https://github.com/github1337","followers_url":"https://api.github.com/users/github1337/followers","following_url":"https://api.github.com/users/github1337/following{/other_user}","gists_url":"https://api.github.com/users/github1337/gists{/gist_id}","starred_url":"https://api.github.com/users/github1337/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/github1337/subscriptions","organizations_url":"https://api.github.com/users/github1337/orgs","repos_url":"https://api.github.com/users/github1337/repos","events_url":"https://api.github.com/users/github1337/events{/privacy}","received_events_url":"https://api.github.com/users/github1337/received_events","type":"User","site_admin":false},"labels":[{"id":196935897,"node_id":"MDU6TGFiZWwxOTY5MzU4OTc=","url":"https://api.github.com/repos/balderdashy/sails/labels/bug","name":"bug","color":"b11420","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-07-31T16:35:02Z","updated_at":"2018-08-01T20:07:52Z","closed_at":null,"author_association":"NONE","body":"<!--\r\n======================================================\r\nHELLO, and welcome to the (experimental) Sailsbot\r\nissue-submission system.  If you encounter any\r\nproblems with this system, please contact us directly\r\nat http://sailsjs.com/contact.\r\n\r\nFIRST THINGS FIRST: before posting, please carefully\r\nread the contribution guide (http://bit.ly/sails-issue-guide),\r\nparticularly if this is a security issue or an issue of a\r\nnon-technical nature (Github org issues, code of conduct\r\nissues, etc.).  Those should be sent directly at\r\nhttp://sailsjs.com/contact.\r\n\r\nNOW THEN: please fill out the following info\r\n(Don't change text between **)\r\n======================================================\r\n### BEGIN VERSION INFO ###\r\n-->\r\n\r\n**Sails version**: 1.0.2\r\n**Node version**: 8.11.2\r\n**NPM version**: 5.6.0\r\n**DB adapter name**: sails-mysql\r\n**DB adapter version**: 1.0.0\r\n**Operating system**: OSX\r\n\r\n<!--\r\n### END VERSION INFO ###\r\n======================================================\r\nGREAT! - Now read carefully\r\n(Sailsbot will know if you don't)!\r\n======================================================\r\n\r\nBefore you submit an issue for Sails, please make sure you have read the issue contribution guide (http://bit.ly/sails-issue-guide) carefully, and then verify the following by typing an X in between each set of [ ] brackets below (don't make any other changes to the text!):\r\n\r\n### BEGIN PLEDGE ###\r\n- [x] I am experiencing a concrete technical issue (aka a bug) with Sails (ideas and feature proposals should follow the guide for proposing features and enhancements (http://bit.ly/sails-feature-guide), which involves making a pull request).  If you're not 100% certain whether it's a bug or not, that's okay--you may continue.  The worst that can happen is that the issue will be closed and we'll point you in the right direction.\r\n\r\n- [x] I am not asking a question about how to use Sails or about whether or not Sails has a certain feature (please refer to the documentation(http://sailsjs.com), or post on http://stackoverflow.com, our Google Group (http://bit.ly/sails-google-group) or our live chat (https://gitter.im/balderdashy/sails).\r\n\r\n- [x] I have already searched for related issues, and found none open (if you found a related _closed_ issue, please link to it in your post).\r\n\r\n- [x] My issue title is concise, on-topic and polite (\"jst.js being removed from layout.ejs on lift\" is good; \"templates dont work\" or \"why is sails dumb\" are not so good).\r\n\r\n- [x] I have tried all the following (if relevant) and my issue remains:\r\n  - Make sure you have the right app lifted.\r\n  - Make sure you've killed the Sails server with CTRL+C and started it again.\r\n  - Make sure you closed any open browser tabs pointed at localhost before starting Sails.\r\n  - Make sure you do not have any other Sails apps running in other terminal windows.\r\n  - Make sure the app you are using to reproduce the issue has a clean node_modules/ directory, meaning:\r\n    * no dependencies are linked (e.g. you haven't run npm link foo)\r\n    * that you haven't made any inline changes to files in the node_modules/ folder\r\n    * that you don't have any weird global dependency loops. The easiest way to double-check any of the above, if you aren't sure, is to run: rm -rf node_modules && npm cache clear && npm install.\r\n\r\nand finally...\r\n- [x] **I can provide steps to reproduce this issue that others can follow.**\r\n\r\nIdeally, this involves creating a new repo that demonstrates the problem (see instructions at http://bit.ly/sails-issue-repro).  Even though your issue may seem so simple to reproduce that a new repo is unnecessary, you'd be surprised how many solutions present themselves when you start from `sails new` and attempt to recreate your issue from scratch in a new app.  This ensures that the real issue isn't in your user code (a forgotten policy file, perhaps?) or in a third-party module.  If you're absolutely _convinced_ that a new repo is unnecessary, provide clear, concise and _specific_ steps to reproduce the problem in your post (not \"create a model then do blueprint create\").\r\n### END PLEDGE ###\r\n\r\nOKAY--THANKS FOR READING!  Continue posting details of your issue below. -->\r\n<hr/>\r\n\r\n\r\nA Query like this fails for every Model with MySQL. The Error happens after Stage 3; the statement compiler creates weird columns for this query:\r\n`Model.find().where({a:1, or: [{b:2, c:3}]})`\r\n-> `Error: Unexpected error from database adapter: ER_BAD_FIELD_ERROR: Unknown column '0' in 'where clause'`\r\n\r\n### Other queries:\r\n* works `Model.find().where({or: [{b:2, c:3}]})`\r\n* works `Model.find().where({a:1, or: [{b:2, c:3}, {b:4, c:5}]})`\r\n* **doesn't work:** `Model.find().where({a:1, or: [{b:2, c:3}]})`\r\n* works `Model.find().where({and: [{b:2, c:3}]})`\r\n* works `Model.find().where({a:1, and: [{b:2, c:3}, {b:4, c:5}]})`\r\n* **doesn't work:** `Model.find().where({a:1, and: [{b:2, c:3}]})`\r\n\r\nSo there seems to be an error if there is a field and an `or`/`and` with only one element"},"comment":{"url":"https://api.github.com/repos/balderdashy/sails/issues/comments/409704955","html_url":"https://github.com/balderdashy/sails/issues/4482#issuecomment-409704955","issue_url":"https://api.github.com/repos/balderdashy/sails/issues/4482","id":409704955,"node_id":"MDEyOklzc3VlQ29tbWVudDQwOTcwNDk1NQ==","user":{"login":"mikermcneil","id":618009,"node_id":"MDQ6VXNlcjYxODAwOQ==","avatar_url":"https://avatars3.githubusercontent.com/u/618009?v=4","gravatar_id":"","url":"https://api.github.com/users/mikermcneil","html_url":"https://github.com/mikermcneil","followers_url":"https://api.github.com/users/mikermcneil/followers","following_url":"https://api.github.com/users/mikermcneil/following{/other_user}","gists_url":"https://api.github.com/users/mikermcneil/gists{/gist_id}","starred_url":"https://api.github.com/users/mikermcneil/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mikermcneil/subscriptions","organizations_url":"https://api.github.com/users/mikermcneil/orgs","repos_url":"https://api.github.com/users/mikermcneil/repos","events_url":"https://api.github.com/users/mikermcneil/events{/privacy}","received_events_url":"https://api.github.com/users/mikermcneil/received_events","type":"User","site_admin":false},"created_at":"2018-08-01T20:07:52Z","updated_at":"2018-08-01T20:07:52Z","author_association":"MEMBER","body":"@github1337 I think next step is to bust this open and make sure the stage 2 query is correct.  If you have a sec to dig that up, that'd be awesome-- if not, no worries.\r\n\r\nBut just to make sure, what version of sails-hook-orm are you running?"}}
{"actor":{"display_login":"mikermcneil"}}