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

JDBC importer does not sanitize default value values

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Do
    • 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

    Description

      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

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: