Null value in column "sqls" of relation "metric" violates not-null constraint

[robinportigliatti]

Hello,

Describe the bug

When adding a metric from the UI, I get the following message in the red alert box:

SQLs

ERROR: null value in column "sqls" of relation "metric" violates not-null constraint (SQLSTATE 23502) 

To Reproduce
Steps to reproduce the behavior:

1. Go to 'Metrics'
2. Click on 'New+'
3. Add a metric with only the name and sqls'
4. See error

Robin,

[pashagolub]

Can you provide a screenshot? And why sqls are empty?

[robinportigliatti]

Can't reproduce as I previously described, I need some testing on my part.

Sorry for any inconvenience.

I will come back to you.

Robin,

[0xgouda]

I am able to reproduce,

using postgres metrics configs

1. Go to 'Metrics'
2. Click on 'New+'
3. Add a new metric and in sqls field write select 1 instead of "11": select 1
   See error

this will actually result in the
ERROR: null value in column "sqls" of relation "metric" violates not-null constraint (SQLSTATE 23502)
error described

but i don't think this is a bug as sqls must have a minimum postgres version number that they can be executed against, but maybe this needs better error handling or docs update.

[robinportigliatti]

Yes that's it!

Thank you

[pashagolub]

oh, I see. We need a better UI for sqls, I believe. Otherwise people will be confused all the time