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

Aria Engine negative Number Index handling

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Incomplete
    • 10.0.4, 5.5.33
    • None
    • None
    • None
    • GNU/Linux all platforms

    Description

      First, I didn't tested the other Versions which may be affected too. But 10.0.4 defenitely has this bug.

      We may have a normal table with the aria engine like

      CREATE TABLE IF NOT EXISTS `sometable` (
        `id` int(11) NOT NULL DEFAULT '0',
        `somechars` varchar(50) NOT NULL DEFAULT '',
        PRIMARY KEY (`id`)
      ) ENGINE=Aria DEFAULT CHARSET=utf8 PAGE_CHECKSUM=1;

      The problem is, we can insert negative Numbers in the primary Key but it is not possible to edit, delete or search for them anymore. Unless u search for !=0 or something, but =-1 wouldn't work.

      And now: Thanks for your awesome work and keep going doing fantastic stuff!

      Attachments

        Activity

          People

            elenst Elena Stepanova
            marknoname Mark Anonymus
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.