Item names might be inconsistent after unique/set name fix #7

New Issue

omicron · 2025-10-02T02:32:15Z

omicron commented

2025-10-02 02:32:15 +00:00

After the uniques and sets got renamed there are still old item names in the database. It's not entirely clear to me if that is a problem or if items are rebuilt from the raw bytes every time they are loaded. I recall being cautious about that in the past, but it has to be verified.

sqlite> SELECT item_id, item_name FROM item INNER JOIN item_extra ON id = item_id WHERE item_name LIKE 'McAu%' AND deleted IS NULL;
471|McAuley's Taboo
499|McAuley's Taboo
527|McAuley's Riprap
565|McAuley's Riprap
608|McAuley's Superstition
632|McAuley's Superstition
1188|McAuley's Taboo
1189|McAuley's Riprap
1970|McAuley's Superstition
2001|McAuley's Taboo
2082|McAuley's Superstition

After the uniques and sets got renamed there are still old item names in the database. It's not entirely clear to me if that is a problem or if items are rebuilt from the raw bytes every time they are loaded. I recall being cautious about that in the past, but it has to be verified. ``` sqlite> SELECT item_id, item_name FROM item INNER JOIN item_extra ON id = item_id WHERE item_name LIKE 'McAu%' AND deleted IS NULL; 471|McAuley's Taboo 499|McAuley's Taboo 527|McAuley's Riprap 565|McAuley's Riprap 608|McAuley's Superstition 632|McAuley's Superstition 1188|McAuley's Taboo 1189|McAuley's Riprap 1970|McAuley's Superstition 2001|McAuley's Taboo 2082|McAuley's Superstition ```

omicron added the

question

label 2025-10-02 02:32:15 +00:00

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: omicron/d2warehouse#7