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=
d=6 and admin_id="yoda" ;
+-----+--+
| host_id | admin_id |
+-+--+
| 6 | yoda |
+-+--+
1 row in set (0,00 sec)
mysql> select * from test_nkomp_admin3 where host_id=6 and admin_id="yoda" ;
+-+--+
| host_id | admin
gregor kling [mailto:gregor.kl...@dvz.fh-giessen.de]
Sent: Thursday, October 28, 2010 1:54 PM
To: mysql@lists.mysql.com
Subject: strange behavior in mysql-server 5.1.49 and 5.1.51
Hello list,
I fight a strange behavior in mysql versions 5.1.49 and 5.1.51 -
maybe a fight against myself ;-)
The fo
egor kling [mailto:gregor.kl...@dvz.fh-giessen.de]
Sent: Thursday, October 28, 2010 1:54 PM
To: mysql@lists.mysql.com
Subject: strange behavior in mysql-server 5.1.49 and 5.1.51
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 wor
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
