dh20 opened a new issue, #1792:
URL: https://github.com/apache/auron/issues/1792
**Describe the bug**
<!--
A clear and concise description of what the bug is.
-->
Connection failure, abnormal data
**To Reproduce**
<!--
Steps to reproduce the behavior:
1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error
-->
sql ：
WITH
t2 AS (
SELECT id AS loan_req_no
FROM range(0, 100000)
),
t1 AS (
SELECT * FROM VALUES
(1, 'A'),
(2, 'B'),
(3, 'C'),
(4, 'D'),
(5, 'E'),
(6, 'F'),
(7, 'G'),
(8, 'H'),
(9, 'I'),
(10,'J')
AS t1(loan_req_no, partner_code)
),
blk AS (
SELECT * FROM VALUES
('B'),
('Z')
AS blk(code)
)
SELECT
COUNT(*) AS cnt
FROM t2
LEFT JOIN t1
ON t1.loan_req_no = t2.loan_req_no
WHERE t1.partner_code NOT IN (SELECT code FROM blk);
abnormal return ：99999
normal return：9
**Expected behavior**
<!--
A clear and concise description of what you expected to happen.
-->
**Screenshots**
<!--
If applicable, add screenshots to help explain your problem.
-->
**Additional context**
<!--
Add any other context about the problem here.
-->
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
