You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Failed to generate go model when using recursive CTE
Relevant log output
-- With database-backed analysis
# package
db/queries/tickers.sql:1:1: star expansion failed for query
-- Without database-backed analysis
# package
db/queries/tickers.sql:1:1: edit start location is out of bounds
-- name: GetLatestTickers :many
WITH RECURSIVE cte AS (
(
SELECT*FROM tickers
ORDER BY symbol,
timestampDESCLIMIT1
)
UNION ALLSELECT l.*FROM cte c
CROSS JOIN LATERAL (
SELECT*FROM tickers t
WHEREt.symbol>c.symbolORDER BYt.symbol,
t.timestampDESCLIMIT1
) l
) TABLE cte
ORDER BY symbol;
Version
1.25.0
What happened?
Failed to generate go model when using recursive CTE
Relevant log output
Database schema
SQL queries
Configuration
Playground URL
https://play.sqlc.dev/p/e71286cd010e207bfe3da341e24d207475ba44382080431f663991f1f6830b89
What operating system are you using?
Linux
What database engines are you using?
PostgreSQL
What type of code are you generating?
Go
The text was updated successfully, but these errors were encountered: