Re: [sqlite] Cannot select specific columns from temp.sqlite_master unless temp.sqlite_master is aliased

2020-03-13 Thread Keith Medcalf 

On Friday, 13 March, 2020 20:14, Justin Ng  wrote:

>I just encountered something weird with "temp" and "sqlite_master".
>I was wondering if it was another bug, or intentional.

The sqlite_master table in "temp" is called "sqlite_temp_master"  
(temp.sqlite_temp_master) even though it responds to the spelling 
temp.sqlite_master as well.  In either case the alias name is 
"sqlite_temp_master", not "sqlite_master".  You can specify your own alias name 
which will be respected.

Three level qualifiers are not recognized.  That is, you cannot use 
.. to identify a column -- it won't work.

I cannot answer why this is as it is, merely that this is indeed how it is.

-- 
The fact that there's a Highway to Hell but only a Stairway to Heaven says a 
lot about anticipated traffic volume.



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

Re: [sqlite] Cannot select specific columns from temp.sqlite_master unless temp.sqlite_master is aliased

2020-03-13 Thread Petite Abeille 


> On Mar 14, 2020, at 03:14, Justin Ng  wrote:
> 
> This works fine,
> 
> SELECT
>x.sql
> FROM
>temp.sqlite_master AS x;
> 

As is this:

SELECT
   sql
FROM
   temp.sqlite_master;

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