maria-developers team mailing list archive
Mailing list archive
Working on spider patches, MDEV-7698
I have now started to work on the spider patches for MariaDB 10.2, MDEV-7698.
I have moved all code from maria-10.1-spider to a new branch
maria-10.2-spider and added some more patches.
I have closed all related MDEV's in MDEV-7698 that is now included in
While doing this, I noticed that spider/handler test was not included
in the test suite. I added the missing suite.pm and suite.opt files
and got the tests to work.
However, when I tried to run test to verify my changes, I noticed that
a lot of test in spider/handler where failing:
produces these failures:
spider/handler.function spider/handler.ha spider/handler.vp_fixes
All failures are because .test and .result file doesn't match.
I checked the patch file:
but this doesn't include any updates to the handler test files:
grep mysql_test * returns nothing.
However the .tar file:
Contains a lot of updated .test and .result files.
Kentoku, do you have patches for the test files, or should I just take
them from the above spider branch or from somewhere else ?
After applying the patches:
I get the following change in spider/handler/basic_sql.result:
@@ -70,6 +70,12 @@ CREATE TABLE ta_l (
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1
IGNORE SELECT a, b, c FROM tb_l
+Warning 1062 Duplicate entry '1' for key 'PRIMARY'
+Warning 1062 Duplicate entry '2' for key 'PRIMARY'
+Warning 1062 Duplicate entry '3' for key 'PRIMARY'
+Warning 1062 Duplicate entry '4' for key 'PRIMARY'
+Warning 1062 Duplicate entry '5' for key 'PRIMARY'
I can't figure out,why we get the above warnings.
This is from a patch we discussed at booking.com one year ago. Any
explanation for the above warnings would be appreciated.
You can branch 10.2-spider and check the current state.