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

LogMiner parser incorrectly parses UNISTR function

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 1.5.0.Final
    • 1.5.0.CR1
    • oracle-connector
    • None

    Description

      DML statement couldn't be parsed. Please open a Jira issue with the statement
      'update "USER"."T2" set "PLAY_DATE" = TO_DATE('2021-04-05 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
      where "ID_ORDERCHILD_TICKET" = '404D5F16D976465FAECBD4570A563090' and "ID_ORDER" = '11111111' and "ID_SELL_PRICE" = '1111111'
      and "PLAY_DATE" = TO_DATE('2021-03-31 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and "TM_SHOW" IS NULL and "ORDERCHILD_TICKET_NUM" = '1' and "AMOUNT_ORDERCHILD" = '0'
      and "IS_DEL" = '0' and "ADD_USER" IS NULL and "TM_ADD" = TO_DATE('2021-03-31 11:15:31', 'YYYY-MM-DD HH24:MI:SS') and "UPDATE_USER" IS NULL and "TM_UPDATE" IS NULL
      and "IS_READ" = '0' and "LOCK_SEAT_ID" IS NULL and "CHECKIN_DATE" IS NULL and "DISCOUNT_PRICE" = '0' and "ID_PRODUCT" = '1111111' and "ID_SELL_PLAN" = '111111'
      and "IS_PACKAGE" = '10201020' and "IS_RECEIVE_ORDER" IS NULL and "IS_VERIFY" IS NULL and "PIRINT_PRICE_TYPE" = '10541010' and "PRODUCT_NAME" = UNISTR('\963F\72F8\5C0F\706B\8F6620')
      and "ROOM_NIGHT" IS NULL and "SP_NAME" = UNISTR('\963F\72F8\5C0F\706B\8F66\5BB6\5EAD\7968(\60CA\559C\FF09\FF082161\FF09') and "IS_REFUND" = '10881010' and "IS_FINGERPRINTS" = '10201020'
      and "ID_HOLIDAY_PLAN" IS NULL and "TICKET_TYPEID" IS NULL and "TICKET_REAL_TYPEID" IS NULL and "IS_TEAM_TICKET_IDCARD" = '10201020' and "ALLOCATIONID" = '111111';'.
      You can set internal.log.mining.dml.parser='legacy' as a workaround until the parse error is fixed.

      Attachments

        Issue Links

          Activity

            People

              ccranfor@redhat.com Chris Cranford
              remember1202@163.com shuang liu (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: