Error in compiling with WITH_VP_STORAGE_ENGINE:BOOL=ON

[Ashish Disawal]

$ tar -zxvf mysql-5.5.8-spider-2.24-vp-0.13-hs-1.0.tgz
$ cd mysql-5.5.8-spider-2.24-vp-0.13-hs-1.0
#### List configure options
$ cmake -DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql-5.5.8 -DWITH_BLACKHOLE_STORAGE_ENGINE:BOOL=ON -DWITH_FEDERATED_STORAGE_ENGINE:BOOL=ON -DWITH_SPIDER_STORAGE_ENGINE:BOOL=ON -DWITH_VP_STORAGE_ENGINE:BOOL=ON -L

##### CMake
$ cmake -DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql-5.5.8 -DWITH_BLACKHOLE_STORAGE_ENGINE:BOOL=ON -DWITH_FEDERATED_STORAGE_ENGINE:BOOL=ON -DWITH_SPIDER_STORAGE_ENGINE:BOOL=ON -DWITH_VP_STORAGE_ENGINE:BOOL=ON .

$ make
Linking CXX static library libsql.a
[ 99%] Built target sql
Scanning dependencies of target mysqld
[100%] Building CXX object sql/CMakeFiles/mysqld.dir/main.cc.o
Linking CXX executable mysqld
../storage/spider/libspider.a(spd_param.cc.o):(.data+0xd60): multiple definition of `mysql_sysvar_bgs_mode'
../storage/vp/libvp.a(vp_param.cc.o):(.data+0x180): first defined here
../storage/spider/libspider.a(spd_param.cc.o):(.data+0x1660): multiple definition of `mysql_sysvar_udf_ct_bulk_insert_interval'
../storage/vp/libvp.a(vp_param.cc.o):(.data+0x2a0): first defined here
../storage/spider/libspider.a(spd_param.cc.o):(.data+0x16a0): multiple definition of `mysql_sysvar_udf_ct_bulk_insert_rows'
../storage/vp/libvp.a(vp_param.cc.o):(.data+0x2e0): first defined here
collect2: ld returned 1 exit status
make[2]: *** [sql/mysqld] Error 1
make[1]: *** [sql/CMakeFiles/mysqld.dir/all] Error 2
make: *** [all] Error 2

##### After I did
$ cmake -DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql-5.5.8 -DWITH_BLACKHOLE_STORAGE_ENGINE:BOOL=ON -DWITH_FEDERATED_STORAGE_ENGINE:BOOL=ON -DWITH_SPIDER_STORAGE_ENGINE:BOOL=ON -DWITH_VP_STORAGE_ENGINE:BOOL=OFF .

$ make clean

$ make

##### I got a lot of warnings and when I started mysql got the following warning:

110510 13:22:50 [Warning] Couldn't load plugin named 'spider' with soname 'ha_spider.so'.

[Kentoku SHIBA (kentokushiba)]

Please try to compile mysql-5.5.14-spider-2.27-vp-0.16-hs-1.0-q4m-0.95.
In the other hand,
you should better to use "-DWITH_SPIDER_STORAGE_ENGINE:BOOL=OFF -DWITH_VP_STORAGE_ENGINE:BOOL=OFF" for using UDFs.