SitePoint.com

alig4321 · Jul 5, 2005, 14:00

Code:

SELECT "A\\" LIKE "A\\"

Effectively this should compare the string 'A\' to the pattern 'A\' yet when I execute this code on v4.1 I get a return of 0.

Can anyone shed light on this?

r937 · Jul 5, 2005, 16:35

on 4.1.12a-nt, i get a return of 1, not 0

alig4321 · Jul 5, 2005, 19:58

Thats real strange. I ran it in the command line client and got 1. I ran it in Query Browser and got 0.

Could it be a bug in Query Browser's parsing maybe?

longneck · Jul 5, 2005, 20:27

maybe. query browser issues a "SET NAMES utf8" command right before it sends the query, and that causes mysql to return 0 when i'm in the CLI, too. i'll post it on the mysql website as a bug in mysql and see waht they say.

Tangerine_Dream · Jul 6, 2005, 03:34

On MySQL 5.0.2-alpha-nt the query also returns 1 for "SET NAMES latin1" and 0 for "SET NAMES utf8"

longneck · Jul 6, 2005, 10:14

it is now officially a bug: http://bugs.mysql.com/bug.php?id=11754

bangkok_knight · Sep 25, 2007, 08:46

Mine is returning 1 too. cheers.

Jul 5, 2005, 14:00	#1
alig4321 SitePoint Enthusiast Join Date: May 2005 Location: UK Posts: 65	Using LIKE to match patterns - strange occurence when escaping Code: SELECT "A\\" LIKE "A\\" Effectively this should compare the string 'A\' to the pattern 'A\' yet when I execute this code on v4.1 I get a return of 0. Can anyone shed light on this?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Jul 5, 2005, 16:35	#2
r937 SQL Consultant Join Date: Jul 2002 Location: Toronto, Canada Posts: 31,026	on 4.1.12a-nt, i get a return of 1, not 0

Jul 5, 2005, 19:58	#3
alig4321 SitePoint Enthusiast Join Date: May 2005 Location: UK Posts: 65	Thats real strange. I ran it in the command line client and got 1. I ran it in Query Browser and got 0. Could it be a bug in Query Browser's parsing maybe?

Jul 5, 2005, 20:27	#4
longneck reads the Community Crier Join Date: Feb 2004 Location: Tampa, FL (US) Posts: 9,896	maybe. query browser issues a "SET NAMES utf8" command right before it sends the query, and that causes mysql to return 0 when i'm in the CLI, too. i'll post it on the mysql website as a bug in mysql and see waht they say.

Jul 6, 2005, 03:34	#5
Tangerine_Dream SitePoint Evangelist Join Date: Apr 2005 Location: Moscow, Russia Posts: 559	On MySQL 5.0.2-alpha-nt the query also returns 1 for "SET NAMES latin1" and 0 for "SET NAMES utf8"

Jul 6, 2005, 10:14	#6
longneck reads the Community Crier Join Date: Feb 2004 Location: Tampa, FL (US) Posts: 9,896	it is now officially a bug: http://bugs.mysql.com/bug.php?id=11754

Sep 25, 2007, 08:46	#7
bangkok_knight SitePoint Member Join Date: Sep 2007 Posts: 13	Mine is returning 1 too. cheers.