Skip to content

pg_class duplicates dolt_* system tables with dolt_show_system_tables active. #2437

@NathanGabrielson

Description

@NathanGabrielson

Issue from Prisma integration. On defaults settings doltgres you get the following results:

postgres=> select oid, relname from pg_class where relname like 'dolt_%';
    oid     |          relname
------------+----------------------------
 3999387287 | dolt_branch_activity
 1167248682 | dolt_backups
 3491847678 | dolt_log
 3210116770 | dolt_schema_conflicts
  341706375 | dolt_remotes
 2056815203 | dolt_column_diff
  458530874 | dolt_branches
 3152041833 | dolt_commits
 1555944102 | dolt_commit_ancestors
 1384122262 | dolt_stashes
 1523309269 | dolt_status_ignored
 2357712556 | dolt_diff
  245736992 | dolt_conflicts
 1060579466 | dolt_status
  604995978 | dolt_merge_status
  629684363 | dolt_help
  887648921 | dolt_remote_branches
 1807684176 | dolt_tags
 1932298159 | dolt_constraint_violations

If you set dolt_show_system_tables to 1, you get the following, which seems to be tripled and then with a couple more tables?

select oid, relname from pg_class where relname like 'dolt_%';
    oid     |          relname
------------+----------------------------
 1131770412 | dolt_branches_name_idx
 1167248682 | dolt_backups
 3999387287 | dolt_branch_activity
 2189963237 | dolt_branches_name_idx
 1620606010 | dolt_branches
 3731857496 | dolt_column_diff
 4097325362 | dolt_commit_ancestors
  755798219 | dolt_commits
 3613478675 | dolt_conflicts
 2643306487 | dolt_constraint_violations
 2194613136 | dolt_diff
  629684363 | dolt_help
 4236387636 | dolt_log
 1805367320 | dolt_merge_status
 3222179546 | dolt_branches_name_idx
 2919711598 | dolt_remote_branches
 2192752933 | dolt_remotes
  399742262 | dolt_schema_conflicts
 1384122262 | dolt_stashes
 2505999383 | dolt_status
 3690448729 | dolt_status_ignored
 1710745452 | dolt_tags
 2777869953 | dolt_branches_name_idx
 3548252808 | dolt_backups
 1955528544 | dolt_branch_activity
 1691921080 | dolt_branches_name_idx
  458530874 | dolt_branches
 2056815203 | dolt_column_diff
 1555944102 | dolt_commit_ancestors
 3152041833 | dolt_commits
  245736992 | dolt_conflicts
 1932298159 | dolt_constraint_violations
 2357712556 | dolt_diff
  734055863 | dolt_help
 3491847678 | dolt_log
  604995978 | dolt_merge_status
 1471391189 | dolt_branches_name_idx
  887648921 | dolt_remote_branches
  341706375 | dolt_remotes
 3210116770 | dolt_schema_conflicts
 3295461428 | dolt_stashes
 1060579466 | dolt_status
 1523309269 | dolt_status_ignored
 1807684176 | dolt_tags
 3491847678 | dolt_log
 1932298159 | dolt_constraint_violations
 3210116770 | dolt_schema_conflicts
 2357712556 | dolt_diff
 1523309269 | dolt_status_ignored
 3999387287 | dolt_branch_activity
  245736992 | dolt_conflicts
  629684363 | dolt_help
  341706375 | dolt_remotes
 1555944102 | dolt_commit_ancestors
  604995978 | dolt_merge_status
 1807684176 | dolt_tags
  458530874 | dolt_branches
 1167248682 | dolt_backups
  887648921 | dolt_remote_branches
 1384122262 | dolt_stashes
 2056815203 | dolt_column_diff
 3152041833 | dolt_commits
 1060579466 | dolt_status

Metadata

Metadata

Labels

bugSomething isn't working

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions