Wordpress-meta_query不适用于超过100万的值 - Wordpress - meta_query does not work with values above 1 million

Wordpress - meta_query does not work with values above 1 million

我有这个代码：

$args3 = array(
                        'post_type'  => 'imoveis_a_venda',
                        'cat'        => $categoria,
                        'meta_query' => array(
                          array(
                            'key' => 'valor',
                            'value' => array($amount1,$amount2),
                            'compare' => 'BETWEEN',
                            'type' => 'NUMERICAL'
                            ),
                          )
                        );

到值在0和999.999,00之间可以完美工作。但是过了100万就没用了。

将meta_query中的类型设置为SIGNED。

$args3 = array(
                  'post_type'  => 'imoveis_a_venda',
                  'cat'        => $categoria,
                  'meta_query' => array(
                      array(
                        'key' => 'valor',
                        'value' => array($amount1,$amount2),
                        'compare' => 'BETWEEN',
                        'type' => 'SIGNED'
                        ),
                    )
           );