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

Dynamic SQL: Executing Dynamic SQL Throws an Error

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 11.2, 11.0.3, 11.1.2
    • 11.1
    • Query Engine
    • None
    • Hide

      In SQuirrel run the following queries and compare results:

      BEGIN
       declare clob sql_query = 'select 1';
       execute immediate sql_query;
END ;;

      BEGIN
       declare clob sql_query = 'select 1';
       execute immediate sql_query as cnt string;
END ;;
      Show
      In SQuirrel run the following queries and compare results: BEGIN declare clob sql_query = ' select 1' ; execute immediate sql_query; END ;; BEGIN declare clob sql_query = ' select 1' ; execute immediate sql_query as cnt string ; END ;;

    Description

      When running the following query:

      BEGIN
       declare clob sql_query = 'select 1';
       execute immediate sql_query;
END ;;

      in result set can see only:

      Unable to find source-code formatter for language: noformat. Available languages are: actionscript, ada, applescript, bash, c, c#, c++, cpp, css, erlang, go, groovy, haskell, html, java, javascript, js, json, lua, none, nyan, objc, perl, php, python, r, rainbow, ruby, scala, sh, sql, swift, visualbasic, xml, yaml
      Error: 0
SQLState:  38000
ErrorCode: 0

      but running the following query just adding the "as cnt string":

      BEGIN
       declare clob sql_query = 'select 1';
       execute immediate sql_query as cnt string;
END ;;

      can see correct "1" in result set. I don't know if it's a correct behavior, maybe it's related to how SQuirrel handles result set.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            dalex005 Dmitrii Pogorelov
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: