vertx-sql-client icon indicating copy to clipboard operation
vertx-sql-client copied to clipboard

JDBCPool and PostgreSQL has inconsistency param type

Open zero88 opened this issue 4 years ago • 0 comments

Version

io.vertx:vertx-sql-client io.vertx:vertx-pg-client

Context

I encountered an exception which looks suspicious while use SQL client and reactive PG client both on PostgreSQL

JDBCPool use INDEX param ?

Prepared Query:          select "public"."temporal_data_type"."id", "public"."temporal_data_type"."Date", "public"."temporal_data_type"."Time", "public"."temporal_data_type"."TimeTz", "public"."temporal_data_type"."Timestamp", "public"."temporal_data_type"."TimestampTz", "public"."temporal_data_type"."Interval" from "public"."temporal_data_type" limit ?

PgSQL client use NAMED param $

POSTGRESQL:          select "public"."temporal_data_type"."id", "public"."temporal_data_type"."Date", "public"."temporal_data_type"."Time", "public"."temporal_data_type"."TimeTz", "public"."temporal_data_type"."Timestamp", "public"."temporal_data_type"."TimestampTz", "public"."temporal_data_type"."Interval" from "public"."temporal_data_type" limit $1

Is it a bug or feature?

zero88 avatar Mar 16 '21 10:03 zero88