Open SteveLeungYL opened 1 year ago
Hello, I am Blathers. I am here to help you get the issue triaged.
Hoot - a bug! Though bugs are the bane of my existence, rest assured the wretched thing will get the best of care here.
I have CC'd a few people who may be able to assist you:
If we have not gotten back to your issue within a few business days, you can try the following:
:owl: Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.
This might be related to #94087.
Describe the problem
The latest version of the CockroachDB (ec83b9eba5f2) shows
Internal Error
when executing the following query:To Reproduce
Here is the detail steps to reproduce the bug.
make install
in the root repository folder../cockroach demo
, and then paste the PoC query to the cockroach cli environment.Internal Error
and log the stack information.Expected behavior The
SELECT
statement should be executed correctly and return empty result.Additional data / screenshots
Here is the outputted stack trace:
Environment:
./cockroach demo
)Additional context
The crashing problem may not happen in the real-world application, since it requires the specific setup:
SET testing_optimizer_disable_rule_probability = 1.0;
, which is a developer option used to control the query optimization. However, having anInternal Error
is still unexpected from the resulted behavior. Therefore, this problem is reported here.The Internal Error problem is reproducible on version
v22.2.0 Production Releases
.Jira issue: CRDB-22318