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

Possible record key hash corruption on insert after an update #52

Open
@monok0

Description

@monok0

PostgreSQL 14.6 (Ubuntu 14.6-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit
pg_variables 1.2.5

I discovered erroneous behaviour with chains of updates to the record variable followed by an insert. The following script makes pgv_select claim that there is no record with key 33, but pgv_select on the whole collection shows, that the record is there. After that it is also possible to insert another record with key 33, meaning that the original record is either lost or its key hash is corrupted.
In addition, if you add or remove a single update, it works fine, showing the record.

`Select pgv_free();
select pgv_insert('test', 'aaa', row(33::text, 'data2'::text));
select pgv_update('test','aaa', row(33::text, 'data2'::text));
select pgv_update('test','aaa', row(33::text, 'data2'::text));
select pgv_update('test','aaa', row(33::text, 'data2'::text));
select pgv_insert('test','aaa', row(32::text, 'data3'::text));

Select pgv_select('test', 'aaa', '33'::text), array(select pgv_select('test', 'aaa'));`

Output of this script
изображение

Output with one update removed
изображение

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions


      [8]ページ先頭

      ©2009-2025 Movatter.jp