Estimation for filtered rows less precise with JSON histogram comparing to DOUBLE_PREC (#5)

--source include/have_sequence.inc

create table t1 (id int, a varchar(8)) engine=MyISAM;

insert into t1 select seq, 'bar' from seq_1_to_100;

insert into t1 select id, 'qux' from t1;

set histogram_type=JSON_HB;

analyze table t1 persistent for all;

explain format=json select COUNT(*) FROM t1 WHERE a > 'foo';

set histogram_type=DOUBLE_PREC_HB;

analyze table t1 persistent for all;

explain format=json select COUNT(*) FROM t1 WHERE a > 'foo';

# Cleanup

drop table t1;

  "query_block": {

    "select_id": 1,

    "nested_loop": [

      {

        "table": {

          "table_name": "t1",

          "access_type": "ALL",

          "rows": 200,

          "filtered": 86.55463409,

          "attached_condition": "t1.a > 'foo'"

        }

      }

    ]

  }

  "query_block": {

    "select_id": 1,

    "nested_loop": [

      {

        "table": {

          "table_name": "t1",

          "access_type": "ALL",

          "rows": 200,

          "filtered": 50,

          "attached_condition": "t1.a > 'foo'"

        }

      }

    ]

  }