[pkg-firebird-general] select distinct and left join bug in 1.5.3.4870 deb

[Normunds]

Hi, Damyan,

> 
>>From where? It is not in the archive yet.
> 

from ftp://shrek.creditreform.bg/public/pool/main/f/firebird2/
is there any better place?

> 
> Same here. Good catch!
> 
> $ isql-fb localhost:employee.fdb
> Database:  localhost:employee.fdb
> SQL> set plan;

<skipped>

> 
> Changing the query to
> 
> select distinct c.customer, c.cust_no
> ...
> makes it sort rightly.
> 


yes, but my software is not ready for such bug and I should
make a lot of changes for that :(

And why original build is working? And why you are not using
sources from original build. Sorry for such questions, but I'm
not expert in deb package building. I'm asking, becouse we had
some stability problems with 1.5.2 deb package, when firebird
simply hung up without any response.

> There is a patch that fiddles with redundant sorts. I'try to remove it and see
> if it makes any difference.
> 

ok, I'm waiting for this new package asap.
thanks for your work!

> 
> Thanks for reporting.
> 

Best regards,
Normunds