From 06918e9c46022cfe056cc584d734cec9371693a8 Mon Sep 17 00:00:00 2001 From: Christoph Berg Date: Tue, 15 Apr 2025 12:56:48 +0000 Subject: [PATCH] Mask all digits of value and toast relation ids This was not noticed before because I was always running the tests in a fresh instance. Close #33. Author: Svetlana Derevyanko --- expected/toast.out | 6 +++--- expected/toast_1.out | 6 +++--- expected/toast_3.out | 6 +++--- expected/toast_4.out | 6 +++--- sed.sh | 2 +- 5 files changed, 13 insertions(+), 13 deletions(-) diff --git a/expected/toast.out b/expected/toast.out index 08369a7..0e90b42 100644 --- a/expected/toast.out +++ b/expected/toast.out @@ -86,17 +86,17 @@ COPY: short inline xxx Item 2 -- Length: 256 Offset: 7888 (0x1ed0) Flags: NORMAL COPY: long inline uncompressed xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Item 3 -- Length: 64 Offset: 7824 (0x1e90) Flags: NORMAL - TOAST value. Raw size: 2804, external size: 2800, value id: ....., toast relation id: ....., chunks: 2 + TOAST value. Raw size: 2804, external size: 2800, value id: ......, toast relation id: ......, chunks: 2 COPY: external uncompressed 0123456789 8< [snipped] Item 4 -- Length: 107 Offset: 7712 (0x1e20) Flags: NORMAL COPY: inline compressed pglz 0123456789 8< [snipped] Item 5 -- Length: 67 Offset: 7640 (0x1dd8) Flags: NORMAL - TOAST value. Raw size: 280004, external size: 3226, value id: ....., toast relation id: ....., chunks: 2 + TOAST value. Raw size: 280004, external size: 3226, value id: ......, toast relation id: ......, chunks: 2 COPY: extended compressed pglz 0123456789 8< [snipped] Item 6 -- Length: 90 Offset: 7544 (0x1d78) Flags: NORMAL COPY: inline compressed lz4 0123456789 8< [snipped] Item 7 -- Length: 66 Offset: 7472 (0x1d30) Flags: NORMAL - TOAST value. Raw size: 700004, external size: 2772, value id: ....., toast relation id: ....., chunks: 2 + TOAST value. Raw size: 700004, external size: 2772, value id: ......, toast relation id: ......, chunks: 2 COPY: extended compressed lz4 0123456789 8< [snipped] diff --git a/expected/toast_1.out b/expected/toast_1.out index b4645cb..1ffb1cf 100644 --- a/expected/toast_1.out +++ b/expected/toast_1.out @@ -89,17 +89,17 @@ COPY: short inline xxx Item 2 -- Length: 256 Offset: 7888 (0x1ed0) Flags: NORMAL COPY: long inline uncompressed xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Item 3 -- Length: 64 Offset: 7824 (0x1e90) Flags: NORMAL - TOAST value. Raw size: 2804, external size: 2800, value id: ....., toast relation id: ....., chunks: 2 + TOAST value. Raw size: 2804, external size: 2800, value id: ......, toast relation id: ......, chunks: 2 COPY: external uncompressed 0123456789 8< [snipped] Item 4 -- Length: 107 Offset: 7712 (0x1e20) Flags: NORMAL COPY: inline compressed pglz 0123456789 8< [snipped] Item 5 -- Length: 67 Offset: 7640 (0x1dd8) Flags: NORMAL - TOAST value. Raw size: 280004, external size: 3226, value id: ....., toast relation id: ....., chunks: 2 + TOAST value. Raw size: 280004, external size: 3226, value id: ......, toast relation id: ......, chunks: 2 COPY: extended compressed pglz 0123456789 8< [snipped] Item 6 -- Length: 107 Offset: 7528 (0x1d68) Flags: NORMAL COPY: inline compressed lz4 0123456789 8< [snipped] Item 7 -- Length: 66 Offset: 7456 (0x1d20) Flags: NORMAL - TOAST value. Raw size: 700004, external size: 8035, value id: ....., toast relation id: ....., chunks: 5 + TOAST value. Raw size: 700004, external size: 8035, value id: ......, toast relation id: ......, chunks: 5 COPY: extended compressed lz4 0123456789 8< [snipped] diff --git a/expected/toast_3.out b/expected/toast_3.out index 3b18250..84aed39 100644 --- a/expected/toast_3.out +++ b/expected/toast_3.out @@ -86,17 +86,17 @@ COPY: short inline xxx Item 2 -- Length: 256 Offset: 7892 (0x1ed4) Flags: NORMAL COPY: long inline uncompressed xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Item 3 -- Length: 64 Offset: 7828 (0x1e94) Flags: NORMAL - TOAST value. Raw size: 2804, external size: 2800, value id: ....., toast relation id: ....., chunks: 2 + TOAST value. Raw size: 2804, external size: 2800, value id: ......, toast relation id: ......, chunks: 2 COPY: external uncompressed 0123456789 8< [snipped] Item 4 -- Length: 107 Offset: 7720 (0x1e28) Flags: NORMAL COPY: inline compressed pglz 0123456789 8< [snipped] Item 5 -- Length: 67 Offset: 7652 (0x1de4) Flags: NORMAL - TOAST value. Raw size: 280004, external size: 3226, value id: ....., toast relation id: ....., chunks: 2 + TOAST value. Raw size: 280004, external size: 3226, value id: ......, toast relation id: ......, chunks: 2 COPY: extended compressed pglz 0123456789 8< [snipped] Item 6 -- Length: 90 Offset: 7560 (0x1d88) Flags: NORMAL COPY: inline compressed lz4 0123456789 8< [snipped] Item 7 -- Length: 66 Offset: 7492 (0x1d44) Flags: NORMAL - TOAST value. Raw size: 700004, external size: 2772, value id: ....., toast relation id: ....., chunks: 2 + TOAST value. Raw size: 700004, external size: 2772, value id: ......, toast relation id: ......, chunks: 2 COPY: extended compressed lz4 0123456789 8< [snipped] diff --git a/expected/toast_4.out b/expected/toast_4.out index 95436c7..fbdd198 100644 --- a/expected/toast_4.out +++ b/expected/toast_4.out @@ -89,17 +89,17 @@ COPY: short inline xxx Item 2 -- Length: 256 Offset: 7892 (0x1ed4) Flags: NORMAL COPY: long inline uncompressed xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Item 3 -- Length: 64 Offset: 7828 (0x1e94) Flags: NORMAL - TOAST value. Raw size: 2804, external size: 2800, value id: ....., toast relation id: ....., chunks: 2 + TOAST value. Raw size: 2804, external size: 2800, value id: ......, toast relation id: ......, chunks: 2 COPY: external uncompressed 0123456789 8< [snipped] Item 4 -- Length: 107 Offset: 7720 (0x1e28) Flags: NORMAL COPY: inline compressed pglz 0123456789 8< [snipped] Item 5 -- Length: 67 Offset: 7652 (0x1de4) Flags: NORMAL - TOAST value. Raw size: 280004, external size: 3226, value id: ....., toast relation id: ....., chunks: 2 + TOAST value. Raw size: 280004, external size: 3226, value id: ......, toast relation id: ......, chunks: 2 COPY: extended compressed pglz 0123456789 8< [snipped] Item 6 -- Length: 107 Offset: 7544 (0x1d78) Flags: NORMAL COPY: inline compressed lz4 0123456789 8< [snipped] Item 7 -- Length: 66 Offset: 7476 (0x1d34) Flags: NORMAL - TOAST value. Raw size: 700004, external size: 8035, value id: ....., toast relation id: ....., chunks: 5 + TOAST value. Raw size: 700004, external size: 8035, value id: ......, toast relation id: ......, chunks: 5 COPY: extended compressed lz4 0123456789 8< [snipped] diff --git a/sed.sh b/sed.sh index b449684..dd8d971 100755 --- a/sed.sh +++ b/sed.sh @@ -3,5 +3,5 @@ sed -e "s/logid ....../logid ....../" \ -e "s/recoff 0x......../recoff 0x......../" \ -e "s/Checksum: 0x..../Checksum: 0x..../" \ - -e "s/id: ...../id: ...../g" \ + -e "s/id: ....../id: ....../g" \ -e "s/ 8< .*/ 8< [snipped]/" -- 2.39.5