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

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Done
    • Affects Version/s: 7.1.1, 7.2
    • Fix Version/s: 7.3
    • Component/s: Build/Kits
    • Labels:
      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.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                van.halbert Van Halbert
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: