Description:
It seems that there's a bug on the case-sensitive / case
insensitive fields. I have a table created as follows:
CREATE TABLE hosoktest (
idx int(11) DEFAULT '0' NOT NULL,
nev varchar(20) binary DEFAULT '' NOT NULL,
jelszo varchar(8) binary,
hosdata blob,
extra varchar(100) binary,
mailinfo varchar(100),
points int(11) DEFAULT '0' NOT NULL,
ipcim varchar(15),
latogatas varchar(14),
kasztal_szam smallint(6),
kasztal_datum datetime,
PRIMARY KEY (nev),
UNIQUE idx (idx),
KEY points (points)
);
If I execute the following select:
SELECT nev FROM hosoktest WHERE nev = 'pokember' OR nev = \
'Pokember'
I got only 'pokember' but 'Pokember' not...
If I execute the following:
SELECT nev FROM hosoktest WHERE nev = 'Pokember' OR nev = \
'pokember'
I got only 'Pokember'.
If I execute:
SELECT nev FROM hosoktest WHERE nev = 'Pokember'
I got correctly 'Pokember' only.
If I execute:
SELECT nev FROM hosoktest WHERE nev = 'pokember'
I got correctly 'pokember' only.
I already tried to repair ISAM table of hosoktest
(hosoktest.ISM with isamchk), but there's no result.
I also tried to dump table 'hosoktest' with mysqldump,
than DROP table 'hosoktest', than rebuild table and
finally import data from the dumpfile, but that
helped nothing...
How-To-Repeat:
With the dumpfile attached at the end of the message you
can simply repeat it.
Fix:
Hope you know!
Submitter-Id:
Originator: [EMAIL PROTECTED]
Organization: Hosemberkepzo
MySQL support: none
Synopsis: binary varchar fields seems non-binary
Severity: serious
Priority: medium
Category: mysql
Class: sw-bug
Release: mysql-3.22.32 (Source distribution)
Environment:
x86 PC, Linux 2.4.x with standard Debian potato stable
packages
System: Linux fules 2.4.10-ac7 #11 Thu Oct 18 13:19:05 CEST 2001 i686 unknown
Architecture: i686
Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.2/specs
gcc version 2.95.2 20000220 (Debian GNU/Linux)
Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer' CXX='g++' CXXFL\
AGS='-O2 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' \
LDFLAGS=''
Configure command: ./configure --enable-shared --without-readline --enable-ass\
embler --with-mysqld-user=mysql --with-unix-socket-path=/var/run/mysqld/mysqld.\
sock --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc/\
mysql --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/\
info --includedir=/usr/include --mandir=/usr/share/man
Perl: This is perl, version 5.005_03 built for i386-linux
====8<=========== attachement ============================================
CREATE TABLE hosoktest (
idx int(11) DEFAULT '0' NOT NULL,
nev varchar(20) binary DEFAULT '' NOT NULL,
jelszo varchar(8) binary,
hosdata blob,
extra varchar(100) binary,
mailinfo varchar(100),
points int(11) DEFAULT '0' NOT NULL,
ipcim varchar(15),
latogatas varchar(14),
kasztal_szam smallint(6),
kasztal_datum datetime,
PRIMARY KEY (nev),
UNIQUE idx (idx),
KEY points (points)
);
INSERT INTO hosoktest VALUES
(14642,'Pokember','xxx','11119540480121111100001000105000116800007100010011011111201160066006066616000000008100036300020000190900930880000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000301170186000000000000000000000000000000000000000000001168020010903000000000000000000000000000005000004600','','OK;[EMAIL PROTECTED]',1043,'139.92.145.242','20011224193559',0,'0000-00-00
00:00:00');
INSERT INTO hosoktest VALUES
(32108,'pokember','xxx','11118206120091111001001000094000116800002100014011001110200060060006060000000000024060606000020000510930632900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000001168020011004000000000000000000000000000028000007000','','OK;[EMAIL PROTECTED]',769,'195.38.103.28','20011224144620',0,'0000-00-00
00:00:00');
====>8=========== attachement ============================================
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
