Re: Back-sql and reserved words

["Dmitry Kovalev" <mitya@seismic.geol.msu.ru>]

Hello Luzian,

If Robert's suggestion of taking alias name into single quotes works for
you - you could make a simple patch to back-sql code, adding these quotes to
SQL generation code.
If you have problems with doing so - please mail servers/slapd/back-sql/* to
me, and I will patch it for you (it is probably better to patch the copy you
are using rather than trying to synchronize with development branch)...

WBW, Dmitry


> On Sat, 17 Nov 2001, Luzian Scherrer wrote:
>
> > Hello,
> >
> > I have a really annoying problem ; I use back-sql to connect to an
> > Oracle Database to map some data from my existing tables to posixAccount
> > objectclass. This results sooner or later in a query like this:
> >
> >   SELECT users.name AS uid FROM users WHERE users.id=?
> >
> >
> >   SELECT 'hello' AS uid_ FROM dual;    -- this works
> >   SELECT 'hello' AS uid FROM DUAL;     -- this does not work :(
>
> You should be able to say
>
> SELECT 'hello' as 'uid' from dual;
>
> Bob Gautier