v1.2.3

What's Changed

Added

• partiql-ast: add With and WithListElement to AstVisitor and SqlDialect
• EXPERIMENTAL partiql-plan: add representation of RelWith and WithListElement to the plan and the
  OperatorVisitor
• EXPERIMENTAL partiql-planner: add planner builder function to control whether With table references are
  rewritten to their query representation
  • NOTE evaluating plans without the inlined With rewrite will not work as expected. Users trying to evaluate
    With should use the default planner.
• Signed INTERVAL literals support
• Metas attached to INTERVAL PTypes if an INTERVAL has an unspecified precision or fractional precision
• EXTRACT function support on INTERVAL datum
• ABS function support on INTERVAL values
• Support for OVERLAPS predicate
• Add cli option -e to load PartiQL literal data as default catalog data
• Add toString() support for all datum types
• Add optional distinguishNullMissing parameter to Datum.comparator() to control whether null and missing are treated as equivalent or distinct in comparisons
• Remove the extra non-character Unicode in the function name when displaying cli errors
• EXPERIMENTAL Add Datum.getTotalMonths to retrieve the total number of months from a year-month Datum
• EXPERIMENTAL Add Datum.getTotalSeconds to retrieve the total number of seconds from a day-time Datum
• fix the parsing of DATE_ADD/DATE_DIFF with an uncapitalized datetime field argument.
• fix that wrong offset is set when parsing Ion timestamp with time zone into Datum.
• Reimplemented DATE_ADD with interval plus arithmetic.

Fixed

• Specify the correct qualifier for INTERVAL datum with MINUTE TO SECOND
• Handle the formatting when the nanoseconds of INTERVAL datum underflow
• CLI printing of negative interval literals
• Fix alias collision problem when multiple table references need auto-generated aliases
• Display of Ion in PartiQL CLI output
• Support INTERVAL times and divide with numerics
• Prioritize missing propagation when both null and missing exist in function args
• Return missing instead of null for NULLIF(MISSING, MISSING)
• CLI printing of mixed sign literals
• Parsing of TIMESTAMP and TIME literals with timezone offsets
• Variable resolution for qualified references with GROUP BY

Contributors

Thank you to all who have contributed!

• @zyfy29
• @alancai98
• @XuechunHHH
• @xd1313113

Full Changelog: v1.2.2...v1.2.3