Joins with USING might lead to crash

Detail name	Value
Changelog Number	6466
Type	Bug
Status	Open
Affected Versions	EXASolution 5.0.20, EXASOL 6.0.10, Exasol 6.1.beta1, Exasol 7.0.0, Exasol 7.1.0, Exasol 8.0.0, Exasol 8.29.0, Exasol 2025.1.0, Exasol 2025.2.0

Problem

Queries that contain joins with USING might lead to an internal server error.

Example
For instance, the following query crashes:

SELECT
        *
    FROM
            (SELECT 1 AS A1, 1 AS A2) T1
        JOIN
            (SELECT 1 AS A1, 1 AS A2) T2
USING
        (A1, A2)
    JOIN
        (SELECT 1 AS A2) T3
USING
        (A2)
    JOIN
        (SELECT 1 AS A2) T4 
USING
    (A2);

The exact conditions to trigger the problem are still unclear.

Workaround

As a workaround, the queries should be rewritten without USING.

Example
The example from above might be written as follows:

SELECT
    T1.A2,
    T1.A1
FROM
        (SELECT 1 AS A1, 1 AS A2) T1
    JOIN
        (SELECT 1 AS A1, 1 AS A2) T2
    ON
        T1.A1 = T2.A1 AND
        T1.A2 = T2.A2
    JOIN
        (SELECT 1 AS A2) T3
    ON
        T1.A2 = T3.A2
    JOIN
        (SELECT 1 AS A2) T4
    ON
        T1.A2 = T4.A2;