Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-1434

Example dynamicvdb-portfolio customer-schema.sql INSERT INTO HOLDINGS has PRODUCT_ID references that don't exist in PRODUCT table causing sql to fail

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Minor
    • 7.3
    • 7.1.1, 7.2
    • Build/Kits
    • None

    Description

      The customer-schema.sql contains insert statements into HOLDINGS that contain references to PRODUCT table that don't exist. Example:

      INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20010027,1020,

      {ts '2001-08-22 00:00:00.000'}

      ,70);

      Product_ID references to 1020 and 1022 don't exist.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            van.halbert Van Halbert (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: