Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-3225

JDBC importer does not sanitize default value values

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major Major
    • None
    • 11.1.2
    • Import/Export
    • None
    • Hide

      1) create postgres table:
      CREATE TABLE bad_default
      (
      id character(32) NOT NULL,
      status character(1) DEFAULT '0'::bpchar
      )

      2) import using JDBC importer
      3) note imported value

      Show
      1) create postgres table: CREATE TABLE bad_default ( id character(32) NOT NULL, status character(1) DEFAULT '0'::bpchar ) 2) import using JDBC importer 3) note imported value

      The JDBC importer does not sanitize the default values imported for physical tables. This may not be obvious until attempting to deploy the VDB and metadata parsing fails. An example is a postgresql import with a column stating a default value of [1].

      [1] Example bad default value:
      '0'::bpchar

            Unassigned Unassigned
            rhn-support-mshirley Marc Shirley (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: