Le 29 mars 2017 à 02:38, Simon Slavin <slav...@bigfraud.org> a écrit :

>> It seems sqlite look first if there is a temp.table before main.table and 
>> without qualification temp.table is used.
> 
> You got it.  It’s not obvious that this is what SQLite would do.  But now you 
> know it you understand what is happening.

It's as documented though. Without qualifier the most recently attached 
database in the connection is used, if the table or column name matches.

temp, even though there is no explicit "attach" is that most recently attached 
compared to main. :)

-- 
Best regards, Meilleures salutations, Met vriendelijke groeten,  
Olivier Mascia (from mobile device), http://integral.software

_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to