Question about the IN. How would we end up sending an array of expressions to validate against? More specifically, are there any examples? I am having a hard time trying to figure out how to send an array from PHP.
The PHP driver currently doesn't support passing array as parameter to stored procedures. I created the following ticket to implement this feature. https://issues.voltdb.com/browse/ENG-7167
As a workaround, if you know the number of items you would like to check in the IN list, you can list the placeholders explicitly in the SQL statement and pass each item as an individual parameter to the stored procedure. For example, if the SQL statement is
SELECT * from EMPLOYEE where STATUS IN (?, ?,?);
Then you can pass the parameters in your PHP client like this
$voltClient->invoke("MyProc", array("Salary", "Parttime", "Hourly"));