Internal server error for large joins
Details
| Detail name | Value |
|---|---|
| Changelog Number | 4905 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | EXASolution 5.0.20, EXASOL 6.0.2 |
| Fix Versions | EXASOL 6.0.3, EXASolution 5.0.21 |
| Resolution Date | 2017-08-11 |
Some queries with many joins of large tables might lead to an internal server error. For instance, the statements
CREATE SCHEMA TEST;
CREATE TABLE TEN(A VARCHAR(10));
INSERT INTO TEN VALUES 1,2,3,4,5,6,7,8,9,10;
CREATE OR REPLACE TABLE BIG AS (SELECT 'A' U, 'B' V FROM TEN,TEN,TEN,TEN,TEN,TEN,TEN,TEN);
SELECT COUNT(*)
FROM BIG BIG01 JOIN BIG BIG02 ON BIG01.U=BIG02.U||'A'
JOIN BIG BIG03 ON BIG02.U=BIG03.U||'A'
JOIN BIG BIG04 ON BIG02.U=BIG04.U||'A'
JOIN BIG BIG05 ON BIG02.U=BIG05.U||'A'
JOIN BIG BIG06 ON BIG02.U=BIG06.U||'A'
JOIN BIG BIG07 ON BIG02.U=BIG07.U||'A'
JOIN BIG BIG08 ON BIG02.U=BIG08.U||'A'
JOIN BIG BIG09 ON BIG02.U=BIG09.U||'A'
JOIN BIG BIG10 ON BIG02.U=BIG10.U||'A'
JOIN BIG BIG11 ON BIG02.U=BIG11.U||'A'
JOIN BIG BIG12 ON BIG01.U=BIG12.U||'A'
JOIN BIG BIG13 ON BIG02.U=BIG13.U||'A'
JOIN BIG BIG14 ON BIG02.U=BIG14.U||'A'
JOIN BIG BIG15 ON BIG02.U=BIG15.U||'A'
JOIN BIG BIG16 ON BIG02.U=BIG16.U||'A'
JOIN BIG BIG17 ON BIG02.U=BIG17.U||'A'
JOIN BIG BIG18 ON BIG02.U=BIG18.U||'A'
JOIN BIG BIG19 ON BIG02.U=BIG19.U||'A'
JOIN BIG BIG20 ON BIG02.U=BIG20.U||'A'
JOIN BIG BIG21 ON BIG02.U=BIG21.U||'A'
JOIN BIG BIG22 ON BIG01.U=BIG22.U||'A'
JOIN BIG BIG23 ON BIG02.U=BIG23.U||'A'
JOIN BIG BIG24 ON BIG02.U=BIG24.U||'A'
JOIN BIG BIG25 ON BIG02.U=BIG25.U||'A'
JOIN BIG BIG26 ON BIG02.U=BIG26.U||'A'
JOIN BIG BIG27 ON BIG02.U=BIG27.U||'A'
JOIN BIG BIG28 ON BIG02.U=BIG28.U||'A'
JOIN BIG BIG29 ON BIG02.U=BIG29.U||'A'
JOIN BIG BIG30 ON BIG02.U=BIG30.U||'A'
JOIN BIG BIG34 ON BIG02.U=BIG34.U||'A'
JOIN BIG BIG35 ON BIG02.U=BIG35.U||'A'
JOIN BIG BIG39 ON BIG02.U=BIG39.U||'A'
JOIN BIG BIG40 ON BIG02.U=BIG40.U||'A'
JOIN BIG BIG41 ON BIG02.U=BIG41.U||'A'
JOIN BIG BIG42 ON BIG02.U=BIG42.U||'A'
JOIN BIG BIG43 ON BIG02.U=BIG43.U||'A'
JOIN BIG BIG44 ON BIG02.U=BIG44.U||'A'
JOIN BIG BIG45 ON BIG02.U=BIG45.U||'A'
JOIN BIG BIG46 ON BIG02.U=BIG46.U||'A'
JOIN BIG BIG47 ON BIG02.U=BIG47.U||'A'
JOIN BIG BIG48 ON BIG02.U=BIG48.U||'A';
lead to a crash.