>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. > > It may make for some pretty long queries, but you can just tell sqlite what to call each of your columns:
sqlite> select field1 as field1 from test; field1 a value -Eli
