List:GUI Tools« Previous MessageNext Message »
From:Jorge del Conde Date:January 9 2003 11:59pm
Subject:Re: BUG - '' does not match ' after \\\\ in LIKE
View as plain text  
Hi!

Thanks for the bug-report !

I just fixed this in my local bk tree ... 0.8.8 has this bug fixed.

Regards,
Jorge
--
For technical support contracts, visit https://order.mysql.com/?ref=mjdc
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Jorge del Conde <jorge@stripped>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Full-Time Developer
/_/  /_/\_, /___/\___\_\___/   Mexico City, Mexico
       <___/   www.mysql.com

MySQL Users Conference and Expo
http://www.mysql.com/events/uc2003/


----- Original Message -----
From: "Sean Tobin" <byrdhuntr@stripped>
To: <mycc@stripped>
Sent: Saturday, November 30, 2002 5:49 AM
Subject: BUG - '' does not match ' after \\\\ in LIKE


> Odd bug I've found in the control center 0.8.6-alpha on win32. Here's the
> quick version:
>
> CREATE TABLE `mismatch` (
> `name` varchar(10) NOT NULL default ''
> ) TYPE=MyISAM;
> INSERT INTO mismatch VALUES ('Foo\\\'bar');
>
> Now we have a table mismatch, with a field name, and one value which is a
> literal: Foo\'bar
>
> Now, in mysqlcc, execute the following sql query (remember, in a LIKE, you
> need 4 \'s to match a literal \ ):
>
> SELECT name FROM mismatch WHERE name LIKE 'Foo\\\\''%';
>
> and watch as you get no results. Now, execute the same query from the
mysql
> command line:
>
> mysql> SELECT name FROM mismatch WHERE name LIKE 'Foo\\\\''%';
> +----------+
> | name     |
> +----------+
> | Foo\'bar |
> +----------+
> 1 row in set (0.00 sec)
>
> MySQLcc has issues using '' to search for a literal ' while following \\\\
> in a like search (for those of you interested, LIKE 'Foo''%' will match a
> literal Foo'bar without problems) As a workaround, you can replace '' with
> \' and MySQLcc will find the record with no problems.
>
> Sean Tobin
>
> _________________________________________________________________
> MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
> http://join.msn.com/?page=features/virus
>
>
> ---------------------------------------------------------------------
> Before posting please check: http://www.mysql.com/products/mycc/index.html
> To unsubscribe, send email to
mysqlcc-unsubscribe-jorge=mysql.com@stripped
>


Thread
BUG - '' does not match ' after \\\\ in LIKESean Tobin30 Nov
  • Re: BUG - '' does not match ' after \\\\ in LIKEJorge del Conde10 Jan