diff options
author | Luis Soares <luis.soares@sun.com> | 2009-10-27 15:15:53 +0000 |
---|---|---|
committer | Luis Soares <luis.soares@sun.com> | 2009-10-27 15:15:53 +0000 |
commit | a3829176845d5f357d5d6a3288543cec93ba2450 (patch) | |
tree | 1cf73005cabb5c5d2ae471fa5fe2357d1e51fee4 /plugin | |
parent | 74b0f6be2fd8f0f46f490fd2b10f6dbfef9dad41 (diff) | |
download | mariadb-git-a3829176845d5f357d5d6a3288543cec93ba2450.tar.gz |
BUG#48297: Schema name is ignored when LOAD DATA is written into
binlog, replication aborts
In SBR or MBR, the schema name is not being written to the binlog
when executing a LOAD DATA statement. This becomes a problem when
the current database (lets call it db1) is different from the
table's schema (lets call it db2). For instance, take the
following statements:
use db1;
load data local infile 'infile.txt' into table db2.t
Should this statement be logged without t's schema (db2), when
replaying it, one can get db1.t populated instead of db2.t (if
db1.t exists). On the other hand, if there is no db1.t at all,
replication will stop.
We fix this by always logging the table (in load file) with fully
qualified name when its schema is different from the current
database or when no default database was selected.
Diffstat (limited to 'plugin')
0 files changed, 0 insertions, 0 deletions