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

Incorrect NameInSource assignment

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Obsolete
    • Icon: Blocker Blocker
    • None
    • 10.0.2
    • Modeling
    • None

      When performing the wizard to materialization into a JDG data source, the nameInSource assigned to the JDG source tables is incorrect. Example:

      CREATE FOREIGN TABLE Stock (
      product_id integer OPTIONS(NAMEINSOURCE '"product_id"', NATIVE_TYPE 'integer', FIXED_LENGTH 'TRUE'),
      symbol string(4000) OPTIONS(NAMEINSOURCE '"symbol"', NATIVE_TYPE 'string'),
      price string(50) OPTIONS(NAMEINSOURCE '"price"', NATIVE_TYPE 'string', FIXED_LENGTH 'TRUE'),
      company_name string(256) OPTIONS(NAMEINSOURCE '"company_name"', NATIVE_TYPE 'string'),
      CONSTRAINT PK_prodid PRIMARY KEY(product_id)
      ) OPTIONS(NAMEINSOURCE '"Stocks"."Stock"', UPDATABLE 'TRUE')

      The NAMEINSOURCE not be set or if it is, should be the same name as the table. In this case, "Stock".

              blafond Barry LaFond
              van.halbert Van Halbert (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: