⚝
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
/
inc
/
View File Name :
partition_alter1_1_2.inc
################################################################################ # inc/partition_alter1_1_2.inc # # # # Purpose: # # ADD/DROP PRIMARY KEYs and/or UNIQUE INDEXes tests on partitioned tables # # This routine is only useful for the partition_<feature>_<engine> tests. # # # #------------------------------------------------------------------------------# # Original Author: mleich # # Original Date: 2006-03-05 # # Change Author: # # Change Date: # # Change: # ################################################################################ --echo --echo #======================================================================== --echo # 1. ALTER TABLE ADD PRIMARY KEY and/or UNIQUE INDEX --echo #======================================================================== # Rule: The table does not have a PRIMARY KEY or UNIQUE INDEX. # ---> $unique must be empty # ---> The PRIMARY KEY or UNIQUE INDEX to be created must contain # the columns used for partitioning. # --echo #------------------------------------------------------------------------ --echo # 1.2 ADD PRIMARY KEY or UNIQUE INDEX to table with two columns --echo # (f_int1 and f_int2) within the partitioning function --echo #------------------------------------------------------------------------ # Rule: f_int1 and f_int2 is used within the partitioning function # ---> inc/partition_alter_13.inc if ($do_pk_tests) { --echo # 1.2.1 PRIMARY KEY consisting of two columns let $alter= ALTER TABLE t1 ADD PRIMARY KEY(f_int1,f_int2); --source suite/parts/inc/partition_alter_13.inc let $alter= ALTER TABLE t1 ADD PRIMARY KEY(f_int2,f_int1); --source suite/parts/inc/partition_alter_13.inc } --echo # 1.2.2 UNIQUE INDEX consisting of two columns let $alter= ALTER TABLE t1 ADD UNIQUE INDEX uidx1 (f_int1,f_int2); --source suite/parts/inc/partition_alter_13.inc let $alter= ALTER TABLE t1 ADD UNIQUE INDEX uidx1 (f_int2,f_int1); --source suite/parts/inc/partition_alter_13.inc if ($do_pk_tests) { --echo # 1.2.3 PRIMARY KEY and UNIQUE INDEX consisting of two columns let $alter= ALTER TABLE t1 ADD UNIQUE INDEX uidx1 (f_int1,f_int2), ADD PRIMARY KEY(f_int2,f_int1); --source suite/parts/inc/partition_alter_13.inc let $alter= ALTER TABLE t1 ADD UNIQUE INDEX uidx1 (f_int2,f_int1), ADD PRIMARY KEY(f_int1,f_int2); --source suite/parts/inc/partition_alter_13.inc let $unique= ; --source suite/parts/inc/partition_alter_13.inc }