Commit Graph

175 Commits

Author SHA1 Message Date
Shlomi Noach
a23e5adc48 added test expecting failure in case-change to shared key column name 2017-07-12 12:41:10 +03:00
Shlomi Noach
bf5489a56d handling column name case change 2017-07-12 11:59:39 +03:00
Shlomi Noach
8f84be1f70 no --postpone-cut-over-flag-file in tests 2017-05-07 14:59:55 +03:00
Shlomi Noach
7f62efba91 tests to only check non dropped columns 2017-04-23 08:48:06 +03:00
Shlomi Noach
b0469b95b5 further fixes to the test case 2017-04-23 08:37:48 +03:00
Shlomi Noach
acd78b392f adding tests for dropping-then-adding a column 2017-04-23 08:00:28 +03:00
Shlomi Noach
8219209c8d tests accept postpone flag file 2017-01-29 09:25:58 +02:00
Shlomi Noach
56ab127b0b Merge branch 'master' into unsigned-int 2017-01-22 07:48:50 +02:00
Shlomi Noach
fae95fc3e1 Added test for swapping uniqye keys without pk 2017-01-10 12:43:06 +02:00
Shlomi Noach
dd9a3e1d0c adding PK, UK, PK-to-UK conversion tests 2017-01-10 12:35:42 +02:00
Shlomi Noach
36a66e0c05 supporting customized 'order by' in tests 2017-01-10 12:35:10 +02:00
Shlomi Noach
115e325d7c sanity replication restart before each test 2017-01-10 11:22:00 +02:00
Shlomi Noach
a07a6f8cf5 fixing mediumint unsigned problem 2017-01-10 09:57:42 +02:00
Shlomi Noach
67cfba3ce4 simplified test 2017-01-10 09:24:57 +02:00
Shlomi Noach
374e82c8eb having the test reproduce the problem for which it was created 2017-01-10 09:17:49 +02:00
Shlomi Noach
1921b0f9df complicating the test 2017-01-10 09:13:05 +02:00
Shlomi Noach
5ba98a627c localtests for unsigned-int 2017-01-09 15:40:29 +02:00
Shlomi Noach
1d84cb933c fix: bailing out on no PRIMARY/UNIQUE KEY 2016-12-11 02:19:19 +01:00
Shlomi Noach
e157f692d5 added 'trivial' test 2016-12-05 13:41:31 +01:00
Shlomi Noach
5119ea4d31 added tests to verify no false positives rename-column found 2016-11-29 11:08:35 +01:00
Shlomi Noach
5d9bac1c97 Merge branch 'master' into more-charset-tests 2016-11-01 12:22:42 +01:00
Shlomi Noach
0e7e15804f handling subsecond resolution DATETIME in binary logs
added localtests for subsecond in DATETIME and TIMESTAMP
2016-10-31 15:09:02 +01:00
Shlomi Noach
0bfff66b51 more DML tests for latin1 2016-10-26 20:03:09 +02:00
Shlomi Noach
25166e33c7 solving the enum-as-part-of-pk bug 2016-10-19 15:22:29 +02:00
Shlomi Noach
3986696813 testing enum as part of PK
reference: https://github.com/github/gh-ost/issues/273

enum values are intentionally not alphabetically monotonic
2016-10-19 11:57:37 +02:00
Shlomi Noach
0ee94e4d21 refined failure tests 2016-10-14 09:34:27 +02:00
Shlomi Noach
ee236744dc testing failure of conversion within chosen key 2016-10-14 09:34:13 +02:00
Shlomi Noach
7c22f25afa support for expected_failure explicit message 2016-10-14 09:33:25 +02:00
Shlomi Noach
e1ac5583e6 support for 'destroy' in testing 2016-10-14 09:05:38 +02:00
Shlomi Noach
d85c9dce1b added/fixed tests 2016-10-13 13:13:51 +02:00
Shlomi Noach
c3e307537b localtests build binary once 2016-10-13 13:13:28 +02:00
Shlomi Noach
184643157b Merge branch 'master' into tz-a-different-approach 2016-10-12 08:33:19 +02:00
Shlomi Noach
5de8a010df restoring original row_event code; tampering with applier time_zone based on global timze_zone 2016-10-10 22:33:54 +02:00
Shlomi Noach
4d4af07295 more tests for foreign keys, including expected failures 2016-10-10 12:29:25 +02:00
Shlomi Noach
56e0833389 support for expect_failure on localtests 2016-10-10 12:28:13 +02:00
Shlomi Noach
a8f75f73ba supporting extra-args in tz tests 2016-10-10 11:43:43 +02:00
Shlomi Noach
8e5c9cd5e1 adding fk tests 2016-10-08 11:07:01 +02:00
Shlomi Noach
0c35a811f7 setting time_zoe='+00:00' on rowcopy 2016-10-08 11:06:27 +02:00
Shlomi Noach
f5d5cc8d8c Merge branch 'master' into test-datetime-timestamp 2016-09-29 10:20:59 +02:00
Shlomi Noach
ddf4f88338 refined tests: tz-datetime only tests datetime issues; tz-datetime-ts converts datetime to timestamp 2016-09-28 10:28:21 +02:00
Shlomi Noach
420370433d adding datetime->timestamp conversion test 2016-09-28 09:44:05 +02:00
Shlomi Noach
db2c8a254f added update/delete tests for multi-charset/alter tests 2016-09-27 12:57:05 +02:00
Shlomi Noach
109ddb0452 fixed integer random values 2016-09-27 12:56:37 +02:00
Shlomi Noach
253e0a1406 columns not null in test 2016-09-27 12:45:22 +02:00
Shlomi Noach
d32534710e added tests for unsigned rename/reorder 2016-09-27 12:41:46 +02:00
Shlomi Noach
e256e06826 Merge remote-tracking branch 'origin/master' into binlog_insert_column_lookup_issue 2016-09-27 11:05:59 +02:00
Shlomi Noach
63419b3636 added test for renaming and reordering same column 2016-09-21 09:45:36 +02:00
Shlomi Noach
2bf882de16 added rename & reorder test 2016-09-21 09:01:33 +02:00
Shlomi Noach
53ef6eae5a added tests for column-reorder 2016-09-20 16:00:07 +02:00
Paulo Bittencourt
8c5dcca187 Add test for modifying columns to different charsets 2016-09-19 09:37:08 -04:00
Paulo Bittencourt
25b5474cfa Add test case for renaming a column and only applying inserts
This catches a bug in `sql.BuildDMLInsertQuery` where we we are fetching
the insert values using the renamed column's name, and end up fetching
the value of the wrong column.

The test in `localtests/rename` did not catch this because binlog
update events were "correcting" the error, as they follow a different
code path that does not contain the bug.
2016-09-14 11:28:30 -04:00
Paulo Bittencourt
671fc71067 Add test case for altering a column's charset
This catches a bug in `sql.BuildDMLInsertQuery` where we are using the target
column's Charset to drive the value conversion.  In the case where we are
altering the charset, the Charset used for conversion will be different than
the original column's charset, resulting in an erroneous conversion.
2016-09-14 11:26:43 -04:00
Shlomi Noach
dc3a03ad6f added mixed-charset tests 2016-09-08 09:27:18 +02:00
Shlomi Noach
791d963ea0 Character set recognition and manipulation
- Identifying textual characters sets; converting into specific type when applying dml events
- Refactored `ColumnsList`: introducing `Column` type
- Refactored `unsigned` handling, as part of `Column`
- `Column` type supports `convertArg()`: converting value of argument according to column data type
- DB URI attempts `utf8mb4,utf8,latin1` charsets in that order (first one to be recognized wins)
- Local tests filter by pattern
- Local tests append table schema on failure
- Local tests do not have postpone flag file
- Added character set local tests: `utf8`, `utf8mb4`, `latin1`
2016-09-07 14:24:11 +02:00
Shlomi Noach
f646021527 added utf8mb4 test 2016-09-06 12:15:53 +02:00
Shlomi Noach
095c607f45 clarified test argument 2016-09-06 09:46:11 +02:00
Shlomi Noach
31a3add1b0 text tests 2016-09-06 09:38:41 +02:00
Shlomi Noach
0adf258b13 added charset tests 2016-09-06 09:36:29 +02:00
Shlomi Noach
b0a2e4c650 graceful sleep for replica lag 2016-08-24 14:18:49 +02:00
Shlomi Noach
79399f446b added documentation for local tests 2016-08-24 12:51:01 +02:00
Shlomi Noach
ec7f641ecb added enum tests 2016-08-23 12:13:40 +02:00
Shlomi Noach
b380578f53 improved rename:DELETE test 2016-08-22 16:35:21 +02:00
Shlomi Noach
f947c46e3c improved rename:DELETE test 2016-08-22 16:34:00 +02:00
Shlomi Noach
f33bebb527 improved rename:DELETE test 2016-08-22 16:33:03 +02:00
Shlomi Noach
1bd93bda70 localtest: rename: testing for DELETE 2016-08-22 16:28:40 +02:00
Shlomi Noach
7a2e3146a2 fixed alter statement in rename test 2016-08-22 15:53:44 +02:00
Shlomi Noach
61237f9e93 rename 2016-08-22 15:49:48 +02:00
Shlomi Noach
2faa27a2c4 elaborate output on failure 2016-08-22 15:43:00 +02:00
Shlomi Noach
6a20808389 adding timezone tests 2016-08-22 15:42:06 +02:00
Shlomi Noach
4c78520f3d fixed argument extrapolation 2016-08-22 12:18:02 +02:00
Shlomi Noach
745fce249c working on extra_args, incomplete 2016-08-22 11:51:03 +02:00
Shlomi Noach
2831a6dc86 adding rename test 2016-08-22 11:50:50 +02:00
Shlomi Noach
744f009b3b remove redundant file 2016-08-22 11:14:06 +02:00
Shlomi Noach
a50f7637a4 working testing suite 2016-08-22 11:13:18 +02:00
Shlomi Noach
0bb8d70fce initial preparation for local tests 2016-08-22 09:20:17 +02:00