Comments - The table have issue. select is empty but can't insert more data
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
I still can't repeat this issue. Do you have sample SQL that will repeat the problem, as well as version information?
Hi lan Gilfillan, Can you share the status of this ticket?
I have run the query: TRUNCATE TABLE table2;
Then, immediately run the insert statement with another session: INSERT INTO UniversalDatasetTable (DSID, Enabled, PollingPeriod, MinPeriod, SnmpVersionNumber) VALUES (10300, 1, 900, 60, 0); The message returned is DUP PRIMARY KEY.
My mariaDB is: mysql Ver 15.1 Distrib 10.1.22-MariaDB, for Linux (x86_64) using readline 5.1