#include #include using namespace std; #include "functor_json.h" #include "functioncolumn.h" #include "constantcolumn.h" #include "rowgroup.h" using namespace execplan; using namespace rowgroup; #include "dataconvert.h" #include "jsonhelpers.h" using namespace funcexp::helpers; namespace funcexp { CalpontSystemCatalog::ColType Func_json_contains_path::operationType( FunctionParm& fp, CalpontSystemCatalog::ColType& /*resultType*/) { return fp[0]->data()->resultType(); } /** * getBoolVal API definition */ bool Func_json_contains_path::getBoolVal(Row& row, FunctionParm& fp, bool& isNull, CalpontSystemCatalog::ColType& /*type*/) { const auto& js_ns = fp[0]->data()->getStrVal(row, isNull); if (isNull) return false; const string_view js = js_ns.unsafeStringRef(); #if MYSQL_VERSION_ID >= 100900 int arrayCounters[JSON_DEPTH_LIMIT]; bool hasNegPath = false; #endif const int argSize = fp.size() - 2; if (!isModeParsed) { if (!isModeConst) isModeConst = (dynamic_cast(fp[1]->data()) != nullptr); auto mode_ns = fp[1]->data()->getStrVal(row, isNull); if (isNull) return false; string mode = mode_ns.unsafeStringRef(); transform(mode.begin(), mode.end(), mode.begin(), ::tolower); if (mode != "one" && mode != "all") { isNull = true; return false; } isModeOne = (mode == "one"); isModeParsed = isModeConst; } initJSPaths(paths, fp, 2, 1); if (paths.size() == 0) hasFound.assign(argSize, false); vector> p_steps_arr(paths.size(), vector(32)); for (size_t i = 2; i < fp.size(); i++) { JSONPath& path = paths[i - 2]; if (!path.parsed) { mem_root_dynamic_array_init(NULL, PSI_INSTRUMENT_MEM | MY_INIT_BUFFER_USED | MY_BUFFER_NO_RESIZE, &path.p.steps, sizeof(json_path_step_t), &p_steps_arr[i-4], JSON_DEPTH_LIMIT, 0, MYF(0)); if (parseJSPath(path, row, fp[i])) { isNull = true; return false; } #if MYSQL_VERSION_ID >= 100900 hasNegPath |= path.p.types_used & JSON_PATH_NEGATIVE_INDEX; #endif } } json_engine_t jsEg; int jsEg_stack[JSON_DEPTH_LIMIT]; json_path_t p; json_path_step_t p_steps[JSON_DEPTH_LIMIT]; mem_root_dynamic_array_init(NULL, PSI_INSTRUMENT_MEM | MY_INIT_BUFFER_USED | MY_BUFFER_NO_RESIZE, &p.steps, sizeof(json_path_step_t), &p_steps, JSON_DEPTH_LIMIT, 0, MYF(0)); mem_root_dynamic_array_init(NULL, PSI_INSTRUMENT_MEM | MY_INIT_BUFFER_USED | MY_BUFFER_NO_RESIZE, &jsEg.stack, sizeof(int), &jsEg_stack, JSON_DEPTH_LIMIT, 0, MYF(0)); json_get_path_start(&jsEg, getCharset(fp[0]), (const uchar*)js.data(), (const uchar*)js.data() + js.size(), &p); bool result = false; int needFound = 0; if (!isModeOne) { hasFound.assign(argSize, false); needFound = argSize; } while (json_get_path_next(&jsEg, &p) == 0) { json_path_step_t *last_step= (json_path_step_t*) (mem_root_dynamic_array_get_val(&p.steps, p.last_step_idx)); if (hasNegPath && jsEg.value_type == JSON_VALUE_ARRAY && json_skip_array_and_count(&jsEg, arrayCounters + (last_step - (json_path_step_t*)p.steps.buffer))) { result = true; break; } #endif for (int restSize = argSize, curr = 0; restSize > 0; restSize--, curr++) { JSONPath& path = paths[curr]; #if MYSQL_VERSION_ID >= 100900 int cmp = cmpJSPath(&path.p, &p, jsEg.value_type, arrayCounters); #else int cmp = cmpJSPath(&path.p, &p, jsEg.value_type); #endif if (cmp >= 0) { if (isModeOne) { result = true; break; } /* mode_all */ if (hasFound[restSize - 1]) continue; /* already found */ if (--needFound == 0) { result = true; break; } hasFound[restSize - 1] = true; } } } if (likely(jsEg.s.error == 0)) return result; isNull = true; return false; } } // namespace funcexp