[MDEV-6198] statistics.test fails in valgrind. - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.0.10
Fix Version/s: 10.0.11
Component/s: None
Labels:
None

Description

statistics.test fails in valgrind after the push for ~~MDEV-5947~~.

Attachments

Activity

Ascending order - Click to sort in descending order

Igor Babaev (Inactive) created issue - 2014-05-02 03:33

Igor Babaev (Inactive) added a comment - 2014-05-02 03:39 - edited

The problem can be easily reproduced with the following simple test case:

CREATE TABLE t1 (

  a int NOT NULL PRIMARY KEY,

  b varchar(32),

  c char(16),

  d date,

  e double,

  f bit(3),

  INDEX idx1 (b, e),

  INDEX idx2 (c, d),

  INDEX idx3 (d),

  INDEX idx4 (e, b, d)

) ENGINE= MYISAM;

INSERT INTO t1 VALUES

  (0, NULL, NULL, NULL, NULL, NULL),

  (7, 'xxxxxxxxxxxxxxxxxxxxxxxxxx', 'dddddddd', '1990-05-15', 0.1, b'100'),

  (17, 'vvvvvvvvvvvvv', 'aaaa', '1989-03-12', 0.01, b'101'),

  (1, 'vvvvvvvvvvvvv', NULL, '1989-03-12', 0.01, b'100'),

  (12, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww', 'dddddddd', '1999-07-23', 0.112, b'001'),

  (23, 'vvvvvvvvvvvvv', 'dddddddd', '1999-07-23', 0.1, b'100'),

  (8, 'vvvvvvvvvvvvv', 'aaaa', '1999-07-23', 0.1, b'100'),

  (22, 'xxxxxxxxxxxxxxxxxxxxxxxxxx', 'aaaa', '1989-03-12', 0.112, b'001'),

  (31, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww', 'aaaa', '1999-07-23', 0.01, b'001'),

  (10, NULL, 'aaaa', NULL, 0.01, b'010'),

  (5, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww', 'dddddddd', '1999-07-23', 0.1, b'100'),

  (15, 'vvvvvvvvvvvvv', 'ccccccccc', '1990-05-15', 0.1, b'010'),

  (30, NULL, 'bbbbbb', NULL, NULL, b'100'),

  (38, 'zzzzzzzzzzzzzzzzzz', 'bbbbbb', NULL, NULL, NULL),

  (18, 'zzzzzzzzzzzzzzzzzz', 'ccccccccc', '1990-05-15', 0.01, b'010'),

  (9, 'yyy', 'bbbbbb', '1998-08-28', 0.01, NULL),

  (29, 'vvvvvvvvvvvvv', 'dddddddd', '1999-07-23', 0.012, b'010'),

  (3, 'yyy', 'dddddddd',  '1990-05-15', 0.112, b'010'),

  (39, 'zzzzzzzzzzzzzzzzzz', 'bbbbbb', NULL, 0.01, b'100'),

  (14, 'xxxxxxxxxxxxxxxxxxxxxxxxxx', 'ccccccccc', '1990-05-15', 0.1, b'100'),

  (40, 'zzzzzzzzzzzzzzzzzz', 'bbbbbb', '1989-03-12', NULL, NULL),

  (44, NULL, 'aaaa', '1989-03-12', NULL, b'010'),

  (19, 'vvvvvvvvvvvvv', 'ccccccccc', '1990-05-15', 0.012, b'011'),

  (21, 'zzzzzzzzzzzzzzzzzz', 'dddddddd', '1989-03-12', 0.112, b'100'),

  (45, NULL, NULL, '1989-03-12', NULL, b'011'),

  (2, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww', 'ccccccccc', '1990-05-15', 0.1, b'001'),

  (35, 'yyy', 'aaaa', '1990-05-15', 0.05, b'011'),

  (4, 'vvvvvvvvvvvvv', 'dddddddd', '1999-07-23', 0.01, b'101'),

  (47, NULL, 'aaaa', '1990-05-15', 0.05, b'010'),

  (42, NULL, 'ccccccccc', '1989-03-12', 0.01, b'010'),

  (32, NULL, 'bbbbbb', '1990-05-15', 0.01, b'011'),

  (49, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww' , 'aaaa', '1990-05-15', NULL, NULL),

  (43, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww' , 'bbbbbb', '1990-05-15', NULL, b'100'),

  (37, 'yyy', NULL, '1989-03-12', 0.05, b'011'),

  (41, 'xxxxxxxxxxxxxxxxxxxxxxxxxx', 'ccccccccc', '1990-05-15', 0.05, NULL),

  (34, 'yyy', NULL, NULL, NULL, NULL),

  (33, 'zzzzzzzzzzzzzzzzzz', 'dddddddd', '1989-03-12', 0.05, b'011'),

  (24,  'wwwwwwwwwwwwwwwwwwwwwwwwwwww', 'dddddddd', '1990-05-15', 0.01,  b'101'),

  (11, 'yyy', 'ccccccccc', '1999-07-23', 0.1, NULL),

  (25, 'zzzzzzzzzzzzzzzzzz', 'bbb', '1989-03-12', 0.01,  b'101');

ANALYZE TABLE t1;

SELECT COUNT(DISTINCT t1.e, t1.b, t1.d) FROM t1;

DROP TABLE t1;

Igor Babaev (Inactive) added a comment - 2014-05-02 03:39 - edited The problem can be easily reproduced with the following simple test case: CREATE TABLE t1 ( a int NOT NULL PRIMARY KEY , b varchar (32), c char (16), d date , e double , f bit (3), INDEX idx1 (b, e), INDEX idx2 (c, d), INDEX idx3 (d), INDEX idx4 (e, b, d) ) ENGINE= MYISAM; INSERT INTO t1 VALUES (0, NULL , NULL , NULL , NULL , NULL ), (7, 'xxxxxxxxxxxxxxxxxxxxxxxxxx' , 'dddddddd' , '1990-05-15' , 0.1, b '100' ), (17, 'vvvvvvvvvvvvv' , 'aaaa' , '1989-03-12' , 0.01, b '101' ), (1, 'vvvvvvvvvvvvv' , NULL , '1989-03-12' , 0.01, b '100' ), (12, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww' , 'dddddddd' , '1999-07-23' , 0.112, b '001' ), (23, 'vvvvvvvvvvvvv' , 'dddddddd' , '1999-07-23' , 0.1, b '100' ), (8, 'vvvvvvvvvvvvv' , 'aaaa' , '1999-07-23' , 0.1, b '100' ), (22, 'xxxxxxxxxxxxxxxxxxxxxxxxxx' , 'aaaa' , '1989-03-12' , 0.112, b '001' ), (31, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww' , 'aaaa' , '1999-07-23' , 0.01, b '001' ), (10, NULL , 'aaaa' , NULL , 0.01, b '010' ), (5, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww' , 'dddddddd' , '1999-07-23' , 0.1, b '100' ), (15, 'vvvvvvvvvvvvv' , 'ccccccccc' , '1990-05-15' , 0.1, b '010' ), (30, NULL , 'bbbbbb' , NULL , NULL , b '100' ), (38, 'zzzzzzzzzzzzzzzzzz' , 'bbbbbb' , NULL , NULL , NULL ), (18, 'zzzzzzzzzzzzzzzzzz' , 'ccccccccc' , '1990-05-15' , 0.01, b '010' ), (9, 'yyy' , 'bbbbbb' , '1998-08-28' , 0.01, NULL ), (29, 'vvvvvvvvvvvvv' , 'dddddddd' , '1999-07-23' , 0.012, b '010' ), (3, 'yyy' , 'dddddddd' , '1990-05-15' , 0.112, b '010' ), (39, 'zzzzzzzzzzzzzzzzzz' , 'bbbbbb' , NULL , 0.01, b '100' ), (14, 'xxxxxxxxxxxxxxxxxxxxxxxxxx' , 'ccccccccc' , '1990-05-15' , 0.1, b '100' ), (40, 'zzzzzzzzzzzzzzzzzz' , 'bbbbbb' , '1989-03-12' , NULL , NULL ), (44, NULL , 'aaaa' , '1989-03-12' , NULL , b '010' ), (19, 'vvvvvvvvvvvvv' , 'ccccccccc' , '1990-05-15' , 0.012, b '011' ), (21, 'zzzzzzzzzzzzzzzzzz' , 'dddddddd' , '1989-03-12' , 0.112, b '100' ), (45, NULL , NULL , '1989-03-12' , NULL , b '011' ), (2, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww' , 'ccccccccc' , '1990-05-15' , 0.1, b '001' ), (35, 'yyy' , 'aaaa' , '1990-05-15' , 0.05, b '011' ), (4, 'vvvvvvvvvvvvv' , 'dddddddd' , '1999-07-23' , 0.01, b '101' ), (47, NULL , 'aaaa' , '1990-05-15' , 0.05, b '010' ), (42, NULL , 'ccccccccc' , '1989-03-12' , 0.01, b '010' ), (32, NULL , 'bbbbbb' , '1990-05-15' , 0.01, b '011' ), (49, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww' , 'aaaa' , '1990-05-15' , NULL , NULL ), (43, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww' , 'bbbbbb' , '1990-05-15' , NULL , b '100' ), (37, 'yyy' , NULL , '1989-03-12' , 0.05, b '011' ), (41, 'xxxxxxxxxxxxxxxxxxxxxxxxxx' , 'ccccccccc' , '1990-05-15' , 0.05, NULL ), (34, 'yyy' , NULL , NULL , NULL , NULL ), (33, 'zzzzzzzzzzzzzzzzzz' , 'dddddddd' , '1989-03-12' , 0.05, b '011' ), (24, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww' , 'dddddddd' , '1990-05-15' , 0.01, b '101' ), (11, 'yyy' , 'ccccccccc' , '1999-07-23' , 0.1, NULL ), (25, 'zzzzzzzzzzzzzzzzzz' , 'bbb' , '1989-03-12' , 0.01, b '101' ); ANALYZE TABLE t1; SELECT COUNT ( DISTINCT t1.e, t1.b, t1.d) FROM t1; DROP TABLE t1;

Igor Babaev (Inactive) added a comment - 2014-05-02 04:51 - edited

There is no complains with the following test case:

CREATE TABLE t2 (

  a int NOT NULL PRIMARY KEY,

  b varchar(32),

  c char(16),

  d int,

  e double,

  f bit(3),

  INDEX idx1 (b, e),

  INDEX idx2 (c, d),

  INDEX idx3 (d),

  INDEX idx4 (e, b, d)

) ENGINE= MYISAM;

INSERT INTO t2 VALUES

  (0, NULL, NULL, NULL, NULL, NULL),

  (7, 'xxxxxxxxxxxxxxxxxxxxxxxxxx', 'dddddddd', 1990, 0.1, b'100'),

  (17, 'vvvvvvvvvvvvv', 'aaaa', 1989, 0.01, b'101'),

  (1, 'vvvvvvvvvvvvv', NULL, 1989, 0.01, b'100'),

  (12, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww', 'dddddddd', 1999, 0.112, b'001'),

  (23, 'vvvvvvvvvvvvv', 'dddddddd', 1999, 0.1, b'100'),

  (8, 'vvvvvvvvvvvvv', 'aaaa', 1999, 0.1, b'100'),

  (22, 'xxxxxxxxxxxxxxxxxxxxxxxxxx', 'aaaa', 1989, 0.112, b'001'),

  (31, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww', 'aaaa', 1997, 0.01, b'001'),

  (10, NULL, 'aaaa', NULL, 0.01, b'010'),

  (5, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww', 'dddddddd', 1999, 0.1, b'100'),

  (15, 'vvvvvvvvvvvvv', 'ccccccccc', 1990, 0.1, b'010'),

  (30, NULL, 'bbbbbb', NULL, NULL, b'100'),

  (38, 'zzzzzzzzzzzzzzzzzz', 'bbbbbb', NULL, NULL, NULL),

  (18, 'zzzzzzzzzzzzzzzzzz', 'ccccccccc', 1990, 0.01, b'010'),

  (9, 'yyy', 'bbbbbb', 1998, 0.01, NULL),

  (29, 'vvvvvvvvvvvvv', 'dddddddd', 1999, 0.012, b'010'),

  (3, 'yyy', 'dddddddd',  1990, 0.112, b'010'),

  (39, 'zzzzzzzzzzzzzzzzzz', 'bbbbbb', NULL, 0.01, b'100'),

  (14, 'xxxxxxxxxxxxxxxxxxxxxxxxxx', 'ccccccccc', 1990, 0.1, b'100'),

  (40, 'zzzzzzzzzzzzzzzzzz', 'bbbbbb', 1989, NULL, NULL),

  (44, NULL, 'aaaa', 1989, NULL, b'010'),

  (19, 'vvvvvvvvvvvvv', 'ccccccccc', 1990, 0.012, b'011'),

  (21, 'zzzzzzzzzzzzzzzzzz', 'dddddddd', 1989, 0.112, b'100'),

  (45, NULL, NULL, 1989, NULL, b'011'),

  (2, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww', 'ccccccccc', 1990, 0.1, b'001'),

  (35, 'yyy', 'aaaa', 1990, 0.05, b'011'),

  (4, 'vvvvvvvvvvvvv', 'dddddddd', 1999, 0.01, b'101'),

  (47, NULL, 'aaaa', 1990, 0.05, b'010'),

  (42, NULL, 'ccccccccc', 1989, 0.01, b'010'),

  (32, NULL, 'bbbbbb', 1990, 0.01, b'011'),

  (49, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww' , 'aaaa', 1990, NULL, NULL),

  (43, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww' , 'bbbbbb', 1990, NULL, b'100'),

  (37, 'yyy', NULL, 1989, 0.05, b'011'),

  (41, 'xxxxxxxxxxxxxxxxxxxxxxxxxx', 'ccccccccc', 1990, 0.05, NULL),

  (34, 'yyy', NULL, NULL, NULL, NULL),

  (33, 'zzzzzzzzzzzzzzzzzz', 'dddddddd', 1989, 0.05, b'011'),

  (24,  'wwwwwwwwwwwwwwwwwwwwwwwwwwww', 'dddddddd', 1990, 0.01,  b'101'),

  (11, 'yyy', 'ccccccccc', 1999, 0.1, NULL),

  (25, 'zzzzzzzzzzzzzzzzzz', 'bbb', 1989, 0.01,  b'101');

ANALYZE TABLE t2;

SELECT COUNT(DISTINCT t2.e, t2.b, t2.d) FROM t2;

It looks like fields of the DATE type trigger the complain.

Igor Babaev (Inactive) added a comment - 2014-05-02 04:51 - edited There is no complains with the following test case: CREATE TABLE t2 ( a int NOT NULL PRIMARY KEY , b varchar (32), c char (16), d int , e double , f bit (3), INDEX idx1 (b, e), INDEX idx2 (c, d), INDEX idx3 (d), INDEX idx4 (e, b, d) ) ENGINE= MYISAM; INSERT INTO t2 VALUES (0, NULL , NULL , NULL , NULL , NULL ), (7, 'xxxxxxxxxxxxxxxxxxxxxxxxxx' , 'dddddddd' , 1990, 0.1, b '100' ), (17, 'vvvvvvvvvvvvv' , 'aaaa' , 1989, 0.01, b '101' ), (1, 'vvvvvvvvvvvvv' , NULL , 1989, 0.01, b '100' ), (12, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww' , 'dddddddd' , 1999, 0.112, b '001' ), (23, 'vvvvvvvvvvvvv' , 'dddddddd' , 1999, 0.1, b '100' ), (8, 'vvvvvvvvvvvvv' , 'aaaa' , 1999, 0.1, b '100' ), (22, 'xxxxxxxxxxxxxxxxxxxxxxxxxx' , 'aaaa' , 1989, 0.112, b '001' ), (31, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww' , 'aaaa' , 1997, 0.01, b '001' ), (10, NULL , 'aaaa' , NULL , 0.01, b '010' ), (5, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww' , 'dddddddd' , 1999, 0.1, b '100' ), (15, 'vvvvvvvvvvvvv' , 'ccccccccc' , 1990, 0.1, b '010' ), (30, NULL , 'bbbbbb' , NULL , NULL , b '100' ), (38, 'zzzzzzzzzzzzzzzzzz' , 'bbbbbb' , NULL , NULL , NULL ), (18, 'zzzzzzzzzzzzzzzzzz' , 'ccccccccc' , 1990, 0.01, b '010' ), (9, 'yyy' , 'bbbbbb' , 1998, 0.01, NULL ), (29, 'vvvvvvvvvvvvv' , 'dddddddd' , 1999, 0.012, b '010' ), (3, 'yyy' , 'dddddddd' , 1990, 0.112, b '010' ), (39, 'zzzzzzzzzzzzzzzzzz' , 'bbbbbb' , NULL , 0.01, b '100' ), (14, 'xxxxxxxxxxxxxxxxxxxxxxxxxx' , 'ccccccccc' , 1990, 0.1, b '100' ), (40, 'zzzzzzzzzzzzzzzzzz' , 'bbbbbb' , 1989, NULL , NULL ), (44, NULL , 'aaaa' , 1989, NULL , b '010' ), (19, 'vvvvvvvvvvvvv' , 'ccccccccc' , 1990, 0.012, b '011' ), (21, 'zzzzzzzzzzzzzzzzzz' , 'dddddddd' , 1989, 0.112, b '100' ), (45, NULL , NULL , 1989, NULL , b '011' ), (2, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww' , 'ccccccccc' , 1990, 0.1, b '001' ), (35, 'yyy' , 'aaaa' , 1990, 0.05, b '011' ), (4, 'vvvvvvvvvvvvv' , 'dddddddd' , 1999, 0.01, b '101' ), (47, NULL , 'aaaa' , 1990, 0.05, b '010' ), (42, NULL , 'ccccccccc' , 1989, 0.01, b '010' ), (32, NULL , 'bbbbbb' , 1990, 0.01, b '011' ), (49, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww' , 'aaaa' , 1990, NULL , NULL ), (43, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww' , 'bbbbbb' , 1990, NULL , b '100' ), (37, 'yyy' , NULL , 1989, 0.05, b '011' ), (41, 'xxxxxxxxxxxxxxxxxxxxxxxxxx' , 'ccccccccc' , 1990, 0.05, NULL ), (34, 'yyy' , NULL , NULL , NULL , NULL ), (33, 'zzzzzzzzzzzzzzzzzz' , 'dddddddd' , 1989, 0.05, b '011' ), (24, 'wwwwwwwwwwwwwwwwwwwwwwwwwwww' , 'dddddddd' , 1990, 0.01, b '101' ), (11, 'yyy' , 'ccccccccc' , 1999, 0.1, NULL ), (25, 'zzzzzzzzzzzzzzzzzz' , 'bbb' , 1989, 0.01, b '101' ); ANALYZE TABLE t2; SELECT COUNT ( DISTINCT t2.e, t2.b, t2.d) FROM t2; It looks like fields of the DATE type trigger the complain.

Sergei Golubchik made changes - 2014-05-02 10:49

Field	Original Value	New Value
Description	statistics.test fails in valgrind after the push for mdev-5947.	statistics.test fails in valgrind after the push for ~~MDEV-5947~~.

Sergei Golubchik made changes - 2014-05-10 23:12

Fix Version/s		10.0.12 [ 15201 ]
Fix Version/s	10.0.11 [ 15200 ]

Sergei Golubchik made changes - 2014-05-10 23:55

Fix Version/s		10.0.11 [ 15200 ]
Fix Version/s	10.0.12 [ 15201 ]

Sergei Golubchik made changes - 2014-05-10 23:55

Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2014-06-13 15:06

Workflow

defaullt [ 39921 ]

MariaDB v2 [ 43719 ]

Rasmus Johansson (Inactive) made changes - 2015-05-18 17:51

Workflow

MariaDB v2 [ 43719 ]

MariaDB v3 [ 62881 ]

Sergei Golubchik made changes - 2021-12-06 21:40

Workflow

MariaDB v3 [ 62881 ]

MariaDB v4 [ 147859 ]

People

Assignee:: Igor Babaev (Inactive)

Reporter:: Igor Babaev (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2014-05-02 03:33

Updated:: 2014-05-10 23:55

Resolved:: 2014-05-10 23:55

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Activity

People

Dates

Git Integration