What's Changed
- ORDER BY clause for multiple UNIONs to fix #7 after 11 years and 11 days
- Let SELECT * INTO SQL() handle NULL values to fix #42 after 10 years, 10 months and 7 days
- ORDER BY with numeric column ref on SELECT * to fix #125 after 10 years, 7 months and 4 days
- Use DISTINCT with object values in SELECT and SEARCH to fix #167 after 10 years, 6 months and 12 days
- Support BETWEEN operator in CASE statement to fix #735 after 9 years, 3 months, and 4 days
- Allow nested subqueries for IN clause to fix #847 after 8 years, 7 months and 29 days
- Support import of multi-sheet XLSX to fix #848 after 8 years, 7 months and 29 days
- Let SERIAL columns handle explicitly provided values including NULL to fix #895 after 8 years, 4 months and 28 days
- Let UNIQUE constraint support JSON properties and expressions to fix #925 after 8 years, 3 months, and 18 days
- Update indexes when bulk loading data to fix #1027 after 7 years, 4 months and 17 days
- Support ROW_NUMBER() OVER (PARTITION BY) syntax for row numbering to fix #1126 after 6 years, 3 months and 5 days
- Let INSERT INTO SELECT FROM overwrite data with defaults to fix #1484 after 6 years, 3 months and 5 days
- Avoid timezone challenge for test408 to accomodate #1587 after 2 years and 11 months.
- Extract compiled JS from SQL to fix #2169 7 days
- Let CREATE INDEX support qualified table names to fix #2184 after 2 days
- Qualified table names for SHOW COLUMNS and SHOW INDEX to fix #2200 after 16 hours
New Contributors
- Thank you to Github for sponsoring @Copilot who made their first contributions and helped nail issues with a combined age of 109 years, 1 month and 28 days from guiding it for a few hours. #theFutureIsNow
Full Changelog: v4.9.0...v4.10.1