Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitf7c9a6e

Browse files
committed
pageinspect: Make btree test more portable
Choose test data that makes the output independent of endianness andalignment.
1 parent9779f71 commitf7c9a6e

File tree

2 files changed

+5
-5
lines changed

2 files changed

+5
-5
lines changed

‎contrib/pageinspect/expected/btree.out

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
1-
CREATE TABLE test1 (aint, b text);
2-
INSERT INTO test1 VALUES (1, 'one');
1+
CREATE TABLE test1 (aint8, b text);
2+
INSERT INTO test1 VALUES (72057594037927937, 'text');
33
CREATE INDEX test1_a_idx ON test1 USING btree (a);
44
\x
55
SELECT * FROM bt_metap('test1_a_idx');
@@ -38,7 +38,7 @@ ctid | (0,1)
3838
itemlen | 16
3939
nulls | f
4040
vars | f
41-
data | 01 00 00 00 00 00 0000
41+
data | 01 00 00 00 00 00 0001
4242

4343
SELECT * FROM bt_page_items('test1_a_idx', 2);
4444
ERROR: block number out of range

‎contrib/pageinspect/sql/btree.sql

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
1-
CREATETABLEtest1 (aint, btext);
2-
INSERT INTO test1VALUES (1,'one');
1+
CREATETABLEtest1 (aint8, btext);
2+
INSERT INTO test1VALUES (72057594037927937,'text');
33
CREATEINDEXtest1_a_idxON test1 USING btree (a);
44

55
\x

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp