Simbafa commented on issue #8903:
URL: https://github.com/apache/shardingsphere/issues/8903#issuecomment-769717881
It's not that the 1st SQL blocked 2nd SQL.
If the client threads < acceptor.size, the tests can run correctly.
The most important thing in this test case is that "CLIENT THREADS >
ACCEPTOR.SIZE"
Which field is the key has no matter to this issue.
In your test, you can pick any field as the key.
In my test case, only one row will be returned for the SQL.
```
CREATE TABLE `forupdate` (
`fid` INT(11) NULL DEFAULT NULL,
`fint` INT(11) NULL DEFAULT NULL,
`ftext` TEXT NULL
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
;
```
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
