-- key aborts. One easy way to achieve that is to use uuids that all

-- have the same prefix, as abbreviated keys for uuids just use the

-- first sizeof(Datum) bytes.

DROP TABLE IF EXISTS abbrev_abort_uuids;

NOTICE: table "abbrev_abort_uuids" does not exist, skipping

CREATE TABLE abbrev_abort_uuids (

CREATE TEMP TABLE abbrev_abort_uuids (

id serial not null,

abort_increasing uuid,

abort_decreasing uuid,

----

-- test tuplesort mark/restore

---

CREATE TABLE test_mark_restore(col1 int, col2 int, col12 int);

CREATETEMPTABLE test_mark_restore(col1 int, col2 int, col12 int);

-- need a few duplicates for mark/restore to matter

INSERT INTO test_mark_restore(col1, col2, col12)

SELECT a.i, b.i, a.i * b.i FROM generate_series(1, 500) a(i), generate_series(1, 5) b(i);

(10 rows)

COMMIT;

-- cleanup

DROP TABLE IF EXISTS abbrev_abort_uuids;

DROP TABLE IF EXISTS test_mark_restore;

DROPTABLE IF EXISTS abbrev_abort_uuids;

CREATETABLEabbrev_abort_uuids (

CREATE TEMP TABLE abbrev_abort_uuids (

idserialnot null,

abort_increasing uuid,

abort_decreasing uuid,

CREATETABLEtest_mark_restore(col1int, col2int, col12int);

CREATETEMPTABLE test_mark_restore(col1int, col2int, col12int);

INSERT INTO test_mark_restore(col1, col2, col12)

SELECTa.i,b.i,a.i*b.iFROM generate_series(1,500) a(i), generate_series(1,5) b(i);

:qry;

COMMIT;

DROPTABLE IF EXISTS abbrev_abort_uuids;

DROPTABLE IF EXISTS test_mark_restore;