[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
RE: [stellation-res] Firebird port w/copyright + more patches
|
> >-----Original Message-----
> >From: stellation-res-admin@xxxxxxxxxxxxxxx
> >[mailto:stellation-res-admin@xxxxxxxxxxxxxxx]On Behalf Of Rodolfo M.
> >Raya
> >Sent: September 2, 2002 3:37 PM
> >To: Stellation list
> >Subject: Re: [stellation-res] Firebird port w/copyright + more patches
> >
> >
> >On Mon, 2002-09-02 at 15:29, Rodolfo M. Raya wrote:
> >
> >> Also, here are 5 patches that must be carefully checked. This patches
> >> modify some queries used to retrieve artifacts.
> >>
> >> Original queries have the form:
> >>
> >> select s_field1, s_field 2
> >> from s_atable AS table
> >> where s_field1 = "1"
> >>
> >> I deleted the AS keyword because in Firebird/Interbase you can only use
> >> AS with fields, not table names.
> >>
> >> Now the queries look like this:
> >>
> >> select s_field1, s_field 2
> >> from s_atable table
> >> where s_field1 = "1"
> >>
> >> I don't know if this will cause troubles with other databases.
> >
> >I tried with Postgres and there is no problem if we omit the AS keyword
> >to create an alias for the table name.
> >
> >Jonathan says MySQL can handle this, so we only need to find out if this
> >affects Oracle and/or DB2.
> >
> >Rodolfo
It appears from looking at the syntax tables for the SELECT statement on
Oracle that the AS keyword is not needed for table aliasing
Regards
Jonathan
