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

update status table in ON_VDB_DROP_SCRIPT should point to correct name and schemaname

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 8.11
    • None
    • Quick Starts
    • None

      This may be caused by miss spelling , in "teiid_rel:ON_VDB_DROP_SCRIPT" section, the name and schemaname should point to stockPricesMatView and StocksMatModel, but current looks
      ~~~
      <model name="StocksMatModel" type="VIRTUAL">
      <metadata type="DDL"><![CDATA[
      CREATE view stockPricesMatView
      ...
      ) OPTIONS(
      ...
      "teiid_rel:ON_VDB_DROP_SCRIPT" 'DELETE FROM Accounts.status WHERE Name=''stock'' AND schemaname = ''Stocks''',
      ~~~

              kylinsoong.1214@gmail.com Kylin Soong (Inactive)
              kylinsoong.1214@gmail.com Kylin Soong (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: