The pg_exec_array_params from lunatic-cat

pg_exec_array_params's People

Contributors

Watchers

pg_exec_array_params's Issues

Upgrade pg_query dependency to 1.3.0

Hi @razum2um,

arm64-based machines cannot install the gem due to the dependency pg_query 1.2.0 not supporting arm.
The version 1.3.0 adds support to ARM and should solve the issue (see Changelog).

I am facing the issue on a M1 macbook and it might happen more and more as the new mac hardware transitions to ARM.

Would it be possible to upgrade the dependency to 1.3.0?

(See this issue for reference)

Process ParamRef in ResTarget->val

Gem processes only REXPR inside A_EXPR (e.g. right part of filter clauses or assignments), but this fails:

> PG::Connection.include(PgExecArrayParams)
=> PG::Connection
> sql = "SELECT $1"
=> "SELECT $1"
> User.connection.raw_connection.exec_array_params(sql, [[1,2]])
PG::ProtocolViolation: ERROR:  bind message supplies 0 parameters, but prepared statement "" requires 1
from /lib/pg_exec_array_params/query.rb:25:in `exec_params'

AST looks like:

> PgQuery.parse sql
=> #<PgQuery:0x00007f84741fc1d8
 @aliases=nil,
 @cte_names=nil,
 @query="SELECT $1",
 @tables=nil,
 @tree=[{"RawStmt"=>{"stmt"=>{"SelectStmt"=>{"targetList"=>[{"ResTarget"=>{"val"=>{"ParamRef"=>{"number"=>1, "location"=>7}}, "location"=>7}}], "op"=>0}}}}],
 @warnings=[]>