comparison between integer and string - Sergey Krasnov - com.mysql.lists.win32

2 messages in com.mysql.lists.win32comparison between integer and string

From	Sent On	Attachments
Sergey Krasnov	03 Feb 2003 05:03
jbon...@sola.com.au	03 Feb 2003 14:16

Subject:	comparison between integer and string
From:	Sergey Krasnov (tig...@ameradio.com)
Date:	02/03/2003 05:03:05 AM
List:	com.mysql.lists.win32

From: tig...@ameradio.com To: mysq...@lists.mysql.com Subject: comparison between integer and string

Description: incorrect comparison between integer field and string constant in SELECT

How-To-Repeat: DROP TABLE IF EXISTS tab; CREATE TABLE tab (col INT); INSERT INTO tab SET col='12345'; SELECT * FROM tab WHERE col='12345unknown';

Fix:

Exectutable: mysqld-nt Environment: Pentium IV System: Win2000 Compiler: VC++ 6.0 Architecture: i