Re[4]: Locked tables while "Sending data" !?

[BAUMEISTER Alexandre]

Salut,

TB> And can you say what the cheapest way to force the use of a
TB> temporary table is? (Using ORDER BY would be too expensive.)
TB> Would a "HAVING 1=1", without a GROUP BY, work or would it be
TB> optimised away?

  I tried with an ORDER BY on one of the columns and the result was
  exactly the same. Writers on the table where locked while the
  "Sending data" !

  Why ?

  Alex.