Engine

• Added new account, role and membership to support the security policy.
  • Added, Grant, Deny, Revoke, Create/Alter role and account.
  • Changed user id to GUID.
• Added LEFT OUTER join support.
• Fixed bool scalar functions returning string true/false instead of 1/0.
• Fixed issue with unique key enforcement on first duplicate.
• Resolved lookup issue on partial match with single schema.
• Fixed issues parsing variables when not followed by whitespace.
• Fixed issue where schema names were being improperly lowercased.
• Better variable declarations using DECLARE.
• Standardize QueryHandlers, APIs and exceptions.
• Major cleanup of query routing.
• Added lots of new system and scalar functions.
  • Sleep, Print, Abs, Ceil, Floor, Pow, SystemShowSchemaPolicy.
  • DateAdd, DateDiff, FormatNumeric, FormatDateTime, Round, ToString, ToNumeric.
  • IfNullNumeric, NullIf, IsNull, NullIf, NullIfNumeric, and quite a bit more.
• Major enhancements to null handling, all functions should allow null return.
• Null propagation for all expressions, including math.
• Insert now uses Values list or json notation.
• Initial schema now created using embedded scripts.
• Proper null serialization, nulls can now be persisted.
• Fixes to GROUP BY when using ordering results.
• Added ability to pass aggregate result to Scalar function.

UI

• Auto-size of result grids, now allow manual resize.
• Empty result-set now populate field names if supplied by engine.
• Resolved exception on close of form.
• Find/replace improvements,
• Default font change, change of output window font.
• Added drag/drop "macros" (right-hand pane)
• Added row number, which is not exported by context menu commands.

Full Changelog: https://github.com/NTDLS/Katzebase/compare/0.25.0...0.26.0

database document-database nosql rdbms