Uploaded image for project: 'SonarPLSQL'
  1. SonarPLSQL
  2. SONARPLSQL-588

Support TABLE collection expressions

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.5
    • Component/s: Parser
    • Labels:
      None

      Description

      TABLE collection expressions should be supported.
      For example, UseAnsiJoinsCheck (RSPEC-1741) should raise an issue on the following code:

      SELECT t1.department_id, t2.* FROM hr_info t1, TABLE(t1.people) t2
         WHERE t2.department_id = t1.department_id;
      /
      

      See the reference and examples (on SELECT, INSERT...).

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              amelie.renard Amélie Renard
              Reporter:
              pierre-yves.nicolas Pierre-Yves Nicolas
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Due:
                Created:
                Updated:
                Resolved: