Request a Demo
Home   >   mailing lists

Re: BUG #19350: Short circuit optimization missed when runningsqlscriptes in JDBC - Mailing list pgsql-bugs

From Greg Sabino Mullane
Subject Re: BUG #19350: Short circuit optimization missed when runningsqlscriptes in JDBC
Date
Msg-id CAKAnmm+G4pjdfKpXzrxVWv4s62_RcpAR4fO8++nYxjRGCqbDOw@mail.gmail.com
Whole thread Raw
In response to Re: BUG #19350: Short circuit optimization missed when runningsqlscriptes in JDBC  (Dave Cramer <davecramer@postgres.rocks>)
Responses Re: BUG #19350: Short circuit optimization missed when runningsqlscriptes in JDBC
List pgsql-bugs
Tree view
Possibly because JDBC does everything using the V3 protocol whereas psql does not. psql uses simple query.

Maybe JDBC is doing something else? I cannot duplicate the error when doing it via the protocol (DBD::Pg) or via psql. Even forcing non-server-side prepares (i.e. making the driver replace the vars itself) fails to fail.

pgsql-bugs by date:

Previous
From: Dave Cramer
Date:
Subject: Re: BUG #19350: Short circuit optimization missed when runningsqlscriptes in JDBC
Next
From: Greg Sabino Mullane
Date:
Subject: Re: BUG #19357: PostgreSQL generates a custom plan that performs worse than the generic plan for a certain query.