These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

SDE Anomaly on dgmtypeattributes table
Author
Previous Topic Next Topic
Lai Rai
Perkone
Caldari State
#1 - 2015-06-18 16:52:43 UTC
I found out that when I run a query such as this:

Large Blaster Specialization Skill Attributes
SELECT * FROM dgmtypeattributes WHERE typeID=12212;


On the row with [attributeID] = 278, it gives me the value under the [valueFloat] column instead of under the [valueInt] column.
Since [attributeID] = 278 pertains to the skill level of the secondary required skill, shouldn't the value be under the [valueInt] column just like the rest of the skills?

Thanks
Desmont McCallock
#2 - 2015-06-18 17:21:56 UTC
This is happening for years now. Just take into consideration that valueFloat overrides valueInt.
Mr Mac
Dark Goliath
#3 - 2015-06-18 20:30:35 UTC
one of value columns always be NULL. you can merge two into one


SELECT [typeID] ,[attributeID] ,ISNULL(COALESCE([valueInt], [valueFloat]), 0) as value
FROM [dbo].[dgmTypeAttributes]
Slivo
Beehive Surveillance
X877.
#4 - 2015-06-19 09:04:50 UTC
I saw while working on EveHQ both column with a value on some row.

We use the valueFloat if the value is not null, even if valueInt is not null