1

CockroachDB Support

Ivan Zhuravlev edited this page 2021-10-24 17:18:50 +03:00

Table of Contents

• Checklist
• Tables
• Indexes
• Columns
• Queries / Transactions
• Dialect

Checklist

Tables

• default PK auto create column rowid
• support INTERLEAVE IN PARENT
• support PARTITION BY differs from postgresql

Indexes

• change PK / PK to second index - alter table
• drop PK or second index - drop constraint
• INVERTED index for jsonb/array/ spatial
• COVERING and INCLUDE are aliases for STORING index
• Hash-sharded index
• (v20.2+) partial Indexes
• (v20.2+) spatial indexes

Columns

• default value by unique_rowid() for type int
• default value by gen_random_uuid() for type uuid
• CHECK constraint
• (v20.2+) type enum

Queries / Transactions

• support UPSERT PR#4767
• support select and transaction with AS OF SYSTEM TIME <time>
• support WINDOW function
• where with time using cost-based optimizer without full table scan
• column name from an outer column inside a subquery as ?column?
• Limitation of schema changes within transactions

Dialect

• version check
• support BigInt
• cancel query
• unsupported stream
• add functions in FunctionHelper and refactoring for difference dialect
• (v20.2+) for share / nowait
• (dev) skip locked https://github.com/cockroachdb/cockroach/issues/40476
• Postgres schemas
• Materialized views

No Footer