Server IP : 104.21.38.3 / Your IP : 162.158.108.125 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/max_parts/inc/ |
Upload File : |
# Need more as 16k open files per process (ulimit -n) on Unix systems. --source include/have_partition_open_file_limit.inc ##### max rows to be inserted let $maxrows=65535; error ER_PARSE_ERROR; eval create table t2 (a int not null, primary key(a)) engine=$engine partition by key (a) partitions ; error ER_PARSE_ERROR; eval create table t2 (a int not null, primary key(a)) engine=$engine partition by key (a) partitions ten; error ER_PARSE_ERROR; eval create table t2 (a int not null, primary key(a)) engine=$engine partition by key (a) partitions 24.56; error ER_PARSE_ERROR; eval create table t2 (a int not null, primary key(a)) engine=$engine partition by key (a) partitions -1; error ER_NO_PARTS_ERROR; eval create table t2 (a int not null, primary key(a)) engine=$engine partition by key (a) partitions 0; error ER_TOO_MANY_PARTITIONS_ERROR; eval create table t2 (a int not null, primary key(a)) engine=$engine partition by key (a) partitions 8193; error ER_PARSE_ERROR; eval create table t2 (a int not null, primary key(a)) engine=$engine partition by hash (a) partitions; error ER_PARSE_ERROR; eval create table t2 (a int not null, primary key(a)) engine=$engine partition by hash (a) partitions ten; error ER_PARSE_ERROR; eval create table t2 (a int not null, primary key(a)) engine=$engine partition by hash (a) partitions 24.56; error ER_PARSE_ERROR; eval create table t2 (a int not null, primary key(a)) engine=$engine partition by hash (a) partitions -1; error ER_NO_PARTS_ERROR; eval create table t2 (a int not null, primary key(a)) engine=$engine partition by hash (a) partitions 0; error ER_TOO_MANY_PARTITIONS_ERROR; eval create table t2 (a int not null, primary key(a)) engine=$engine partition by hash (a) partitions 8193; # Create a range partitioned table with 8193 partitions. # The CREATE will be written into a temporary file ($MYSQL_TMP_DIR/part_list_elem.inc). # After inserting the content of the file it will be removed. perl; use strict; use warnings; my $fname= "$ENV{'MYSQL_TMP_DIR'}/part_list_elem.inc"; my @wrlines; push (@wrlines, "error ER_TOO_MANY_PARTITIONS_ERROR;\n"); push (@wrlines, "eval create table t2 (a int) engine=\$engine\n"); push (@wrlines, " partition by range (a) (\n"); for(my $i=0; $i<8193; $i++) { my $j= ($i+1)* 8; my $pattern= " PARTITION p$i VALUES LESS THAN ($j),\n"; my $last_pattern= " PARTITION p$i VALUES LESS THAN ($j)\n"; if ($i<8192) { push(@wrlines,$pattern); } else { push(@wrlines,$last_pattern); } } push (@wrlines, " );\n"); open(FILE, ">", $fname) or die; print FILE @wrlines; close FILE; EOF source $MYSQL_TMP_DIR/part_list_elem.inc; remove_file $MYSQL_TMP_DIR/part_list_elem.inc; # Create a range partitioned table with 8193 partitions. # The CREATE will be written into a temporary file ($MYSQL_TMP_DIR/part_list_elem.inc). # After inserting the content of the file it will be removed. perl; use strict; use warnings; my $fname= "$ENV{'MYSQL_TMP_DIR'}/part_list_elem.inc"; my @wrlines; push (@wrlines, "error ER_TOO_MANY_PARTITIONS_ERROR;\n"); push (@wrlines, "eval create table t2 (a int) engine=\$engine\n"); push (@wrlines, " partition by list (a) (\n"); for(my $i=0; $i<8193; $i++) { my $j= $i*4; if ($i<8192) { my $pattern= " PARTITION p$i VALUES IN (".$j++.",".$j++.",".$j++.",".$j++."),\n"; push(@wrlines,$pattern); } else { my $last_pattern= " PARTITION p$i VALUES IN (".$j++.",".$j++.",".$j++.",".$j++.")\n"; push(@wrlines,$last_pattern); } } push (@wrlines, " );\n"); open(FILE, ">", $fname) or die; print FILE @wrlines; close FILE; EOF error ER_TOO_MANY_PARTITIONS_ERROR; source $MYSQL_TMP_DIR/part_list_elem.inc; remove_file $MYSQL_TMP_DIR/part_list_elem.inc;