Project

General

Profile

Actions

Bug #26976

open

Rudder webapp create table ScoreDetails with an invalid constraint

Added by Nicolas CHARLES 1 day ago.

Status:
New
Priority:
To review
Assignee:
-
Category:
Web - Maintenance
Target version:
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

Also available in: Atom PDF