Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 10.0.12
    • Fix Version/s: 10.0.13
    • Component/s: None
    • Labels:
      None

      Description

      See http://buildbot.askmonty.org/buildbot/builders/bintar-rhel6-p8/builds/237/steps/test/logs/stdio

      CURRENT_TEST: main.statistics
      --- /home/buildbot/maria-slave/power8-vlp01/build/mysql-test/r/statistics.result	2014-07-22 14:13:54.530966000 -0400
      +++ /home/buildbot/maria-slave/power8-vlp01/build/mysql-test/r/statistics.reject	2014-07-22 16:01:11.256022665 -0400
      @@ -238,12 +238,12 @@
       hist_size, hist_type, HEX(histogram)
       FROM mysql.column_stats;
       db_name	table_name	column_name	min_value	max_value	nulls_ratio	avg_frequency	hist_size	hist_type	HEX(histogram)
      -test	t1	a	0	49	0.0000	1.0000	8	DOUBLE_PREC_HB	052F4363F4A1F9D0
      -test	t1	b	vvvvvvvvvvvvv	zzzzzzzzzzzzzzzzzz	0.2000	6.4000	8	DOUBLE_PREC_HB	0000FF3FFFBFFFFF
      +test	t1	a	0	49	0.0000	1.0000	8	DOUBLE_PREC_HB	2F056343A1F4D0F9
      +test	t1	b	vvvvvvvvvvvvv	zzzzzzzzzzzzzzzzzz	0.2000	6.4000	8	DOUBLE_PREC_HB	00003FFFBFFFFFFF
       test	t1	c	aaaa	dddddddd	0.1250	7.0000	8	DOUBLE_PREC_HB	00005555AAAAFFFF
      -test	t1	d	1989-03-12	1999-07-23	0.1500	8.5000	8	DOUBLE_PREC_HB	0000031A031AFFFF
      +test	t1	d	1989-03-12	1999-07-23	0.1500	8.5000	8	DOUBLE_PREC_HB	00001A031A03FFFF
       test	t1	e	0.01	0.112	0.2250	6.2000	8	DOUBLE_PREC_HB	000005056464E1E1
      -test	t1	f	1	5	0.2000	6.4000	8	DOUBLE_PREC_HB	FF3FFF7FFFBFFFBF
      +test	t1	f	1	5	0.2000	6.4000	8	DOUBLE_PREC_HB	3FFF7FFFBFFFBFFF
       DELETE FROM mysql.column_stats;
       set histogram_size= 0;
       set histogram_type=default;
      @@ -1480,7 +1480,7 @@
       avg_frequency	1.0467
       hist_size	254
       hist_type	DOUBLE_PREC_HB
      -hex(histogram)	1F00A1002B023002350238023F02430249024E02520258025D02630268026E02720276027B02800285028C02920297029D02A102A802AC02B402BC02C402CC02D302DA02E302EA02F102F802010305030C03120319031F03290333033D0343034F03590363036D037803840390039A03A603B303C303D103E003F203020412042404330440045304600472047F049104A204B804C804DE04F2040A0526053F0558056F058E05B305D905F4051306380667068406AB06DA06020731075C079407C507F8072E085E08A508DF0824096909CC092E0A760AD50A400BA90B150CAD0C310D240E130F0E103B11B9126B14F0166B192F1CB71FFF240630483FC567
      +hex(histogram)	001F00A1022B023002350238023F02430249024E02520258025D02630268026E02720276027B02800285028C02920297029D02A102A802AC02B402BC02C402CC02D302DA02E302EA02F102F803010305030C03120319031F03290333033D0343034F03590363036D037803840390039A03A603B303C303D103E003F204020412042404330440045304600472047F049104A204B804C804DE04F2050A0526053F0558056F058E05B305D905F4061306380667068406AB06DA07020731075C079407C507F8082E085E08A508DF0924096909CC0A2E0A760AD50B400BA90C150CAD0D310E240F13100E113B12B9146B16F0196B1C2F1FB724FF30063F4867C5
       decode_histogram(hist_type,histogram)	0.00047,0.00198,0.00601,0.00008,0.00008,0.00005,0.00011,0.00006,0.00009,0.00008,0.00006,0.00009,0.00008,0.00009,0.00008,0.00009,0.00006,0.00006,0.00008,0.00008,0.00008,0.00011,0.00009,0.00008,0.00009,0.00006,0.00011,0.00006,0.00012,0.00012,0.00012,0.00012,0.00011,0.00011,0.00014,0.00011,0.00011,0.00011,0.00014,0.00006,0.00011,0.00009,0.00011,0.00009,0.00015,0.00015,0.00015,0.00009,0.00018,0.00015,0.00015,0.00015,0.00017,0.00018,0.00018,0.00015,0.00018,0.00020,0.00024,0.00021,0.00023,0.00027,0.00024,0.00024,0.00027,0.00023,0.00020,0.00029,0.00020,0.00027,0.00020,0.00027,0.00026,0.00034,0.00024,0.00034,0.00031,0.00037,0.00043,0.00038,0.00038,0.00035,0.00047,0.00056,0.00058,0.00041,0.00047,0.00056,0.00072,0.00044,0.00060,0.00072,0.00061,0.00072,0.00066,0.00085,0.00075,0.00078,0.00082,0.00073,0.00108,0.00089,0.00105,0.00105,0.00151,0.00150,0.00110,0.00145,0.00163,0.00160,0.00165,0.00232,0.00201,0.00371,0.00365,0.00383,0.00459,0.00583,0.00662,0.00984,0.00969,0.01080,0.01379,0.02063,0.04308,0.05960,0.15816,0.59464
       set histogram_type=default;
       set histogram_size=default;
      @@ -1577,7 +1577,7 @@
       hist_size, hist_type, HEX(histogram)
       FROM mysql.column_stats;
       db_name	table_name	column_name	min_value	max_value	nulls_ratio	avg_frequency	hist_size	hist_type	HEX(histogram)
      -test	t1	a	1	5	0.0000	1.0000	10	DOUBLE_PREC_HB	0000FF3FFF7FFFBFFFFF
      +test	t1	a	1	5	0.0000	1.0000	10	DOUBLE_PREC_HB	00003FFF7FFFBFFFFFFF
       set histogram_size=default;
       set histogram_type=default;
       drop table t1;
      

        Attachments

          Issue links

            Activity

              People

              • Assignee:
                svoj Sergey Vojtovich
                Reporter:
                svoj Sergey Vojtovich
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: