xuqianjin created CALCITE-2791: ---------------------------------- Summary: Add the JSON_TYPE function Key: CALCITE-2791 URL: https://issues.apache.org/jira/browse/CALCITE-2791 Project: Calcite Issue Type: Improvement Reporter: xuqianjin Assignee: Julian Hyde
The data in json can be =, <, <=, >, >=, <>,! =, and <=>. But the data types in json can be diverse, so when you compare different types, you have a priority, and the high priority is greater than the low priority (you can view the types with the JSON_TYPE() function). The priorities are as follows: BLOB BIT OPAQUE DATETIME TIME DATE BOOLEAN ARRAY OBJECT STRING INTEGER, DOUBLE NULL -- This message was sent by Atlassian JIRA (v7.6.3#76005)