maria:bb-10.5-MDEV-34041

Last commit made on 2024-05-25
Get this branch:
git clone -b bb-10.5-MDEV-34041 https://git.launchpad.net/maria

Branch merges

Branch information

Name:
bb-10.5-MDEV-34041
Repository:
lp:maria

Recent commits

5e20e26... by Oleg Smirnov

MDEV-32041 Fix code review comments 2

8b9d336... by Oleg Smirnov

MDEV-32041 Fix code review comments

5729b3b... by Oleg Smirnov

MDEV-34041 Display additional information for materialized subqueries in EXPLAIN/ANALYZE FORMAT=JSON

f957549... by Bernard Spil <email address hidden>

Fix typo

There is no component `SuportFiles` in MariaDB server, yet a `SupportFiles` component exists.

9e6858a... by Rucha Deodhar <email address hidden>

MDEV-22141: JSON_REMOVE returns NULL on valid arguments

Analysis:
When we scan json to get to a beginning according to the path, we end up
scanning json even if we have exhausted it. When eventually returns error.

Fix:
Continue scanning json only if we have not exhausted it and return result
accordingly.

5ca64e6... by Rucha Deodhar <email address hidden>

MDEV-32287: JSON_EXTRACT not returning multiple values for same path

Analysis:
When scanning json and getting the exact path at each step, if a path
is reached, we end up adding the item in the result and immediately get the
next item which results in current path changing.
Fix:
Instead of immediately returning the item, count the occurences of the path
in argument and append in the result as needed.

d7df63e... by Rucha Deodhar <email address hidden>

MDEV-19487: JSON_TYPE doesnt detect the type of String Values
(returns NULL) and for Date/DateTime returns "INTEGER"

Analysis:
When the first character of json is scanned it is number. Based on that
integer is returned.
Fix:
Scan rest of the json before returning the final result to ensure json is
valid in the first place in order to have a valid type.

c6e3fe2... by Alexander Barkov

MDEV-30646 View created via JSON_ARRAYAGG returns incorrect json object

Backporting add782a13e58 from 10.6, this fixes the problem.

dc25d60... by Alexander Barkov

MDEV-21058 CREATE TABLE with generated column and RLIKE results in sigabrt

Regexp_processor_pcre::fix_owner() called Regexp_processor_pcre::compile(),
which could fail on the regex syntax error in the pattern and put
an error into the diagnostics area. However, the callers:
  - Item_func_regex::fix_length_and_dec()
  - Item_func_regexp_instr::fix_length_and_dec()
still returned "false" in such cases, which made the code
crash later inside Diagnostics_area::set_ok_status().

Fix:

- Change the return type of fix_onwer() from "void" to "bool"
  and return "true" whenever an error is put to the DA
  (e.g. on the syntax error in the pattern).
- Fixing fix_length_and_dec() of the mentioned Item_func_xxx
  classes to return "true" if fix_onwer() returned "true".

267dd5a... by Yuchen Pei <email address hidden>

MDEV-30727 Check spider_hton_ptr in spider udfs

We have to #undef my_error and find it from udfs when spider is not
installed.