Public bug reported: Ubuntu 10.10 mysql-server 5.1.49-1ubuntu8
Query delivers wrong result! In Ubuntu 10.10 the attached query returns no result while in Ubuntu 10.04 with mysql-server 5.1.41 it properly returned the entry with this_.id=1. Note that when omitting the last part of the where clause (and this_.id=1) the query correctly lists all entries. But when adding the additional part to select a specific one nothing is returned. select this_.id as id61_1_, aclkunde3_.akte_acl_kunde_id as akte1_3_, aclkunde_a1_.id as kunde2_3_, aclkunde_a1_.id as id13_0_, aclkunde_a1_.kundennummer as kundennu3_13_0_, aclkunde_a1_1_.anrede as anrede14_0_, aclkunde_a1_1_.vorname as vorname14_0_, aclkunde_a1_1_.zuname as zuname14_0_, aclkunde_a1_2_.anrede as anrede15_0_, aclkunde_a1_2_.vorname as vorname15_0_, aclkunde_a1_2_.zuname as zuname15_0_, case when aclkunde_a1_1_.id is not null then 1 when aclkunde_a1_2_.id is not null then 2 when aclkunde_a1_.id is not null then 0 end as clazz_0_ from akte this_ left outer join akte_kunde aclkunde3_ on this_.id=aclkunde3_.akte_acl_kunde_id left outer join kunde aclkunde_a1_ on aclkunde3_.kunde_id=aclkunde_a1_.id left outer join anwalt aclkunde_a1_1_ on aclkunde_a1_.id=aclkunde_a1_1_.id left outer join kunde_glaeubiger aclkunde_a1_2_ on aclkunde_a1_.id=aclkunde_a1_2_.id where ( aclkunde_a1_.id=1 ) and this_.id=1; ** Affects: mysql-5.1 (Ubuntu) Importance: Undecided Status: New -- Query with this_.id=? buggy https://bugs.launchpad.net/bugs/663192 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs