|
Some how condition (not((t1.i <= 3))) was pushed in the view which made view have no records.
{
|
"query_block": {
|
"select_id": 1,
|
"r_loops": 1,
|
"r_total_time_ms": 0.0577,
|
"table": {
|
"table_name": "<derived3>",
|
"access_type": "ALL",
|
"r_loops": 1,
|
"rows": 2,
|
"r_rows": 0,
|
"r_total_time_ms": 2.3e-4,
|
"filtered": 100,
|
"r_filtered": 100,
|
"attached_condition": "<nop>((v1.i <= 3))",
|
"materialized": {
|
"query_block": {
|
"select_id": 3,
|
"r_loops": 1,
|
"r_total_time_ms": 0.0244,
|
"table": {
|
"table_name": "t1",
|
"access_type": "ALL",
|
"r_loops": 1,
|
"rows": 2,
|
"r_rows": 2,
|
"r_total_time_ms": 0.0048,
|
"filtered": 100,
|
"r_filtered": 0,
|
"attached_condition": "(not((t1.i <= 3)))"
|
}
|
}
|
}
|
}
|
}
|
}
|
|