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

[Damyan Ivanov]

Normunds wrote:
>>> From where? It is not in the archive yet.
> 
> from ftp://shrek.creditreform.bg/public/pool/main/f/firebird2/
> is there any better place?

No, I just wasn't sure whether I published www.cdeditreform.bg (an alias that
now points to another server) or shrek (the canonical host name).

>> 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 :(

Yes, sure. It was meant just as a comment. The original query should return the
correct result, I agree.

> And why original build is working? And why you are not using
> sources from original build. Sorry for such questions, but I'm

Debian packages use original sources plus patches. If you're interested you may
simply apt-get source firebird2-super-server and look in debian/patches

These patches are mostly to make firebird work nicely with Debian's autotools,
bootstrap auto* and fix some file locations. Well, mostly.

My suspiction is that opt-bypass-redundant-sort.dpatch needs to be fixed or
dropped.

I'll offer packages when time permits.

> 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.

Never heard of this problem. :(

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


Regards,
dam
-- 
Damyan Ivanov                              Creditreform Bulgaria
divanov at creditreform.bg              http://www.creditreform.bg/
phone: +359(2)928-2611, 929-3993            fax: +359(2)920-0994
mob. +359(88)856-6067               dam at jabber.minus273.org/Gaim
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 258 bytes
Desc: OpenPGP digital signature
Url : http://lists.alioth.debian.org/pipermail/pkg-firebird-general/attachments/20060315/06e33063/signature.pgp