--- David Crawshaw <[EMAIL PROTECTED]> wrote:
> 2008/5/11 neuro <[EMAIL PROTECTED]>:
> > David, I'm in no way sqlite specialist :) I'm just trying to help
> > SQLiteJDBC to be 'nice' from the point of JDBC driver user :)
>
> Sorry if I came across as grumpy. I'll definitely be applying some
> version of your patch, as it is a sensible change.
>
> I just worry about de facto standards appearing in the way JDBC
> drivers behave that is not documented in the JavaDoc. It seems to me
> that relying on get("tablename.colname") is a bad idea, as the JavaDoc
> doesn't promise it will work. However, that no reason for rejecting a
> patch that makes the driver better.
Long/short column names in result sets have always been unpredictable
in sqlite - especially when joins, unions and subqueries are used.
I can't see how you can implement this behavior outside of sqlite
itself or without parsing and understanding SQL syntax and name
resolution rules. Otherwise, you risk breaking working programs.
As you pointed out, if the programmer uses the "AS" construct,
they can always get the columns names they want.
It's probably best to do nothing in this case.
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
--~--~---------~--~----~------------~-------~--~----~
Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
To unsubscribe, send email to [EMAIL PROTECTED]
-~----------~----~----~----~------~----~------~--~---
