10.11.4-MariaDB-1:10.11.4+maria~deb11 (mariadb.org binary distribution) Linux xxxx.local 5.10.0-23-amd64 #1 SMP Debian 5.10.179-2 (2023-07-14) x86_64 GNU/Linux MariaDB [mcatu001]> select gsid, ROW_START, ROW_END from grid_show FOR SYSTEM_TIME ALL WHERE gsid in (25119, 25120) ORDER BY ROW_START; +-------+----------------------------+----------------------------+ | gsid | ROW_START | ROW_END | +-------+----------------------------+----------------------------+ | 25119 | 2024-01-03 12:08:45.804315 | 2024-01-03 17:08:08.453210 | | 25120 | 2024-01-03 12:08:45.805367 | 2024-01-03 17:08:08.454756 | | 25119 | 2024-01-03 17:08:08.453210 | 2024-01-03 17:08:08.370360 | | 25120 | 2024-01-03 17:08:08.454756 | 2024-01-03 17:08:08.370360 | +-------+----------------------------+----------------------------+ 4 rows in set (0.001 sec) MariaDB [mcatu001]> select gsid, ROW_START, ROW_END from grid_show FOR SYSTEM_TIME AS OF TIMESTAMP '2024-01-03 17:08:08.370359' WHERE gsid in (25119, 25120) ; +-------+----------------------------+----------------------------+ | gsid | ROW_START | ROW_END | +-------+----------------------------+----------------------------+ | 25119 | 2024-01-03 12:08:45.804315 | 2024-01-03 17:08:08.453210 | | 25120 | 2024-01-03 12:08:45.805367 | 2024-01-03 17:08:08.454756 | +-------+----------------------------+----------------------------+ 2 rows in set (0.001 sec) MariaDB [mcatu001]> select gsid, ROW_START, ROW_END from grid_show FOR SYSTEM_TIME AS OF TIMESTAMP '2024-01-03 17:08:08.370360' WHERE gsid in (25119, 25120) ; +-------+----------------------------+----------------------------+ | gsid | ROW_START | ROW_END | +-------+----------------------------+----------------------------+ | 25119 | 2024-01-03 12:08:45.804315 | 2024-01-03 17:08:08.453210 | | 25120 | 2024-01-03 12:08:45.805367 | 2024-01-03 17:08:08.454756 | +-------+----------------------------+----------------------------+ 2 rows in set (0.000 sec) MariaDB [mcatu001]>