129
130
Note 1050 Table 't2' already exists
130
131
DROP DATABASE testdb;
135
# Bug#11763507 - 56224: FUNCTION NAME IS CASE-SENSITIVE
138
CREATE FUNCTION testf_bug11763507() RETURNS INT
143
CREATE PROCEDURE testp_bug11763507()
145
SELECT "PROCEDURE testp_bug11763507";
148
SELECT testf_bug11763507();
151
SELECT TESTF_bug11763507();
154
SHOW FUNCTION STATUS LIKE 'testf_bug11763507';
155
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
156
test testf_bug11763507 FUNCTION root@localhost # # DEFINER latin1 latin1_swedish_ci latin1_swedish_ci
157
SHOW FUNCTION STATUS WHERE NAME='testf_bug11763507';
158
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
159
test testf_bug11763507 FUNCTION root@localhost # # DEFINER latin1 latin1_swedish_ci latin1_swedish_ci
160
SHOW FUNCTION STATUS LIKE 'TESTF_bug11763507';
161
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
162
test testf_bug11763507 FUNCTION root@localhost # # DEFINER latin1 latin1_swedish_ci latin1_swedish_ci
163
SHOW FUNCTION STATUS WHERE NAME='TESTF_bug11763507';
164
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
165
test testf_bug11763507 FUNCTION root@localhost # # DEFINER latin1 latin1_swedish_ci latin1_swedish_ci
166
SHOW CREATE FUNCTION testf_bug11763507;
167
Function sql_mode Create Function character_set_client collation_connection Database Collation
168
testf_bug11763507 CREATE DEFINER=`root`@`localhost` FUNCTION `testf_bug11763507`() RETURNS int(11)
171
END latin1 latin1_swedish_ci latin1_swedish_ci
172
SHOW CREATE FUNCTION TESTF_bug11763507;
173
Function sql_mode Create Function character_set_client collation_connection Database Collation
174
testf_bug11763507 CREATE DEFINER=`root`@`localhost` FUNCTION `testf_bug11763507`() RETURNS int(11)
177
END latin1 latin1_swedish_ci latin1_swedish_ci
178
CALL testp_bug11763507();
179
PROCEDURE testp_bug11763507
180
PROCEDURE testp_bug11763507
181
CALL TESTP_bug11763507();
182
PROCEDURE testp_bug11763507
183
PROCEDURE testp_bug11763507
184
SHOW PROCEDURE STATUS LIKE 'testp_bug11763507';
185
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
186
test testp_bug11763507 PROCEDURE root@localhost # # DEFINER latin1 latin1_swedish_ci latin1_swedish_ci
187
SHOW PROCEDURE STATUS WHERE NAME='testp_bug11763507';
188
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
189
test testp_bug11763507 PROCEDURE root@localhost # # DEFINER latin1 latin1_swedish_ci latin1_swedish_ci
190
SHOW PROCEDURE STATUS LIKE 'TESTP_bug11763507';
191
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
192
test testp_bug11763507 PROCEDURE root@localhost # # DEFINER latin1 latin1_swedish_ci latin1_swedish_ci
193
SHOW PROCEDURE STATUS WHERE NAME='TESTP_bug11763507';
194
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
195
test testp_bug11763507 PROCEDURE root@localhost # # DEFINER latin1 latin1_swedish_ci latin1_swedish_ci
196
SHOW CREATE PROCEDURE testp_bug11763507;
197
Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
198
testp_bug11763507 CREATE DEFINER=`root`@`localhost` PROCEDURE `testp_bug11763507`()
200
SELECT "PROCEDURE testp_bug11763507";
201
END latin1 latin1_swedish_ci latin1_swedish_ci
202
SHOW CREATE PROCEDURE TESTP_bug11763507;
203
Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
204
testp_bug11763507 CREATE DEFINER=`root`@`localhost` PROCEDURE `testp_bug11763507`()
206
SELECT "PROCEDURE testp_bug11763507";
207
END latin1 latin1_swedish_ci latin1_swedish_ci
208
SELECT specific_name FROM INFORMATION_SCHEMA.ROUTINES WHERE specific_name LIKE 'testf_bug11763507';
211
SELECT specific_name FROM INFORMATION_SCHEMA.ROUTINES WHERE specific_name LIKE 'TESTF_bug11763507';
214
SELECT specific_name FROM INFORMATION_SCHEMA.ROUTINES WHERE specific_name='testf_bug11763507';
217
SELECT specific_name FROM INFORMATION_SCHEMA.ROUTINES WHERE specific_name='TESTF_bug11763507';
220
DROP PROCEDURE testp_bug11763507;
221
DROP FUNCTION testf_bug11763507;
222
#END OF BUG#11763507 test.