Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008204opensim[REGION] OpenSim Corepublic2017-06-29 12:062017-07-04 23:20
Reportertestdev627 
Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOSOS Version
Product Versionmaster (dev code) 
Target VersionFixed in Version 
Summary0008204: PGSQL need to replace 36 with 128 in the AssetSore.migration file under the appropriate VERSION for the creatorid
DescriptionOn a fresh install the PGSQL AssetSore.migration will create the creatorid to be of length 36 instead of 128. Many creatorids are urls with or without guids. This data will be truncated without a fix.
Steps To ReproduceA fresh install of OpenSimulator using Postgresql as the Database.
TagsNo tags attached.
Git Revision or version number
Run Mode Grid (Multiple Regions per Sim)
Physics EngineBulletSim
Script Engine
EnvironmentUnknown
Mono VersionNone
Viewer
Attached Files

- Relationships

-  Notes
(0032122)
Gavin Hird (reporter)
2017-07-04 23:20

That field was never intended for hyper grid use, but is populated by the UUID of local users when they create assets.

To replace a UUID native datatype with a 128 char string is a particularly bad idea for all kinds of reasons.

A better approach to accommodate the need to identify creators would be to create a new table for the purpose that will hold all the information required to identify an asset creator and relate to this table everywhere the information needs to be displayed.

Adding a new table will both make for better storage and indexing, centralise the information that is now repeated across tables and enable foreign key operations.

- Issue History
Date Modified Username Field Change
2017-06-29 12:06 testdev627 New Issue
2017-07-04 23:20 Gavin Hird Note Added: 0032122


Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker