403Webshell
Server IP : 172.67.216.182  /  Your IP : 162.158.163.229
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/gcol/r/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /www/server/mysql/src/mysql-test/suite/gcol/r/gcol_blocked_sql_funcs_myisam.result
SET @@session.default_storage_engine = 'MyISAM';
# RAND()
create table t1 (b double generated always as (rand()) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
# LOAD_FILE()
create table t1 (a varchar(64), b varchar(1024) generated always as (load_file(a)) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
# CURDATE()
create table t1 (a datetime generated always as (curdate()) virtual);
ERROR HY000: Expression of generated column 'a' contains a disallowed function.
# CURRENT_DATE(), CURRENT_DATE
create table t1 (a datetime generated always as (current_date) virtual);
ERROR HY000: Expression of generated column 'a' contains a disallowed function.
create table t1 (a datetime generated always as (current_date()) virtual);
ERROR HY000: Expression of generated column 'a' contains a disallowed function.
# CURRENT_TIME(), CURRENT_TIME
create table t1 (a datetime generated always as (current_time) virtual);
ERROR HY000: Expression of generated column 'a' contains a disallowed function.
create table t1 (a datetime generated always as (current_time()) virtual);
ERROR HY000: Expression of generated column 'a' contains a disallowed function.
# CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP
create table t1 (a datetime generated always as (current_timestamp()) virtual);
ERROR HY000: Expression of generated column 'a' contains a disallowed function.
create table t1 (a datetime generated always as (current_timestamp) virtual);
ERROR HY000: Expression of generated column 'a' contains a disallowed function.
# CURTIME()
create table t1 (a datetime generated always as (curtime()) virtual);
ERROR HY000: Expression of generated column 'a' contains a disallowed function.
# LOCALTIME(), LOCALTIME
create table t1 (a datetime, b varchar(10) generated always as (localtime()) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
create table t1 (a datetime, b varchar(10) generated always as (localtime) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
# LOCALTIMESTAMP, LOCALTIMESTAMP()(v4.0.6)
create table t1 (a datetime, b varchar(10) generated always as (localtimestamp()) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
create table t1 (a datetime, b varchar(10) generated always as (localtimestamp) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
# NOW()
create table t1 (a datetime, b varchar(10) generated always as (now()) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
# SYSDATE()
create table t1 (a int, b varchar(10) generated always as (sysdate()) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
# UNIX_TIMESTAMP()
create table t1 (a datetime, b datetime generated always as (unix_timestamp()) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
# UTC_DATE()
create table t1 (a datetime, b datetime generated always as (utc_date()) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
# UTC_TIME()
create table t1 (a datetime, b datetime generated always as (utc_time()) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
# UTC_TIMESTAMP()
create table t1 (a datetime, b datetime generated always as (utc_timestamp()) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
# MATCH()
create table t1 (a varchar(32), b bool generated always as (match a against ('sample text')) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
# BENCHMARK()
create table t1 (a varchar(1024), b varchar(1024) generated always as (benchmark(a,3)) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
# CONNECTION_ID()
create table t1 (a int generated always as (connection_id()) virtual);
ERROR HY000: Expression of generated column 'a' contains a disallowed function.
# CURRENT_USER(), CURRENT_USER
create table t1 (a varchar(32) generated always as (current_user()) virtual);
ERROR HY000: Expression of generated column 'a' contains a disallowed function.
create table t1 (a varchar(32) generated always as (current_user) virtual);
ERROR HY000: Expression of generated column 'a' contains a disallowed function.
# DATABASE()
create table t1 (a varchar(1024), b varchar(1024) generated always as (database()) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
# FOUND_ROWS()
create table t1 (a varchar(1024), b varchar(1024) generated always as (found_rows()) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
# GET_LOCK()
create table t1 (a varchar(1024), b varchar(1024) generated always as (get_lock(a,10)) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
# IS_FREE_LOCK()
create table t1 (a varchar(1024), b varchar(1024) generated always as (is_free_lock(a)) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
# IS_USED_LOCK()
create table t1 (a varchar(1024), b varchar(1024) generated always as (is_used_lock(a)) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
# LAST_INSERT_ID()
create table t1 (a int generated always as (last_insert_id()) virtual);
ERROR HY000: Expression of generated column 'a' contains a disallowed function.
# MASTER_POS_WAIT()
create table t1 (a varchar(32), b int generated always as (master_pos_wait(a,0,2)) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
# NAME_CONST()
create table t1 (a varchar(32) generated always as (name_const('test',1)) virtual);
ERROR HY000: Expression of generated column 'a' contains a disallowed function.
# RELEASE_LOCK()
create table t1 (a varchar(32), b int generated always as (release_lock(a)) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
# ROW_COUNT()
create table t1 (a int generated always as (row_count()) virtual);
ERROR HY000: Expression of generated column 'a' contains a disallowed function.
# SCHEMA()
create table t1 (a varchar(32) generated always as (schema()) virtual);
ERROR HY000: Expression of generated column 'a' contains a disallowed function.
# SESSION_USER()
create table t1 (a varchar(32) generated always as (session_user()) virtual);
ERROR HY000: Expression of generated column 'a' contains a disallowed function.
# SLEEP()
create table t1 (a int, b int generated always as (sleep(a)) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
# SYSTEM_USER()
create table t1 (a varchar(32) generated always as (system_user()) virtual);
ERROR HY000: Expression of generated column 'a' contains a disallowed function.
# USER()
create table t1 (a varchar(1024), b varchar(1024) generated always as (user()) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
# UUID_SHORT()
create table t1 (a varchar(1024) generated always as (uuid_short()) virtual);
ERROR HY000: Expression of generated column 'a' contains a disallowed function.
# UUID()
create table t1 (a varchar(1024) generated always as (uuid()) virtual);
ERROR HY000: Expression of generated column 'a' contains a disallowed function.
# VALUES()
create table t1 (a varchar(1024), b varchar(1024) generated always as (values(a)) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
# VERSION()
create table t1 (a varchar(1024), b varchar(1024) generated always as (version()) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
# ENCRYPT()
create table t1 (a varchar(1024), b varchar(1024) generated always as (encrypt(a)) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
# Stored procedures
create procedure p1()
begin
select current_user();
end //
create function f1()
returns int
begin
return 1;
end //
create table t1 (a int generated always as (p1()) virtual);
ERROR HY000: Expression of generated column 'a' contains a disallowed function.
create table t1 (a int generated always as (f1()) virtual);
ERROR HY000: Expression of generated column 'a' contains a disallowed function.
drop procedure p1;
drop function f1;
# Unknown functions
create table t1 (a int generated always as (f1()) virtual);
ERROR HY000: Expression of generated column 'a' contains a disallowed function.
#
# GROUP BY FUNCTIONS
#
# AVG()
create table t1 (a int, b int generated always as (avg(a)) virtual);
ERROR HY000: Invalid use of group function
# BIT_AND()
create table t1 (a int, b int generated always as (bit_and(a)) virtual);
ERROR HY000: Invalid use of group function
# BIT_OR()
create table t1 (a int, b int generated always as (bit_or(a)) virtual);
ERROR HY000: Invalid use of group function
# BIT_XOR()
create table t1 (a int, b int generated always as (bit_xor(a)) virtual);
ERROR HY000: Invalid use of group function
# COUNT(DISTINCT)
create table t1 (a int, b int generated always as (count(distinct a)) virtual);
ERROR HY000: Invalid use of group function
# COUNT()
create table t1 (a int, b int generated always as (count(a)) virtual);
ERROR HY000: Invalid use of group function
# GROUP_CONCAT()
create table t1 (a varchar(32), b int generated always as (group_concat(a,'')) virtual);
ERROR HY000: Invalid use of group function
# MAX()
create table t1 (a int, b int generated always as (max(a)) virtual);
ERROR HY000: Invalid use of group function
# MIN()
create table t1 (a int, b int generated always as (min(a)) virtual);
ERROR HY000: Invalid use of group function
# STD()
create table t1 (a int, b int generated always as (std(a)) virtual);
ERROR HY000: Invalid use of group function
# STDDEV_POP()
create table t1 (a int, b int generated always as (stddev_pop(a)) virtual);
ERROR HY000: Invalid use of group function
# STDDEV_SAMP()
create table t1 (a int, b int generated always as (stddev_samp(a)) virtual);
ERROR HY000: Invalid use of group function
# STDDEV()
create table t1 (a int, b int generated always as (stddev(a)) virtual);
ERROR HY000: Invalid use of group function
# SUM()
create table t1 (a int, b int generated always as (sum(a)) virtual);
ERROR HY000: Invalid use of group function
# VAR_POP()
create table t1 (a int, b int generated always as (var_pop(a)) virtual);
ERROR HY000: Invalid use of group function
# VAR_SAMP()
create table t1 (a int, b int generated always as (var_samp(a)) virtual);
ERROR HY000: Invalid use of group function
# VARIANCE()
create table t1 (a int, b int generated always as (variance(a)) virtual);
ERROR HY000: Invalid use of group function
#
# XML FUNCTIONS
#
# UpdateXML()
create table t1 (a varchar(1024), b varchar(1024) generated always as (UpdateXML(a,'/a','<e>fff</e>')) virtual);
ERROR HY000: Expression of generated column 'b' contains a disallowed function.
#
# Sub-selects
#
create table t1 (a int);
create table t2 (a int, b int generated always as (select count(*) virtual from t1));
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select count(*) virtual from t1))' at line 1
drop table t1;
#
# Long expression
create table t1 (a int, b varchar(300) generated always as (concat(a,'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa')) virtual);
drop table t1;
create table t1 (a int, b varchar(300) generated always as (concat(a,'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa')) virtual);
drop table t1;
#
# Constant expression
create table t1 (a int generated always as (PI()) virtual);
drop table t1;
# bug#21098119: GCOL WITH MATCH/AGAINST -->
# ASSERTION FAILED: TR && TR->TABLE->FILE
#
create table t1 (a int);
alter table t1 add column r blob generated always
as (match(a) against ('' in boolean mode)) virtual;
ERROR HY000: Expression of generated column 'r' contains a disallowed function.
drop table t1;
DROP VIEW  IF EXISTS v1,v2;
DROP TABLE IF EXISTS t1,t2,t3;
DROP PROCEDURE IF EXISTS p1;
DROP FUNCTION IF EXISTS f1;
DROP TRIGGER IF EXISTS trg1;
DROP TRIGGER IF EXISTS trg2;
set sql_warnings = 0;

Youez - 2016 - github.com/yon3zu
LinuXploit