4paradigm / 4paradigm/OpenMLDB

[TBC] CLI does not support multiple SQL strings

Open
#2,432 4 comments 0 reactions 1 assignee Claimed by @dl239 View on GitHub
bug enhancement high-priority
Dominant language
C++
Stars
1.7k
Forks
331
Avg merge
12d 12h
Merged PRs (30d)
1

Description

**Bug Description**
When copying the following DDL statement, CLI has a lot of strange information output
![b24148abfb9312a38e99a609662e30d7](https://user-images.githubusercontent.com/18275570/188352464-45cfe9bf-8aec-415d-9d2d-4be2b753f1ea.png)

+ sql
```sql
create table test_memory_absolute(
yumid string,
user_code string,
md5_usercode string,
cross_dp_tag string,
repeat_dp_tag string,
usercode_tail string,
insert_time timestamp,
update_time string,
city string,
city_code bigint,
cross_dp_tag_posterior string,
repeat_dp_tag_posterior string,
p_update_date int,
index(key=(user_code,update_time),ttl=0m,ttl_type=absolute),
index(key=(md5_usercode,update_time),ttl=0m,ttl_type=absolute),
index(key=(yumid,update_time),ttl=0m,ttl_type=absolute))
options(partitionnum=1,replicanum=1,storage_mode='memory'
);
create table test_ssd_absolute(
yumid string,
user_code string,
md5_usercode string,
cross_dp_tag string,
repeat_dp_tag string,
usercode_tail string,
insert_time timestamp,
update_time string,
city string,
city_code bigint,
cross_dp_tag_posterior string,
repeat_dp_tag_posterior string,
p_update_date int,
index(key=(user_code,update_time),ttl=0m,ttl_type=absolute),
index(key=(md5_usercode,update_time),ttl=0m,ttl_type=absolute),
index(key=(yumid,update_time),ttl=0m,ttl_type=absolute))
options(partitionnum=1,replicanum=1,storage_mode='ssd'
);
```

**Expected Behavior**
Prompt: create successfully

**Steps to Reproduce**

1.
2.
3.
4.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.