Project

General

Profile

Actions

Bug #26976

open

Rudder webapp migration create table ScoreDetails with message constraint

Added by Nicolas CHARLES 25 days ago. Updated 9 days ago.

Status:
Pending release
Priority:
1 (highest)
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)
);

Actions

Also available in: Atom PDF