Skip to content

Add test in schema_spec.db to ensure that FK indices on partitioned tables are defined with partition_id at the end

As shown in the #8547 incident, it is important for FK indices on partitioned tables to be defined with the partition_id column at the end, for 2 reasons:

  • Queries specified only the id will still leverage the index;
  • Consistency is ensured across the database schema.