← Back to team overview

maria-developers team mailing list archive

Add hidden level 2/3 (PSEDUO_HIDDEN_COLUMN / COMPLETELY_HIDDEN_COLUMN) to mariadb

 

Hello Everyone!

Currently I am implementing 10177. But I have one doubt I am not sure
how to implement a function
which will create hidden level 2/3 field for server.

Suppose we create a  function (say add_hidden_field(.....)) which will
add the field to
table T.

But the issue is where should we call this function in
mysql_prepare_create_table / mysql_prepare_alter_table

or

init_from_binary_frm_image

Doing it from init_from_binary_frm_image make sense because this way
server and slave frm of table T will be same
(We have decided that we wont log hidden level 2/3 field to binlog) ,
But the issue is optimizer wont be ready to decide
whether we require a hidden level 3 field at that time.

We can also do it from mysql_prepare_create_table , but I dont think
this wont be good idea because at this time optimizer wont be ready
plus this
will complicate binlog handling.

Or may be we should have a function which can modify table object any
time. But I am not sure if it is possible/good idea ?

What you guys think ?
-- 
 Regards
Sachin Setiya
Software Engineer at  MariaDB


Follow ups