summaryrefslogtreecommitdiff
path: root/mysql-test/suite/compat/oracle/r/sp.result
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.org>2016-08-25 15:07:42 +0400
committerAlexander Barkov <bar@mariadb.org>2017-04-05 15:02:47 +0400
commit7e7ba7cb948910e138922d6524cc125f9aa02848 (patch)
tree932553a0086815aef6dd995aead344a360ef4d1a /mysql-test/suite/compat/oracle/r/sp.result
parent5721ea6ab7dc24a957ed06d0b4930fa3f679328b (diff)
downloadmariadb-git-7e7ba7cb948910e138922d6524cc125f9aa02848.tar.gz
Removing SHOW FUNCTION CODE from compat/oracle.sp,
as this type of SHOW is only available in debug builds. A bug in b7af3e704dd7800638ef677e9d921ad3e467a9a6. All SHOW FUNCTION CODE queries should be in compat/oracle.sp-code.
Diffstat (limited to 'mysql-test/suite/compat/oracle/r/sp.result')
-rw-r--r--mysql-test/suite/compat/oracle/r/sp.result18
1 files changed, 0 insertions, 18 deletions
diff --git a/mysql-test/suite/compat/oracle/r/sp.result b/mysql-test/suite/compat/oracle/r/sp.result
index c1f1b1c415d..17d6837f85f 100644
--- a/mysql-test/suite/compat/oracle/r/sp.result
+++ b/mysql-test/suite/compat/oracle/r/sp.result
@@ -924,24 +924,6 @@ END LOOP la;
RETURN total;
END;
/
-SHOW FUNCTION CODE f1;
-Pos Instruction
-0 set total@3 0
-1 set ia@4 1
-2 set [upper_bound]@5 a@0
-3 jump_if_not 15(15) (ia@4 <= [upper_bound]@5)
-4 set total@3 (total@3 + 1000)
-5 set ib@6 1
-6 jump_if_not 13(13) (ib@6 <= b@1)
-7 jump_if_not 10(10) (ib@6 > blim@2)
-8 set ia@4 (ia@4 + 1)
-9 jump 3
-10 set ib@6 (ib@6 + 1)
-11 set total@3 (total@3 + 1)
-12 jump 6
-13 set ia@4 (ia@4 + 1)
-14 jump 3
-15 freturn 3 total@3
SELECT f1(3,3,0), f1(3,3,1), f1(3,3,2), f1(3,3,3), f1(3,3,4) FROM DUAL;
f1(3,3,0) f1(3,3,1) f1(3,3,2) f1(3,3,3) f1(3,3,4)
3000 3003 3006 3009 3009