Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
11.3.2
-
None
Description
Forgive me if I'm just misreading the results, but I'm not sure why I'm seeing the results I'm getting given the criteria for the system version (temporal table) query.
select registration_date,order_number,id,row_start,row_end from registration FOR SYSTEM_TIME BETWEEN '2024-04-04 19:10' and NOW() limit 5; |
 |
+---------------------+--------------+----+----------------------------+----------------------------+ |
| registration_date | order_number | id | row_start | row_end |
|
+---------------------+--------------+----+----------------------------+----------------------------+ |
| 2013-02-15 14:54:50 | NULL | 1 | 2024-04-04 19:03:18.695546 | 2038-01-19 03:14:07.999999 | |
| 2013-02-15 14:54:49 | NULL | 2 | 2024-04-04 19:03:18.695546 | 2038-01-19 03:14:07.999999 | |
| 2013-02-15 14:54:49 | NULL | 3 | 2024-04-04 19:03:18.695546 | 2038-01-19 03:14:07.999999 | |
| 2013-02-15 14:54:49 | NULL | 4 | 2024-04-04 19:03:18.695546 | 2038-01-19 03:14:07.999999 | |
| 2013-02-15 14:58:10 | NULL | 5 | 2024-04-04 19:03:18.695546 | 2038-01-19 03:14:07.999999 | |
+---------------------+--------------+----+----------------------------+----------------------------+ |
Looking at the `row_start` I would expect records only AFTER `2024-04-04 19:10` UP TO `NOW()`
But I'm seeing records BEFORE the start date.
I am running that query straight from the `mariadb` console inside the docker image.
I am using `MariaDB 11.3.2-MariaDB-1.11.3.2+maria~ubu2204` which is the current latest `MariaDB` docker image.