Open
Description
When trying to use sqlc for our project I noticed a few things were not supported that we require. We do use CockroachDB with the postgres engine.
- The
ON UPDATE
expression caused SQL validation errors. This is specific to CRDB. - Hash sharded indexes caused SQL validation errors as well
- Composite primary keys with ordering like
PRIMARY KEY(col1, col2 DESC)
said thatDESC
was an error - The
STORING
clause was also found to be an error