Bugs item #523452, was opened at 2002-02-27 19:30
Message generated for change (Settings changed) made by dimitr
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=523452&group_id=9028
Category: Core Engine
Group: Feature v1.5
>Status: Closed
Resolution: Invalid
Priority: 1
Submitted By: Fabiano Bonin (fabianobonin)
Assigned to: Dmitry Yemanov (dimitr)
Summary: Allow ORDER BY in subquery
Initial Comment:
/* master */
create table t1 (
t1_id integer not null,
t1_code varchar(10),
t1_sum_t2_value numeric(11,2) default 0 not null );
/* detail */
create table t2 (
t2_id integer not null,
t1_id integer,
t2_value numeric(11,2) default 0 not null );
alter table t1 add primary key (t1_id);
alter table t2 add primary key (t2_id);
insert into t1 values (1, 'invoice 1', 0);
insert into t1 values (2, 'invoice 2', 0);
insert into t1 values (3, 'invoice 3', 0);
insert into t1 values (4, 'invoice 4', 0);
insert into t2 values (1, 1, 5);
insert into t2 values (2, 1, 10);
insert into t2 values (3, 2, 5);
insert into t2 values (4, 2, 10);
insert into t2 values (5, 3, 5);
insert into t2 values (6, 3, 10);
select
( select first 1 t2.t2_value from t2 where t2.t1_id
= t1.t1_id ) as some_field
from
t1;
/* works */
select
( select first 1 t2.t2_value from t2 where t2.t1_id
= t1.t1_id ORDER BY t2.t2_id DESC ) as some_field
from
t1;
/* token unknown - order */
----------------------------------------------------------------------
Comment By: Nobody/Anonymous (nobody)
Date: 2002-02-27 20:22
Message:
Logged In: NO
Ann, I, I too ask to for it as a new feature. Or LAST, no
difference. We have this and some other feature requests but
decided don't bother you with it until FB1 release and wait
some time while you'll celebrate this great achievement. I'm
not Anonimus, just forgot my SF password as usual.
Best regards, Alexander V.Nevsky.
----------------------------------------------------------------------
Comment By: Ann W. Harrison (awharrison)
Date: 2002-02-27 19:52
Message:
Logged In: YES
user_id=66088
The SQL standards (89, 92, 99) distinguish between a query statement
and a query expression. Only a select statement is a query statement.
Subselects are query expressions. Query expressions do not include an
order by clause.
If you think we should change the code to allow order by statements
in query expressions, you should ask for it as a new feature. This is not
a bug.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=523452&group_id=9028
|
