Feature Request: Add support for INVISIBLE columns as introduced in MySQL 8.0.23+

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
tfrancois
Posts: 44
Joined: Mon 11 Jun 2018 23:58

Feature Request: Add support for INVISIBLE columns as introduced in MySQL 8.0.23+

Post by tfrancois » Mon 07 Mar 2022 11:06

As of MySQL 8 version 8.0.23, support for INVISIBLE columns has been added and I am able to create a table with the INVISIBLE flag as shown:

Code: Select all

CREATE TABLE t1 (
  i INT,
  j DATE INVISIBLE
) ENGINE = InnoDB;

ALTER TABLE t1 ADD COLUMN k INT INVISIBLE;
See documentation on this feature:
https://dev.mysql.com/doc/refman/8.0/en ... lumns.html

The issue is that the visibility status of the column is now shown/displayed in the Table Editor in dbForge or in the accompanying Create Table SQL tab there either. Can the visibility status be shown in the Column properties and create table SQL code for MySQL versions that support this?

Thank you!

Raudar
Devart Team
Posts: 19
Joined: Fri 02 Apr 2021 11:04

Re: Feature Request: Add support for INVISIBLE columns as introduced in MySQL 8.0.23+

Post by Raudar » Tue 15 Mar 2022 13:57

Hi there,

Please note that we are already working on this and will add this functionality in one of the further releases.

Cheers,
Devart Team

Post Reply