Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-4522

Adding constraint DEFAULT getdate() on column having datetime datatype and NOT NULL failing the connector

    XMLWordPrintable

Details

    • Bug
    • Resolution: Obsolete
    • Blocker
    • None
    • 1.8.0.Alpha2
    • sqlserver-connector
    • None

    Description

      I am facing issue while creating the connector for SQL Server table in Debezium for SQL Server Version -1.8.0.Alpha2,
       I found that the Exception raises because of below DDL's

      ALTER TABLE [dbo].[trWOhead] ADD  CONSTRAINT [DF_trWOhead_updatedate]  DEFAULT (getdate()) FOR [updatedate]
      GO
      ALTER TABLE [dbo].[trWOhead] ADD  CONSTRAINT [DF_trWOhead_createdate]  DEFAULT (getdate()) FOR [createdate]
      GO

      Dropping above constraints or excluding these columns from column.include.list.
      connector works fine in both cases. 

      Table SQL and Exception logs are attached here for ready reference.

      Please help me on this.

      Attachments

        1. Exception.txt
          6 kB
        2. WOHead.sql
          10 kB

        Activity

          People

            Unassigned Unassigned
            rohit_728 Rohit Srivastav (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: