Support: Indexable negative number

Created on 30 October 2024, 16 days ago

Problem/Motivation

The negative values field can not be indexed.

If you have a weight(number) field used for "number-field-boost-settings( Aggregation - maximum) " and there is a negative value in these fields, the index does not work and gives an error.

SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'score' at row 1: INSERT INTO "dr_search_api_db_default_user_index_text" ("item_id", "field_test", "word", "score") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3), (:db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7), (:db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11); Array ( [:db_insert_placeholder_0] => entity:user/40:tr [:db_insert_placeholder_1] => rendered_item [:db_insert_placeholder_2] =>

Any idea, please. Thanks

Note:
By the way, when importing the configuration to a new site with an empty database, the search API gives an error about this weight field.

💬 Support request
Status

Active

Version

1.0

Component

General code

Created by

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Merge Requests

Comments & Activities

Production build 0.71.5 2024