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

    Details

    • Type: Task
    • Status: In Progress
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: core
    • Labels:
      None

      Description

      Complete JSON support for Calcite.

        Attachments

        Issue Links

        1.
        Implement SQL 2016 JSON functions Sub-task Closed Unassigned   Actions
        2.
        JSON data type support Sub-task Open Unassigned   Actions
        3.
        Add the JSON_DEPTH function Sub-task Closed Forward Xu

        100%

        Original Estimate - Not Specified Original Estimate - Not Specified
        Time Spent - 50m
        Actions
        4.
        Add the JSON_TYPE function Sub-task Closed Forward Xu

        100%

        Original Estimate - Not Specified Original Estimate - Not Specified
        Time Spent - 3h 20m
        Actions
        5.
        Add the JSON_PRETTY function Sub-task Closed Unassigned

        100%

        Original Estimate - Not Specified Original Estimate - Not Specified
        Time Spent - 1h 20m
        Actions
        6.
        Add the JSON_LENGTH function Sub-task Closed Forward Xu

        100%

        Original Estimate - Not Specified Original Estimate - Not Specified
        Time Spent - 13h 20m
        Actions
        7.
        Add the JSON_KEYS function Sub-task Closed Forward Xu

        100%

        Original Estimate - Not Specified Original Estimate - Not Specified
        Time Spent - 3h
        Actions
        8.
        Implement JSON_INSERT, JSON_REPLACE, JSON_SET Sub-task Open Forward Xu

        100%

        Original Estimate - Not Specified Original Estimate - Not Specified
        Time Spent - 8h
        Actions
        9.
        Implement JSON_TABLE table function Sub-task Open Forward Xu   Actions
        10.
        Combine similar JSON aggregate functions in operator table Sub-task Closed Julian Hyde   Actions
        11.
        Add order by clause support for JSON_ARRAYAGG Sub-task Closed Hongze Zhang

        100%

        Original Estimate - Not Specified Original Estimate - Not Specified
        Time Spent - 50m
        Actions
        12.
        JSON aggregate calls with different null clause get incorrectly merged during converting from SQL to relational algebra Sub-task Closed Hongze Zhang

        100%

        Original Estimate - Not Specified Original Estimate - Not Specified
        Time Spent - 20m
        Actions
        13.
        Support for JSON key uniqueness constraint Sub-task Open Unassigned   Actions
        14.
        Support for JSON query quotes behavior Sub-task Open Ritesh

        100%

        Original Estimate - Not Specified Original Estimate - Not Specified
        Time Spent - 1h 20m
        Actions
        15.
        Support for specifying encoding in JSON representation clause Sub-task Open Unassigned   Actions
        16.
        Implement JSON_REMOVE function Sub-task Closed Forward Xu

        100%

        Original Estimate - Not Specified Original Estimate - Not Specified
        Time Spent - 3.5h
        Actions
        17.
        Implement JSON_STORAGE_SIZE function Sub-task Closed Forward Xu

        100%

        Original Estimate - Not Specified Original Estimate - Not Specified
        Time Spent - 2h 40m
        Actions
        18.
        In SQL parser, move JsonValueExpression into Expression Sub-task Closed Hongze Zhang

        100%

        Original Estimate - Not Specified Original Estimate - Not Specified
        Time Spent - 20m
        Actions
        19.
        Improve null handling of JsonValueExpressionOperator Sub-task Closed Hongze Zhang

        100%

        Original Estimate - Not Specified Original Estimate - Not Specified
        Time Spent - 1.5h
        Actions
        20.
        Move MySQL's JSON operators to SqlLibraryOperators Sub-task Closed Hongze Zhang

        100%

        Original Estimate - Not Specified Original Estimate - Not Specified
        Time Spent - 20m
        Actions
        21.
        Implement JSON_UNQUOTE, JSON_QUOTE function Sub-task Open Forward Xu

        100%

        Original Estimate - Not Specified Original Estimate - Not Specified
        Time Spent - 1h 40m
        Actions
        22.
        Implement JSON_EXTRACT function Sub-task Open Forward Xu

        100%

        Original Estimate - Not Specified Original Estimate - Not Specified
        Time Spent - 2h
        Actions

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              zhztheplayer Hongze Zhang

              Dates

              • Created:
                Updated:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 44h 20m
                44h 20m

                  Issue deployment