Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Blocker
-
Resolution: Incomplete
-
Affects Version/s: 10.0.4, 5.5.33
-
Fix Version/s: None
-
Component/s: None
-
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!
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Closing as incomplete for now, please feel free to comment to reopen the bug if the problem still exists.
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;
---
----------+---
----------+---
----------+1 row in set (0.00 sec)
MariaDB [test]>
What are you getting instead?