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

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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Resolution: Not a Bug
    • None
    • None
    • None

    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
      ----------------------------------------------------

      Attachments

        Activity

          People

            Unassigned Unassigned
            hakanküçükyılmaz Hakan Küçükyılmaz (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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