[pgpool-committers: 890] pgpool: Fix bug with on memory query cache in handling UPDATE/DELETE wi
ishii at postgresql.org
Fri Apr 19 14:49:25 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.
pool_memqcache.c | 36 ++++++++++++++++++++++++++++++++++--
1 files changed, 34 insertions(+), 2 deletions(-)
More information about the pgpool-committers