Skip to content

Table comments are "ignored" #2389

@knutwannheden

Description

@knutwannheden

When a CREATE TABLE DDL contains a COMMENT clause the comment ends up being dropped and is not visible in the information schema, as exemplified here:

create table foo(x int) comment 'foo table'
;
select table_comment
from information_schema.tables
where table_name = 'foo'
;

This appears to work fine for table comments, but I didn't check other object types.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingcorrectnessWe don't return the same result as MySQLsqlIssue with SQL

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions