Uploaded image for project: 'JS - JobScheduler'
  1. JS - JobScheduler
  2. JS-1912

The column EXPRESSION in the tables JSTREAM_IN_CONDITIONS and JSTREAM_OUT_CONDITIONS should have the length 4000

    XMLWordPrintable

Details

    • Feature
    • Status: Released (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.13.7
    • 1.13.8
    • Setup

    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.

      Attachments

        Activity

          People

            ur Uwe Risse
            ur Uwe Risse
            Aditi Dubey Aditi Dubey (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: