Closed
Description
Version
Other
What happened?
A bug happened!
Relevant log output
I have sqlc update from brew to 1.19 and realise this could not compile but work in PostgreSQL. Used to work prior to 1.19.
SELECT listing_id as listingid FROM reviews r
WHERE cast(r.listing_id as int) < $1 AND cast(enddate_unixtime as int) > extract(epoch FROM now())::int
UNION ALL
SELECT listing_id as listingid FROM articles a
WHERE cast(listing_id as int) < $1 AND cast(enddate_unixtime as int) > extract(epoch FROM now())::int
ORDER BY listingid DESC FETCH FIRST 10 ROWS ONLY;
Error refer to ORDER BY listingid
# package db
... column reference "listingid" not found: if you want to skip this validation, set 'strict_order_by' to false
### Database schema
```sql
NA
SQL queries
No response
Configuration
No response
Playground URL
No response
What operating system are you using?
No response
What database engines are you using?
No response
What type of code are you generating?
No response