[
https://issues.apache.org/jira/browse/DERBY-7170?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lukas Eder updated DERBY-7170:
------------------------------
Description:
On a fresh database connection using org.apache.derby.jdbc.EmbeddedDriver,
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}
was:
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}
> 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
> Priority: Major
>
> On a fresh database connection using org.apache.derby.jdbc.EmbeddedDriver,
> 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)
