Uploaded image for project: 'StreamSets Data Collector'
  1. StreamSets Data Collector
  2. SDC-9417

SQL Server Change Tracking Origin on composite primary key

    XMLWordPrintable

    Details

    • Type: Integration Test
    • Status: In Progress
    • Priority: P3 (Limited Impact)
    • Resolution: Unresolved
    • Component/s: None
    • Labels:
      None

      Description

      Test case with the following table schema,

       

      CREATE TABLE events (
        id biting identity(1,1),
        date_state datetime not null,
        description varchar(100),
        primary key(id, date_state)
      )
      

       

      We also need to test the following DB type,

      BIT
      BOOLEAN,
      CHAR,
      VARCHAR,
      NCHAR,
      NVARCHAR,
      LONGNVARCHAR,
      LONGVARCHAR,
      TIME,
      DATE,
      TIMESTAMP,
      INTEGER,
      SMALLINT,
      TINYINT,
      BIGINT,
      FLOAT,
      REAL,
      DOUBLE,
      DECIMAL,
      NUMERIC
      

       

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jisun Ji Sun Kim (Inactive)
              Reporter:
              jisun Ji Sun Kim (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: