logictestccl: flake in the zone config tests due to non-determinisgm in SHOW CREATE #59644
Description
Found in https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_UnitTests/2628156?
expected:
[...]
ALTER PARTITION p1 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
gc.ttlseconds = 15210;
ALTER PARTITION p2 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
gc.ttlseconds = 15213;
ALTER PARTITION p3 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
gc.ttlseconds = 15411;
ALTER PARTITION p4 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
gc.ttlseconds = 15418
but found (query options: "") :
[...]
ALTER PARTITION p3 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
gc.ttlseconds = 15411;
ALTER PARTITION p4 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
gc.ttlseconds = 15418;
ALTER PARTITION p1 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
gc.ttlseconds = 15210;
ALTER PARTITION p2 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
gc.ttlseconds = 15213
Observe: the partitions are reported in a different order. This suggests that the output of SHOW CREATE is non-determinisitc when there are partitions.
cc @RaduBerinde @otan for triage.