LOAD DATA INFILE INSERTs not registered by the transaction log
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
Fix Released
|
Medium
|
David Shrewsbury | ||
Dexter |
Fix Released
|
Medium
|
David Shrewsbury |
Bug Description
The transaction log does not appear to be capturing INSERTs from LOAD DATA INFILE operations.
From the test transaction_
./test-run --suite=
--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings
CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT, b CHAR(50), PRIMARY KEY(a) );
LOAD DATA INFILE '../std_
--source ../plugin/
--echo
DROP TABLE t1;
Result in this data in t1:
SELECT * FROM t1;
a b
1 abbazabba
2 my_only_friend
However, only the CREATE TABLE t1 statement is logged.
This may not be a bug, but it seems that adding data to a table by any means should be logged.
Related branches
- Drizzle Merge Team: Pending requested
-
Diff: 743 lines (+306/-105)4 files modifieddrizzled/cursor.cc (+1/-0)
drizzled/message/transaction_reader.cc (+56/-2)
drizzled/transaction_services.cc (+171/-39)
drizzled/transaction_services.h (+78/-64)
Changed in drizzle: | |
assignee: | nobody → David Shrewsbury (dshrews) |
importance: | Undecided → Medium |
Confirmed with revno 1712.