5,'anakin');
insert into test_nkomp_admin3 (host_id,admin_id) values
(6,'luke'),(6,'yoda');
mysql> select * from test_nkomp_admin where host_id=6 and admin_id="yoda" ;
Empty set (0,00 sec)
mysql> select * from test_nkomp_admin2 where host_id=6 and admin_id=
6 | luke |
+-+--+
1 row in set (0.00 sec)
But not this one:
mysql> select * from test_nkomp_admin where host_id=6 and admin_id like
'luke';
Empty set (0.00 sec)
So I guess, I should bag a bugreport ...
cheers
gregor
Regards,
m
-Original Message-
From:
Hello list,
I fight a strange behavior in mysql versions 5.1.49 and 5.1.51 -
maybe a fight against myself ;-)
The following query works exactly as assumed in version 5.1.41 with
the given testbed:
select * from test_nkomp_admin where host_id=6 and admin_id="yoda";
/* version 5.1.41 ubuntu 1
7;yoda'),(3,'anakin'),(3,'leia'),(3,'r2');
insert into test_nkomp_admin (host_id,admin_id) values
(4,'luke'),(4,'yoda'),(4,'anakin'),(4,'leia');
insert into test_nkomp_admin (host_id,admin_id) values
(5,'luke'),(5,'yoda'),(5,'anakin');
insert into test_nkomp_admin (host_id,admin_id) values
(6,'luke'),(6,'yoda');
cheers
gregor
--
Gregor Kling
Abteilung ITS, Sachgebiet DVZ
Fachhochschule Giessen
Tel: 0641/309-1292
E-Mail: gregor.kl...@its.fh-giessen.de
smime.p7s
Description: S/MIME Cryptographic Signature
