4paradigm / 4paradigm/OpenMLDB

map data type limitations

Aperta
#3,915 1 commento 0 reazioni 1 assegnatario Rivendicata da @aceforeverd Vedi su GitHub
bug documentation enhancement execute-engine sql
Lingua principale
C++
Stelle
1.7k
Fork
331
Merge medio
12g 12h
PR unite (30g)
1

Descrizione

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

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.
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`
6. In the `SELECT * FROM t1;` statement, the columns are displaying incorrectly or out of alignment.
![image](https://github.com/4paradigm/OpenMLDB/assets/162977423/fef88b45-5e2d-4069-be5b-4f8156f6a748)

Guida per i contributori

Apri la guida per i contributori

Valutazione

Questa issue non è ancora stata valutata.

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.