[GeneX-dev] [ genex-Bugs-848040 ] Scratch wants to have it's float fields turned into ints

[SourceForge.net <no...@so...>]

Bugs item #848040, was opened at 2003-11-24 00:26
Message generated for change (Comment added) made by jason_e_stewart
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=116453&aid=848040&group_id=16453

Category: DB Schema
Group: Genex-2
>Status: Open
>Resolution: Accepted
Priority: 9
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Jason E. Stewart (jason_e_stewart)
Summary: Scratch wants to have it's float fields turned into ints

Initial Comment:
Scratch wants to have it's float fields turned into ints - this is  for indexing performance reasons (how many do we need? Just one I  think) perhaps create a SELECT trigger so that the columns are  returned correctly as floats? Probably not, since that would  probably really confuse the DBI.

----------------------------------------------------------------------

>Comment By: Jason E. Stewart (jason_e_stewart)
Date: 2004-05-10 07:48

Message:
Logged In: YES 
user_id=85550

Whoops! This didn't get fixed properly.

It's back and this time the DB needs a major rehaul. We're
going to store all data table floats as ints. The data
loader needs to do the conversion from floats => ints at
load time.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=116453&aid=848040&group_id=16453