Skip to content

map data type limitations  #3915

Open
Open
@gaoboal

Description

Bug Description
test table: CREATE TABLE t1 (c1 string, c2 int, c3 MAP<string, string>);

  1. In the desc t1; statement, the key and value types of the map are not displayed.
  2. In the SHOW CREATE TABLE t1; statement, columns of type map are not displayed.
  3. In the SQL syntax documentation for table creation, the support for the map type is not specified. It is necessary to add support documentation for the map type and provide an example. https://openmldb.ai/docs/zh/main/openmldb_sql/ddl/CREATE_TABLE_STATEMENT.html
  4. After executing the statement INSERT INTO t1 VALUES ("1", 1, map(1, "12", 2, "100"));, a warning-level alert log is being displayed.
    insert into t1 values ("1", 1, map(1, "12", 2, "100"));
    W20240429 14:40:09.353835 19961 codec.cc:82] type is not supported
  5. In the SELECT * FROM t1; statement, the columns are displaying incorrectly or out of alignment.
    image

Metadata

Assignees

Labels

bugSomething isn't workingdocumentationImprovements or additions to documentationenhancementNew feature or requestexecute-enginehybridse sql enginesqlSQL standard. definition/revise for a SQL statement/clause etc

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions