131
132
Note 1050 Table 't2' already exists
132
133
DROP DATABASE testdb;
137
# Bug#11763507 - 56224: FUNCTION NAME IS CASE-SENSITIVE
140
CREATE FUNCTION testf_bug11763507() RETURNS INT
145
CREATE PROCEDURE testp_bug11763507()
147
SELECT "PROCEDURE testp_bug11763507";
150
SELECT testf_bug11763507();
153
SELECT TESTF_bug11763507();
156
SHOW FUNCTION STATUS LIKE 'testf_bug11763507';
157
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
158
test testf_bug11763507 FUNCTION root@localhost # # DEFINER latin1 latin1_swedish_ci latin1_swedish_ci
159
SHOW FUNCTION STATUS WHERE NAME='testf_bug11763507';
160
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
161
test testf_bug11763507 FUNCTION root@localhost # # DEFINER latin1 latin1_swedish_ci latin1_swedish_ci
162
SHOW FUNCTION STATUS LIKE 'TESTF_bug11763507';
163
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
164
test testf_bug11763507 FUNCTION root@localhost # # DEFINER latin1 latin1_swedish_ci latin1_swedish_ci
165
SHOW FUNCTION STATUS WHERE NAME='TESTF_bug11763507';
166
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
167
test testf_bug11763507 FUNCTION root@localhost # # DEFINER latin1 latin1_swedish_ci latin1_swedish_ci
168
SHOW CREATE FUNCTION testf_bug11763507;
169
Function sql_mode Create Function character_set_client collation_connection Database Collation
170
testf_bug11763507 CREATE DEFINER=`root`@`localhost` FUNCTION `testf_bug11763507`() RETURNS int(11)
173
END latin1 latin1_swedish_ci latin1_swedish_ci
174
SHOW CREATE FUNCTION TESTF_bug11763507;
175
Function sql_mode Create Function character_set_client collation_connection Database Collation
176
testf_bug11763507 CREATE DEFINER=`root`@`localhost` FUNCTION `testf_bug11763507`() RETURNS int(11)
179
END latin1 latin1_swedish_ci latin1_swedish_ci
180
CALL testp_bug11763507();
181
PROCEDURE testp_bug11763507
182
PROCEDURE testp_bug11763507
183
CALL TESTP_bug11763507();
184
PROCEDURE testp_bug11763507
185
PROCEDURE testp_bug11763507
186
SHOW PROCEDURE STATUS LIKE 'testp_bug11763507';
187
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
188
test testp_bug11763507 PROCEDURE root@localhost # # DEFINER latin1 latin1_swedish_ci latin1_swedish_ci
189
SHOW PROCEDURE STATUS WHERE NAME='testp_bug11763507';
190
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
191
test testp_bug11763507 PROCEDURE root@localhost # # DEFINER latin1 latin1_swedish_ci latin1_swedish_ci
192
SHOW PROCEDURE STATUS LIKE 'TESTP_bug11763507';
193
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
194
test testp_bug11763507 PROCEDURE root@localhost # # DEFINER latin1 latin1_swedish_ci latin1_swedish_ci
195
SHOW PROCEDURE STATUS WHERE NAME='TESTP_bug11763507';
196
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
197
test testp_bug11763507 PROCEDURE root@localhost # # DEFINER latin1 latin1_swedish_ci latin1_swedish_ci
198
SHOW CREATE PROCEDURE testp_bug11763507;
199
Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
200
testp_bug11763507 CREATE DEFINER=`root`@`localhost` PROCEDURE `testp_bug11763507`()
202
SELECT "PROCEDURE testp_bug11763507";
203
END latin1 latin1_swedish_ci latin1_swedish_ci
204
SHOW CREATE PROCEDURE TESTP_bug11763507;
205
Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
206
testp_bug11763507 CREATE DEFINER=`root`@`localhost` PROCEDURE `testp_bug11763507`()
208
SELECT "PROCEDURE testp_bug11763507";
209
END latin1 latin1_swedish_ci latin1_swedish_ci
210
SELECT specific_name FROM INFORMATION_SCHEMA.ROUTINES WHERE specific_name LIKE 'testf_bug11763507';
213
SELECT specific_name FROM INFORMATION_SCHEMA.ROUTINES WHERE specific_name LIKE 'TESTF_bug11763507';
216
SELECT specific_name FROM INFORMATION_SCHEMA.ROUTINES WHERE specific_name='testf_bug11763507';
219
SELECT specific_name FROM INFORMATION_SCHEMA.ROUTINES WHERE specific_name='TESTF_bug11763507';
222
DROP PROCEDURE testp_bug11763507;
223
DROP FUNCTION testf_bug11763507;
224
#END OF BUG#11763507 test.