[MDEV-2524] LP:501400 - sql-bench test-insert.sh fails with MariaDB Created: 2009-12-29  Updated: 2012-10-04  Resolved: 2012-10-04

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

Type: Bug
Reporter: Hakan Küçükyılmaz (Inactive) Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug501400.xml    

 Description   

The test test-insert.sh of the sql-bench suite fails with latest MariaDB 5.1.41

How to reproduce

  • Build and instal MariaDB 5.1.41
  • Start mysqld
  • run sql-bench like
    ./run-all-tests --fast --small-test --server=mysql --user=root --socket=/tmp/mysql.sock
    Benchmark DBD suite: 2.15
    Date of test: 2009-12-29 18:10:31
    Running tests on: Linux 2.6.27.29-0.1-default x86_64
    Arguments: --fast --small-test --socket=/tmp/mysql.sock
    Comments:
    Limits from:
    Server version: MySQL 5.1.41 MariaDB beta log
    Optimization: None
    Hardware:
    ...
    ...
    ...
    insert: Warning: Can't execute insert. Check the file 'output/insert-mysql_fast-Linux_2.6.27.29_0.1_default_x86_64'

Looking into output/insert-mysql_fast-Linux_2.6.27.29_0.1_default_x86_64 tells us:

Test of compares with simple ranges
'select * from bench1 where (id>=1 and id<=2 or id>=4 and id<=5) or (id>=0 and id <=10)' returned wrong number of rows: 12 instead of 11

I tried several combinations to make sure that the test itself is OK.

Server | Test | Result
----------------------------------------------------
lp:maria | lp:maria | test-insert.sh fails
----------------------------------------------------
lp:maria | lp:mysql-server | test-insert.sh fails
----------------------------------------------------
lp:mysql-server | lp:mysql-server | All tests OK
----------------------------------------------------
lp:mysql-server | lp:maria | All test OK
----------------------------------------------------



 Comments   
Comment by Rasmus Johansson (Inactive) [ 2010-01-27 ]

Launchpad bug id: 501400

Comment by Hakan Küçükyılmaz (Inactive) [ 2010-01-27 ]

Re: sql-bench test-insert.sh fails with MariaDB
I cannot repeat this bug with latest sources from lp:maria anymore.
Case closed.

Generated at Thu Feb 08 06:42:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.