diff options
author | Dmitry Shulga <dmitry.shulga@mariadb.com> | 2021-04-26 10:47:10 +0700 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2021-06-17 19:30:24 +0200 |
commit | 7586eead5d5f323d9d95b73c21de51e6b992d8c7 (patch) | |
tree | c29369cbef48d79004e6280e9ea0be296cbdde1f /mysql-test/main/ps.test | |
parent | 327402291a8239579f8c80297bb01676d25ab25d (diff) | |
download | mariadb-git-7586eead5d5f323d9d95b73c21de51e6b992d8c7.tar.gz |
MDEV-16708: Unsupported commands for prepared statements
Disable running of the statements
PREPARE FROM/EXECUTE/EXECUTE IMMEDIATE/DEALLOCATE
in PS mode. Adjust tests main.ps, main.ps_1general
Diffstat (limited to 'mysql-test/main/ps.test')
-rw-r--r-- | mysql-test/main/ps.test | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/mysql-test/main/ps.test b/mysql-test/main/ps.test index 5933aea4a03..e5285022efd 100644 --- a/mysql-test/main/ps.test +++ b/mysql-test/main/ps.test @@ -38,10 +38,12 @@ deallocate prepare no_such_statement; execute stmt1; # Nesting ps commands is now allowed: +--error ER_UNSUPPORTED_PS prepare stmt2 from 'prepare nested_stmt from "select 1"'; +--error ER_UNSUPPORTED_PS prepare stmt2 from 'execute stmt1'; +--error ER_UNSUPPORTED_PS prepare stmt2 from 'deallocate prepare z'; -deallocate prepare stmt2; # PS insert prepare stmt3 from 'insert into t1 values (?,?)'; @@ -4193,12 +4195,16 @@ EXECUTE IMMEDIATE 'SELECT 1' USING @a; --error ER_WRONG_ARGUMENTS EXECUTE IMMEDIATE 'SELECT ?'; +--error ER_UNSUPPORTED_PS EXECUTE IMMEDIATE 'EXECUTE IMMEDIATE "SELECT 1"'; +--error ER_UNSUPPORTED_PS EXECUTE IMMEDIATE 'PREPARE stmt FROM "SELECT 1"'; +--error ER_UNSUPPORTED_PS EXECUTE IMMEDIATE 'EXECUTE stmt'; +--error ER_UNSUPPORTED_PS EXECUTE IMMEDIATE 'DEALLOCATE PREPARE stmt'; --error ER_CANT_AGGREGATE_2COLLATIONS |