[MYSQL] frm2sdi(3) 将frm文件转为sdi page & ibd2sql v1.9 出土

-- 查询collation_id=33的字符集
show collation where id=33;

-- 查询utf8字符集的最大字节长度
show charset where Charset='utf8';

                        if col['metadata']['field_type'] == 246: # decimal
                                numeric_precision = char_length - 2
                                numeric_scale = (pack_flag>>8) & 31
                                numeric_scale_null = False

                        if field_type == 22: # enum 重新计算type_default_size
                                type_default_size = 2 if len(col['elements']) >= 2**8 else 1
                                options = f'interval_count={len(col["elements"])}'
                        elif field_type == 23: # set
                                type_default_size = (len(col['elements'])+7)//8
                                options = f'interval_count={len(col["elements"])}

null_bitmask_adds = 0 if self.pack_record == 1 else 1
default_value_null = False if self.default_value_null_bitmask&(1<<(i+null_bitmask_adds)) == 0 else True

                # 补充隐藏字段 rowid,rollptr & trxid
                if not self.HAVE_PRIMARY:
                        current_ordinal_position += 1
                        COLUMN.append({
                                'name':'DB_ROW_ID',
                                'type':10,
                                'hidden':2,
                                'char_length':6,
                                'ordinal_position':current_ordinal_position,
                        })
                current_ordinal_position += 1
                COLUMN.append({
                        'name':'DB_TRX_ID',
                        'type':10,
                        'hidden':2,
                        'char_length':6,
                        'ordinal_position':current_ordinal_position,
                })
                current_ordinal_position += 1
                COLUMN.append({
                        'name':'DB_ROLL_PTR',
                        'type':9,
                        'hidden':2,
                        'char_length':7,
                        'ordinal_position':current_ordinal_position,
                })

python3 main.py /data/mysql_3314/mysqldata/ibd2sql/ddcw_alltype_table.ibd --sql --limit 1

python3 main.py /data/mysql_3308/mysqldata/ibd2sql/ddcw_alltype_table.ibd --ddl