Describe the bug
If using _OR in a combiner it can't have the same value twice in the $whereClause. I came across this when trying to make a function to group WHERE clauses. Working on a fix now so hope to push that soon.
To Reproduce
Create a selecting statement using a where() and 2x eq(), with the first eq() having an _OR combiner
$db->selecting(
"login_log",
"login_id",
where(
eq("login_user_id", "1", _OR),
eq("login_user_id", "2"),
)
);
Expected behavior
The compiled SQL would be as follows
SELECT login_id FROM login_log WHERE login_user_id = '1' OR login_user_id = '2'
Environment (please complete the following information):
- EZSQL Version : 4.0.9
- PHP Version: 7.4.3
- SQL Driver: PDO:mysql
PHP code snippet used
See above
Describe the bug
If using
_ORin a combiner it can't have the same value twice in the$whereClause. I came across this when trying to make a function to groupWHEREclauses. Working on a fix now so hope to push that soon.To Reproduce
Create a selecting statement using a
where()and 2xeq(), with the firsteq()having an_ORcombinerExpected behavior
The compiled SQL would be as follows
Environment (please complete the following information):
PHP code snippet used
See above