Support show create tag/edge xxx, show create space xxx SQL

[ayyt]

Current， desc tag/edge, not display table-level attributes, only display column attributes.
so, use show create tag/edge SQL, to display column attributes and table-level attributes.
e.g. comment，ttl_duration, ttl_col, character set, engines.

[ayyt]

Does anyone claim this issue? If not, I will try.

[dangleptr]

Go ahead!!

[ayyt]

Because use this feature to display the TTL attribute， So first implement this function.
An example is as follows:

create table t(a varchar(10));

gbase> show create table t;
+-------+---------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                        |
+-------+---------------------------------------------------------------------------------------------------------------------+
| t     | CREATE TABLE "t" (
  "a" varchar(10) DEFAULT NULL
) ENGINE=EXPRESS DEFAULT CHARSET=utf8 TABLESPACE='sys_tablespace' |
+-------+---------------------------------------------------------------------------------------------------------------------+
1 row in set (Elapsed: 00:00:00.00)


gbase> alter table t add column b int;
Query OK, 0 rows affected (Elapsed: 00:00:00.03)
Records: 0  Duplicates: 0  Warnings: 0

gbase> show create table t;
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                    |
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------+
| t     | CREATE TABLE "t" (
  "a" varchar(10) DEFAULT NULL,
  "b" int(11) DEFAULT NULL
) ENGINE=EXPRESS DEFAULT CHARSET=utf8 TABLESPACE='sys_tablespace' |
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (Elapsed: 00:00:00.00)


gbase> desc t;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| a     | varchar(10) | YES  |     | NULL    |       |
| b     | int(11)     | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
2 rows in set (Elapsed: 00:00:00.00)

[ayyt]

Execution result in nebula：

show create tag t;
+-------+---------------------------------------------------------------------------------------------------------------------+
| Tag | Create Tag                                                                                                        |
+-------+---------------------------------------------------------------------------------------------------------------------+
| t     | CREATE TAG t (
  a int，
  b string
) ttl_duration = 100, ttl_col = a  |
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------+

show create edge e;
+-------+---------------------------------------------------------------------------------------------------------------------+
| Edge | Create Edge                                                                                                        |
+-------+---------------------------------------------------------------------------------------------------------------------+
| e     | CREATE EDGE t (
  a int，
  b string
) ttl_duration = 100, ttl_col = a  |
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------+

show create space s;
+-------+---------------------------------------------------------------------------------------------------------------------+
| Space | Create Space                                                                                                        |
+-------+---------------------------------------------------------------------------------------------------------------------+
| s    | CREATE SPACE s (partition_num = 9，replica_factor = 1)   |
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------+

[sherman-the-tank]

I would suggest to output only one column

[ayyt]

@sherman-the-tank ，

In mysql, output two columns， first column is object（database，table), second column is create object（create database，create table).

mysql> show create database test;
+----------+-----------------------------------------------------------------+
| Database | Create Database                                                 |
+----------+-----------------------------------------------------------------+
| test     | CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET latin1 */ |
+----------+-----------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> show create table t;
+-------+--------------------------------------------------------------------------------------+
| Table | Create Table                                                                         |
+-------+--------------------------------------------------------------------------------------+
| t     | CREATE TABLE `t` (
  `a` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+-------+--------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

Of course, it is ok to display only one column

[sherman-the-tank]

@steppenwolfyuetong Let's follow mysql then ^_^