support create index on virtual generated column.

Edit
ID 5667
Title support create index on virtual generated column.
CI (CFBot) Summary
Stats (from CFBot) Patch version: v9, Patch count: 1, First patch: +601−198, All patches: +601−198
Tags
Created 2025-03-26 08:29:53
Last modified 2026-07-22 13:07:02 (1 hour ago)
Latest email 2026-07-22 13:02:27 (1 hour ago)
Status
PG20-1 (2026-07-01 – 2026-07-31): Needs review
PG19-Final (2026-03-01 – 2026-04-09): Moved to different CF
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
PG19-2 (2025-09-01 – 2025-09-30): Moved to different CF
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
Target version
Authors Jian He (stayreal)
Reviewers Soumya S Murali (soumyamurali), Zizhuan Liu (liuzizhuan) Become reviewer
Committer
Links
Emails
support create index on virtual generated column.
First at 2025-03-26 07:15:00 by jian he <jian.universality at gmail.com>
Latest at 2026-07-22 13:02:27 by ZizhuanLiu X-MAN <44973863 at qq.com>
Latest attachment (v9-0001-v9-enhance-index-support-for-virtual-generated-co.patch) at 2026-07-22 13:02:27 from ZizhuanLiu X-MAN <44973863 at qq.com>
    Attachment (v9-0001-v9-enhance-index-support-for-virtual-generated-co.patch) at 2026-07-22 13:02:27 from ZizhuanLiu X-MAN <44973863 at qq.com> (Patch: No)
    Attachment (v8-0001-V8-enhance-index-support-for-virtual-generated-co.patch) at 2026-07-21 15:13:32 from ZizhuanLiu X-MAN <44973863 at qq.com> (Patch: No)
    Attachment (v7-0001-enhance-index-support-for-virtual-generated-colum.patch) at 2026-07-12 03:00:34 from ZizhuanLiu X-MAN <44973863 at qq.com> (Patch: Yes)
    Attachment (v6-0001-enhance-index-support-for-virtual-generated-colum.patch) at 2026-07-11 14:28:02 from ZizhuanLiu X-MAN <44973863 at qq.com> (Patch: Yes)
    Attachment (v5-0001-v5-enhance-index-support-for-virtual-generated-co.patch) at 2026-07-08 10:02:40 from ZizhuanLiu X-MAN <44973863 at qq.com> (Patch: Yes)
    Attachment (v4-0001-enhance-index-support-for-virtual-generated-colum.patch) at 2026-07-07 13:40:10 from ZizhuanLiu X-MAN <44973863 at qq.com> (Patch: Yes)
    Attachment (v3-0001-v2-enhance-index-support-for-virtual-generated-co.patch) at 2026-07-06 16:09:36 from ZizhuanLiu X-MAN <44973863 at qq.com> (Patch: Yes)
    Attachment (v0.patch.txt) at 2026-07-05 03:04:09 from ZizhuanLiu X-MAN <44973863 at qq.com> (Patch: Yes)
    Attachment (v1-0001-index-on-virtual-generated-column.patch) at 2026-05-06 09:20:15 from Kirill Reshke <reshkekirill at gmail.com> (Patch: Yes)
    Attachment (v8-0001-index-on-virtual-generated-column.patch) at 2026-03-16 03:31:42 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (0001-Add-test-for-virtual-generated-column-index-restrict.patch) at 2026-03-04 05:43:33 from Soumya S Murali <soumyamurali.work at gmail.com> (Patch: Yes)
    Attachment (0001-skip-virtual-generated-column-handling-during-bootst.patch) at 2026-02-27 10:45:33 from Soumya S Murali <soumyamurali.work at gmail.com> (Patch: Yes)
    Attachment (v7-0001-index-on-virtual-generated-column.patch) at 2026-01-08 06:16:49 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v6-0001-index-on-virtual-generated-column.patch) at 2025-07-24 10:46:39 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v5-0001-index-on-virtual-generated-column.patch) at 2025-07-10 03:47:51 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v4-0001-index-on-virtual-generated-column.patch) at 2025-07-08 06:37:37 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v3-0001-index-on-virtual-generated-column.patch) at 2025-04-15 08:36:46 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v2-0001-index-on-virtual-generated-column.patch) at 2025-04-14 11:09:45 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v1-0001-support-create-index-on-virtual-generated-column.patch) at 2025-03-26 07:15:00 from jian he <jian.universality at gmail.com> (Patch: Yes)
Allow virtual columns in index expressions or predicate
First at 2025-09-30 09:13:43 by Richard Guo <guofenglinux at gmail.com>
Latest at 2025-10-03 09:10:35 by Chengpeng Yan <chengpeng_yan at Outlook.com>
Latest attachment (v1-0001-Allow-virtual-columns-in-index-expressions-or-pre.patch) at 2025-09-30 09:13:43 from Richard Guo <guofenglinux at gmail.com>
    Attachment (v1-0001-Allow-virtual-columns-in-index-expressions-or-pre.patch) at 2025-09-30 09:13:43 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
Proposal: Support virtual generated columns in index expressions and predicates
First at 2026-06-24 11:41:44 by ZizhuanLiu X-MAN <44973863 at qq.com>
Latest at 2026-06-24 11:41:44 by ZizhuanLiu X-MAN <44973863 at qq.com>
History
When Who What
2026-07-22 13:13:36 CFbot Patch does not need rebase anymore
2026-07-22 13:07:02 Zizhuan Liu (liuzizhuan) New status: Needs review
2026-07-21 15:31:31 CFbot Patch needs rebase
2026-07-05 08:58:27 Zizhuan Liu (liuzizhuan) Attached mail thread CAMbWs4811nG3w_3sLxps+EAuUsffA_83ZQ-1acEH_jQeq117mg@mail.gmail.com
2026-07-05 08:57:41 Zizhuan Liu (liuzizhuan) Attached mail thread tencent_54EF3ECB626AD14621788C36625A8109A207@qq.com
2026-07-05 02:23:58 Zizhuan Liu (liuzizhuan) Added liuzizhuan as reviewer
2026-05-06 09:32:29 CFbot Patch does not need rebase anymore
2026-03-27 18:46:24 CFbot Patch needs rebase
2026-03-13 14:08:00 Peter Eisentraut (petere) New status: Waiting on Author
2026-03-05 03:17:13 Jian He (stayreal) Moved from CF PG19-Final to CF PG20-1
2026-03-04 06:09:29 CFbot Patch does not need rebase anymore
2026-02-27 11:10:26 CFbot Patch needs rebase
2026-02-19 04:49:16 Soumya S Murali (soumyamurali) Added soumyamurali as reviewer
2026-02-01 00:00:09 CFbot Moved from CF PG19-4 to CF PG19-Final
2026-01-08 06:45:27 CFbot Patch does not need rebase anymore
2025-12-03 08:57:19 Jian He (stayreal) Moved from CF PG19-3 to CF PG19-4
2025-10-09 16:11:05 Jian He (stayreal) Moved from CF PG19-2 to CF PG19-3
2025-09-20 13:12:20 CFbot Patch needs rebase
2025-08-31 16:21:07 Peter Eisentraut (petere) Moved from CF PG19-1 to CF PG19-2
2025-07-08 07:06:25 CFbot Patch does not need rebase anymore
2025-07-03 12:41:22 CFbot Patch needs rebase
2025-04-14 11:50:37 CFbot Patch does not need rebase anymore
2025-03-29 00:50:38 CFbot Patch needs rebase
2025-03-26 08:29:54 Jian He (stayreal) Attached mail thread CACJufxGao-cypdNhifHAdt8jHfK6-HX=tRBovBkgRuxw063GaA@mail.gmail.com
2025-03-26 08:29:53 Jian He (stayreal) Created patch record
Edit