I tried to reproduce this on a very simple table:
+----+----------+ | id | gne | +----+----------+ | 1 | 10:01:20 | | 2 | 00:02:29 | | 3 | 10:09:00 | | 4 | 10:09:00 | | 5 | 01:00:00 | | 6 | 09:00:00 | +----+----------+
Then after doing the full process, the dump file is:
-- Page id: 3, Format: COMPACT, Records list: Valid, Expected records: (6 6) 000000001B03 83000001350110 fred 1 "03:48:40" 000000001B05 85000001B00110 fred 2 "00:03:49" 000000001B0A 87000001770110 fred 3 "04:01:40" 000000001B0B 88000001E60110 fred 4 "04:01:40" 000000001B0D 8A000001750110 fred 5 "02:46:40" 000000001B0E 8B000001780110 fred 6 "01:00:00" -- Page id: 3, Found records: 6, Lost records: NO, Leaf page: YES
and dates are incorrect.
After applying the patch and running constraints_parser again, the dump file is correct:
-- Page id: 3, Format: COMPACT, Records list: Valid, Expected records: (6 6) 000000001B03 83000001350110 fred 1 "10:01:20" 000000001B05 85000001B00110 fred 2 "00:02:29" 000000001B0A 87000001770110 fred 3 "10:09:00" 000000001B0B 88000001E60110 fred 4 "10:09:00" 000000001B0D 8A000001750110 fred 5 "01:00:00" 000000001B0E 8B000001780110 fred 6 "09:00:00" -- Page id: 3, Found records: 6, Lost records: NO, Leaf page: YES
I tried to reproduce this on a very simple table:
+----+----------+
| id | gne |
+----+----------+
| 1 | 10:01:20 |
| 2 | 00:02:29 |
| 3 | 10:09:00 |
| 4 | 10:09:00 |
| 5 | 01:00:00 |
| 6 | 09:00:00 |
+----+----------+
Then after doing the full process, the dump file is:
-- Page id: 3, Format: COMPACT, Records list: Valid, Expected records: (6 6)
000000001B03 83000001350110 fred 1 "03:48:40"
000000001B05 85000001B00110 fred 2 "00:03:49"
000000001B0A 87000001770110 fred 3 "04:01:40"
000000001B0B 88000001E60110 fred 4 "04:01:40"
000000001B0D 8A000001750110 fred 5 "02:46:40"
000000001B0E 8B000001780110 fred 6 "01:00:00"
-- Page id: 3, Found records: 6, Lost records: NO, Leaf page: YES
and dates are incorrect.
After applying the patch and running constraints_parser again, the dump file is correct:
-- Page id: 3, Format: COMPACT, Records list: Valid, Expected records: (6 6)
000000001B03 83000001350110 fred 1 "10:01:20"
000000001B05 85000001B00110 fred 2 "00:02:29"
000000001B0A 87000001770110 fred 3 "10:09:00"
000000001B0B 88000001E60110 fred 4 "10:09:00"
000000001B0D 8A000001750110 fred 5 "01:00:00"
000000001B0E 8B000001780110 fred 6 "09:00:00"
-- Page id: 3, Found records: 6, Lost records: NO, Leaf page: YES