maria-developers team mailing list archive

[Ian Gilfillan <ian@xxxxxxxxxxx>]

I like Jocelyn's solution. The whole situation is quite messy with all 
sorts of edge cases, but this seems to make the best of it. THE SHOW 
CREATE statement will be functional, and the metadata will be displayed 
in a readable form.

On 08/07/2014 14:21, Jocelyn Fournier wrote:
> > This is easy to do, I've just tried.
> >
> > It might look confusing, though, the table from connect.alter test would
> > then be:
> >
> >    SHOW CREATE TABLE t1;
> >    Table   Create Table
> >    t1      CREATE TABLE `t1` (
> >      `d` char(10) NOT NULL /* `FLAG`=11 */,
> >      `c` int(11) NOT NULL /* `FLAG`=0 */
> >    ) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 /* 
> > `TABLE_TYPE`=fix `FILE_NAME`='tf1.txt' `ENDING`=1 */
>
> Perhaps something like :
>
>   SHOW CREATE TABLE t1;
>   Table   Create Table
>   t1      CREATE TABLE `t1` (
>     `d` char(10) NOT NULL /* `FLAG`=11 */,
>     `c` int(11) NOT NULL /* `FLAG`=0 */
>   ) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 /* Ignored 
> Options : `TABLE_TYPE`=fix `FILE_NAME`='tf1.txt' `ENDING`=1 */
>
>
> would be clearer ?
>
>   Jocelyn