Open am0nshi opened 6 years ago
Hi @biggora ! I didn't found anywhere in mysql driver construction for "IS NOT NULL" query. Currently we have null check here - https://github.com/biggora/caminte/blob/b662a3e2f18861dd4c18ba772a89998870d44fd6/lib/adapters/mysql.js#L851. In MySQL construction like xxx != NULL is not the same as xxx IS NOT NULL.
xxx != NULL
xxx IS NOT NULL
Have you any ideas, better than just add one additional condition here https://github.com/biggora/caminte/blob/b662a3e2f18861dd4c18ba772a89998870d44fd6/lib/adapters/mysql.js#L885 ?
Hi @biggora ! I didn't found anywhere in mysql driver construction for "IS NOT NULL" query. Currently we have null check here - https://github.com/biggora/caminte/blob/b662a3e2f18861dd4c18ba772a89998870d44fd6/lib/adapters/mysql.js#L851. In MySQL construction like
xxx != NULL
is not the same asxxx IS NOT NULL
.Have you any ideas, better than just add one additional condition here https://github.com/biggora/caminte/blob/b662a3e2f18861dd4c18ba772a89998870d44fd6/lib/adapters/mysql.js#L885 ?