0.19.0

• Fixed issue with scaler functions when optional parameters were not passed.
• Resolved issue with calculating mathematical expressions when in line with string concatenation.
• Added new "single" schema that is intended to mimic the Oracle "dual" function.
• Reimplemented insert of "ragged key/value" pairs. This is in addition to field/value insert style.

Full Changelog: 0.18.0...0.19.0

0.18.0

• Reimplemented "set".
• Massively improved insert performance.
• Greatly reduced schema lock contention.
• Resolved issues with case-sensitivity of schema aliases in where clause and joins.
• Greatly reduced duration and memory requirements for creating and rebuilding indexes.

Full Changelog: 0.17.0...0.18.0

0.17.0

• Reimplemented "select into".
• Reimplemented Sample, Analyze, List, Alter, Rebuild, Set, Kill, and Exec.
• Reimplemented system functions.
• Resolved issue with "select top" when offset is not specified.
• Client package update.

Full Changelog: 0.16.0...0.17.0

0.16.0

Changes

• Rewrote tokenizer.
• Rewrote entire query parser.
  • Parsers are now separated into separate static classes for each query type.
  • Parsers are now reusable, allowing for the condition parser, field parser and the like to be reused inside other query parser types.
• Functions are now fully recursive and are parsed in select fields, group by, order by, insert, update, select, where clause and join clauses.
• Update statements now allow for joins.
• Delete statements now allow for joins.
• Introduced "insert select from" statements.
• Temporarily removed support for procedures, they will need to be reimplemented.
• Major changes to the way that indexes are selected and used. Multiple values for a single index are now handled in one index lookup operation.
• Condition parser rewrite is now more robust and understandable.
• Introduction of new dapper like queries using classes as return objects.
• Introduction of parameterized queries prevents sql-injection attacks.
• Scaler and aggregate function parser rewrite allowing for reusability in various parts of queries.
• Added inline query string concatenation.
• Added query field type detection for inline math and string aggregation to coexist without "casting" which would be found in other RDBMSs.
• Added windowing functionality with TOP and OFFSET.

Remaining to-do:

• Reimplement "SELECT INTO".
• Reimplement stored procedures.
• More robust parser validation.

What's Changed

• Implementation of robust parser in PR #68

Full Changelog: 0.15.0...0.16.0

0.15.0

• Separated thread pools for indexing and lookup operations.
• Added full support for composite index seeks and scans.
• Vastly improved query optimizer.
• Added API to show query plan and order of operations, this is also available in the UI.
• Added finer granularity and additional categories to performance trace operations
• Performance counter refactoring.
• Removed element compression in favor of full page compression for better performance and space usage
• Greatly improved locking and concurrency. Much less contention and higher performance.

Full Changelog: 0.14.0...0.15.0

0.14.0

• Updated reliable messaging to allow async queries. Each connection can now handle more than one query at a time.
• Added configurable child thread pool queue depth.
• Updated delegate thread pooling to allows for consolidation of thread exceptions and process cancelation.
• Improved semaphore locking.
• Query explain, attached conditions to root schema, removed double optimize
• Cleaned up condition/indexing explanation.
• Cleaning up condition parser.
• Added condition inversion.
• Resolved selecting dynamic fields from specific schemas.
• Exception formatting.
• Added aggregate exception to one threaded call, need to do others.
• Condition parser improvements, thread exceptions, perf and refactoring.
• Added ShowVersion, faster string comparison, much faster like comparison

Full Changelog: 0.13.0...0.14.0

0.13.0

• Added: SystemProcedures and SystemAggregateFunctions
• Added serilog.
• Removed delayed document materialization.
• Removed stability lock conversion.
• Corrected index analytics for root node calculations.
• Fixed parser issue which was not tagging NULL as a constant.
• Resolved null equality issues.
• Resolved issue where constant values were not filled out on one-to-many relationships.
• Vastly improved exception reporting.
• Refactoring of expressions, sub-expressions and conditions.

Full Changelog: 0.12.0...0.13.0

0.12.0

• Major updates to dependency libraries.
• Lots of bug fixes.
• Lots of optimizations.
• Incredible amounts of refactoring.

Full Changelog: 0.10.0...0.12.0

0.10.0

• Update ReliableMessaging nuget, this allows us to make convention based API calls.

0.9.0

• Release as a seperate module.