# HG changeset patch # User Sylvain Thénault # Date 1302123172 -7200 # Node ID 1e2d8e4d2c7b369445327d0f036cb0caa9b0e4ba # Parent f72e3f4666b0b83dc69dbf76c49ce0d291df1bfc [ms planner] fix buggy temp table name generation, may generate duplicated unique id with subqueries/union diff -r f72e3f4666b0 -r 1e2d8e4d2c7b server/msplanner.py --- a/server/msplanner.py Wed Apr 06 22:52:51 2011 +0200 +++ b/server/msplanner.py Wed Apr 06 22:52:52 2011 +0200 @@ -1420,9 +1420,7 @@ steps.append(ppi.build_final_part(minrqlst, solindices, inputmap, sources, insertedvars)) else: - table = '_T%s%s' % (''.join(sorted(v._ms_table_key() for v in terms)), - ''.join(sorted(str(i) for i in solindices))) - table = plan.make_temp_table_name(table) + table = plan.make_temp_table_name('T%s' % make_uid(id(select))) ppi.build_non_final_part(minrqlst, solindices, sources, insertedvars, table) # finally: join parts, deal with aggregat/group/sorts if necessary