From ef770cbb6913cc4c816bb09acd7cb13f996281bd Mon Sep 17 00:00:00 2001 From: Teodor Sigaev Date: Fri, 1 Jul 2005 13:44:56 +0000 Subject: Fixes from Janko Richter - Fix wrong index results on text, char, varchar for multibyte strings - Fix some SIGFPE signals - Add support for infinite timestamps - Because of locale settings, btree_gist can not be a prefix index anymore (for text). Each node holds now just the lower and upper boundary. --- contrib/btree_gist/btree_utils_num.h | 20 +++++++++++++++----- 1 file changed, 15 insertions(+), 5 deletions(-) (limited to 'contrib/btree_gist/btree_utils_num.h') diff --git a/contrib/btree_gist/btree_utils_num.h b/contrib/btree_gist/btree_utils_num.h index 714144f676..8f140953f5 100644 --- a/contrib/btree_gist/btree_utils_num.h +++ b/contrib/btree_gist/btree_utils_num.h @@ -43,16 +43,26 @@ typedef struct */ -#define penalty_range_enlarge(olower,oupper,nlower,nupper) do { \ - res = 0; \ + +/* + * Note: The factor 0.49 in following macro avoids floating point overflows +*/ +#define penalty_num(result,olower,oupper,nlower,nupper) do { \ + double tmp = 0.0F; \ + (*(result)) = 0.0F; \ if ( (nupper) > (oupper) ) \ - res += ( (nupper) - (oupper) ); \ + tmp += ( ((double)nupper)*0.49F - ((double)oupper)*0.49F ); \ if ( (olower) > (nlower) ) \ - res += ( (olower) - (nlower) ); \ + tmp += ( ((double)olower)*0.49F - ((double)nlower)*0.49F ); \ + if (tmp > 0.0F) \ + { \ + (*(result)) += FLT_MIN; \ + (*(result)) += (float) ( ((double)(tmp)) / ( (double)(tmp) + ( ((double)(oupper))*0.49F - ((double)(olower))*0.49F ) ) ); \ + (*(result)) *= (FLT_MAX / (((GISTENTRY *) PG_GETARG_POINTER(0))->rel->rd_att->natts + 1)); \ + } \ } while (0); - extern bool gbt_num_consistent(const GBT_NUMKEY_R * key, const void *query, const StrategyNumber *strategy, bool is_leaf, const gbtree_ninfo * tinfo); -- cgit v1.2.1