INVISIBLE/VISIBLE documentation

[cdcarson]

Edited: I realized I was actually using mysql2, not the serverless driver, to do migrations. I haven't tested this with the serverless driver.

Trying to do this (using the serverless driver mysql2, if that matters) results in an error:

ALTER TABLE `Foo` MODIFY COLUMN `novel` text  INVISIBLE;

It worked, however, from the web console. Looking at the create table SQL, it seemed the web console (or something down the line) wrapped the INVISIBLE in a comment, so I tried it that, again using the serverless driver mysql2.

ALTER TABLE `Foo` MODIFY COLUMN `novel` text  /*!80023 INVISIBLE */;
-- and the opposite...
ALTER TABLE `Foo` MODIFY COLUMN `novel` text  /*!80023 VISIBLE */;

Both those work.

I think it'd be a good idea to document this behavior on the MySQL compatibility page. I couldn't find anything there or using the documentation search. Sorry if I missed something. Thanks.