Op maandag 25 april 2005 14:12, schreef George Ionescu:
> Hello Dr. Hipp,
> Hello dear sqlite users,
>
> while working with sqlite v3.2.1, I've noticed another annoyance in the way
> sqlite returns column names (besides the bug with #1141, duplicated as
> #1218).
>
> Using sqlite command line, enter the following:
>
> sqlite3 test.db
> create table test(Field1 text(20));
> insert into test values ('a value');
> select field1 from test;did you try select field1 as field1 from test; regards Bert Verhees > > Field1 > a value > > notice the uppercase F from Field1, although field1 is requested. > So, it seems that sqlite returns column names as defined in schema, not as > requested by the user. This may not seem a big problem, but it becomes one > when working with columns and trying to refer them by name and not wanting > to do a case-insensitive comparison (I'm using a std::map to store > columns). > > Any ideas? Should I write a ticket? > > If this is so hard to resolve, could someone point out the routine in which > sqlite computes column names? I could try to solve it myself and post a > patch. > > Thanks. -- Met vriendelijke groet Bert Verhees ROSA Software
