Details
-
Feature
-
Status: Released (View Workflow)
-
Minor
-
Resolution: Fixed
-
1.13.7
Description
Current Situation
The length for the column EXPRESSION in the tables JSTREAM_IN_CONDITIONS and JSTREAM_OUT_CONDITIONS is 255.
When updating JobScheduler the "alter table" script modifies the length for the table JSTREAM_IN_CONDITIONS
Oracle: to varchar(4000) only when the field SKIP_NOT_IN_PERIOD_OUT_COND does not exist.
MSSQL: NTEXT
MYSQL: LONGTEXT
PGSQL: TEXT
The columns type for the column EXPRESSION in the table JSTREAM_OUT_CONDITIONS remains unchanged.
Desired Behavior
The column type for the column EXPRESSION in the tables JSTREAM_IN_CONDITIONS and JSTREAM_OUT_CONDITIONS should be changed to
Oracle: to varchar(4000)
MSSQL: NTEXT
MYSQL: LONGTEXT
PGSQL: TEXT
When updating JobScheduler the existing columns should be changed accordingly.