[ODBC-324] Excel+MariaDB driver not showing table with SYSTEM VERSIONING Created: 2021-06-18  Updated: 2021-07-30  Resolved: 2021-07-30

Status: Closed
Project: MariaDB Connector/ODBC
Component/s: General
Affects Version/s: 3.1.13
Fix Version/s: 3.1.14

Type: Bug Priority: Major
Reporter: Nicolas De Amicis Assignee: Lawrin Novitsky
Resolution: Fixed Votes: 0
Labels: None
Environment:

mariadb 10.3.29

Attachments: PNG File 2021-06-18 16_27_19-.png    

 Description   

If I try to connect mariadb on excel 2016 via MariaDB driver (3.1.13), not all tables are listed. Please see screenshot. It seems that only tables with SYSTEM VERSIONING are missing.

MariaDB [fb_bde]> show tables;
 
+--------------------------+
 
| Tables_in_fb_bde         |
 
+--------------------------+
 
| ACL_Orginalfile          |
 
| tbl_trait_therm_ACL_Test |
 
| tblactivite              |
 
| tblistactivite           |
 
| tbllaser_proprete        |
 
| tbllt3_largeur           |
 
| tbllub_acquisition       |
 
| tbllub_conf              |
 
| tbllub_mesure            |
 
| tbllub_msa               |
 
| tbllub_reference         |
 
| tblpoidsbalance          |
 
| vw_lsa_proprete          |
 
| vwlub_acquisition        |
 
+--------------------------+
 
14 rows in set (0.047 sec)

On Excel they are only 13 tables, tblistactivite is missing, it's the only one that have SYSTEM VERSIONING.



 Comments   
Comment by Lawrin Novitsky [ 2021-06-18 ]

Thank you for your report!
Is this something, that didn't happen with previous versions of the driver?

Comment by Nicolas De Amicis [ 2021-06-22 ]

It's seems that is the same problem on 3.1.9

Comment by Nicolas De Amicis [ 2021-06-24 ]

I have tested with MyISAM, Aria and InnoDB engines and the problem is on all these engines.

I found a workaround, if I create a view of the system versioned table, the table will be loaded with ODBC

Comment by Nicolas De Amicis [ 2021-06-29 ]

It seems that is only the table browser display that don't work: on Windows, with text file .dqy, the file loads data directly into Excel (I found this tip on the web).
I also tested the same driver ODBC on Linux with unixODBC, it's the same behaviour like Windows: with isql (small tool provided by unixODBC), I can query data, but if I try to browse table with LibreOffice (and ODBC), the tables with SYSTEM VERSIONING aren't visible.

Generated at Thu Feb 08 03:27:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.