Actions
Bug #26976
openRudder webapp create table ScoreDetails with an invalid constraint
Pull Request:
Severity:
UX impact:
User visibility:
Effort required:
Priority:
0
Name check:
To do
Fix check:
To do
Regression:
No
Description
the webapp creates the table with the following code
val sql2 = sql"""CREATE TABLE IF NOT EXISTS ScoreDetails ( nodeId text , scoreId text , score score NOT NULL , message text NOT NULL CHECK (message <> '') , details jsonb NOT NULL , PRIMARY KEY (nodeId, scoreId) );"""
the constraint on message breaks the creation of benchmark, and it should not include it. The sql for creation is
Create table scoreDetails ( nodeId text NOT NULL , scoreId text NOT NULL , score score NOT NULL , message text NOT NULL , details jsonb NOT NULL , PRIMARY KEY (nodeId, scoreId) );
No data to display
Actions