pbxt-1.0.11-pre2-ga first time create partition table error.
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
PBXT |
Fix Committed
|
Undecided
|
Paul McCullagh |
Bug Description
centos 5.5 x64
pbxt-1.0.11-pre2-ga
mysql5.1.47
mysql
compile options
CC="gcc -static-libgcc" CFLAGS="-O3 -pipe -m64 -fPIC -fomit-
mysql work with mysql plugin1.0.8
pbxt compile options
./configure --with-
install
INSTALL PLUGIN pbxt SONAME 'libpbxt.so';
after install ,exec following script to create table
use test;
CREATE TABLE part_date3
( c1 bigint(20) unsigned NOT NULL AUTO_INCREMENT,
c2 varchar(40) not null default '',
c3 datetime not NULL,
PRIMARY KEY (c1,c3),
KEY partindex(c3)) ENGINE=pbxt DEFAULT CHARSET=utf8
partition by range (to_days(c3))
(
PARTITION p201003 VALUES LESS THAN (to_days(
PARTITION p201004 VALUES LESS THAN (to_days(
PARTITION p201005 VALUES LESS THAN (to_days(
PARTITION p201006 VALUES LESS THAN (to_days(
PARTITION p201007 VALUES LESS THAN (to_days(
PARTITION p201008 VALUES LESS THAN (to_days(
PARTITION p201009 VALUES LESS THAN (to_days(
PARTITION p201010 VALUES LESS THAN (to_days(
PARTITION p201011 VALUES LESS THAN (to_days(
PARTITION p201912 VALUES LESS THAN MAXVALUE );
it's ok
but when exec
SELECT * FROM pbxt.location l;
the following error
Unknown column 'c3' in 'partition function'
exec
SELECT * FROM pbxt.statistics s;
the same error
if part_date3 is not the partition table.it work fine.
if create a normal(not partition)table first then create partition table it's work fine too.
Thanks for the big report!
Confirmed as described.