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.