sql: don't apply disallow_full_table_scans to virtual tables #122708
Labels
C-enhancement
Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)
O-support
Would prevent or help troubleshoot a customer escalation - bugs, missing observability/tooling, docs
P-2
Issues/test failures with a fix SLA of 3 months
T-sql-queries
SQL Queries Team
Since we currently don't collect stats for virtual tables, (tracked in #27611), we unconditionally apply costing changes due to the
disallow_full_table_scans
setting for virtual table scans, even iflarge_full_scan_rows
is larger than the row count. Until tracked in #27611 is fixed, we should preventdisallow_full_table_scans
from applying to virtual tables, likely using a setting.Jira issue: CRDB-38031
The text was updated successfully, but these errors were encountered: