Re: [opendbx] [Pharo-users] DBXTypeNotSupoorted with Glorp

[Norbert S. <no...@li...>]

Hi Mariano

> INSERT INTO student (id, name_surname, nullable_field) VALUES (88,
> ''Mariano Squeak'', null) .
> INSERT INTO student (id, name_surname, nullable_field) VALUES (89,
> ''Mariano Squeak'', ''riptobe'' )
>
> SELECT id, nullable_field FROM student
>
> And then I get all the rows of the resultset. But still, for "riptobe" we
> have an 16rFF 255 type :(

The record including 'riptobe' shouldn't have been of type unknown (255) 
before. Only the first one (id 88) was of type 255 before applying the 
patch.

> I even recompiled/installed Sqlite3 with the option
> SQLITE_ENABLE_COLUMN_METADATA as suggested here:
> http://source.online.free.fr/Linux_HowToCompileSQLite.html

Can you have a look if the function are really available in your sqlite3 
library?

nm -D /usr/lib/libsqlite3.so (or wherever it's located)

You should then see something like:

000095a0 T sqlite3_column_database_name
000096a0 T sqlite3_column_origin_name
00009620 T sqlite3_column_table_name
0005a1a0 T sqlite3_table_column_metadata

When running the test suite (./test/odbxtest ...), it works pretty well 
on my machine.


Norbert