[jira] [Created] (CALCITE-3861) MSSQL DECOMPRESS Function Support
Ritesh created CALCITE-3861: --- Summary: MSSQL DECOMPRESS Function Support Key: CALCITE-3861 URL: https://issues.apache.org/jira/browse/CALCITE-3861 Project: Calcite Issue Type: Sub-task Reporter: Ritesh -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (CALCITE-3860) MSSQL COMPRESS Function Support
Ritesh created CALCITE-3860: --- Summary: MSSQL COMPRESS Function Support Key: CALCITE-3860 URL: https://issues.apache.org/jira/browse/CALCITE-3860 Project: Calcite Issue Type: Sub-task Reporter: Ritesh -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (CALCITE-3859) MSSQL Compression Functions
Ritesh created CALCITE-3859: --- Summary: MSSQL Compression Functions Key: CALCITE-3859 URL: https://issues.apache.org/jira/browse/CALCITE-3859 Project: Calcite Issue Type: New Feature Reporter: Ritesh Assignee: Ritesh -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (CALCITE-3858) MySQL UNCOMPRESSED_LENGTH Function Support
Ritesh created CALCITE-3858: --- Summary: MySQL UNCOMPRESSED_LENGTH Function Support Key: CALCITE-3858 URL: https://issues.apache.org/jira/browse/CALCITE-3858 Project: Calcite Issue Type: Sub-task Reporter: Ritesh -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (CALCITE-3857) Support the nested ROW validation while declaring Objects for Type
Ritesh created CALCITE-3857: --- Summary: Support the nested ROW validation while declaring Objects for Type Key: CALCITE-3857 URL: https://issues.apache.org/jira/browse/CALCITE-3857 Project: Calcite Issue Type: Sub-task Reporter: Ritesh Assignee: Ritesh -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (CALCITE-3849) SUBSTRING Function to support binary
Ritesh created CALCITE-3849: --- Summary: SUBSTRING Function to support binary Key: CALCITE-3849 URL: https://issues.apache.org/jira/browse/CALCITE-3849 Project: Calcite Issue Type: New Feature Reporter: Ritesh Assignee: Ritesh [https://docs.microsoft.com/en-us/sql/t-sql/functions/substring-transact-sql?view=sql-server-ver15] -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (CALCITE-3726) Allow declaring type objects
Ritesh created CALCITE-3726: --- Summary: Allow declaring type objects Key: CALCITE-3726 URL: https://issues.apache.org/jira/browse/CALCITE-3726 Project: Calcite Issue Type: New Feature Reporter: Ritesh Assignee: Ritesh [https://docs.oracle.com/cd/B19306_01/appdev.102/b14261/objects.htm#i7530] -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (CALCITE-3679) Calcite to support Lamda Expressions
Ritesh created CALCITE-3679: --- Summary: Calcite to support Lamda Expressions Key: CALCITE-3679 URL: https://issues.apache.org/jira/browse/CALCITE-3679 Project: Calcite Issue Type: New Feature Reporter: Ritesh Assignee: Ritesh -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (CALCITE-3678) Calcite to support map_filter function
Ritesh created CALCITE-3678: --- Summary: Calcite to support map_filter function Key: CALCITE-3678 URL: https://issues.apache.org/jira/browse/CALCITE-3678 Project: Calcite Issue Type: New Feature Reporter: Ritesh Assignee: Ritesh [https://prestodb.io/docs/current/functions/map.html] -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (CALCITE-3648) MySQL DECOMPRESS function support
Ritesh created CALCITE-3648: --- Summary: MySQL DECOMPRESS function support Key: CALCITE-3648 URL: https://issues.apache.org/jira/browse/CALCITE-3648 Project: Calcite Issue Type: Sub-task Reporter: Ritesh Assignee: Ritesh -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (CALCITE-3647) MySQL COMPRESS function support
Ritesh created CALCITE-3647: --- Summary: MySQL COMPRESS function support Key: CALCITE-3647 URL: https://issues.apache.org/jira/browse/CALCITE-3647 Project: Calcite Issue Type: Sub-task Reporter: Ritesh Assignee: Ritesh -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (CALCITE-3646) MySQL compression functions
Ritesh created CALCITE-3646: --- Summary: MySQL compression functions Key: CALCITE-3646 URL: https://issues.apache.org/jira/browse/CALCITE-3646 Project: Calcite Issue Type: New Feature Reporter: Ritesh Assignee: Ritesh -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (CALCITE-3641) Oracle XMLCOMMENT Function Support
Ritesh created CALCITE-3641: --- Summary: Oracle XMLCOMMENT Function Support Key: CALCITE-3641 URL: https://issues.apache.org/jira/browse/CALCITE-3641 Project: Calcite Issue Type: Sub-task Reporter: Ritesh Assignee: Ritesh [https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions218.htm] -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (CALCITE-3640) Oracle EXISTSNODE Function Support
Ritesh created CALCITE-3640: --- Summary: Oracle EXISTSNODE Function Support Key: CALCITE-3640 URL: https://issues.apache.org/jira/browse/CALCITE-3640 Project: Calcite Issue Type: Sub-task Reporter: Ritesh [https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions048.htm] -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (CALCITE-3616) Add BOOL_AND Aggregate Function
Ritesh created CALCITE-3616: --- Summary: Add BOOL_AND Aggregate Function Key: CALCITE-3616 URL: https://issues.apache.org/jira/browse/CALCITE-3616 Project: Calcite Issue Type: New Feature Reporter: Ritesh [https://docs.aws.amazon.com/redshift/latest/dg/r_BOOL_AND.html] -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (CALCITE-3617) Add BOOL_OR Aggregate Function
Ritesh created CALCITE-3617: --- Summary: Add BOOL_OR Aggregate Function Key: CALCITE-3617 URL: https://issues.apache.org/jira/browse/CALCITE-3617 Project: Calcite Issue Type: New Feature Reporter: Ritesh -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (CALCITE-3580) Oracle EXTRACT(XML) Function Support
Ritesh created CALCITE-3580: --- Summary: Oracle EXTRACT(XML) Function Support Key: CALCITE-3580 URL: https://issues.apache.org/jira/browse/CALCITE-3580 Project: Calcite Issue Type: Sub-task Reporter: Ritesh Assignee: Ritesh -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (CALCITE-3579) Oracle XMLTRANSFORM Function Support
Ritesh created CALCITE-3579: --- Summary: Oracle XMLTRANSFORM Function Support Key: CALCITE-3579 URL: https://issues.apache.org/jira/browse/CALCITE-3579 Project: Calcite Issue Type: Sub-task Reporter: Ritesh Assignee: Ritesh -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (CALCITE-3578) Oracle XML Functions
Ritesh created CALCITE-3578: --- Summary: Oracle XML Functions Key: CALCITE-3578 URL: https://issues.apache.org/jira/browse/CALCITE-3578 Project: Calcite Issue Type: Bug Reporter: Ritesh Assignee: Ritesh -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (CALCITE-3553) Support MySQL UpdateXML function
Ritesh created CALCITE-3553: --- Summary: Support MySQL UpdateXML function Key: CALCITE-3553 URL: https://issues.apache.org/jira/browse/CALCITE-3553 Project: Calcite Issue Type: Sub-task Reporter: Ritesh -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (CALCITE-3552) Support MySQL ExtractValue
Ritesh created CALCITE-3552: --- Summary: Support MySQL ExtractValue Key: CALCITE-3552 URL: https://issues.apache.org/jira/browse/CALCITE-3552 Project: Calcite Issue Type: Sub-task Reporter: Ritesh -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (CALCITE-3551) MySQL XML Functions Support
Ritesh created CALCITE-3551: --- Summary: MySQL XML Functions Support Key: CALCITE-3551 URL: https://issues.apache.org/jira/browse/CALCITE-3551 Project: Calcite Issue Type: Bug Reporter: Ritesh Assignee: Ritesh [https://dev.mysql.com/doc/refman/8.0/en/xml-functions.html|https://dev.mysql.com/doc/refman/8.0/en/xml-functions.html#function_updatexml] -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (CALCITE-2881) Add the JSON_PRETTY function
Ritesh created CALCITE-2881:
---
Summary: Add the JSON_PRETTY function
Key: CALCITE-2881
URL: https://issues.apache.org/jira/browse/CALCITE-2881
Project: Calcite
Issue Type: Sub-task
Reporter: Ritesh
```
JSON_PRETTY(*json_string_doc*)
```
Returns the pretty formatted JSON document. Returns `NULL` if any argument is
`NULL` or if JSON document is invalid.
Example Sql:
```sql
SELECT JSON_PRETTY(v) AS c1
FROM (VALUES ('\{"a": [10, true],"b": [10, true]}')) as t(v)
limit 10
```
Result:
c1
{ "a" : [ 10, true ], "b" : [ 10, true ] }
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Created] (CALCITE-2880) Add the JSON_PRETTY function
Ritesh created CALCITE-2880:
---
Summary: Add the JSON_PRETTY function
Key: CALCITE-2880
URL: https://issues.apache.org/jira/browse/CALCITE-2880
Project: Calcite
Issue Type: Sub-task
Reporter: Ritesh
Assignee: Forward Xu
```
JSON_LENGTH(**json_doc**[, *path*])
```
Returns the length of a JSON document, or, if a *path* argument is given, the
length of the value within the document identified by the path. Returns `NULL`
if any argument is `NULL` or the *path* argument does not identify a value in
the document. An error occurs if the *json_doc* argument is not a valid JSON
document or the *path* argument is not a valid path expression or contains a
\{**} or }}**{{`*` wildcard.
The length of a document is determined as follows:
- The length of a scalar is 1.
- The length of an array is the number of array elements.
- The length of an object is the number of object members.
- The length does not count the length of nested arrays or objects.
Example Sql:
```sql
SELECT JSON_LENGTH(v, 'lax $' ERROR ON ERROR) AS c1
,JSON_LENGTH(v, 'lax $.a' ERROR ON ERROR) AS c2
,JSON_LENGTH(v, 'strict $.a[0]' ERROR ON ERROR) AS c3
,JSON_LENGTH(v, 'strict $.a[1]' ERROR ON ERROR) AS c4
FROM (VALUES ('\{"a": [10, true]}')) AS t(v)
limit 10;
```
Result:
| c1 | c2 | c3 | c4 |
| | | | |
| 1 | 2 | 1 | 1 |
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
