Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-2524

LP:501400 - sql-bench test-insert.sh fails with MariaDB

    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

            Hide
            hakanküçükyılmaz Hakan Küçükyılmaz added a comment -

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

            Show
            hakanküçükyılmaz Hakan Küçükyılmaz added a comment - Re: sql-bench test-insert.sh fails with MariaDB I cannot repeat this bug with latest sources from lp:maria anymore. Case closed.
            Hide
            ratzpo Rasmus Johansson added a comment -

            Launchpad bug id: 501400

            Show
            ratzpo Rasmus Johansson added a comment - Launchpad bug id: 501400

              People

              • Assignee:
                Unassigned
                Reporter:
                hakanküçükyılmaz Hakan Küçükyılmaz
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: