[Date Prev][Date Next]
Re: Back-sql and reserved words
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)...
> 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