tpch-kit icon indicating copy to clipboard operation
tpch-kit copied to clipboard

Fix PostgreSQL qgen

Open LinuzJ opened this issue 1 year ago • 0 comments

qgen is not working for PostgreSQL due to the following reasons. The output has:

  • negative limits.
  • the limit clause outside the select statement.

The following is an example of an output (with some comments):

group by
	cntrycode
order by
	cntrycode; <- closes statement before limit
limit -1;  <- negative limit

This makes using the tool quite difficult since manual intervention is needed. There is a PR open to fix this issue: https://github.com/gregrahn/tpch-kit/pull/4

LinuzJ avatar Jun 28 '24 16:06 LinuzJ