Details
-
Type:
Bug
-
Status: Closed
-
Resolution: Not a Bug
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
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
----------------------------------------------------
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Re: sql-bench test-insert.sh fails with MariaDB
I cannot repeat this bug with latest sources from lp:maria anymore.
Case closed.