Bug 332565 – [FEATURES=test] dev-db/mysql-5.1.49-r1 fails a test

• Status: RESOLVED FIXED
• Product: Gentoo Linux

[Description Hans de Graaff 2010-08-13 06:48:00 UTC]

main.range                               [ fail ]
        Test ended at 2010-08-13 08:29:13

CURRENT_TEST: main.range
mysqltest: At line 1320: query 'CREATE TABLE t1 (
a INT,
b INT,
KEY ( a, b )
) PARTITION BY HASH (a) PARTITIONS 1' failed: 1289: The 'partitioning' feature is disabled; you need MySQL built with '--with-partition' to have it working

The result from queries just before the failure was:
< snip >
# Bug #48665: sql-bench's insert test fails due to wrong result
#
CREATE TABLE t1 (a INT, b INT, PRIMARY KEY (a));
INSERT INTO t1 VALUES (0,0), (1,1);
EXPLAIN 
SELECT * FROM t1 FORCE INDEX (PRIMARY) 
WHERE (a>=1 AND a<=2) OR (a>=4 AND a<=5) OR (a>=0 AND a <=10);
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
@	@	@	range	@	@	@	@	@	@
# Should return 2 rows
SELECT * FROM t1 FORCE INDEX (PRIMARY) 
WHERE (a>=1 AND a<=2) OR (a>=4 AND a<=5) OR (a>=0 AND a <=10);
a	b
0	0
1	1
DROP TABLE t1;
#
# Bug#50939: Loose Index Scan unduly relies on engine to remember range 
# endpoints
#


My USE flags:

[ebuild     U ] dev-db/mysql-5.1.49-r1 [5.1.46] USE="community perl ssl test -big-tables -cluster -debug -embedded -extraengine -latin1 -max-idx-128 -minimal -pbxt -profiling (-selinux) -static -xtradb" 0 kB

[Comment 1 Brian Evans (RETIRED) 2010-08-18 17:17:03 UTC]

According to the ebuild:

# Official test instructions:
# USE='berkdb -cluster embedded extraengine perl ssl community' \
# FEATURES='test userpriv -usersandbox' \
# ebuild mysql-X.X.XX.ebuild \
# digest clean package

[Comment 2 Hans de Graaff 2010-08-22 08:59:55 UTC]

Still an issue with mysql-5.1.40. Other tests seem to select for the partition feature, e.g.:

main.partition_symlink                   [ skipped ]  Test requires: 'have_partition'

So I guess this test needs to be protected in the same way.

[Comment 3 Robin Johnson 2010-09-01 19:04:08 UTC]

In 5.1.50-r1

[Comment 4 Hans de Graaff 2010-09-04 07:52:39 UTC]

Still fails for me with =dev-db/mysql-5.1.50-r1

main.query_cache_ps_ps_prot              [ pass ]     50
main.query_cache_with_views              [ pass ]     39
main.range                               [ fail ]
        Test ended at 2010-09-04 09:02:25

CURRENT_TEST: main.range
mysqltest: At line 1320: query 'CREATE TABLE t1 (
a INT,
b INT,
KEY ( a, b )
) PARTITION BY HASH (a) PARTITIONS 1' failed: 1289: The 'partitioning' feature is disabled; you need MySQL built with '--with-partition' to have it working

[Comment 5 Jeremy Murphy 2010-09-05 04:36:56 UTC]

main.range still fails in 5.1.50-r1 on x86.

Robin, I think you misunderstood Hans' comment: main.partition_symlink is an example of a test that is appropriately skipped but main.range is not skipped.

Upstream bug: http://bugs.mysql.com/bug.php?id=54444

[Comment 6 Robin Johnson 2010-09-05 08:52:16 UTC]

Fixed again.

[Comment 7 Hans de Graaff 2010-09-06 19:02:32 UTC]

Nope, sorry. Then again, I don't see a commit from you around this date, so perhaps it wasn't committed?

[Comment 8 Robin Johnson 2010-09-07 01:48:13 UTC]

(In reply to comment #7)
> Nope, sorry. Then again, I don't see a commit from you around this date, so
> perhaps it wasn't committed?
http://sources.gentoo.org/cgi-bin/viewvc.cgi/gentoo-x86/dev-db/mysql/mysql-5.1.50-r1.ebuild?r1=1.3&r2=1.4

[Comment 9 Hans de Graaff 2010-09-07 05:19:10 UTC]

Ah, no ChangeLog entry, I didn't check the ebuild itself. In any case now the problem is clear:

  if use extraengine ; then

should be "if ! use extraengine"

[Comment 10 Robin Johnson 2010-09-07 18:38:54 UTC]

Fixed yet again.
My echangelog entry got eaten by something. The overlay copy had it, but not the main tree one.

[Comment 11 Hans de Graaff 2010-09-10 07:07:08 UTC]

Fix confirmed. Thanks!