CockroachDB Support
Ivan Zhuravlev edited this page Oct 24, 2021
·
1 revision
- default PK auto create column
rowid
- support
INTERLEAVE IN PARENT
- support
PARTITION BY
differs from postgresql
- change PK / PK to second index - alter table
- drop PK or second index - drop constraint
- INVERTED index for
jsonb
/array
/ spatial -
COVERING
andINCLUDE
are aliases forSTORING
index - Hash-sharded index
- (v20.2+) partial Indexes
- (v20.2+) spatial indexes
- default value by
unique_rowid()
for typeint
- default value by
gen_random_uuid()
for typeuuid
-
CHECK
constraint - (v20.2+) type
enum
- 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
- 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