403Webshell
Server IP : 104.21.38.3  /  Your IP : 162.158.106.35
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/sys_vars/r/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /www/server/mysql/src/mysql-test/suite/sys_vars/r/updatable_views_with_limit_func.result
SET @session_updatable_views_with_limit = @@Session.UPDATABLE_VIEWS_WITH_LIMIT;
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (a INT, b INT, c INT, PRIMARY KEY(a,b));
INSERT INTO t1 VALUES (10,2,-1), (20,3,-2),
(30,4,-3), (40,5,-4);
CREATE VIEW v1 (x,y) AS SELECT a, c FROM t1;
** Connecting test_con1 using username 'root' **
** Connection test_con1 **
SET @@Session.UPDATABLE_VIEWS_WITH_LIMIT=YES;
Warning expected, 'View does not contain complete key of the table'
UPDATE v1 SET x=x+6 LIMIT 1;
Warnings:
Note	1355	View being updated does not have complete key of underlying table in it
SELECT * FROM t1;
a	b	c
16	2	-1
20	3	-2
30	4	-3
40	5	-4
UPDATE v1 SET x=x+5;
SELECT * FROM t1;
a	b	c
21	2	-1
25	3	-2
35	4	-3
45	5	-4
** Connecting test_con2 using username 'root' **
** Connection test_con2 **
SET @@Session.UPDATABLE_VIEWS_WITH_LIMIT=NO;
SELECT @@SESSION.UPDATABLE_VIEWS_WITH_LIMIT;
@@SESSION.UPDATABLE_VIEWS_WITH_LIMIT
NO
UPDATE v1 SET x=x+10 LIMIT 1;
ERROR HY000: The target table v1 of the UPDATE is not updatable
Expected error 'Non updatable table'
SELECT * FROM t1;
a	b	c
21	2	-1
25	3	-2
35	4	-3
45	5	-4
'#---------------------FN_DYNVARS_039_01----------------------#'
SET UPDATABLE_VIEWS_WITH_LIMIT=NO;
UPDATE v1 SET x=x+1 LIMIT 1;
ERROR HY000: The target table v1 of the UPDATE is not updatable
Expected error 'Non updatable table'
SET UPDATABLE_VIEWS_WITH_LIMIT=0;
UPDATE v1 SET x=x+1 LIMIT 1;
ERROR HY000: The target table v1 of the UPDATE is not updatable
Expected error 'Non updatable table'
'#---------------------FN_DYNVARS_039_02----------------------#'
Warning expected, 'View does not contain complete key of the table'
SET UPDATABLE_VIEWS_WITH_LIMIT=DEFAULT;
UPDATE v1 SET x=x+1 LIMIT 1;
Warnings:
Note	1355	View being updated does not have complete key of underlying table in it
Warning expected, 'View does not contain complete key of the table'
SET UPDATABLE_VIEWS_WITH_LIMIT=YES;
UPDATE v1 SET x=x+2 LIMIT 1;
Warnings:
Note	1355	View being updated does not have complete key of underlying table in it
** Connection default **
** Disconnecting test_con1, test_con2 **
SET @@SESSION.updatable_views_with_limit = @session_updatable_views_with_limit;
DROP VIEW IF EXISTS v1;
DROP TABLE IF EXISTS t1;

Youez - 2016 - github.com/yon3zu
LinuXploit