Skip to main content

SingleStoreDB v8.1

Distributed SQL Surface Area

SingleStoreDB supports a large subset of the SQL surface area, with the following limitations:

  • Reference tables must have explicit primary keys.

  • An AUTO_INCREMENT column in a distributed table must be a BIGINT. Auto-increment values are monotonically increasing on each aggregator but not consecutive across the cluster.

  • Sharded tables do not support unique keys (unless the unique key contains all columns of the shard key).

  • Sharded tables do not support UPDATE queries that modify the shard key.

  • Sharded tables do not support UPDATE...LIMIT.

In this section:

The amount of components installed and or configuration options that are enabled.