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
Wrong NOT NULL criteria on MYSQL #6803
Comments
@Medioman92 Thanks for posting! We'll take a look as soon as possible. In the mean time, there are a few ways you can help speed things along:
Please remember: never post in a public forum if you believe you've found a genuine security vulnerability. Instead, disclose it responsibly. For help with questions about Sails, click here. |
@Medioman92 Thanks for bringing this to attention, have you tried this out in our latest MySQL adapter sails-sql? This one is honestly ready to use for MySQL in production and features updates to the boolean and NULL criteria. PostgreSQL support is particularly still in development and only recommended for testing at the moment. Edit: Sorry for the repeat recommendation, just noticed I mentioned that in a previous recent post we shared - were you able to give it a go? |
I waited since we’re actually in pre-production phase with our product. |
@johnabrams7 seems working just fine with sails-sql |
Node version: 10.4.1
Sails version (sails): 1.1.0
ORM hook version (sails-hook-orm): 2.1.1
DB adapter & version (sails-mysql): 1.0.1
Hi, i'm trying execute a simple find on MySQL 5.7.25 looking for records where a field is not null. Waterline ORM should use "IS NOT NULL" instead of "!=" to compare NULLS in the generated SQL query. This is the controller's relevant portion of code:
This is the generated SQL query:
If you try to use {FIELD:null} as criteria is correctly translated to IS NULL instead of "="
Is this a regression of some kind ? it seems a pretty bad bug to me
The text was updated successfully, but these errors were encountered: