Broken auto completion for MariaDB and temporal data tables

[Jens168]

Hello,

Issue: Auto completion is either not working or broken for MariaDB.

Reason: It has something to do with temporal data tables (defined by SQL:2011, https://mariadb.com/kb/en/library/temporal-data-tables/)

Reproduction:
I have the schema "test" with the following tables:

Code: Select all

assets
dyn
mon
number_savegame
Nummern
Nummernbereiche
savegame
schub
table1
table2
table3
untest
untest2

All of them have the TABLE_TYPE = BASE TABLE.

Currently auto completion is working fine: As i type

Code: Select all

SELECT * FROM 

I get the list of all 13 tables.

If I change the table

Code: Select all

number_savegame

to a temporal data table with

Code: Select all

ALTER TABLE number_savegame ADD SYSTEM VERSIONING;

and afterwards refresh the local cache the autocompletion not only isn't showing the number_savegame table anymore but only shows the tables assets, dyn, mon. (So the other tables disapper from the list as well despite not being changed.)

Wanted behavior:
Tables should be listed no matter what the TABLE_TYPE is, or include "SYSTEM VERSIONED" as a valid table type. Also the list should not break on an unexpected type.

I'm using:
dbForge Studio 2019 for MySQL, Enterprise Edition, Version: 8.1.45
10.3.10-MariaDB-1:10.3.10+maria~bionic

[alexa]

We will fix this issue in one of the next product builds and will notify you once it's available for downloading.