22 Commits

Author SHA1 Message Date
Sveta Smirnova
f837672d1d Merge pull request #861 from hpoettker/PT-2377_table_sync_with_utf8_json
PT-2377 - fixed pt-table-sync for JSON utf8 strings
2025-01-14 18:04:41 +03:00
Henning Poettker
16b06dcfc2 PT-2377 - fixed pt-table-sync for JSON utf8 strings
The MySQL driver DBD::mysql does not decode JSON values as utf8
although MySQL uses utf8mb4 for all JSON strings.

This change decodes JSON values as utf8 (when not already done)
such that SQL statements are generated correctly.
2024-12-27 13:46:55 +01:00
Henning Poettker
5f14441d19 PT-2375 - fixed pt-table-sync for tables with generated columns
Previously, pt-table-sync generated DML statements that included
the generated columns of a table, which is however rejected by
the database and not necessary for the required sync statements.
2024-11-14 23:51:40 +01:00
Viktor Szépe
2bd40d8c39 Remove trailing spaces (#665)
* Remove trailing spaces

* PR-665 -  Remove trailing spaces

- Updated not stable test t/pt-online-schema-change/preserve_triggers.t
- Updated utilities in bin directory

* PR-665 -  Remove trailing spaces

- Fixed typos

* PR-665 -  Remove trailing spaces

- Fixed typos

---------

Co-authored-by: Sveta Smirnova <sveta.smirnova@percona.com>
2023-09-06 01:15:12 +03:00
Viktor Szépe
c57441be8c War on typos Act 1 (#655)
* Fix typos in lib/ directory

* Update generated bin/ files

* PR 655 -  War on typos Act 1 #655

- Updated modules in tools that were not updated
- Fixed tests to reflect proposed changes

---------

Co-authored-by: Sveta Smirnova <sveta.smirnova@percona.com>
2023-08-22 16:18:38 +03:00
Carlos Salguero
c5a22407a7 PT-2016 pt-table-sync and CRC32 columns (#521)
* PT-2016 CRC32 on key

* PT-2016 Added tests

* Removed commented out line
2021-11-03 13:53:30 -03:00
Carlos Salguero
3b6f1c3aff PT-96 Fixes for ChangeHandler & TableSync 2017-03-10 14:51:43 -03:00
Carlos Salguero
e414820c7f Merge commit 'b09e70a' into PT-96 2017-03-10 11:57:55 -03:00
Carlos Salguero
b09e70a5a2 PT-96 Fixed changehandler sort that were causing problems. 2017-03-10 11:55:23 -03:00
Carlos Salguero
0118c93cc3 PT-96 Made TableSyncer testeable 2017-03-10 09:32:34 -03:00
Carlos Salguero
9a5b0d4b95 PT-96 Made TableSyncChunk testeable 2017-03-10 00:19:52 -03:00
Daniel Kinon
0053d01aed Adding enum fix to ChangeHandler.pm 2016-07-11 10:34:33 -07:00
Daniel Nichter
166173a318 Don't quote FLOAT or DOUBLE in Quoter::quote_val(). 2013-10-10 15:58:02 -07:00
Daniel Nichter
feab2f0925 s/Percona Inc/Percona Ireland Ltd/g 2013-01-02 17:19:16 -07:00
Brian Fraser fraserb@gmail.com
031cc1751c ChangeHandler: Don't hexify text columns.
As far as I understand, it doesn't make any sense to hexify text
columns; they break in many ways (you can't roundtrip the UTFs,
quote_val gets the hex quoting wrong, etc) and in any case,
the maatkit bugs about the feature are all about blob/binary
columns.

And, while a perilous excercise of genetic programming, removing
it didn't break any pt-table-sync tests, so this commit does
exactly that.
2012-08-27 15:04:51 -03:00
Brian Fraser
b84ac535d2 Merged fix-1038276-changehandler-hex-looking-vals 2012-08-24 20:26:04 -03:00
Brian Fraser
e52ca00348 Fix for 1038276: ChangeHandler doesn't quote varchar columns with hex-looking values 2012-08-22 16:19:43 -03:00
Brian Fraser
9a788e16df Fix for 930693: ChangeHandler and text columns with just whitespace 2012-08-16 14:07:58 -03:00
Daniel Nichter
88304e69fb Replace MKDEBUG with PTDEBUG in modules. 2012-01-19 12:46:56 -07:00
Daniel Nichter
b805f7c92d Remove $Revision$ and finish re-branding modules. Rename MaatkitTest.pm to PerconaTest.pm. Put copyrights on one line. 2011-07-12 15:47:07 -06:00
Daniel Nichter
55c69ffbc1 Move module docu to work for NaturalDocs. 2011-07-02 12:29:08 -06:00
Daniel Nichter
6c501128e6 Add lib/, t/lib/, and sandbox/. All modules are updated and passing on MySQL 5.1. 2011-06-24 11:22:06 -06:00