Re: [sqlite] querying attached database

2004-02-03 Thread Kurt Welgehausen
I don't think this is a bug, at least not in the context presented. "commodities.id" really is ambiguous here, and it can be disambiguated with "main" or "temp" or the name of the attached database, per the documentation. Regards --

Re: [sqlite] md5sum()

2004-02-03 Thread Rickard Andersson
b.bum wrote: > I'm curious as to why the md5sum() aggregate is only available for the > purposes of unit testing. > > It seems like a fairly generically useful feature in a number of > contexts. Any reason that it isn't included as a normal part of the > sqlite installation/api? Also, might I re

[sqlite] md5sum()

2004-02-03 Thread b.bum
I'm curious as to why the md5sum() aggregate is only available for the purposes of unit testing. It seems like a fairly generically useful feature in a number of contexts. Any reason that it isn't included as a normal part of the sqlite installation/api? It would look to mostly be a matter o

[sqlite] test/format 11.3 failing?

2004-02-03 Thread b.bum
Test 11.3 of format is failing on OS X... do_test format3-11.3 { execsql {SELECT '123456789012345678901'=='123456789012345678900'} } {1} why? thanks, b.bum - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional command

Re: [sqlite] querying attached database

2004-02-03 Thread Dennis Cote
From: "Bronislav Klučka" <[EMAIL PROTECTED]> > Hi, I've got two same databases (one is older then the second one) and I > wanted to attach them, so I've done: > > attach database './database/produkty.sdb' as commodities2; > select * from commodities left join commodities2.commodities on > commodit

Re: [sqlite] querying attached database

2004-02-03 Thread Kurt Welgehausen
Try main.commodities.id = commodities2.commodities.id. See the first paragraph of www.sqlite.org/lang.html#attach. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] querying attached database

2004-02-03 Thread Bronislav Klučka
Hi, I've got two same databases (one is older then the second one) and I wanted to attach them, so I've done: attach database './database/produkty.sdb' as commodities2; select * from commodities left join commodities2.commodities on commodities.id = commodities2.commodities.id the second query re