>>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
Yes, I'm well aware of the AS workaround. However, I was looking for a way to avoid this, since it would mean rewriting most of our queries. Thanks.