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

Bug #587740 reported by limohao
6
This bug affects 1 person
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-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

Revision history for this message
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
Revision history for this message
limohao (limohao) wrote :

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

Revision history for this message
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  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.