[CALCITE-5614] Serialize Sarg objects to and from JSON

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.35.0
• Labels: pull-request-available
• Assignee: Oliver Lee
• Reporter: Oliver Lee
• Created: 27/Mar/23 23:57
• Updated: 30/Aug/23 18:44
• Resolved: 28/Apr/23 06:22

Description

Context: Bounded filter conditions (e.g. SUM(field> > 1 AND SUM(field) < 10) are converted to calls to a SEARCH operator. If this is then serialized and deserialized, it will throw an exception when resolving SEARCH.

 

 

To complete this ticket: Add functionality such that Sarg literals can be serialized and deserialized.

 

RelJson.java should be updated so that toRex can serialize Sarg objects

 

RexBuilder.java should be updated to be able to successfully deserialize a JSON string that includes Sarg literals 

Issue Links

• relates to: CALCITE-5625 Expand SEARCH RexNode when converting toJson
• links to: GitHub Pull Request #3140
• links to: GitHub Pull Request #3255

Sub-Tasks

• Expand SEARCH RexNode when converting toJson: Closed
• Add to Sarg serialization/deserialization TimestampString: Closed