very very strange nested query
Posted by:
an chang
Date: July 24, 2023 02:21AM
problem:SQL 错误 [1054] [42S22]: Unknown column 'aa.c_int' in 'where clause'
version:8.0.27
SELECT
1
FROM (
SELECT
bb.c_int+1 AS c_int111
FROM (
SELECT
aa.c_int AS c_int
FROM (
SELECT 0 AS c_int
) AS aa
) AS bb
) AS cc
WHERE c_int111 > 1
Subject
Written By
Posted
very very strange nested query
July 24, 2023 02:21AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.