Query parsing error (read/write splitting mode)

[leo-ural]

An error occurs while pgcat is in read/write queries splitting mode.
Original SQL query is:
SELECT req_tab_0.* FROM validation req_tab_0 WHERE array['http://www.w3.org/ns/shacl#ValidationResult'] && req_tab_0.type::text[] AND ( ( (req_tab_0.focusnode = 'DataSource_Credilogic_DataSourceAddress_144959227') ) )

When parsing the query pgcat has logged an error:
QueryRouterParserError("sql parser error: Expected an expression:, found: &")

Version: pgcat-0.1.0

[pchaseh]

The 0.1.0 release was built on Feb 22nd, where-in sqlparser v0.34 would have still been in use. You can see from the commit apache/datafusion-sqlparser-rs@a50671d that support for the overlap operator is only available in v0.36 or later. You'll have to build your own pgcat binary from the latest master branch until the maintainers offer a newer release which includes sqlparser v0.41 (see 0d94d0b).

[drdrsh]

I verified that this was fixed in the updated sqlparser version and is no longer reproducible under the latest version of PgCat.

I used that query to create a test case for the parser. Thank you for reporting