[MDEV-20683] MariaDB Transaction insert one data 1 row affected BUT select Empty set Created: 2019-09-27  Updated: 2019-10-23  Resolved: 2019-10-23

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Tony Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: need_feedback

Issue Links:
Duplicate
is duplicated by MDEV-20354 All but last insert ignored in InnoDB... Closed

 Description   

Server version: 10.4.8-MariaDB MariaDB Server
#######################################

MariaDB [test]> begin;
Query OK, 0 rows affected (0.000 sec)

MariaDB [test]> insert into t values ("1");
Query OK, 1 row affected (0.001 sec)

MariaDB [test]> select * from t;
Empty set (0.001 sec)

 Comments   
Comment by Elena Stepanova [ 2019-09-27 ]

Please provide the output of SHOW CREATE TABLE t and SHOW VARIABLES from the session where you execute the queries.

Comment by Tony [ 2019-09-29 ]

This is resolved , thanks ~

Comment by Elena Stepanova [ 2019-10-23 ]

This is likely to be a duplicate of MDEV-20354

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