[MDEV-5020] Aria Engine negative Number Index handling Created: 2013-09-16  Updated: 2013-10-17  Due: 2013-10-16  Resolved: 2013-10-17

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

Type: Bug Priority: Blocker
Reporter: Mark Anonymus Assignee: Elena Stepanova
Resolution: Incomplete Votes: 0
Labels: None
Environment:

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!

 Comments   
Comment by Elena Stepanova [ 2013-09-16 ]

Hi,

Could you please be a bit more specific in regard to how it is not possible to work with the negative numbers, what exactly you observe?

So far you said =-1 wouldn't work, it seems to work for me:

Server version: 10.0.4-MariaDB-debug Source distribution

Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [test]> 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;
Query OK, 0 rows affected (0.49 sec)

MariaDB [test]> insert into sometable values (-1, 'a'),(-2,'b'),(1,'c');
Query OK, 3 rows affected (0.07 sec)
Records: 3 Duplicates: 0 Warnings: 0

MariaDB [test]> select * from sometable where id = -1;
-------------+

id somechars

-------------+

-1 a

-------------+
1 row in set (0.00 sec)

MariaDB [test]>

What are you getting instead?

Comment by Elena Stepanova [ 2013-10-17 ]

Closing as incomplete for now, please feel free to comment to reopen the bug if the problem still exists.

Generated at Thu Feb 08 07:01:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.