Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-14535

Caclite SQL engine capabilities

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • sql
    • None
    • Docs Required, Release Notes Required

    Description

      Umbrella ticket to track issues related to SQL logical tests.

      Attachments

        Issue Links

          incorporates

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-14964 Calcite engine. Huge list for IN clause canot be compiled

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-15001 Calcite engine. Sort out tests for REGEXP_REPLACE function

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-15003 Calcite engine. Function argument is not casted implicitly

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-15418 Calcite engine. TIMESTAMPDIFF function returns INTEGER type for MICROSECOND time unit

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-14541 Calcite engine. HAVING fails on scalar

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-14602 Calcite engine. Wrong string representation of dates outside standard ISO range

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-15004 Calcite engine. LIKE ESCAPE fails with empty escape string

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-15080 Calcite. Functions extends string parameters by trailing spaces

          • Major - Major loss of function.
          • In Progress

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-14537 Calcite engine. Nested arbitrary queries hangs on optimizing

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-14542 Calcite engine. Need to support TableFunctions / SYSTEM_RANGE dynamic table

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-14543 Calcite engine. Aggregate functions fail on scalar values

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-14544 Calcite engine. Support DISTINCT aggregates

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-14545 Calcite engine. Unicode literal not supported

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-14546 Calcite engine. MIN/MAX aggregates doesn't support string types

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-14553 Calcite engine. Duplicated result on insert

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-14589 Calcite engine. Numerous problem with type Decimal

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-14597 Calcite engine. Exception when using FIRST

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-14680 Calcite engine. Node stopped by failure handler after inserting several thousand values

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-14681 Calcite engine. Extend return type of sum() aggregate function

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-14724 Calcite engine. Create table with DATE column creates INTEGER column

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-14960 Calcite engine. EXTRACT(DOW FROM d) returns invalid results

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-14963 Calcite engine. Date interval arythmetic returns invalid results

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-14973 Calcite engine. IgniteLimit is pushed down under Exchange invalid

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-14975 Calcite engine. Introduce suppot INTERVAL type.

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-14991 Calcite engine. Supports regexp operators

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-15002 Calcite engine. String functions fail on NULL constant

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-15031 Calcite engine. Parser fails on REPLACE function

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-15037 Calcite engine. CURRENT_DATE/TIME/TIMESTAMP fails with NPE

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-15109 Calcite engine. TIMESTAMPDIFF for MICROSECOND unit doesn't work

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-15110 Calcite bug. Function CHAR_LENGTH works incorrect with UNICODE

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-15111 Calcite bug. Function INITCAP fails for NULL argument

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-15112 Calcite bug. Function TRUNCATE fails for NULL argument

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-14730 Calcite engine. Cast to INTERVAL data type is not working

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-15066 Calcite. Function CONCAT and NULL arguments

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-14540 Calcite engine. Support correlated subquery in having

          • Major - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-14885 Calcite engine. Allow grouping by alias or ordinal

          • Major - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-14955 Calcite engine. Not supported DATE/TIME functions

          • Major - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-14539 Calcite engine. Support DISTINCT ON expression

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-14632 Calcite engine. Support for unsigned types

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-14637 Calcite engine. Support for statistics and approximate statistics aggregate functions

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-14639 Calcite engine. Support for ARG_MIN/MAX aggregate functions

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-14640 Calcite engine. Support for bit aggregate functions

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-14641 Calcite engine. Support for covariance aggregate functions

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-14642 Calcite engine. Support for standard deviation aggregate functions

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-14643 Calcite engine. Support for linear regression aggregate functions

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-14677 Calcite engine. Add 32-bit Unicode characters support

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-14961 Calcite engine. Arithmetic operators cannot be applied to <DATE> + <INTEGER>

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-15075 Calcite. TRIM function doesn't support multicharacter trim

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-14636 Calcite engine. Support for LISTAGG (aka GROUP_CONCAT, STRING_AGG) aggregate function

          • Major - Major loss of function.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-14849 Calcite engine. Support '%' operator as alias for 'mod' function

          • Major - Major loss of function.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-14954 Calcite engine. MONTHNAME, DAYNAME functions fail due to null locale

          • Major - Major loss of function.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-14552 Calcite engine. Alias for function CHARACTER_LENGTH

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-14554 Calcite engine. Provide ability to parse huge numeric literals

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-14555 Calcite engine. Create table from query result

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-14596 Calcite engine. Support for function TYPEOF

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Task - A task that needs to be done. IGNITE-14590 Calcite engine. Sort out the types/decimal and types/string directories

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-14633 Calcite engine. Sort out the types/[hugeint|map|null|struct|unsigned] directories

          • Major - Major loss of function.
          • Resolved
          is related to

          Task - A task that needs to be done. IGNITE-14623 Calcite. Sort out test scripts at: sql/aggregate/aggregates/*

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              Unassigned Unassigned
              tledkov-gridgain Taras Ledkov
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: