select column meta for table map event

[siddontang]

I think this can improve #28.

@karmakaze

[karmakaze]

Yes it does. However have to be mindful that a schema change may mean that the column meta is newer than the point in time of the stream that is being processed.

[siddontang]

We can check table id too, if table id exists, we can guarantee that the schema is not changed. if not, we may degrade to old use.

[gdey]

Is there a way to get the table id from the information_schema? I'm running into this issue as well, and want to know if the map_table_event corresponds to current table schema.

[siddontang]

Hi @gdey
You can find it in INFORMATION_SCHEMA.INNODB_SYS_TABLES, but as you see, this may be only for innodb. 😭