Jul 2017-SP4 bugfix release (11.27.13)

Build Environment
  • Added the .lib and .h files needed for building extensions to the Windows installer.
Bug Fixes
  • 3470: Support setClob without length restrictions
  • 6468: JDBC 2.27 fails with year < 1000
  • 6482: Query failures on order by on union
  • 6483: Monetdb crashes, on query
  • 6487: UNION of NULLs with several tables fails
  • 6488: Semijoin returns duplicate values from a column with unique values
  • 6489: Sqlitelogictest - Wrong result set of complex conditional query
  • 6490: Sqlitelogictest - Select query with an IN clause parse error
  • 6491: SELECT IN returns NULL instead of false when not found
  • 6492: Persistent hashes stored and then ignored. Storage info not in sync with actual indices.
  • 6493: Sqlitelogictest - Aggregation query on empty table with DISTINCT clause
  • 6494: Sqlitelogictest - Algebra operators priority in select query
  • 6495: Sqlitelogictest - Omitting AS in a result set column alias name
  • 6496: Sqlitelogictest - Select interval comparisons between floating-points and NULL
  • 6497: Sqlitelogictest - Select not between query producing wrong results
  • 6498: large virtual memory spike on BLOB column COUNT
  • 6499: Crash when trying to replace a function defined in sys from a different schema
  • 6502: Query with multiple limit clauses does not return anything
  • 6508: Segmentation fault in mserver5 on Python2 UDF with TIMESTAMP column input that has NULL values (conversion.c:438, PyNullMask_FromBAT)
  • 6510: Sqlitelogictest: Wrong output in aggregation query
  • 6512: Monetdb crashes on query with limit after sort with case
  • 6514: Sqlitelogictest: Range query between NULL values not possible
  • 6515: Insert null second interval value results in 0
  • 6516: Sqlitelogictest unknown bat append operation
  • 6517: Sqlitelogictest overflow in conversion during MAL plan execution
  • 6518: Sqlitelogictest: count aggregation with not in operator
  • 6519: Sqlitelogictest: algebra join between lng and int BATs undefined
  • 6520: UPDATE with correlated subquery causes assertion (or segfault)
  • 6522: Sqlitelogictest: IN operator return a single column
  • 6523: Sqlitelogictest: Case statement subquery missing
  • 6524: Sqlitelogictest: Crash in aggregation query with IN operator
  • 6527: Crash using order by alias in subquery