[Bug 663192] [NEW] Query with this_.id=? buggy

[Ingo Busse]

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.