diff options
| author | unknown <pem@mysql.comhem.se> | 2004-03-23 12:04:40 +0100 |
|---|---|---|
| committer | unknown <pem@mysql.comhem.se> | 2004-03-23 12:04:40 +0100 |
| commit | 220494bde06fe2c0b288845c9b027764341e443f (patch) | |
| tree | e1b3c90ba9364af795aae3308287a5fc445ee3c3 /mysql-test | |
| parent | 645d19f694c1237d4c9d34475dcbdc541e9f35d6 (diff) | |
| download | mariadb-git-220494bde06fe2c0b288845c9b027764341e443f.tar.gz | |
Fixed BUG#3259: Stored procedure names are case sensitive.
Procedure names were unintentionally case-sensitive when read from the database
(but case-insensitive when fetched from the cache).
Note that the DB-part of qualified names is still case-sensitive (for consistency
with other usage in mysql).
Docs/sp-imp-spec.txt:
Removed "binary" from name and specific_name columns in mysql.proc definition.
mysql-test/r/sp.result:
Test case for BUG#3259; SP names were supposed to be case-insensitive.
mysql-test/t/sp.test:
Test case for BUG#3259; SP names were supposed to be case-insensitive.
scripts/mysql_create_system_tables.sh:
Removed "binary" from name and specific_name columns in mysql.proc definition.
scripts/mysql_fix_privilege_tables.sql:
Removed "binary" from name and specific_name columns in mysql.proc definition,
and added a corresponding ALTER TABLE to fix existing tables.
sql/sp.cc:
Added missing init of variable.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/sp.result | 12 | ||||
| -rw-r--r-- | mysql-test/t/sp.test | 19 |
2 files changed, 31 insertions, 0 deletions
diff --git a/mysql-test/r/sp.result b/mysql-test/r/sp.result index 620f22aca68..1f3064605bc 100644 --- a/mysql-test/r/sp.result +++ b/mysql-test/r/sp.result @@ -1000,6 +1000,18 @@ select bug2674()| bug2674() 262136 drop function bug2674| +create procedure bug3259_1 () begin end| +create procedure BUG3259_2 () begin end| +create procedure Bug3259_3 () begin end| +call BUG3259_1()| +call BUG3259_1()| +call bug3259_2()| +call Bug3259_2()| +call bug3259_3()| +call bUG3259_3()| +drop procedure bUg3259_1| +drop procedure BuG3259_2| +drop procedure BUG3259_3| drop table if exists fac| create table fac (n int unsigned not null primary key, f bigint unsigned)| create procedure ifac(n int unsigned) diff --git a/mysql-test/t/sp.test b/mysql-test/t/sp.test index 943e150ce1f..69433514728 100644 --- a/mysql-test/t/sp.test +++ b/mysql-test/t/sp.test @@ -1159,6 +1159,25 @@ create function bug2674 () returns int select bug2674()| drop function bug2674| +# +# BUG#3259 +# + +create procedure bug3259_1 () begin end| +create procedure BUG3259_2 () begin end| +create procedure Bug3259_3 () begin end| + +call BUG3259_1()| +call BUG3259_1()| +call bug3259_2()| +call Bug3259_2()| +call bug3259_3()| +call bUG3259_3()| + +drop procedure bUg3259_1| +drop procedure BuG3259_2| +drop procedure BUG3259_3| + # # Some "real" examples |