MySQL Forums
Forum List  »  Memory Storage Engine

Re: COMPARING WITH INNODB
Posted by: Ingo Strüwing
Date: February 16, 2007 03:28AM

Hi.

I fail to understand how this query might give you ther results that you expect. Also I am clueless why it works with InnoDB.

At first I believe that instr(code,142546997) can only return a non-zero number if code is longer or equal than 142546997 and starts with this sequence.

At second I believe that instr() is not able to tell you how many characters are matched.

At third I don't see any ORDER BY. So how could you select the longest match?

At last I wonder why LIMIT in the middle of the query is syntactically accepted. It fails for me.

IMHO this query cannot work at all. Please ask for help in the newbie forum.

Regards
Ingo

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
5487
February 14, 2007 08:53AM
Re: COMPARING WITH INNODB
3943
February 16, 2007 03:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.