Klustron 1.3.1 Release Notes

1.3.1 New Syntax Additions:

1. Added MySQL-compatible SHOW commands

SHOW CREATE DATABASE db_name;
SHOW CREATE SCHEMA schema_name;
SHOW INDEX IN table_name [ WHERE expr ];

Example:

mysql> show index in t1;
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+------------+
| table | non_unique | key_name | seq_in_index | column_name | collation | cardinality | sub_part | packed | null | index_type | comment | index_comment | visible | expression |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+------------+
| t1    | 1          | t1_a_idx | 1            | a           | A         | 0           | NULL     | NULL   | YES  | BTREE      |         |               | YES     | NULL       |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+------------+
1 row in set (0.00 sec)

2. Generated Columns

create table t1(a int,
    b int generated always as (a+1) virtual,
    c int generated always as (a+2) stored);

3. Added cache_method attribute for sequences. Used to control whether the cache size dynamically changes based on load

CREATE [ TEMPORARY | TEMP ] SEQUENCE [ IF NOT EXISTS ] name
    [ AS data_type ]
    [ INCREMENT [ BY ] increment ]
    [ MINVALUE minvalue | NO MINVALUE | NOMINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE | NOMAXVALUE ]
    [ { START | STARTS } [ WITH ] start ] [ NOCACHE | CACHE cache ] [ [ NO ] CYCLE | NOCYCLE ] [CACHE METHOD cache_method]
    [ ORDER | NOORDER ] [ SHARD  shard ]
    [ OWNED BY { table_name.column_name | NONE } ]

where cache_method can be one of:
    'STATIC'
    'DYNAMIC'

4. Supported EXPLAIN aliases DESC and DESCRIBE. For example:

mysql> desc select * From t1;
+----------------------------------------------------------------+
| QUERY PLAN                                                     |
+----------------------------------------------------------------+
| RemotePlan  (cost=101.02..101.02 rows=1 width=4)               |
|   Shard: 1    Remote SQL: SELECT t1.a FROM  `abc_$$_public`.`t1`  |
+----------------------------------------------------------------+
2 rows in set (0.00 sec)

5. Supported "DESC table_name" to view table structure:

mysql> desc t1;
+-------+---------+------+------+---------+-------+
| field | type    | null | key  | default | extra |
+-------+---------+------+------+---------+-------+
| a     | integer | YES  |      | NULL    |       |
+-------+---------+------+------+---------+-------+
1 row in set (0.00 sec)

END