Home - Waterfall Grid T-Grid Console Builders Recent Builds Buildslaves Changesources - JSON API - About

Console View


Categories: connectors experimental galera main
Legend:   Passed Failed Warnings Failed Again Running Exception Offline No data

connectors experimental galera main
eaaa15cd8a24...
eaaa15cd8a24ace232340eee89a20fc82c58ae9b
Sergei Golubchik
fix --path to work

complex object sysvars (plugins, time zone, path) cannot be
set by my_getopt, they have to use NO_CMD_LINE and special
code in mysqld.cc
de976df5fc0a...
de976df5fc0a3b34cffca9da1e3c134e10393e17
Sergei Golubchik
reserve PATH_SYM in the same way as NAMES_SYM
ddf534a2ecdf...
ddf534a2ecdf6deeddacb014399f2a8d0b03f689
Oleg Smirnov
WIP
da321d7a0f8c...
da321d7a0f8c2b7e2d14831ede30b070191ccb0b
Sergei Golubchik
remove Sql_path_stack and Sql_path_push

don't create a permanent stack of paths on the heap and in THD.

Do it on the stack like for sql_mode, sctx, abort_on_warning, and
other THD properties that often need to be changed temporarily.

Fix Sql_path constructor.
d4d516c9b938...
d4d516c9b938cbe9f66e850ffa4cf3e43a72867c
Oleg Smirnov
WIP: parsing
d229780e513d...
d229780e513db5e66c84f7761fe225e338c66e6d
Sergei Golubchik
don't backtick-quote CURRENT_SCHEMA
ccbb12634f81...
ccbb12634f81f7e5760e4d1022be372d18d8249c
bsrikanth-mariadb
MDEV-36523: Load basic stats from trace into optimizer

This task loads the stats of the tables that are used in a query,
from the trace into the optimizer. This feature is controlled
by optimizer_replay_context, and points to an user defined variable name,
that has the context information.
The stats such as num_of_records present in the table, indexes if present,
their names, along with the average number of records_per_key
with in each index, cost of reading an index are loaded from the trace.
Additionally, stats from range analysis i.e. ranges, and the
corresponding number of records, along with their costs are also
loaded from the trace.

The trace context which is in JSON format is firstly set into the
user defined session variable, and this variable name is set to
optimizer_replay_context system variable.
Later, when a user issues a query, the contents of the json context is
parsed and an in memory representation is built using the class
Optimizer_context_replay. This class is then used by the optimizer
to update and save original values of the tables, indexes, and range stats
in the methods "set_statistics_for_table()" of sql_statistics.cc, and
"check_quick_select()" of opt_range.cc.
After the query gets finished, the statistics that were updated
in the optimizer are restored back to the saved original values.

The entry point for parsing the json structure is in
"mysql_execute_command()" of sql_parse.cc, and similarly exit point
i.e. to restore the saved stats of the optimizer is at the end
of the same method.

Two new warning/error messages are introduced:
ER_JSON_OPTIMIZER_REPLAY_CONTEXT_PARSE_FAILED, and
ER_JSON_OPTIMIZER_REPLAY_CONTEXT_MATCH_FAILED
cb6060f263cd...
cb6060f263cd91756f5ad7a59baa7ac9edc1975d
Sergei Golubchik
mysql.proc.path DEFAULT 'CURRENT_SCHEMA' NOT NULL
caa6f70b5d6f...
caa6f70b5d6f50309c3fa5d775c81f5fc319c350
Rex Johnston
MDEV-38258 No error thrown when CTE columns updated in updates set clause

CTE's are read only i.e It cannot have their columns updated in updates
set clause. Attempting to do so , should throw error
ERROR 1288 (HY000): The target table cte of the UPDATE is not updatable

with cte as (select * from t1 where c < 5)
  update cte set cte.a =(select a from cte);
Here, conversion from a single table to a multi table update bypasses
the normal check by setting the TABLE_LIST object representing cte
to be merge derived.  This is incorrect, so we prohibit this conversion
in TABLE_LIST::init_derived.
c1f388248fec...
c1f388248fec314be49dc775757e1012c61d3015
Oleg Smirnov
MDEV-38045: Implement implicit query block names for optimizer hints

This patch implements support for implicit query block (QB) names in
optimizer hints, allowing hints to reference query blocks and tables
within derived tables, views and CTEs without requiring explicit
QB_NAME hints.

Examples.
-- Addressing a table inside a derived table using implicit QB name
select /*+ no_index(t1@dt) */ *
  from (select * from t1 where a > 10) as DT;
-- this is an equivalent to:
select /*+ no_index(t1@dt) */ * from
  (select /*+ qb_name(dt)*/ * from t1 where a > 10) as DT;
-- Addressing a query block corresponding to the derived table
select /*+ no_bnl(@dt) */ *
  from (select * from t1, t2 where t.1.a > t2.a) as DT;

-- View
create view v1 as select * from t1 where a > 10 and b > 100;
-- referencing a table inside a view by implicit QB name:
select /*+ index_merge(t1@v1 idx_a, idx_b) */ *
  from v1, t2 where v1.a = t2.a;
-- equivalent to:
create view v1 as select /*+ qb_name(qb_v1) */ *
  from t1 where a > 10 and b > 100;
select /*+ index_merge(t1@qb_v1 idx_a, idx_b) */ *
  from v1, t2 where v1.a = t2.a;

-- CTE
with aless100 as (select a from t1 where b <100)
  select /*+ index(t1@aless100) */ * from aless100;
-- equivalent to:
with aless100 as (select /*+ qb_name(aless100) */ a from t1 where b <100)
  select /*+ index(t1@aless100) */ * from aless100;

Key changes:

1. Two-stage hint resolution
  - Introduced hint_resolution_stage enum (EARLY/LATE) to control
    when different hint types are resolved:
    - EARLY stage: before opening tables (QB_NAME, MERGE hints)
    - LATE stage: after opening tables (all other hints)

2. Implicit QB name support
  - Derived table/view/CTE aliases can now be used as implicit query
    block names in hint syntax: @alias, table@alias
  - Derived tables inside views can be addressed from outer queries
    using their aliases
b4f3713ce92a...
b4f3713ce92adb6cec817007c40e34534bff975c
Lawrin Novitsky
ODBC-482 Problems with SQLSetPos on block cursor with NULL values.

If position was changed, SQLGetData would still read if value is NULL
from first row in the block cursor. That could lead to different issues
and even crash on SQL_DELETE or in SQLGetData() after SQL_POSITION.
Part of fix is also in the part that has been moved to c/c++ repo -
get() method returned true, i.e. error on NULL field value. Plus
resultset method isNull has been made public.
a639cb87ac96...
a639cb87ac9630956498cab306a8456a4e4827c2
Sergei Golubchik
small cleanup
a57c3210d7a9...
a57c3210d7a9d9351c53af6190bafa466044f397
Sergei Golubchik
more tests for duplicate values in path
a361fe00b81f...
a361fe00b81f430917bb96dc98070de30171624f
Sergei Golubchik
allocate Sql_path in one memory chunk, not one per schema

because it's always allocated and freed as a whole, there is
no operation "replace one name in the middle of the path"

this needed a reworked parser to create the whole list
of names, not append one name at a time.

Fixed a bug where Sql_path::from_text() pretended it can take
a string in any charset, but was always implicitly
assuming it's in my_charset_utf8mb3_general_ci.
a2ce5fda610e...
a2ce5fda610e283b1182e1593c2b493e800058fc
Sergei Golubchik
remove always-false agument
9ce2b79e92da...
9ce2b79e92dafe9a655fd2714db2a020a5eef1b4
Andrei Elkin
MDEV-38212 MDEV-37686 Breaks Parallel Replication

Instead of `NULL`ifying of this member a finer approach is taken to
screen the replicated temporary tables from the slave applier
when it runs within `start_new_trans` context.

For that *all* access critical `THD::{has,lock,unlock}_temporary_tables`
functions are made to check possible `start_new_trans` condition.
This measure forces `start_new_trans` executing slave thread to always take
the normal thread access path to a temporary table repository.

This commit also unifies with sql/temporary_tables.cc checking of the
current thread is slave with usage of THD::rgi_slave instead of
THD::slave_thread (last time chosen by MDEV-33426).

Tested with rpl.create_or_replace_mix2 of GTT feature branch.
92597ccd8a16...
92597ccd8a164c60653e32e36bed22a4bd8cca63
Sergei Golubchik
disallow SET PATH in sf or trg while parsing

but also when executing, of course
8ee7f5bac1b7...
8ee7f5bac1b7c298c67ba7c4260b5e64c8237936
Sergei Golubchik
do NOT prefer itself in seemingly recursive calls, follow the path
8c5cc7692a35...
8c5cc7692a3533806b808b170df7c78502a4c295
Sergei Golubchik
PATH is not a chistic, it's like sql_mode, remembered implicitly per routine
8b666ce5b098...
8b666ce5b098f0df2128756bf8123a357700f61e
Oleg Smirnov
WIP
85878eb1cef1...
85878eb1cef19ffecc5e9751b36647069413e602
Sergei Golubchik
fix name resolution of name1.name2()

only search in thd->db if the path includes CURRENT_SCHEMA

Also, fix a bug with recursive function calls.
84755de168f3...
84755de168f3f0ec2addeaa6460ad364b3e50d85
Sergei Golubchik
remove LEX::make_sp_name_sql_path()

it confusingly didn't have anything to do with sql path,
so merged into LEX::make_sp_name()
7fde72db9e15...
7fde72db9e1574ca1fa1075de279df4d331093d5
Rex Johnston
MDEV-38258 No error thrown when CTE columns updated in updates set clause

CTE's are read only i.e It cannot have their columns updated in updates
set clause. Attempting to do so , should throw error
ERROR 1288 (HY000): The target table cte of the UPDATE is not updatable

with cte as (select * from t1 where c < 5)
  update cte set cte.a =(select a from cte);
Here, conversion from a single table to a multi table update bypasses
the normal check by setting the TABLE_LIST object representing cte
to be merge derived.  This is incorrect, so we prohibit this conversion
in TABLE_LIST::init_derived.
7f8f90a4e091...
7f8f90a4e091b1609dc69795fc9bd8c5617774d8
Marko Mäkelä
squash! baff127a9ecbaee9ccd266e92508ca0908a25e60

log_t::set_archive(my_bool): Implement SET GLOBAL innodb_log_archive.
An error will be returned if non-archived SET GLOBAL innodb_log_file_size
(log file resizing) is in progress.
FIXME: Rename and update the current log file.

innodb_log_archive_start: The initial value of the status variable
innodb_lsn_archived, or 0 to autodetect from the log files.
7a826f4914e4...
7a826f4914e4f0cdc13eccbb9b2e48dc79cebab6
Sergei Golubchik
consistency in error message naming
6932f71b1a5d...
6932f71b1a5d4a8032f3cfa13eb8cc44444c0a40
Rex Johnston
MDEV-38258 No error thrown when CTE columns updated in updates set clause

CTE's are read only i.e It cannot have their columns updated in updates
set clause. Attempting to do so , should throw error
ERROR 1288 (HY000): The target table cte of the UPDATE is not updatable

with cte as (select * from t1 where c < 5)
  update cte set cte.a =(select a from cte);
Here, conversion from a single table to a multi table update bypasses
the normal check by setting the TABLE_LIST object representing cte
to be merge derived.  This is incorrect, so we prohibit this conversion
in TABLE_LIST::init_derived.
5ff30343918f...
5ff30343918ff28f374e686205d3f92bb004c97d
Lawrin Novitsky
get methods returned true for the NULL value - i.e. error. That is

incorrect.
Made isNull method public.
51aea8d02072...
51aea8d02072ef81aaca2211ee0dfbee35574ba9
Rex Johnston
MDEV-37220  Allow UPDATE/DELETE to read from a CTE

We extend from the SQL standard to match the functionality of other
databases that allow the inclusion of a CTE definition prior to update
and delete statements.

These CTEs are currently read only, like other derived tables, so
cannot have their columns updated in updates set clause, nor have rows
removed in the delete statement.

Approved by: Oleksandr Byelkin ([email protected])
46775ef64556...
46775ef6455669aa177b51091e2603da9b2289e9
Sergei Golubchik
free Sql_path in the destructor, perform cleanup in cleanup()
2d0088e4f671...
2d0088e4f671a9862e9d3602fd4f1887abd8ed3d
Sergei Golubchik
disallow SET PATH DEFAULT in stored routines and triggers

also fix Sys_var_charset_collation_map where this bug was copied from
26439096b493...
26439096b49309633aa9fa24dcc9e1703c2267e5
Hemant Dangi
MDL BF-BF conflict on ALTER and INSERT with multi-level foreign key parents

Issue:
On galera write node INSERT statements does not acquire MDL locks on it's all child
tables and thereby wsrep certification keys are also added for limited tables, but
on applier nodes it does acquire MDL locks for all child tables. This can result
into MDL BF-BF conflict on applier node when transactions referring to parent and
child tables are executed concurrently. For example:

Tables with foreign keys: t1<-t2<-t3<-t4
Conflicting transactions: INSERT t1 and DROP TABLE t4

Wsrep certification keys taken on write node:
- for INSERT t1: t1 and t2
- for DROP TABLE t4: t4

On applier node MDL BF-BF conflict happened between two transaction because
MDL locks on t1, t2, t3 and t4 were taken for INSERT t1, which conflicted
with MDL lock on t4 taken by DROP TABLE t4.
The Wsrep certification keys helps in resolving this MDL BF-BF conflict by
prioritizing and scheduling concurrent transactions. But to generate Wsrep
certification keys it needs to open and take MDL locks on all the child tables.

On applier nodes Write_rows event is implicitly a REPLACE, deleting all conflicting
rows which can cause cascading FK actions and locks on foreign key children tables.

Solution:
For Galera applier nodes the Write_rows event is considered pure INSERT
which will never cause cascading FK actions and locks on foreign key children tables.
2547a4c3efd3...
2547a4c3efd382568cc30f532d527f47e6dbe517
Andrei Elkin
Revert "MDEV-37686 rpl.create_or_replace_mix2 fails in MDEV-35915 branch"

This reverts commit 3241798214b066d62ba3274ba5dc29549349ca65.
Due to MDEV-38212.
1eddbceb5a52...
1eddbceb5a52735451492af583ac1259ba8cee9f
Sergei Golubchik
relax assert to account for recursive RETURNS TEXT functions
1dc9ee5b66aa...
1dc9ee5b66aa74ce2f10de4b86bfe86470bd5e9f
Sergei Golubchik
clarify the test for triggers with different paths
1ca108de7a6c...
1ca108de7a6ca5ececb962d022ca8fcd2b6be249
Sergei Golubchik
use standard SET PATH syntax in tests
1ad47afd072e...
1ad47afd072e90c3a4dc4e9ab0da1d8b076a8486
Sergei Golubchik
bug: `current_schema` is not current_schema

quoted `current_schema` is literally a schema name and must
but treated as such. because Sql_path stores all names unquoted
let's store the current_schema as an empty name, length=0.
No valid schema name can be empty.
10cb25e642b0...
10cb25e642b0cbd5525a7629ff43cfec08a8b9a7
Oleksandr Byelkin
MDEV-38126:fix the version of server_audit plugin taking into account its feature set
05bc3a8a194b...
05bc3a8a194b2f080c67061cd0b95f62e44d1fda
Sergei Golubchik
cache routines during path resolution
03f3b107691d...
03f3b107691dbf98708a8853af26ae9db1962a89
Alexander Barkov
FETCH anchored_cursor_with_return INTO var1,var2,var3
BuildBot (0.8.9) working for the MariaDB project.
Page built: Fri 05 Dec 2025 22:57:12 (UTC)