Details
-
Bug
-
Resolution: Fixed
-
Major
-
6.0.3, 6.5.1, Cheshire-Cat
-
Untriaged
-
1
-
Unknown
Description
create index tx1 on `travel-sample` (schedule);
|
select count(1) from `travel-sample` t where ANY v IN t.schedule SATISFIES v.flight LIKE "A%" END AND t.schedule IS NOT NULL; |
|
{
|
"requestID": "2edb8ee1-ab92-4901-afd4-f6441773721f", |
"signature": { |
"$1": "number" |
},
|
"results": [ |
{
|
"$1": 5348 |
}
|
],
|
"status": "success", |
"metrics": { |
"elapsedTime": "794.997532ms", |
"executionTime": "794.945549ms", |
"resultCount": 1, |
"resultSize": 26 |
}
|
}
|
|
prepare p1 from select count(1) from `travel-sample` t where ANY v IN t.schedule SATISFIES v.flight LIKE $1 END AND t.schedule IS NOT NULL; |
\set -args ["A%"]; |
|
execute p1;
|
|
{
|
"requestID": "e980f556-9c46-4408-ae17-d402e2a06ea4", |
"signature": { |
"$1": "number" |
},
|
"results": [ |
{
|
"$1": 5348 |
}
|
],
|
"status": "success", |
"metrics": { |
"elapsedTime": "3.749420749s", |
"executionTime": "3.749330119s", |
"resultCount": 1, |
"resultSize": 26 |
}
|
}
|
|
Same Plan only filter is difference 800ms vs 3.7secs