>
>
>
> sqlite> select * from ( select count(*)count,* from addresses join users
> on users.address_id=addresses.id ) address join pets pet on pet.user_id=
> address.users.id;
> Error: no such column: address.users.id
>
>
>> console.log( db.do( "select count(*)count,* from ( select count(*)count,*
from addresses join users on users.address_id=addresses.id ) address join
pets pet on pet.user_id='address.user.id';" ) );
13:34:27.325|212800001160~sql_module.cc(571):Do Command[04F1ECF4:test.db]:
select count(*)count,* from ( select count(*)count,* from addresses join
users on users.address_id=addres
ses.id ) address join pets pet on pet.user_id='address.user.id';
13:34:27.326|212800001160~sack.cc(97503):Sqlite3 Err: (284) automatic index
on users(address_id)
13:34:27.326|212800001160~sack.cc(104891):0
13:34:27.326|212800001160~sack.cc(101458):Column 0 : table_name:(null)
origin_name:(null) table_alias:(null)
13:34:27.327|212800001160~sack.cc(101458):Column 1 : table_name:(null)
origin_name:(null) table_alias:(null)
13:34:27.327|212800001160~sack.cc(101458):Column 2 : table_name:addresses
origin_name:id table_alias:addresses
13:34:27.327|212800001160~sack.cc(101458):Column 3 : table_name:addresses
origin_name:name table_alias:addresses
13:34:27.327|212800001160~sack.cc(101458):Column 4 : table_name:users
origin_name:id table_alias:users
13:34:27.327|212800001160~sack.cc(101458):Column 5 : table_name:users
origin_name:address_id table_alias:users
13:34:27.328|212800001160~sack.cc(101458):Column 6 : table_name:users
origin_name:name table_alias:users
13:34:27.328|212800001160~sack.cc(101458):Column 7 : table_name:pets
origin_name:id table_alias:pet
13:34:27.328|212800001160~sack.cc(101458):Column 8 : table_name:pets
origin_name:user_id table_alias:pet
13:34:27.328|212800001160~sack.cc(101458):Column 9 : table_name:pets
origin_name:name table_alias:pet
13:34:27.328|212800001160~sack.cc(104418):no data
[
{
count: 0,
'address.count': null,
'address.addresses.id': null,
'address.addresses.name': null,
'address.users.id': null,
'address.users.address_id': null,
'address.users.name': null,
'pet.id': null,
'pet.user_id': null,
'pet.name': null
}
]
Hmm... I don't get any values that way, I wonder what happens?
I suppose parsing that might be an option; not sure I can guarantee
databases will always pragma longname....
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
