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

Parse error on "CREATE [NO] FORCE VIEW"

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Parser
    • Labels:
      None

      Description

      CREATE VIEW statements can have a FORCE or NO FORCE clause as described in the Oracle documentation.

      They should be parsed as a meaningful AST so that custom rules can work on them, for example to have a naming convention for views or to check whether FORCE is used.

      Example:

      create or replace force view v2 as select * from dual;
      create or replace no force view v2 as select * from dual;
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            pierre-yves.nicolas Pierre-Yves Nicolas
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated: