search

MonetDB / MonetDBLite-Python

MonetDBLite as a Python Package
Other
32 stars 7 forks source link

SQL Error when executing "create table if not exists" #39

Open sedot42 opened 5 years ago

sedot42 commented 5 years ago

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 commented 5 years ago

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 commented 5 years ago

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

kutsurak commented 5 years ago

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.