is this a buy or a feature?

i try this in FB 1.5 rc3 and it works fine

create view "requestsummary"
("RequestDate",
"ItemID",
"Qty",
"Use",
"Name",
"Unit")
as
select "RequestDate", m."ItemID", sum(m."Qty") as "Qty",
sum(m."Use") as "Use",
(select "Name" from "items" d where d.ID = m."ItemID") as "Name",
(select "Unit2" from "items" d2 where d2.ID = m."ItemID")
as "Unit"
from "usage" m
where "Status" != 'CAN'
group by "RequestDate", "ItemID"



but the same script in IB 6 open source edition give me an error
message. I know the error message is that the Name and the Unit field
must be included in the group by clause to fix the error. But it
works here in FB 1.5

before that script I have this one ...

create view "requestsummary"
("RequestDate",
"ItemID",
"Qty",
"Use",
"Name",
"Unit")
as
select "RequestDate", m."ItemID", sum(m."Qty") as "Qty",
sum(m."Use") as "Use", d."Name", d."Unit2"
from "usage" m left join "items" d on d.ID = m."ItemID"
where "Status" != 'CAN'
group by "RequestDate", "ItemID"


which neither the FB 1.5 rc3 and IB open source edition give the same
error.

I just try my luck to produce the script above and lucky for me it
works in FB 1.5 rc3 and in my opinion that should the right way the
database engine should behave. because the Name and Unit field is
just a lookup column.

But I wonder which is right the FB 1.5 rc3 or IB 6 open source ed. I
wonder what is the result in FB 1.0.....