>
> On Mon, 11 May 1998, David Hartwig wrote:
>
>
> > It is not very difficult to produce this problem in MS Access 97; I
> > expect my users to beat me up pretty good on this issue. Thus, I plan to
> > look into making the fix in the backend myself. Conceptually it does not
> > seem too difficult.
> >
> > 1. Add a hidden attribute to the target node structure.
> >
> > 2. Modify the parser/analyzer to add any attributes in the GROUP/ORDER BY
> > clause that are missing from the target list, to the target list with the
> > hidden attribute set.
> This would be a great enhancement!
> SQL92 specifies that columns in the ORDER BY must appear in the
> SELECT clause, but this limitation has no sense, indeed many databases
> already implement this enhancement.
> Go for it!
There already is code in the backend for Junk fields to be removed. Not
sure what it does, though.
--
Bruce Momjian | 830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)