Skip to content

Lot of joined sources in SELECT #188

@agershun

Description

@agershun

Some of sqllogictest tests include queries like this (they are located in the selec4.test file):

query ITTTIII rowsort join261 SELECT d6, x4, x7, x8, a1, b9, d5*934 FROM t8, t7, t1, t6, t5, t9, t4 WHERE (689=c5 OR 657=c5 OR c5=187) AND a1 in (324,241,330,352,32,829) AND d6=21 AND b4=735 AND e8 in (106,846,859,349) AND e7 in (248,356,503) AND b9 in (214,122,211,913,900,214,524,688)

Usually they return about 20000 records from huge cube space. Current version of AlaSQL does not like such huge queries. The goal is to resolve this problem.

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions