use columnstore_info;

drop procedure columnstore_upgrade();

create procedure columnstore_upgrade()

DELIMITER //

`columnstore_upgrade`: BEGIN

    DECLARE done INTEGER DEFAULT 0;

    DECLARE schema_table VARCHAR(100) CHARACTER SET utf8 DEFAULT "";

    DECLARE table_list CURSOR FOR select concat('`', table_schema,'`.`',table_name,'`') from information_schema.tables where engine='columnstore';

    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;

    OPEN table_list;

    tlist: LOOP

        FETCH table_list INTO schema_table;

        IF done = 1 THEN LEAVE tlist;

        END IF;

        SET @sql_query = concat('ALTER TABLE ', schema_table, ' COMMENT=\'\'');

        PREPARE stmt FROM @sql_query;

        EXECUTE stmt;

        DEALLOCATE PREPARE stmt;

    END LOOP;

END //

DELIMITER ;

call columnstore_upgrade();