Re: COMPARING WITH INNODB
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
Subject
Views
Written By
Posted
5465
February 14, 2007 08:53AM
Re: COMPARING WITH INNODB
3928
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.