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

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

      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.

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

                Created:
                Updated:
                Resolved: