List:Bugs« Previous MessageNext Message »
From:Michael Widenius Date:May 30 2000 2:06am
Subject:substring incorrect syntax causes crash
View as plain text  
Hi!

>>>>> "John" == John Calder <john@stripped> writes:

John> Bug report
John> MySQL Win32 3.23.14 crashes on getting an SQL syntax wrong.
John> Following SQL query is incorrect, has "substring" where I should
John> have used "substring_index" but the punishment is a little 
John> excessive! ie complete engine crash!

John> select A0 from wptact where A0 like 'MISMATCH%' 
John> order by substring(A0, "*", -1) desc limit 1;

John> The correct syntax works well.

<cut>

Any change you can make a full example of this that we can run?  This
would help us find and fix this problem!

Regards,
Monty
Thread
substring incorrect syntax causes crashJohn Calder30 May
  • substring incorrect syntax causes crashMichael Widenius30 May
    • serious bug allows anyone access to database as rootBrad Johnson30 May
      • RE: serious bug allows anyone access to database as rootjason30 May
      • Re: serious bug allows anyone access to database as rootMichael Labbe30 May
      • No Risk - Re: serious bug allows anyone access to database as rootNick Lindridge31 May
RE: serious bug allows anyone access to database as rootMatt Vermette30 May
  • Re: serious bug allows anyone access to database as rootsasha31 May
    • Re: serious bug allows anyone access to database as rootMichael Widenius5 Jun