Skip to content

Some SQL extra spaces combinations fail #10

@nmaguiar

Description

@nmaguiar

Describe the bug
When adding SQL, extra space combinations might produce syntax errors.

To Reproduce
Steps to reproduce the behavior:

  1. Setup your favorite LLM model with OAFP_MODEL
  2. Execute oafp data=“list of jupiter moons” in=llm getlist=true out=json > data.json”
  3. Execute oafp data.json out=ctable sql="select * order by diameter_km desc " (adapt, if necessary, to the results of the LLM as long as you get an extra space on the end of a order desc”
  4. See error

Expected behavior
It shouldn’t produce any errors.

Screenshots
n/a

Additional context
n/a

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

Status

Backlog

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions