0.6.0

Pre-release of 0.6.0, based on MonetDB Mar2018

• Main new feature is integer64 support via the bit64 package. If you pass bigint="integer64" to dbConnect(), dbWriteTable and dbGetQuery will write/retrieve integer64 columns. See #2 for an example. Supports Zero-Copy for reading.

See https://www.monetdb.org/Downloads/ReleaseNotes for their changelog
Main changes from there:

• A column default value can be used in a UPDATE statement: UPDATE tname SET cname = DEFAULT, and INSERT statements: INSERT INTO tname VALUES (..., DEFAULT, ...)
• Support for the creation of ordered indices, e.g. CREATE ORDERED INDEX idxname ON mtcars (mpg, cyl);
• Support for non-cascading deletions, e.g. DROP SCHEMA my_schema RESTRICT
• Support for schema comments
• Support for TRUNCATE statements conforming to the SQL:2008 standard: TRUNCATE [ TABLE ] qname [ CONTINUE IDENTITY | RESTART IDENTITY ] [ RESTRICT | CASCADE ]