diff options
| author | unknown <konstantin@mysql.com> | 2004-11-05 22:02:07 +0300 |
|---|---|---|
| committer | unknown <konstantin@mysql.com> | 2004-11-05 22:02:07 +0300 |
| commit | 01df29fdd57c091cd36ad26828734a3f7f7e6faa (patch) | |
| tree | 6506efd1bf1a077deccfa6ecc196387ffbc38906 /mysql-test/t/ps.test | |
| parent | f833dc815b9c69e13a2e0032419555b36147666d (diff) | |
| download | mariadb-git-01df29fdd57c091cd36ad26828734a3f7f7e6faa.tar.gz | |
A fix and test case for Bug#6102 "Server crash with prepared statement
and blank after function name".
Crop fruits of copy-paste programming: pre-caching of stored functions
wasn't performed for prepared statements just because implementation
of prepared statements is done as an add-on to the main execution flow,
and the preload was originally implemented for main execution branch
only (mysql_execute_command).
mysql-test/r/ps.result:
Test results fixed: bug#6102
mysql-test/t/ps.test:
A test case for Bug#6102 "Server crash with prepared statement
and blank after functionname"
sql/sql_prepare.cc:
A fix for Bug#6102 "Server crash with prepared statement and blank
after functionname": we need to preload stored functions from system tables
before we open any other tables.
Diffstat (limited to 'mysql-test/t/ps.test')
| -rw-r--r-- | mysql-test/t/ps.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/ps.test b/mysql-test/t/ps.test index 978ce2bc2c3..8bd535a08ec 100644 --- a/mysql-test/t/ps.test +++ b/mysql-test/t/ps.test @@ -462,3 +462,14 @@ EXECUTE stmt; DEALLOCATE PREPARE stmt; DROP TABLE t1; +# +# Bug#6102 "Server crash with prepared statement and blank after +# function name" +# ensure that stored functions are cached when preparing a statement +# before we open tables +# +create table t1 (a varchar(20)); +insert into t1 values ('foo'); +--error 1305 +prepare stmt FROM 'SELECT char_length (a) FROM t1'; +drop table t1; |