balderdashy / balderdashy/sails

Multiple Condition (WHERE AND)not working properly in mysql sail.js

Open
#4,516 8 comments 0 reactions 0 assignees View on GitHub
more info please
Dominant language
JavaScript
Stars
22.8k
Forks
1.9k
PR merge metrics
No merged PRs in 30d

Description

**Sails version**: 1.0
**Node version**:8.4.0
**NPM version**:6.4.1
**DB adapter name**: sails-mysql
**DB adapter version**: 1.0.0
**Operating system**: Window



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.

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).

I have tried all the following (if relevant) and my issue remains

Contributor guide

Open the contributing guide

Research direction

The issue names no source files, tests, or reproducible query details. Start by obtaining a minimal reproduction using Sails 1.0, sails-mysql 1.0.0, and the reported Node environment, then inspect the adapter's handling of multiple WHERE conditions. Done means the reported AND query works correctly and has a regression test.

Written by the indexing model from the issue text.

Assessment

Tech stack
javascript, mysql, node.js
Domain
backend, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
20/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.