Hi,

> > I use a stored procedure to concat 2 fields where the second can have
> > NULL value.
> > But I have an Invalid request BLR at offset XXXX when I try to use a
> > Distinct clause.
> >
> > For example :
> > select distinct Q2.*,(select FIRSTLASTNAME from CONCAT_FIRSTLASTNAME
> > (Q2.FIRSTNAME ,Q2.LASTNAME)) R_FIRSTLASTNAME
> > from CUSTOMER Q2
>
> This is a known bug, DISTINCT on sub-select in select list.

If this worked in Fb 1.0, but doesn't in 1.5, will it be fixed
in 1.5.1 - as this bug makes upgrading tougher.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com