diff options
| author | unknown <pem@mysql.comhem.se> | 2004-06-15 14:26:19 +0200 |
|---|---|---|
| committer | unknown <pem@mysql.comhem.se> | 2004-06-15 14:26:19 +0200 |
| commit | 05f9e4dd0ec743b352eb480ec8eab3af046b745d (patch) | |
| tree | 5e2d1fa612ee5fb62747669f6e5325cc3936c7fd /mysql-test/r/sp.result | |
| parent | 83703fcc16a056b2bc4cdef31ae3ddc788761d71 (diff) | |
| download | mariadb-git-05f9e4dd0ec743b352eb480ec8eab3af046b745d.tar.gz | |
Fixed BUG#3368: Stored procedure crash if group_concat(variable).
mysql-test/r/sp.result:
New test case for BUG#3368.
mysql-test/t/sp.test:
New test case for BUG#3368.
sql/item.h:
Corrected const_item() for item_splocal. (Confusing semantics here, but this
makes group_concat() behave as expected, instead of crashing, and does not
appear to affect anything else.)
Diffstat (limited to 'mysql-test/r/sp.result')
| -rw-r--r-- | mysql-test/r/sp.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/sp.result b/mysql-test/r/sp.result index 306b4ba89a8..7f496000644 100644 --- a/mysql-test/r/sp.result +++ b/mysql-test/r/sp.result @@ -1372,6 +1372,21 @@ select 1+2| 1+2 3 drop procedure bug3843| +drop table if exists t3| +create table t3 ( s1 char(10) )| +insert into t3 values ('a'), ('b')| +create procedure bug3368(v char(10)) +begin +select group_concat(v) from t3; +end| +call bug3368('x')| +group_concat(v) +x,x +call bug3368('yz')| +group_concat(v) +yz,yz +drop procedure bug3368| +drop table t3| drop table if exists fac| create table fac (n int unsigned not null primary key, f bigint unsigned)| create procedure ifac(n int unsigned) |