cockroach 过滤索引,计算列

cockroach 过滤索引,部分数据索引的创建

CREATE INDEX ON rides (city, revenue) WHERE end_time IS NOT NULL;
CREATE UNIQUE INDEX ON users (name) WHERE city='new york';

修改索引的名字

alter table if exists tbname@tbidexname rename to index_name;
alter table [if exists] [tbname@]tbidexname rename to index_name;

添加和重命名列

CREATE TABLE users (
    id INT PRIMARY KEY,
    name STRING
  );
  
  ALTER TABLE users
    RENAME COLUMN name TO last_name,
    ADD COLUMN first_name STRING,
    ADD COLUMN name STRING
      AS (CONCAT(first_name, ' ', last_name)) STORED;
      
 SHOW CREATE TABLE users;
  table_name |                           create_statement
+------------+----------------------------------------------------------------------+
  users      | CREATE TABLE users (
             |     id INT8 NOT NULL,
             |     last_name STRING NULL,
             |     first_name STRING NULL,
             |     name STRING NULL AS (concat(first_name, ' ', last_name)) STORED,
             |     CONSTRAINT "primary" PRIMARY KEY (id ASC),
             |     FAMILY "primary" (id, last_name, first_name, name)
             | )
(1 row)

创建计算列

CREATE TABLE users (
    id INT PRIMARY KEY,
    name STRING,
    id_c int as (id %10) stored
  );