Skip to content

Fix PostgreSQL qgen #5

@LinuzJ

Description

@LinuzJ

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: #4

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions