select * from <table> without where clause does not show all rows in the table
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
PBXT |
In Progress
|
Undecided
|
Paul McCullagh |
Bug Description
This bug is similar to #340314, but is different.
At the time of the test, I made high load on the linux machine (copy some files) and made two concurrent connections on the MariaDB. I did not used transactions (BEGIN / COMMIT), but I also did not changed default isolation level. I can provide the table files and log, just tell me what files you want.
MariaDB [test]> select version();
+------
| version() |
+------
| 5.1.47-MariaDB-log |
+------
1 row in set (0.00 sec)
MariaDB [test]> create table b (a int primary key) engine=pbxt;
Query OK, 0 rows affected (3 min 43.59 sec)
MariaDB [test]> insert into b values(1);
Query OK, 1 row affected (8.08 sec)
MariaDB [test]> insert into b values(2);
Query OK, 1 row affected (8.08 sec)
MariaDB [test]> insert into b values(3);
Query OK, 1 row affected (1 min 21.43 sec)
MariaDB [test]> select * from b;
+---+
| a |
+---+
| 1 |
| 2 | <==== where is 3 ???
+---+
2 rows in set (0.00 sec)
MariaDB [test]> insert into b values(3);
ERROR 1062 (23000): Duplicate entry '3' for key 'PRIMARY'
MariaDB [test]> select * from b where a = 3;
+---+
| a |
+---+
| 3 |
+---+
1 row in set (0.10 sec)
MariaDB [test]> select * from b order by a;
+---+
| a |
+---+
| 1 |
| 2 |
| 3 |
+---+
3 rows in set (0.00 sec)
MariaDB [test]> select * from b where 1;
+---+
| a |
+---+
| 1 |
| 2 |
| 3 |
+---+
3 rows in set (0.00 sec)
Hi Nikolay,
Thanks for the bug report. So far I have not been able to repeat the error.
I was wondering if:
1. You still have the database with this error?
2. You are able to repeat the error with an empty database?
Thanks for you help!