SQL Error when executing "create table if not exists"

[sedot42]

• MonetDBLite-Python version: 0.6.3
• Python version: 3.7.3
• Pip version: 19.0.3
• Operating System: Arch Linux

Description

I'm trying to execute the following statement:
monetdblite.sql('CREATE TABLE IF NOT EXISTS points (X FLOAT, Y FLOAT, Z FLOAT);')
MonetDBLite yields an error "SQL Query Failed: ParseException:SQLparser:42000!"

I believe this is a bug that was fixed in the Mar2018 release: https://www.monetdb.org/bugzilla/show_bug.cgi?id=6629

[kutsurak]

Hi,

Thanks for the report. This is indeed a regression, but it will take some time to fix: probably the week after the next.

[ant1j]

Is there a way to know to which version of MonetDB the MonetDBlite is linked to?

[kutsurak]

Hi,

The current release of MonetDBLite-Python (v0.6.3) is based on the August 2018 release of MonetDB. The C library is based on MonetDB code, but has a number of changes, and it needs to be merged by hand every time there is a new MonetDB release. This unfortunately is unsustainable for us.

@PedroTadim has been working the past few months in order to streamline and standardize this process. The idea is that we should have only one codebase that produces all the needed binaries, including the MonetDBLite libraries (see https://github.com/MonetDB/MonetDB/tree/branches/cmake-monetdblite). This is a lot of work, but hopefully will pay off with faster releases and closer integration with MonetDB proper.

Best regards,
Panos.