Broken auto completion for MariaDB and temporal data tables

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
Jens168
Posts: 9
Joined: Wed 10 Jul 2019 09:11

Broken auto completion for MariaDB and temporal data tables

Post by Jens168 » Wed 10 Jul 2019 09:22

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
Devart Team
Posts: 2782
Joined: Fri 24 Jun 2011 14:17

Re: Broken auto completion for MariaDB and temporal data tables

Post by alexa » Wed 10 Jul 2019 14:09

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

Post Reply