Fixed issue regarding to setting the variable gtid_slave_pos in PS mode
"
035d7b4...
by
Dmitry Shulga <email address hidden>
MDEV-16708: Unsupported commands for prepared statements
Fixed the test main.sp_security
0cd2f1e...
by
Dmitry Shulga <email address hidden>
MDEV-25302
Fixed issue regarding to setting the variable gtid_slave_pos in PS mode
e915b30...
by
Dmitry Shulga <email address hidden>
MDEV-16708: Unsupported commands for prepared statements
Added commands SQLCOM_CREATE_PACKAGE, SQLCOM_CREATE_PACKAGE_BODY
into assert in the function lex_end_stage1.
41cdfb4...
by
Dmitry Shulga <email address hidden>
MDEV-16708: Unsupported commands for prepared statements
Fixed the following issues:
The statement
explain select (select 2)
executed in regular and PS mode produces different results:
MariaDB [test]> prepare stmt from "explain select (select 2)";
Query OK, 0 rows affected (0,000 sec)
Statement prepared
MariaDB [test]> execute stmt;
+------+-------------+-------+------+---------------+------+---------+------+------+----------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+-------+------+---------------+------+---------+------+------+----------------+
| 1 | PRIMARY | NULL | NULL | NULL | NULL | NULL | NULL | NULL | No tables used |
| 2 | SUBQUERY | NULL | NULL | NULL | NULL | NULL | NULL | NULL | No tables used |
+------+-------------+-------+------+---------------+------+---------+------+------+----------------+
2 rows in set (0,000 sec)
MariaDB [test]> explain select (select 2);
+------+-------------+-------+------+---------------+------+---------+------+------+----------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+-------+------+---------------+------+---------+------+------+----------------+
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | No tables used |
+------+-------------+-------+------+---------------+------+---------+------+------+----------------+
1 row in set, 1 warning (0,000 sec)
In case the statement
CREATE TABLE t1 SELECT * FROM (SELECT 1 AS a, (SELECT a+0)) a
is run in PS mode it fails with the error
ERROR 1054 (42S22): Unknown column 'a' in 'field list'.
7ec8e76...
by
Dmitry Shulga <email address hidden>
MDEV-16708: Unsupported commands for prepared statements
Uniform handling of read-only variables both in case the SET var=val
statement is executed as regular or prepared statememt.
c5d00b1...
by
Dmitry Shulga <email address hidden>
MDEV-16708: Unsupported commands for prepared statements
Follow-up patch for the bug MDEV-25197 that fixes missed restoring
of thd->cur_stmt on returning error code.
3f7eced...
by
Dmitry Shulga <email address hidden>
MDEV-16708: Unsupported commands for prepared statements
Follow-up patch for the bug MDEV-25197 that fixes the same issue
in case binary protocol used for sending prepared statements
a6ffb93...
by
Dmitry Shulga <email address hidden>
MDEV-16708: Unsupported commands for prepared statements
Fixed the bug MDEV-25197
43a8407...
by
Dmitry Shulga <email address hidden>
MDEV-16708: Unsupported commands for prepared statements
Fixed the tests main.func_time, main.ps_missed_cmds_bin_prot
