From: Michael P. <mic...@gm...> - 2014-02-14 05:45:09
|
On Fri, Feb 14, 2014 at 11:07 AM, Koichi Suzuki <koi...@gm...> wrote: > Disconnecting the connection as you suggested will bring another > problem such as TEMPORARY object in the subsequent queries. We do > not support TEMPORARY object but I believe we should be consistent on > this for future releases. AFAIK, temporary object are supported, no? There is even a parameter allowing to enforce autocommit instead of 2PC when temp objects are used. This is dangerous, OK, but that's a trade-off and user is normally aware of that when using temp tables. Actually, temporary tables are useful even without 2PC with for example a join pushed down to a unique remote node: it might be better to use a temporary table gathering a list of keys instead of a heavy ANY clause or a array with many values. -- Michael |