Mailinglist Archive: opensuse (1702 mails)

< Previous Next >
[opensuse] mysql upgrade 5.0.51 to 5.1.36 - TRUNCATE/DROP on temp table?
  • From: Per Jessen <per@xxxxxxxxxxxx>
  • Date: Wed, 09 Sep 2009 08:32:12 +0200
  • Message-id: <h87i5c$3rs$3@xxxxxxxxxxxxxxxx>
After my upgrade to 5.1.36 I hit this odd little problem:

I have an application which does roughly this:

CREATE TEMP TABLE new LIKE old;
populate 'new'.
do some stuff
TRUNCATE new;
populate again

This has always worked fine, but after the upgrade it failed because the
user does not have DROP authority on 'new'.  Can anyone explain to me
what caused this change in behaviour?  For the time being I've changed
the TRUNCATE to a DELETE.


/Per

--
Per Jessen, Zürich (13.7°C)

--
To unsubscribe, e-mail: opensuse+unsubscribe@xxxxxxxxxxxx
For additional commands, e-mail: opensuse+help@xxxxxxxxxxxx

< Previous Next >
This Thread
Follow Ups