On 10/12/15, R.Smith <rsmith at rsweb.co.za> wrote:
>
> More explicitly - would these be valid queries:
>
> SELECT props.*
> FROM (
> SELECT 1 as id, JSON_OBJECT('i',5,'n','James') AS obj UNION ALL
> SELECT 2, JSON_OBJECT('i',6,'n','Jill') UNION ALL
> SELECT 3, JSON_OBJECT('i',7,'n','John')
> ) AS T1, JSON_EACH(T1.obj) AS props
> WHERE 1
>
Yes.
>
> and in future (without JSON):
>
> SELECT B.* FROM
> (SELECT (C1 || C2 || C3) AS CX FROM T) AS A,
> (SELECT CX FROM A) AS B
> WHERE 1
>
This is not valid, and has never been valid. I'm sorry, but I don't
understand the connection to the previous query. They are completely
different, as far as I can see.
--
D. Richard Hipp
drh at sqlite.org
