You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
36 lines
1.0 KiB
36 lines
1.0 KiB
# Tests for bug and features related to prelocking which require
|
|
# case-sensitive file system.
|
|
--source include/have_case_sensitive_file_system.inc
|
|
|
|
--echo #
|
|
--echo # Bug #25807393 "IMPROPER HANDLING OF DATABASE NAMES WHEN LOCKING TABLES
|
|
--echo # FOR TRIGGER EXECUTION.".
|
|
--echo #
|
|
create table t1 (i int);
|
|
create table t2 (i int);
|
|
create database mysqltest_A;
|
|
use mysqltest_A;
|
|
create table t1 (i int);
|
|
create trigger trg before insert on t1 for each row
|
|
insert into test.t1 values (1);
|
|
create database mysqltest_a;
|
|
use mysqltest_a;
|
|
create table t2 (i int);
|
|
create trigger trg before insert on t2 for each row
|
|
insert into test.t2 values (1);
|
|
use test;
|
|
delimiter |;
|
|
create function f1() returns int
|
|
begin
|
|
insert into mysqltest_A.t1 values (1);
|
|
insert into mysqltest_a.t2 values (1);
|
|
return 0;
|
|
end|
|
|
delimiter ;|
|
|
# The below statement has failed with "Table 'test.t1' doesn't exist" error
|
|
# prior to fix.
|
|
select f1();
|
|
drop database mysqltest_A;
|
|
drop database mysqltest_a;
|
|
drop tables t1, t2;
|
|
drop function f1;
|
|
|