Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
3.0.8
-
None
Description
For instance, given the following data:
Id | Event_Date_Time |
---|---|
0 | 2022-09-01T00:00:00Z |
1 | 2022-09-01T01:00:00Z |
2 | 2022-09-01T02:00:00Z |
3 | 2022-09-01T03:00:00Z |
4 | 2022-09-01T04:00:00Z |
5 | 2022-09-02T00:00:00Z |
6 | 2022-09-02T01:00:00Z |
7 | 2022-09-02T02:00:00Z |
8 | 2022-09-02T03:00:00Z |
9 | 2022-09-02T04:00:00Z |
If I insert these rows with 2 threads in parallel (one thread bulk inserting the 5 first rows and another thread bulk inserting the 5 last rows), when I select the inserted rows, the values are randomly scrambled, for instance:
Id | Event_Date_Time |
---|---|
0 | 2022-09-01T00:00:00Z |
1 | 2022-09-02T01:00:00Z |
2 | 2022-09-02T03:00:00Z |
3 | 2022-09-02T04:00:00Z |
4 | 2022-09-01T04:00:00Z |
5 | 2022-09-01T00:00:00Z |
6 | 2022-09-02T01:00:00Z |
7 | 2022-09-02T02:00:00Z |
8 | 2022-09-02T03:00:00Z |
9 | 2022-09-02T04:00:00Z |
If I insert these rows in bulk without concurrence, there's no issue.