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

Sql. Enhancing test coverage of type coercion

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • sql

    Description

      Currently, we have neither an understanding of how type coercion impacts the system, nor decent test coverage. As a result, trying to fix one part causes the other to break (see IGNITE-19128 --> IGNITE-19615 --> IGNITE-19976).

      To improve the situation, let us perform the following steps:

      • first, it is necessary to cover the current behavior of planner with an exhaustive set of tests:. Here, we need to cover following cases
        • coercion for set operations like UNION, INTERSECT and EXCEPT
        • coercion for binary comparison and arithmetic
        • coercion for IN operator
        • coercion for CASE operator
        • coercion for function arguments
        • coercion of source for INSERT, UPDATE and MERGE operators
        • etc (did I miss something?)
      • then, we need to cover execution by the similar tests to make sure coercion and execution are aligned
      • finally, we should revise coercion rules to remove unnecessary casts

      Attachments

        Issue Links

        relates to

        Bug - A problem which impairs or prevents the functions of the product. IGNITE-18644 Sql. Type system. Types in predicate expressions may have unnecessary casts.

        • Major - Major loss of function.
        • Open

        Bug - A problem which impairs or prevents the functions of the product. IGNITE-19882 Sql. Queries that access columns of type DECIMAL do not pick index, when compared with INT/BIGINT.

        • 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-19931 Sql. Varbinary. Index is not selected for key = '1'::VARBINARY

        • 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-19128 Sql. Custom data types. IgniteIndexScan has incorrect types in searchBounds.

        • Major - Major loss of function.
        • Resolved

        Bug - A problem which impairs or prevents the functions of the product. IGNITE-19615 Index is not used while performing SELECT over an indexed column

        • Major - Major loss of function.
        • Resolved

        Bug - A problem which impairs or prevents the functions of the product. IGNITE-19976 Sql: ClassCastException when trying to select from indexed smallint column

        • Major - Major loss of function.
        • Resolved

        Bug - A problem which impairs or prevents the functions of the product. IGNITE-22698 Sql. Extend test coverage for numeric comparison with literal wider than numeric type

        • Major - Major loss of function.
        • Resolved

        Improvement - An improvement or enhancement to an existing feature or task. IGNITE-19999 Sql. Add planner test to verify numeric type coercion in binary comparison

        • Major - Major loss of function.
        • Resolved

        Improvement - An improvement or enhancement to an existing feature or task. IGNITE-20000 Sql. Add planner test to verify numeric type coercion in binary arithmetic

        • Major - Major loss of function.
        • Resolved

        Improvement - An improvement or enhancement to an existing feature or task. IGNITE-22462 Sql. Add planner test to verify type coercion for set operations like UNION, INTERSECT and EXCEPT

        • Major - Major loss of function.
        • Resolved

        Improvement - An improvement or enhancement to an existing feature or task. IGNITE-22579 Sql. Add planner test to verify numeric type coercion for IN operator

        • Major - Major loss of function.
        • Resolved

        Improvement - An improvement or enhancement to an existing feature or task. IGNITE-22580 Sql. Add planner test to verify numeric type coercion for CASE operator

        • Major - Major loss of function.
        • Resolved

        Improvement - An improvement or enhancement to an existing feature or task. IGNITE-22581 Sql. Add planner test to verify numeric type coercion of source for INSERT, UPDATE and MERGE operators

        • Major - Major loss of function.
        • Resolved

        Improvement - An improvement or enhancement to an existing feature or task. IGNITE-23041 Sql. Add planner test to verify numeric type coercion for function arguments

        • Major - Major loss of function.
        • Patch Available

        Improvement - An improvement or enhancement to an existing feature or task. IGNITE-23141 Sql. Add execution test to verify numeric type coercion in binary comparison and arithmetic

        • Major - Major loss of function.
        • Patch Available

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            korlov Konstantin Orlov
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Slack

                Issue deployment