Lukas Eder created DERBY-7170:
---------------------------------
Summary: Error [30000] [42Y07]: Schema 'SA' does not exist when
joining SYS.SYSTABLES to SYS.SYSSCHEMAS when aliasing the SYSCHEMAS table
Key: DERBY-7170
URL: https://issues.apache.org/jira/browse/DERBY-7170
Project: Derby
Issue Type: Bug
Components: SQL
Affects Versions: 10.17.1.0
Reporter: Lukas Eder
On a fresh database connection using username "sa", and this URL, for example:
"jdbc:derby:C:\Users\lukas\.data\derby\test", I'm trying to run this query in
Dbeaver:
{code}
SELECT
a.SCHEMANAME,
SYS.SYSTABLES.TABLENAME
FROM
SYS.SYSTABLES
JOIN SYS.SYSSCHEMAS AS a ON
SYS.SYSTABLES.SCHEMAID = a.SCHEMAID
{code}
It fails with this error:
> SQL Error [30000] [42Y07]: Schema 'SA' does not exist
Avoiding the alias is a valid workaround:
{code}
SELECT
SYS.SYSSCHEMAS.SCHEMANAME,
SYS.SYSTABLES.TABLENAME
FROM
SYS.SYSTABLES
JOIN SYS.SYSSCHEMAS ON
SYS.SYSTABLES.SCHEMAID = SYS.SYSSCHEMAS.SCHEMAID
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
