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 /Docs | |
| 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 'Docs')
| -rw-r--r-- | Docs/sp-imp-spec.txt | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/Docs/sp-imp-spec.txt b/Docs/sp-imp-spec.txt index 24a47aa2c38..ac17a375926 100644 --- a/Docs/sp-imp-spec.txt +++ b/Docs/sp-imp-spec.txt @@ -1057,9 +1057,9 @@ CREATE TABLE proc ( db char(64) binary DEFAULT '' NOT NULL, - name char(64) binary DEFAULT '' NOT NULL, + name char(64) DEFAULT '' NOT NULL, type enum('FUNCTION','PROCEDURE') NOT NULL, - specific_name char(64) binary DEFAULT '' NOT NULL, + specific_name char(64) DEFAULT '' NOT NULL, language enum('SQL') DEFAULT 'SQL' NOT NULL, sql_data_access enum('CONTAINS_SQL') DEFAULT 'CONTAINS_SQL' NOT NULL, is_deterministic enum('YES','NO') DEFAULT 'NO' NOT NULL, |