MySQL workbench can't deal with MariaDB's new Invisible columnsMySQL Workbench EER Diagram and ENUM data...

How do you funnel food off a cutting board?

Why does magnet wire need to be insulated?

How to assess the long-term stability of a college as part of a job search

Saint abbreviation

In Linux what happens if 1000 files in a directory are moved to another location while another 300 files were added to the source directory?

Is there a lava-breathing lizard creature (that could be worshipped by a cult) in 5e?

Explanation of a regular pattern only occuring for prime numbers

Decision problem that can be verified but not run in n^2 time

Why don't key signatures indicate the tonic?

Citing paywalled articles accessed via illegal web sharing

Why do we have to make "peinlich" start with a capital letter and also end with -s in this sentence?

Potential client has a problematic employee I can't work with

What happened to my GE option?

Looking for a specific 6502 Assembler

Has any human ever had the choice to leave Earth permanently?

What game did these black and yellow dice come from?

How can I play a serial killer in a party of good PCs?

Bash script to truncate subject line of incoming email

How to visualize the Riemann-Roch theorem from complex analysis or geometric topology considerations?

Why did Democrats in the Senate oppose the Born-Alive Abortion Survivors Protection Act (2019 S.130)?

Globe trotting Grandpa. Where is he going next?

Why would space fleets be aligned?

Airplane generations - how does it work?

Is a new boolean field better than null reference when a value can be meaningfully absent?



MySQL workbench can't deal with MariaDB's new Invisible columns


MySQL Workbench EER Diagram and ENUM data typeMySQL - Alter Table Fails As Workbench Tries To Create Existing TableDatatype for phone number: VARCHAR, INT or BIGINT?MySQL workbench alter table is incompletetransaction isolation in MySQL workbenchImporting larger CSV files to an empty table in a local MySQL databaseBest way forward for setting up Debian 9 / MariaDB (10.1.26-0+deb9u1) with root user Adminer accessMySQL Workbench - Error Getting DDL Object (It doesn't exist?)What are “Invisible Columns” and how are they used?MariaDB GTID current_pos vs slave_pos













0















Recently upgraded to MariaDB 10.3 which has a new feature whereby we can create an invisible column like so:



ALTER TABLE MyTable ADD COLUMN `TestA` INT INVISIBLE;


But once I create this column, MySql Workbench will error on this table. Is there any way to workaround this? Or is there another GUI tool that can deal with this new column type?









share























  • List on their kb no idea which ones keep up with later features sorry.

    – danblack
    1 min ago
















0















Recently upgraded to MariaDB 10.3 which has a new feature whereby we can create an invisible column like so:



ALTER TABLE MyTable ADD COLUMN `TestA` INT INVISIBLE;


But once I create this column, MySql Workbench will error on this table. Is there any way to workaround this? Or is there another GUI tool that can deal with this new column type?









share























  • List on their kb no idea which ones keep up with later features sorry.

    – danblack
    1 min ago














0












0








0








Recently upgraded to MariaDB 10.3 which has a new feature whereby we can create an invisible column like so:



ALTER TABLE MyTable ADD COLUMN `TestA` INT INVISIBLE;


But once I create this column, MySql Workbench will error on this table. Is there any way to workaround this? Or is there another GUI tool that can deal with this new column type?









share














Recently upgraded to MariaDB 10.3 which has a new feature whereby we can create an invisible column like so:



ALTER TABLE MyTable ADD COLUMN `TestA` INT INVISIBLE;


But once I create this column, MySql Workbench will error on this table. Is there any way to workaround this? Or is there another GUI tool that can deal with this new column type?







mariadb mysql-workbench





share












share










share



share










asked 4 mins ago









ChrisFChrisF

31




31













  • List on their kb no idea which ones keep up with later features sorry.

    – danblack
    1 min ago



















  • List on their kb no idea which ones keep up with later features sorry.

    – danblack
    1 min ago

















List on their kb no idea which ones keep up with later features sorry.

– danblack
1 min ago





List on their kb no idea which ones keep up with later features sorry.

– danblack
1 min ago










0






active

oldest

votes











Your Answer








StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230822%2fmysql-workbench-cant-deal-with-mariadbs-new-invisible-columns%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes
















draft saved

draft discarded




















































Thanks for contributing an answer to Database Administrators Stack Exchange!


  • Please be sure to answer the question. Provide details and share your research!

But avoid



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230822%2fmysql-workbench-cant-deal-with-mariadbs-new-invisible-columns%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

ORA-01691 (unable to extend lob segment) even though my tablespace has AUTOEXTEND onORA-01692: unable to...

Always On Availability groups resolving state after failover - Remote harden of transaction...

Circunscripción electoral de Guipúzcoa Referencias Menú de navegaciónLas claves del sistema electoral en...