Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-2504

SQL warning "01501: The view V21VIEWTEST has been dropped" can be lost (ie. not seen when it should be)

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.2.1.6, 10.2.2.0, 10.3.1.4
    • Fix Version/s: None
    • Component/s: SQL
    • Urgency:
      Normal

      Description

      Example, grantRevokeDDL test has this SQL and correct output:

      revoke select on t11ViewTest from public;
      0 rows inserted/updated/deleted
      WARNING 01501: The view V21VIEWTEST has been dropped.

      But if instead the statement is prepared and another statement prepared before the execution then the warning will not appear

      prepare R1 as 'revoke select on t11ViewTest from public';
      ij(MAMTA1)> prepare V1 as 'values 1';
      ij(MAMTA1)> execute R1;
      0 rows inserted/updated/deleted
      ij(MAMTA1)> execute V1;
      1
      -----------
      1
      1 row selected

      If I don't prepare V1 then the exception is seen, so it's not the prepare causing the issue.

        Attachments

        1. repro.zipx
          2 kB
          Lily Wei
        2. Derby-2504.diff
          1 kB
          Lily Wei

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              djd Daniel John Debrunner
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: