Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.11, 11.4, 12.2, 11.8
-
None
-
None
Description
Hi,
In the following test case, I TRUNCATE the table with NOWAIT. I run this in a single thread without other connections to the server, but this statement failed 99% time (100 executions with less than 1 success).
DROP DATABASE IF EXISTS database5o; |
CREATE DATABASE database5o; |
USE database5o; |
CREATE OR REPLACE TABLE t1(c0 REAL UNIQUE NOT NULL, PRIMARY KEY(c0)); |
INSERT INTO t1 VALUES (1001595716); |
INSERT INTO t1 VALUES (2910800); |
TRUNCATE t1 NOWAIT; |
SELECT t1.c0 FROM t1; |
These are the steps to trigger this:
docker run -itd --name mariadb -e MYSQL_ROOT_PASSWORD=root -p 3306:3306 mariadb:latest
|
docker exec -i mariadb mariadb -uroot -proot -f < test.sql
|
Attachments
Issue Links
- relates to
-
MDEV-11388 AliSQL: [Feature] Issue#15 DDL FAST FAIL
-
- Closed
-