0000659: sql_attr_decimal (for prices)

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

Project

Category

View Status

Date Submitted

Last Update

0000659

Sphinx

general

public

2010-12-03 09:37

2013-04-11 13:10

Reporter

atissier

Assigned To

Tomat

Priority

normal

Severity

feature

Reproducibility

always

Status

assigned

Resolution

open

Platform

OS Version

Product Version

Target Version

Fixed in Version

Summary

0000659: sql_attr_decimal (for prices)

Description

Hello,

I am afraid neither sql_attr_float nor sql_attr_string is ok for indexing prices.

If I got it, if I index 9.99 using sql_attr_float it may become someting like 9.9900000000000000000000000000000008 for instance (cf : http://docs.sun.com/source/806-3568/ncg_goldberg.html [^])

If I Index "9.99" using sql_attr_string, it will rise sorting issue.

At the moment, in my opinion, the best thing to do is to index 9.99 * 100 as sql_attr_uint, but i think it would be easier for anyone if a sql_attr_decimal attribute type would exist.

Thx in advance.

Regards

Antoine

Tags

No tags attached.

Attached Files

Relationships

Notes
(0001264) Tomat (manager) 2011-03-10 12:31	in current trunk (around r2712) you could use sort with string attributes

Issue History
Date Modified	Username	Field	Change
2010-12-03 09:37	atissier	New Issue
2011-03-10 12:31	Tomat	Note Added: 0001264
2011-03-10 12:31	Tomat	Assigned To	=> Tomat
2011-03-10 12:31	Tomat	Status	new => assigned
2013-04-11 13:10	Ordos	Issue Monitored: Ordos