From: SourceForge.net <no...@so...> - 2004-03-09 21:13:42
|
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 |