Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-34557

sql_mode=ORACLE: SQL%NOTFOUND

    XMLWordPrintable

Details

    • New Feature
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      Example:

      DROP TABLE IF EXISTS t1;
      		 
      CREATE TABLE t1 (a INT);
      		 
      INSERT INTO t1 VALUES (10);
      		 
      BEGIN
      		 
        UPDATE t1 SET a=10;
      		 
        IF SQL%NOTFOUND
      		 
        THEN
      		 
          DBMS_OUTPUT.PUT_LINE('NOT FOUND');
      		 
        END IF;
      		 
        IF SQL%NOTFOUND IS NULL
      		 
        THEN
      		 
          DBMS_OUTPUT.PUT_LINE('IS NULL');
      		 
        END IF;
      		 
        IF NOT SQL%NOTFOUND
      		 
        THEN
      		 
          DBMS_OUTPUT.PUT_LINE('FOUND');
      		 
        END IF;
      		 
      END;
      		 
      /


      FOUND

      Attachments

        Issue Links

          blocks

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34569 Oracle compatibility project 4

          • Major - Major loss of function.
          • Open
          relates to

          Technical task - A technical task. MDEV-10583 sql_mode=ORACLE: SQL%ROWCOUNT

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.