whereIn doesn't work with more than one value in 'values' on pg

[mkozjak]

(haven't tested other drivers)

Throws:
{"name":"error","length":84,"severity":"ERROR","code":"42601","position":"423","file":"scan.l","line":"1053","routine":"scanner_yyerror"}

when this piece of code is used:

myModel.using(connection)
.whereIn('nameofcolumn', ['one', 'two'])
.all....

Managed to debug up to _runSql3, where it gave:

text: select t0."nameofcolumn1" AS c0, t0."nameofcolumn2" AS c1 FROM tablename1 AS t0 WHERE t0.nameofcolumn IN ($1,?)

values: [ 'one', 'two' ]

[buchatsky]

It's easy - the author forgot to add "g" to Regexp . Driver.js:
getSqlFromSqlTree: function(sqlTree) {
...
// process where
...
expr = expr.replace(/?/g, getValuesSubstitutionStringFunc);