Devart Forums

Posted: **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

Posted: **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.

Devart Forums

Broken auto completion for MariaDB and temporal data tables

Broken auto completion for MariaDB and temporal data tables

Re: Broken auto completion for MariaDB and temporal data tables