Postgres array escaping in where clause broken in 0.12 #1710

joshrickert · 2016-09-30T00:33:26Z

So, I just updated from 0.11.10 to 0.12.2, and it broke one of my queries. I've confirmed that this occurs on 0.12.0 and 0.12.1 as well.

This used to work:

query.where('array_field', '&&', [7]);

0.11.10 output: (working)

WHERE "array_field" && '{"7"}'

0.12.2 output: (not working)

WHERE "array_field" && {7}

My workaround for now is:

query.whereRaw(`"array_field" && '?'`, [[7]]);

tgriesser · 2016-10-09T18:34:31Z

Should be fixed in 0.12.3

* master: release 0.12.3 Update changelog Fix #1710 Fix #1694 release 0.12.2 Update changelog for 0.12.2 features Don't force master as release branch Remove unused pool2 dependency Fix #1701 Fix #1675 Fix for #1691

tgriesser added a commit that referenced this issue Oct 9, 2016

Fix #1710

aa62398

tgriesser mentioned this issue Oct 9, 2016

0.12.3 #1731

Merged

tgriesser closed this as completed in fa30dfb Oct 9, 2016

rslabbert pushed a commit to rslabbert/knex that referenced this issue Nov 9, 2016

Fix knex#1710

18aacc6

chamini2 mentioned this issue Jan 31, 2017

Postgres string arrays escaped characters #1793

Closed

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Postgres array escaping in where clause broken in 0.12 #1710

Postgres array escaping in where clause broken in 0.12 #1710

joshrickert commented Sep 30, 2016 •

edited

tgriesser commented Oct 9, 2016

Postgres array escaping in where clause broken in 0.12 #1710

Postgres array escaping in where clause broken in 0.12 #1710

Comments

joshrickert commented Sep 30, 2016 • edited

tgriesser commented Oct 9, 2016

joshrickert commented Sep 30, 2016 •

edited