2 messages in com.mysql.lists.win32comparison between integer and string
FromSent OnAttachments
Sergey Krasnov03 Feb 2003 05:03 
jbon...@sola.com.au03 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