How do I resolve the issue of MariaDB 10.3.18 index not functioning properly when using the clause "where (value 1, value2)" and having value1 greater than 2^32-1 and value2 less than 2^32-1?

edit

There are a few potential solutions to this issue:

1. Upgrade to a newer version of MariaDB. There may be bug fixes or optimizations in later releases that resolve this issue.

2. Use a different data type for the affected columns. If possible, consider using a larger data type such as BIGINT or DECIMAL to avoid exceeding the 32-bit limit.

3. Reorder the values in the WHERE clause. Changing the order in which the values are compared may improve index usage.

4. Use a composite index. If the affected columns are frequently used together in queries, creating a composite index on both columns may improve performance.

5. Rewrite the query. Depending on the specifics of the query and the data being queried, it may be possible to modify the query itself to improve indexing and avoid the issue altogether.