matrixone
matrixone copied to clipboard
Add jq and try_jq function.
User description
What type of PR is this?
- [ ] API-change
- [ ] BUG
- [ ] Improvement
- [ ] Documentation
- [x] Feature
- [ ] Test and CI
- [ ] Code Refactoring
Which issue(s) this PR fixes:
issue #17134
What this PR does / why we need it:
Added jq and try_jq function.
PR Type
Enhancement, Tests
Description
- Added new
jq
andtry_jq
functions for JSON querying. - Implemented caching for jq queries and added an encoder for jq results.
- Refactored
Or
method inNulls
to modify in place. - Added methods for handling null values in
FunctionResult
. - Updated null handling in
opBinaryStrStrToFixedWithErrorCheck
to use newFunctionResult
methods. - Added null checks in
FunctionSelectList
methods. - Added
JQ
andTRY_JQ
function IDs. - Added
jq
andtry_jq
to the list of supported functions. - Added
gojq
dependency and updatedgolang.org/x/sys
dependency. - Added test cases and SQL test script for
jq
andtry_jq
functions.
Changes walkthrough 📝
Relevant files | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Enhancement | 7 files
| ||||||||||||||
Dependencies | |||||||||||||||
Tests | 2 files
|
💡 PR-Agent usage: Comment
/help
on the PR to get a list of all available PR-Agent tools and their descriptions