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

MySQL identifier with dot or space could not be parsed

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Done
    • Icon: Major Major
    • 0.9.0.Alpha2
    • 0.8.0.Final
    • core-library
    • None

      MySql table name with spaces or dot(.) , like "DP_TEST.ABC TEST" or "DP_TEST.A.B.C.D",

      String table1 = "DP_TEST.ABC TEST";
      String table2 = "DP_TEST.A.B.C.D";

      List<String> parts1 = TableIdParser.parse(table1);
      expected result:
      parts1.size() = 2
      parts1.get(0) = DP_TEST
      parts1.get(1) = ABC TEST

      List<String> parts2 = TableIdParser.parse(table2);
      expected result:
      parts2.size() = 2
      parts2.get(0) = DP_TEST
      parts2.get(1) = A.B.C.D

      I know I'd avoid using dot or space in any identifier,but is it possible to support it?

              gunnar.morling Gunnar Morling
              gejunling ge junling (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: