I've added some regression tests for SEQUENCE. A cumulative patch is attached.
Barring a (still to decipher) function seq_redo() and trying to learn how to actually test it, this takes care of most branches of (src/backend/commands/sequence.c) taking code-coverage (of 'make check') to ~95%.
robins wrote: > Attached is a small patch to test corner cases related to Sequences (basically aimed at increasing > code-coverage of sequence.sql in regression tests). > > Look forward to any and all feedback.
Looks ok except that the patch is backwards (all added lines start with "-"). I found a typo: "exit" instead of "exist".