RE: [stellation-res] Firebird port w/copyright + more patches

["Jonathan Gossage" <jgossage@xxxxxxxx>]

> >-----Original Message-----
> >From: stellation-res-admin@xxxxxxxxxxxxxxx
> >[mailto:stellation-res-admin@xxxxxxxxxxxxxxx]On Behalf Of Rodolfo M.
> >Raya
> >Sent: September 2, 2002 2:30 PM
> >To: Stellation list
> >Subject: [stellation-res] Firebird port w/copyright + more patches
> >
> >
> >Hi,
> >
> >Here is another version of the Firebird access point with the copyright
> >notice included.
> >
> >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.

MySQL will accept this syntax, the AS is optional.

> >
> >Another problem I noticed is the comparison against NULL. 
> >
> >Current queries have the form:
> >
> >   select s_field1, s_field 2 
> >   from s_atable AS table 
> >   where s_field1 = NULL
> >
> >and they should be like:
> >
> >   select s_field1, s_field 2 
> >   from s_atable table 
> >   where s_field1 IS NULL
> >
> >to avoid problems with Firebird/Interbase.

MySQL also requires this syntax.
 
> >
> >I have hot found all the places where this happens, so I can't provide
> >patches yet.Again, I don't know how this will affect other databases.
> >
> >Regards,
> >
> >Rodolfo
> >


Regards

Jonathan