diff options
| author | Konstantin Osipov <kostja@sun.com> | 2010-04-14 01:56:19 +0400 |
|---|---|---|
| committer | Konstantin Osipov <kostja@sun.com> | 2010-04-14 01:56:19 +0400 |
| commit | b8d014b8f6671395b9965b5a9953f5b2efa0fd15 (patch) | |
| tree | 7a87035df6e8d664a8301574158d57d8305c65cf /sql/item.h | |
| parent | 03b1cdd04549c754a24e996f1aefd4e3a050af49 (diff) | |
| download | mariadb-git-b8d014b8f6671395b9965b5a9953f5b2efa0fd15.tar.gz | |
A fix for Bug#11918 "SP does not accept variables in LIMIT clause"
Allow stored procedure variables in LIMIT clause.
Only allow variables of INTEGER types.
Handle negative values by means of an implicit cast to UNSIGNED
(similarly to prepared statement placeholders).
Add tests.
Make sure replication works by not doing NAME_CONST substitution
for variables in LIMIT clause.
Add replication tests.
Diffstat (limited to 'sql/item.h')
| -rw-r--r-- | sql/item.h | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/item.h b/sql/item.h index 4241074c659..11b4199da2c 100644 --- a/sql/item.h +++ b/sql/item.h @@ -1302,6 +1302,13 @@ class Item_splocal :public Item_sp_variable, Item_result m_result_type; enum_field_types m_field_type; public: + /* + Is this variable a parameter in LIMIT clause. + Used only during NAME_CONST substitution, to not append + NAME_CONST to the resulting query and thus not break + the slave. + */ + bool limit_clause_param; /* Position of this reference to SP variable in the statement (the statement itself is in sp_instr_stmt::m_query). |