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