search

django-daiquiri / daiquiri

A framework for the publication of scientific databases
https://escience.aip.de/daiquiri
Apache License 2.0
26 stars 8 forks source link

IMPROVMENT: Propagate database syntax errors to the frontend #246

Open kimakan opened 2 months ago

kimakan commented 2 months ago

Currently, the following query fails with the error message There has been an server error with your job. if col is of any other type then char.

SELECT * FROM schema_name.table_name
WHERE col='somestring'

The actual error message that is returned by the PostgreSQL database is ERROR: invalid input syntax for type integer: "somestring". Ideally, this message should be propagated to the user in the "Error summary". image