[pgpool-committers: 891] pgpool: Fix bug with on memory query cache in handling UPDATE/DELETE wi

Tatsuo Ishii ishii at postgresql.org
Fri Apr 19 14:58:53 JST 2013


Fix bug with on memory query cache in handling UPDATE/DELETE with table alias.

If UPDATE/DELETE is with table alias (UPDATE t1 AS foo...) pgpool
thinks the table name is "t1 AS foo" and fails to invalidate query
cache. This is caused by _outRangeVar() called from nodeToString()
which generates a query string from RangeVar node in raw parse
tree. The solution is removing "AS foo" part from the output of the
string. But reported in bugtrack #56.

Branch
------
master

Details
-------
http://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=d549074d30355ec0e239cd0e4d3ce21a64448ad0

Modified Files
--------------
pool_memqcache.c |   38 +++++++++++++++++++++++++++++++++++---
1 files changed, 35 insertions(+), 3 deletions(-)



More information about the pgpool-committers mailing list