dhcpdb_create.pgsql erroneously creates dhcp4_server_modification_ts index on dhcp6_server table
name: Bug report
about: Create a report to help us improve
Describe the bug
dhcpdb_create.pgsql erroneously creates the dhcp4_server_modification_ts index on the dhcp6_server table
To Reproduce Steps to reproduce the behavior:
- Initialize a PostgreSQL database using dhcpdb_create.pgsql
- Inspect the dhcp4_server_modification_ts index
- See that it is associated with the dhcp6_server table
Expected behavior A clear and concise description of what you expected to happen:
The dhcp4_server_modification_ts index should be associated with the dhcp4_server table.
Environment:
- Kea version: 2.2.0
- OS: FreeBSD 13.2-RELEASE amd64
- Compiled with pgsql backend
- Loaded hooks: pgsql_cb
Additional Information
kea=> \di dhcp4_server_modification_ts
List of relations
Schema | Name | Type | Owner | Table
--------+------------------------------+-------+-------+--------------
public | dhcp4_server_modification_ts | index | kea | dhcp6_server
(1 row)
This appears to have been introduced as a copy/paste error in version 7.0 of the schema. I could identify no correspond bug in the MySQL schema.
Contacting you
- SMS/Signal: (available upon request)
- GitHub/GitLab: neirbowj
- Mastodon: @neirbowj@mastodon.online