Tim Bunce writes:
> On Mon, Mar 19, 2001 at 02:24:52PM +0200, Sinisa Milivojevic wrote:
> >
> > Hi!
> >
> > I tested your test case and you are right !
>
> We've just discovered a very similar sounding problem immediately after
> upgrading to 3.23.35. In our case an update is reporting
On Mon, Mar 19, 2001 at 02:24:52PM +0200, Sinisa Milivojevic wrote:
>
> Hi!
>
> I tested your test case and you are right !
We've just discovered a very similar sounding problem immediately after
upgrading to 3.23.35. In our case an update is reporting 0 zero rows
updated which then triggers an
"Gerald L. Clark" wrote:
>
> This does not answer your problem, but 'timestamp' is a reserved word.
>
...not the complete truth ;-) :
7.34 Is MySQL picky about reserved words?
A common problem stems from trying to create a table with column names
that use the names of datatypes or functions b
This does not answer your problem, but 'timestamp' is a reserved word.
Jan Legenhausen wrote:
>
> Hi,
>
> i just upgraded from 3.23.33 to 3.23.35 and found that a little script of
> mine which simply modifys a table went mad completly.
> I figured out a testcase which shows at least one of the
Hi!
I tested your test case and you are right !
Thank you for a reproducible test case.
We will fix it shortly.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mail
Jan Legenhausen writes:
>
> No other messages at all - simply repeating the query _does_ show the
> expected.
> - no message in the error log (...would have mentioned this... ;-)
> - no special thing in the normal log:
> 010318 20:41:44 7 Query alter table t_webmaster change lfd
>
>
> Hi!
>
> I have tested your case and it works just fine for me.
>
> What error message do you get ??
What i wrote was all i got - so there's just
> mysql> update t_webmaster set status=1 where type='Open';
> Query OK, 0 rows affected (0.01 sec)
No other messages at all - simply repeating
Jan Legenhausen writes:
> Hi,
>
> i just upgraded from 3.23.33 to 3.23.35 and found that a little script of
> mine which simply modifys a table went mad completly.
> I figured out a testcase which shows at least one of the strange things
> which happen:
>
> Table definition and data:
>
Hi,
i just upgraded from 3.23.33 to 3.23.35 and found that a little script of
mine which simply modifys a table went mad completly.
I figured out a testcase which shows at least one of the strange things
which happen:
Table definition and data:
CREATE TABLE t_webmaster (
lfdnr int(10) unsigne
