pbxt-1.0.11-pre2-ga first time create partition table error.

Bug #587740 reported by limohao on 2010-05-31
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
PBXT
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-frame-pointer" CXX="gcc -static-libgcc" CXXFLAGS="-O3 -pipe -m64 -fPIC -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/opt/xtradb --enable-local-infile --enable-thread-safe-client --enable-assembler --with-client-ldflags=-static --with-mysqld-ldflags=-static --with-unix-socket-path=/opt/xtradb/tmp/mysql.sock --with-plugins=partition,archive,blackhole,csv,federated,heap,ibmdb2i,innobase,myisam,myisammrg --with-big-tables --without-debug --with-tcp-port=3306 --with-readline --enable-profiling --enable-shared --enable-static --with-extra-charsets=complex --with-pic --with-fast-mutexes --with-zlib-dir=bundled --with-ssl

mysql work with mysql plugin1.0.8

pbxt compile options
./configure --with-mysql=/opt/mysql-5.1.47 --with-plugindir=/opt/xtradb/lib/mysql/plugin/

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('2010-04-01')),
     PARTITION p201004 VALUES LESS THAN (to_days('2010-05-01')),
     PARTITION p201005 VALUES LESS THAN (to_days('2010-06-01')),
     PARTITION p201006 VALUES LESS THAN (to_days('2010-07-01')),
     PARTITION p201007 VALUES LESS THAN (to_days('2010-08-01')),
     PARTITION p201008 VALUES LESS THAN (to_days('2010-09-01')),
     PARTITION p201009 VALUES LESS THAN (to_days('2010-10-01')),
     PARTITION p201010 VALUES LESS THAN (to_days('2010-11-01')),
     PARTITION p201011 VALUES LESS THAN (to_days('2010-12-01')),
     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.

Related branches

Paul McCullagh (paul-mccullagh) wrote :

Thanks for the big report!

Confirmed as described.

Changed in pbxt:
assignee: nobody → Paul McCullagh (paul-mccullagh)
status: New → Confirmed
limohao (limohao) wrote :

it does not work for pbxt-1.0.9 and pbxt-1.0.10

Paul McCullagh (paul-mccullagh) wrote :

This bug has been fixed in 1.0.11-3, RN326. The bug fix has been pushed to the 1.0 trunk: lp:pbxt/

Changed in pbxt:
status: Confirmed → Fix Committed
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers