sollhui opened a new pull request, #42148:
URL: https://github.com/apache/doris/pull/42148
If use **explicit transactions**, error messages may display inaccurately:
```
mysql> begin;
Query OK, 0 rows affected (0.00 sec)
{'label':'txn_insert_df15d2c71f594be9-a7cbb425b53316b4', 'status':'PREPARE',
'txnId':''}
mysql> insert into test_begin_insert_mow1 values (13, false, 621,
723115.801, "c5","2024-10-15","2024-10-15", "c8", 1.1234, "c10");
Query OK, 1 rows affected (0.04 sec)
{'label':'txn_insert_df15d2c71f594be9-a7cbb425b53316b4', 'status':'PREPARE',
'txnId':'XXX'}
mysql> commit;
ERROR 1105 (HY000): errCode = 2, detailMessage = User Abort
```
But actually, it is **DATA_QUALITY_ERROR**. The reason is:
explicit transactions reuses the logic of stream load, but when stream load
aborts transactions, it will not submit error messages.
Fix result:
```
mysql> begin;
Query OK, 0 rows affected (0.00 sec)
{'label':'txn_insert_bebe57d15b7b4462-93bc160c3580d47f', 'status':'PREPARE',
'txnId':''}
mysql> insert into test_begin_insert_mow1 values (13, false, 621,
723115.801, "c5","2024-10-15","2024-10-15", "c8", 1.1234, "c10");
Query OK, 1 rows affected (0.04 sec)
{'label':'txn_insert_bebe57d15b7b4462-93bc160c3580d47f', 'status':'PREPARE',
'txnId':'XXX'}
mysql> commit;
ERROR 1105 (HY000): errCode = 2, detailMessage = [DATA_QUALITY_ERROR]too
many filtered rows
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
