Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Validate mulitple events in the position range #2

Open
lefred opened this issue Nov 30, 2014 · 1 comment
Open

Validate mulitple events in the position range #2

lefred opened this issue Nov 30, 2014 · 1 comment

Comments

@lefred
Copy link
Owner

lefred commented Nov 30, 2014

No description provided.

@lefred
Copy link
Owner Author

lefred commented Nov 30, 2014

This doesn't work,
only one BEGIN and COMMIT needs to be run at the time.

| mysql-bin.000008 | 1514 | Query       |         1 |        1586 | BEGIN                                 |
| mysql-bin.000008 | 1586 | Table_map   |         1 |        1636 | table_id: 72 (fred.fred)              |
| mysql-bin.000008 | 1636 | Delete_rows |         1 |        1694 | table_id: 72 flags: STMT_END_F        |
| mysql-bin.000008 | 1694 | Xid         |         1 |        1725 | COMMIT /* xid=146 */                  |
| mysql-bin.000008 | 1725 | Query       |         1 |        1797 | BEGIN                                 |
| mysql-bin.000008 | 1797 | Table_map   |         1 |        1847 | table_id: 72 (fred.fred)              |
| mysql-bin.000008 | 1847 | Delete_rows |         1 |        1898 | table_id: 72 flags: STMT_END_F        |
| mysql-bin.000008 | 1898 | Xid         |         1 |        1929 | COMMIT /* xid=147 */                  |

This requires 2 runs, one from 1586 to 1725 and one from 1797 to 1929.

I'll have to add some verification in the code.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant