回复: BUG #17998: Postgres crashes when executing WorkTableScan.

From: 梁 成林 <chenglin-liang(at)outlook(dot)com>
To: 梁 成林 <chenglin-liang(at)outlook(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: 回复: BUG #17998: Postgres crashes when executing WorkTableScan.
Date: 2023-06-26 03:53:28
Message-ID: DM6PR02MB66491619ED1CF10C16839F2E9026A@DM6PR02MB6649.namprd02.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Since pg is tested directly using the physical plan, the executed SQL includes a complete physical plan, and the abbreviated physical plan is:
WORKTABLESCAN{targetlist=[TargetEntry{targetexpr=CONST{constvalue ="61",consttype ="int4"},targetresname="Z",resjunk=False}],qual=[],wtParam = 59}

________________________________
发件人: PG Bug reporting form <noreply(at)postgresql(dot)org>
发送时间: 2023年6月26日 3:47
收件人: pgsql-bugs(at)lists(dot)postgresql(dot)org <pgsql-bugs(at)lists(dot)postgresql(dot)org>
抄送: chenglin-liang(at)outlook(dot)com <chenglin-liang(at)outlook(dot)com>
主题: BUG #17998: Postgres crashes when executing WorkTableScan.

The following bug has been logged on the website:

Bug reference: 17998
Logged by: Jerry
Email address: chenglin-liang(at)outlook(dot)com
PostgreSQL version: Unsupported/Unknown
Operating system: Ubuntu 18.04.6
Description:

I developed a fuzzing tool that skips the optimizer and directly uses the
correct physical plan to fuzz postgres, and found a crash caused by
executing WorkTableScan.
For detailed steps to reproduce, see the
link:https://github.com/chenglinLiang/pg-report.

-- Environment --
PG version: 10.23
Platform: Ubuntu 18.04.6
Kernel: Linux 5.15.0-75-generic

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2023-06-26 04:21:47 Re: BUG #17995: Segmentation fault caused by UPDATE statement
Previous Message PG Bug reporting form 2023-06-26 03:47:26 BUG #17998: Postgres crashes when executing WorkTableScan.