⚝
One Hat Cyber Team
⚝
Your IP:
216.73.216.124
Server IP:
50.28.103.30
Server:
Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software:
nginx/1.28.0
PHP Version:
8.3.12
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
www
/
server
/
mysql
/
mysql-test
/
suite
/
parts
/
r
/
View File Name :
partition_exch_qa_8_myisam.result
CREATE USER test2@localhost; CREATE DATABASE testdb; USE testdb; USE test; GRANT CREATE, ALTER, DROP, INSERT, SELECT on test.* TO test2@localhost; GRANT CREATE, ALTER, DROP, INSERT, SELECT on testdb.* TO test2@localhost; connect (test2,localhost,test2,,test,MASTER_MYPORT,MASTER_MYSOCK); ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE testdb.t_10; SELECT * FROM testdb.t_10; a b 2 Two 4 Four 6 Six 8 Eight SELECT * FROM tp WHERE a BETWEEN 0 AND 10; a b 1 One 3 Three 5 Five 9 Nine Warning 1287 The partition engine, used by table 'test.tp', is deprecated and will be removed in a future release. Please use native partitioning instead. Warnings: ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE testdb.t_10; SELECT * FROM testdb.t_10; a b 1 One 3 Three 5 Five 9 Nine SELECT * FROM tp WHERE a BETWEEN 0 AND 10; a b 2 Two 4 Four 6 Six 8 Eight Warning 1287 The partition engine, used by table 'test.tp', is deprecated and will be removed in a future release. Please use native partitioning instead. Warnings: ALTER TABLE testdb.tp EXCHANGE PARTITION p0 WITH TABLE t_10; SELECT * FROM t_10; a b 2 Two 4 Four 6 Six 8 Eight SELECT * FROM testdb.tp WHERE a BETWEEN 0 AND 10; a b 1 One 3 Three 5 Five 9 Nine Warning 1287 The partition engine, used by table 'testdb.tp', is deprecated and will be removed in a future release. Please use native partitioning instead. Warnings: ALTER TABLE testdb.tp EXCHANGE PARTITION p0 WITH TABLE t_10; SELECT * FROM t_10; a b 1 One 3 Three 5 Five 9 Nine SELECT * FROM testdb.tp WHERE a BETWEEN 0 AND 10; a b 2 Two 4 Four 6 Six 8 Eight Warning 1287 The partition engine, used by table 'testdb.tp', is deprecated and will be removed in a future release. Please use native partitioning instead. Warnings: disconnect test2; connection default; REVOKE INSERT ON testdb.* FROM test2@localhost; connect (test2,localhost,test2,,test,MASTER_MYPORT,MASTER_MYSOCK); ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE testdb.t_10; ERROR 42000: INSERT command denied to user 'test2'@'localhost' for table 't_10' ALTER TABLE testdb.tp EXCHANGE PARTITION p0 WITH TABLE t_10; ERROR 42000: INSERT command denied to user 'test2'@'localhost' for table 'tp' disconnect test2; connection default; DROP TABLE IF EXISTS t_10; DROP TABLE IF EXISTS t_100; DROP TABLE IF EXISTS t_1000; DROP TABLE IF EXISTS tp; DROP TABLE IF EXISTS tsp; DROP TABLE IF EXISTS tsp_00; DROP TABLE IF EXISTS tsp_01; DROP TABLE IF EXISTS tsp_02; DROP TABLE IF EXISTS tsp_03; DROP TABLE IF EXISTS tsp_04; DROP TABLE IF EXISTS t_empty; DROP TABLE IF EXISTS t_null; DROP USER test2@localhost; DROP DATABASE testdb;