[Test] add test for check show create table sql

[Test] add test for check show create table sql #1898