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

Incorrect NameInSource assignment

    XMLWordPrintable

Details

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

    Description

      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".

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: