Bug with pgsql query

[chekalsky]

If you will try to do this:

$pdo->fetchCol("SELECT id FROM table WHERE removed = false AND data @> '{\"is_hidden\":false}'::jsonb AND type in (:types)", ['types' => [1, 2]]);

you will get an error from DB: SQLSTATE[08P01]: <<Unknown error>>: 7 ERROR: bind message supplies 0 parameters, but prepared statement "pdo_stmt_00000001" requires 1

And this is because :types will be skipped here.

[chekalsky]

Anybody?

[chekalsky]

@pmjones is Aura.SQL abandoned?

[pmjones]

Which version are you trying this with: v2, or v3?

[chekalsky]

v3

[harikt]

@chekalsky sorry for being late here. I actually added a failing test.

The fun fact is if you change the order

SELECT * FROM table WHERE type in (:types) AND removed = false AND data @> '{\"is_hidden\":false}'::jsonb

this will work.

I don't have a fix right now. But can look into it at some point of time.