Details
-
Bug
-
Status: Needs Feedback (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.8.6
-
None
-
Linux Debian
Description
Hello,
Here is what I am trying to do.
On my Debian 12 server I have MariaDB version 10.11 running.
I have there a database with system-versioned tables.
So I make my dumps using the -H / --dump-history option.
Then I am trying to load the dump content into another Debian server, of course with the historical data.
I tried with different MariaDB releases, always on Debian servers (12 and 13).
- If I load the dumps into (another) MariaDB 10.11.* or 11.4.* it works fine.
- If I try with MariaDB 11.8 (or later), I can't see my data anymore... The "select *" query gives an empty set.
When I add "FOR SYSTEM_TIME ALL" I then can see it all.
So the data is probably not lost in the process, but how can I see it normally?
I have read the docs on these topics but I am unable to find a solution to my issue.
Thanks a lot for any help.