AnonSec Shell
Server IP : 185.86.78.101  /  Your IP : 216.73.216.124
Web Server : Apache
System : Linux 675867-vds-valikoshka1996.gmhost.pp.ua 5.4.0-150-generic #167-Ubuntu SMP Mon May 15 17:35:05 UTC 2023 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 : OFF
Directory :  /www/server/mysql/mysql-test/t/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME ]     

Current File : /www/server/mysql/mysql-test/t/wl4435_generated.inc
###########################################################################

--echo
--echo TINYINT
--echo

CREATE PROCEDURE p1(OUT v TINYINT)
  SET v = 127;

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = 127;

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo SMALLINT
--echo

CREATE PROCEDURE p1(OUT v SMALLINT)
  SET v = 32767;

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = 32767;

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo MEDIUMINT
--echo

CREATE PROCEDURE p1(OUT v MEDIUMINT)
  SET v = 8388607;

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = 8388607;

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo INT
--echo

CREATE PROCEDURE p1(OUT v INT)
  SET v = 2147483647;

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = 2147483647;

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo BIGINT
--echo

CREATE PROCEDURE p1(OUT v BIGINT)
  SET v = 9223372036854775807;

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = 9223372036854775807;

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo BIT(11)
--echo

CREATE PROCEDURE p1(OUT v BIT(11))
  SET v = b'10100100101';

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = b'10100100101';

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo TIMESTAMP
--echo

CREATE PROCEDURE p1(OUT v TIMESTAMP)
  SET v = '2007-11-18 15:01:02';

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = '2007-11-18 15:01:02';

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo DATETIME
--echo

CREATE PROCEDURE p1(OUT v DATETIME)
  SET v = '1234-11-12 12:34:59';

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = '1234-11-12 12:34:59';

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo TIME
--echo

CREATE PROCEDURE p1(OUT v TIME)
  SET v = '123:45:01';

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = '123:45:01';

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo DATE
--echo

CREATE PROCEDURE p1(OUT v DATE)
  SET v = '1234-11-12';

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = '1234-11-12';

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo YEAR
--echo

CREATE PROCEDURE p1(OUT v YEAR)
  SET v = 2010;

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = 2010;

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo FLOAT(7, 4)
--echo

CREATE PROCEDURE p1(OUT v FLOAT(7, 4))
  SET v = 123.4567;

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a - 123.4567 < 0.00001;

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo DOUBLE(8, 5)
--echo

CREATE PROCEDURE p1(OUT v DOUBLE(8, 5))
  SET v = 123.45678;

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a - 123.45678 < 0.000001;

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo DECIMAL(9, 6)
--echo

CREATE PROCEDURE p1(OUT v DECIMAL(9, 6))
  SET v = 123.456789;

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = 123.456789;

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo CHAR(32)
--echo

CREATE PROCEDURE p1(OUT v CHAR(32))
  SET v = REPEAT('a', 16);

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = REPEAT('a', 16);

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo VARCHAR(32)
--echo

CREATE PROCEDURE p1(OUT v VARCHAR(32))
  SET v = REPEAT('b', 16);

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = REPEAT('b', 16);

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo TINYTEXT
--echo

CREATE PROCEDURE p1(OUT v TINYTEXT)
  SET v = REPEAT('c', 16);

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = REPEAT('c', 16);

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo TEXT
--echo

CREATE PROCEDURE p1(OUT v TEXT)
  SET v = REPEAT('d', 16);

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = REPEAT('d', 16);

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo MEDIUMTEXT
--echo

CREATE PROCEDURE p1(OUT v MEDIUMTEXT)
  SET v = REPEAT('e', 16);

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = REPEAT('e', 16);

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo LONGTEXT
--echo

CREATE PROCEDURE p1(OUT v LONGTEXT)
  SET v = REPEAT('f', 16);

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = REPEAT('f', 16);

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo BINARY(32)
--echo

CREATE PROCEDURE p1(OUT v BINARY(32))
  SET v = REPEAT('g', 32);

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = REPEAT('g', 32);

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo VARBINARY(32)
--echo

CREATE PROCEDURE p1(OUT v VARBINARY(32))
  SET v = REPEAT('h', 16);

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = REPEAT('h', 16);

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo TINYBLOB
--echo

CREATE PROCEDURE p1(OUT v TINYBLOB)
  SET v = REPEAT('i', 16);

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = REPEAT('i', 16);

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo BLOB
--echo

CREATE PROCEDURE p1(OUT v BLOB)
  SET v = REPEAT('j', 16);

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = REPEAT('j', 16);

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo MEDIUMBLOB
--echo

CREATE PROCEDURE p1(OUT v MEDIUMBLOB)
  SET v = REPEAT('k', 16);

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = REPEAT('k', 16);

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo LONGBLOB
--echo

CREATE PROCEDURE p1(OUT v LONGBLOB)
  SET v = REPEAT('l', 16);

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = REPEAT('l', 16);

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo SET('aaa', 'bbb')
--echo

CREATE PROCEDURE p1(OUT v SET('aaa', 'bbb'))
  SET v = 'aaa';

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = 'aaa';

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

###########################################################################

--echo
--echo ENUM('aaa', 'bbb')
--echo

CREATE PROCEDURE p1(OUT v ENUM('aaa', 'bbb'))
  SET v = 'aaa';

PREPARE stmt1 FROM 'CALL p1(?)';
EXECUTE stmt1 USING @a;

CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;

SHOW CREATE TABLE tmp1;

SELECT @a, @a = 'aaa';

DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;

Anon7 - 2022
AnonSec Team