[odb-users] ODB 2.5.0-b.19 self-referential attribute mapping error

[Craig Burton]

Hi,

In updating from 2.4 to 2.5, I'm hitting an issue for a class that
represents nodes in a graph, resulting in this error:

Node.h:14:28: error: unable to map C++ type '::boost::shared_ptr< ::Node >'
used in data member '_above' to a MySQL database type
Node.h:14:28: info: use '#pragma db type' to specify the database type

This worked in 2.4; I'm wondering if I've not properly set up my 2.5
environment.  This is the class definition:

#include <odb/core.hxx>
#include <boost/shared_ptr.hpp>
#include <boost/weak_ptr.hpp>

#pragma db object table ("Node")
class Node
{
protected:
   friend class odb::access;
   #pragma db id auto
   unsigned long id_;

private:
   boost::shared_ptr<Node> _above;

   #pragma db value_not_null inverse(_above)
   std::vector<boost::weak_ptr<Node> > _below;
};

This is the command used to invoke the odb compiler:
/usr/local/odb-2.5.0/bin/odb \
--database mysql \
--std c++11 \
--generate-schema \
--generate-query \
--profile boost/date-time \
--generate-session \
--at-once \
--input-name Depot \
-I/home/cburton/Development/odb-2.5-runtime/odb/include \
-I/usr/local/boost_1_62_0 Node.h

odb compiler output with -v listed below.

Thank you in advance!
Craig

Profile search paths:
 /home/cburton/Development/odb-2.5-runtime/odb/include
 /usr/local/boost_1_62_0
 /usr/include/c++/5
 /usr/include/x86_64-linux-gnu/c++/5
 /usr/include/c++/5/backward
 /usr/lib/gcc/x86_64-linux-gnu/5/include
 /usr/local/include
 /usr/lib/gcc/x86_64-linux-gnu/5/include-fixed
 /usr/include/x86_64-linux-gnu
 /usr/include
Compiling Node.h
g++ -x c++ -std=c++0x -S -Wunknown-pragmas -Wno-deprecated
-fplugin=/usr/local/odb-2.5.0/bin/odb.so -v
-I/home/cburton/Development/odb-2.5-runtime/odb/include
-I/usr/local/boost_1_62_0
-fplugin-arg-odb-svc-path=/home/cburton/Development/odb-2.5-runtime/odb/include
-fplugin-arg-odb-svc-path=/usr/local/boost_1_62_0
-fplugin-arg-odb-svc-path=/usr/include/c++/5
-fplugin-arg-odb-svc-path=/usr/include/x86_64-linux-gnu/c++/5
-fplugin-arg-odb-svc-path=/usr/include/c++/5/backward
-fplugin-arg-odb-svc-path=/usr/lib/gcc/x86_64-linux-gnu/5/include
-fplugin-arg-odb-svc-path=/usr/local/include
-fplugin-arg-odb-svc-path=/usr/lib/gcc/x86_64-linux-gnu/5/include-fixed
-fplugin-arg-odb-svc-path=/usr/include/x86_64-linux-gnu
-fplugin-arg-odb-svc-path=/usr/include -DODB_COMPILER
-DODB_COMPILER_VERSION=2049969 -DODB_DATABASE_MYSQL
-fplugin-arg-odb-database=mysql -fplugin-arg-odb-std=c++11
-fplugin-arg-odb-generate-schema -fplugin-arg-odb-generate-query
-fplugin-arg-odb-profile=boost/date-time -fplugin-arg-odb-generate-session
-fplugin-arg-odb-at-once -fplugin-arg-odb-input-name=Depot
-fplugin-arg-odb-svc-file=Node.h -
Using built-in specs.
COLLECT_GCC=g++
Target: x86_64-linux-gnu
Configured with: ../src/configure -v --with-pkgversion='Ubuntu
5.4.0-6ubuntu1~16.04.12'
--with-bugurl=file:///usr/share/doc/gcc-5/README.Bugs
--enable-languages=c,ada,c++,java,go,d,fortran,objc,obj-c++ --prefix=/usr
--program-suffix=-5 --enable-shared --enable-linker-build-id
--libexecdir=/usr/lib --without-included-gettext --enable-threads=posix
--libdir=/usr/lib --enable-nls --with-sysroot=/ --enable-clocale=gnu
--enable-libstdcxx-debug --enable-libstdcxx-time=yes
--with-default-libstdcxx-abi=new --enable-gnu-unique-object
--disable-vtable-verify --enable-libmpx --enable-plugin --with-system-zlib
--disable-browser-plugin --enable-java-awt=gtk --enable-gtk-cairo
--with-java-home=/usr/lib/jvm/java-1.5.0-gcj-5-amd64/jre --enable-java-home
--with-jvm-root-dir=/usr/lib/jvm/java-1.5.0-gcj-5-amd64
--with-jvm-jar-dir=/usr/lib/jvm-exports/java-1.5.0-gcj-5-amd64
--with-arch-directory=amd64 --with-ecj-jar=/usr/share/java/eclipse-ecj.jar
--enable-objc-gc --enable-multiarch --disable-werror --with-arch-32=i686
--with-abi=m64 --with-multilib-list=m32,m64,mx32 --enable-multilib
--with-tune=generic --enable-checking=release --build=x86_64-linux-gnu
--host=x86_64-linux-gnu --target=x86_64-linux-gnu
Thread model: posix
gcc version 5.4.0 20160609 (Ubuntu 5.4.0-6ubuntu1~16.04.12)
COLLECT_GCC_OPTIONS='-std=c++11' '-S' '-Wunknown-pragmas' '-Wno-deprecated'
'-fplugin=/usr/local/odb-2.5.0/bin/odb.so' '-v' '-I'
'/home/cburton/Development/odb-2.5-runtime/odb/include' '-I'
'/usr/local/boost_1_62_0'
'-fplugin-arg-odb-svc-path=/home/cburton/Development/odb-2.5-runtime/odb/include'
'-fplugin-arg-odb-svc-path=/usr/local/boost_1_62_0'
'-fplugin-arg-odb-svc-path=/usr/include/c++/5'
'-fplugin-arg-odb-svc-path=/usr/include/x86_64-linux-gnu/c++/5'
'-fplugin-arg-odb-svc-path=/usr/include/c++/5/backward'
'-fplugin-arg-odb-svc-path=/usr/lib/gcc/x86_64-linux-gnu/5/include'
'-fplugin-arg-odb-svc-path=/usr/local/include'
'-fplugin-arg-odb-svc-path=/usr/lib/gcc/x86_64-linux-gnu/5/include-fixed'
'-fplugin-arg-odb-svc-path=/usr/include/x86_64-linux-gnu'
'-fplugin-arg-odb-svc-path=/usr/include' '-D' 'ODB_COMPILER' '-D'
'ODB_COMPILER_VERSION=2049969' '-D' 'ODB_DATABASE_MYSQL'
'-fplugin-arg-odb-database=mysql' '-fplugin-arg-odb-std=c++11'
'-fplugin-arg-odb-generate-schema' '-fplugin-arg-odb-generate-query'
'-fplugin-arg-odb-profile=boost/date-time'
'-fplugin-arg-odb-generate-session' '-fplugin-arg-odb-at-once'
'-fplugin-arg-odb-input-name=Depot' '-fplugin-arg-odb-svc-file=Node.h'
'-shared-libgcc' '-mtune=generic' '-march=x86-64'
 /usr/lib/gcc/x86_64-linux-gnu/5/cc1plus -quiet -v -I
/home/cburton/Development/odb-2.5-runtime/odb/include -I
/usr/local/boost_1_62_0 -imultiarch x86_64-linux-gnu
-iplugindir=/usr/lib/gcc/x86_64-linux-gnu/5/plugin -D_GNU_SOURCE -D
ODB_COMPILER -D ODB_COMPILER_VERSION=2049969 -D ODB_DATABASE_MYSQL -
-iplugindir=/usr/lib/gcc/x86_64-linux-gnu/5/plugin -quiet -dumpbase -
-mtune=generic -march=x86-64 -auxbase - -Wunknown-pragmas -Wno-deprecated
-std=c++11 -version -fplugin=/usr/local/odb-2.5.0/bin/odb.so
-fplugin-arg-odb-svc-path=/home/cburton/Development/odb-2.5-runtime/odb/include
-fplugin-arg-odb-svc-path=/usr/local/boost_1_62_0
-fplugin-arg-odb-svc-path=/usr/include/c++/5
-fplugin-arg-odb-svc-path=/usr/include/x86_64-linux-gnu/c++/5
-fplugin-arg-odb-svc-path=/usr/include/c++/5/backward
-fplugin-arg-odb-svc-path=/usr/lib/gcc/x86_64-linux-gnu/5/include
-fplugin-arg-odb-svc-path=/usr/local/include
-fplugin-arg-odb-svc-path=/usr/lib/gcc/x86_64-linux-gnu/5/include-fixed
-fplugin-arg-odb-svc-path=/usr/include/x86_64-linux-gnu
-fplugin-arg-odb-svc-path=/usr/include -fplugin-arg-odb-database=mysql
-fplugin-arg-odb-std=c++11 -fplugin-arg-odb-generate-schema
-fplugin-arg-odb-generate-query -fplugin-arg-odb-profile=boost/date-time
-fplugin-arg-odb-generate-session -fplugin-arg-odb-at-once
-fplugin-arg-odb-input-name=Depot -fplugin-arg-odb-svc-file=Node.h -o -.s
-fstack-protector-strong -Wformat -Wformat-security
GNU C++11 (Ubuntu 5.4.0-6ubuntu1~16.04.12) version 5.4.0 20160609
(x86_64-linux-gnu)
compiled by GNU C version 5.4.0 20160609, GMP version 6.1.0, MPFR version
3.1.4, MPC version 1.0.3
GGC heuristics: --param ggc-min-expand=100 --param ggc-min-heapsize=131072
Versions of loaded plugins:
 odb: 2.5.0-b.19
ignoring duplicate directory "/usr/include/x86_64-linux-gnu/c++/5"
ignoring nonexistent directory "/usr/local/include/x86_64-linux-gnu"
ignoring nonexistent directory
"/usr/lib/gcc/x86_64-linux-gnu/5/../../../../x86_64-linux-gnu/include"
#include "..." search starts here:
#include <...> search starts here:
 /home/cburton/Development/odb-2.5-runtime/odb/include
 /usr/local/boost_1_62_0
 /usr/include/c++/5
 /usr/include/x86_64-linux-gnu/c++/5
 /usr/include/c++/5/backward
 /usr/lib/gcc/x86_64-linux-gnu/5/include
 /usr/local/include
 /usr/lib/gcc/x86_64-linux-gnu/5/include-fixed
 /usr/include/x86_64-linux-gnu
 /usr/include
End of search list.
GNU C++11 (Ubuntu 5.4.0-6ubuntu1~16.04.12) version 5.4.0 20160609
(x86_64-linux-gnu)
compiled by GNU C version 5.4.0 20160609, GMP version 6.1.0, MPFR version
3.1.4, MPC version 1.0.3
GGC heuristics: --param ggc-min-expand=100 --param ggc-min-heapsize=131072
Versions of loaded plugins:
 odb: 2.5.0-b.19
Compiler executable checksum: 85af4995304287cdd19cfa43cf5d6cf1
Node.h:14:28: error: unable to map C++ type '::boost::shared_ptr< ::Node >'
used in data member '_above' to a MySQL database type
Node.h:14:28: info: use '#pragma db type' to specify the database type