sas_fedsql_check
Checks a FedSQL SELECT before execution for subqueries pushed into CREATE TABLE that fail on SingleStore; warns when a derived-table rewrite is not possible and explains why.
Instructions
Before a FedSQL run (nothing runs): does the SELECT have a subquery FedSQL would push down with the CREATE
TABLE (fails on SingleStore libraries), and can the editor run it as a derived table instead? warn: it
can't (an ORDER BY on expressions) - message says why and how to rewrite it.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes |