On Sat, 2005-02-26 at 22:43 +0100, Jakub Adamek wrote: > Hi, I really love SQLite, but upgrading to 3.1.3 was not a good idea. I > have already posted 3 tickets with rather serious problems with column > names. > > The last one is really annoying and I can't believe the auto-tests could > have missed it ... > > create table a (id, x); > create table b (id, y); > insert into a values (1,1); > insert into b values (1,2); > select * from a inner join b; > > column names returned: id,x,id,y How am I supposed to use such > column names? Ouwey. No wonder that my C++ wrapper does not want to work > with such a result set. >
Your tickets are unhelpful and will likely be ignored. Rather than complain about the column names, perhaps you can present alternative suggestions. Posting what PostgreSQL, Oracle, and MySQL do with the same queries would be a good start. Explaining why you think the current names are undesirable (instead of just saying "Ouwey") would also be a positive step toward getting the problem addressed. -- D. Richard Hipp <[EMAIL PROTECTED]>
