[MDEV-6473] main.statistics fails on PPC64 Created: 2014-07-23  Updated: 2014-07-23  Resolved: 2014-07-23

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.12
Fix Version/s: 10.0.13

Type: Bug Priority: Critical
Reporter: Sergey Vojtovich Assignee: Sergey Vojtovich
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
PartOf
is part of MDEV-6478 MariaDB on Power8 Closed

 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;



 Comments   
Comment by Sergey Vojtovich [ 2014-07-23 ]

Sergei, please review fix for this bug.

Comment by Sergei Petrunia [ 2014-07-23 ]

Reviewed, ok to push.

Comment by Sergey Vojtovich [ 2014-07-23 ]

Fixed in 10.0.13:

revno: 4303
revision-id: svoj@mariadb.org-20140723085526-i0v39faneybs7m4p
parent: jplindst@mariadb.org-20140722163145-c2hibh40f3jjj2yc
committer: Sergey Vojtovich <svoj@mariadb.org>
branch nick: 10.0
timestamp: Wed 2014-07-23 12:55:26 +0400
message:
  MDEV-6473 - main.statistics fails on PPC64
  
  mysql.column_stats wasn't stored/restored properly on big-endian
  with histogram_type=DOUBLE_PREC_HB.
  
  Store histogram values using int2store()/uint2korr().
  
  Note that this patch invalidates previously calculated histogram
  values on big-endian.

Generated at Thu Feb 08 07:12:10 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.