Simon Binder
ac4947f266
Support `INT64` type for bigints in drift files
...
https://github.com/simolus3/drift/issues/2955
2024-04-15 21:18:10 +02:00
Simon Binder
c6f0fa27aa
sqlparser: Extend support for `IN` expressions
...
This adds support for table names and table-valued function
invocations as right-hand targets in `IN` expressions.
The lint for row values around `IN` expressions is updated to
only report warnings if there's an actual mismatch in the amount
of columns.
Closes https://github.com/simolus3/drift/issues/2948
2024-04-12 17:36:31 +02:00
Simon Binder
f9fa123e4a
Forbid unqualified access to aliases in triggers
2024-01-01 19:18:04 +01:00
tibotix
deaf58c5fb
Add/Update TestCases for all introduced changes
2023-11-17 01:49:37 +01:00
Simon Binder
222dc3063e
sqlparser: Support new SQL functions
2023-10-24 22:56:12 +02:00
Simon Binder
559cf986a1
sqlparser: Support `ORDER BY` in functions
2023-10-24 22:32:39 +02:00
Simon Binder
d70de95382
Make `sum()` nullable
2023-10-22 12:33:03 +02:00
Simon Binder
eb03ac5ff0
Fix converters on `int64` breaking inference
2023-10-03 20:54:28 +02:00
Simon Binder
d0a3feee12
Fix star columns resolving to too many columns
2023-09-26 23:15:29 +02:00
Simon Binder
fe242e5a17
Support `timediff` and `octet_length`
2023-08-17 17:30:45 +02:00
Simon Binder
c700b5b4be
Resolve CTEs for compound selects
2023-06-20 14:17:53 +02:00
Simon Binder
e481f29138
Fix resolving table aliases ( #2453 )
2023-06-03 23:10:54 +02:00
Simon Binder
07fe555753
Report syntax error for WITH in trigger
2023-06-01 00:08:41 +02:00
Simon Binder
9154f60dfd
Improve resolving recursive CTEs
2023-05-30 13:53:03 +02:00
Simon Binder
db15b792ca
Fix column name inference in CTEs and subqueries
2023-04-20 16:43:27 +02:00
Simon Binder
611fd4c4e9
Fix crash with CTE on insert/update/delete
2023-04-20 15:37:51 +02:00
Simon Binder
11b563f9de
Add static analysis for the `IIF` function ( #2392 )
2023-04-18 12:42:51 +02:00
Simon Binder
834cc154bc
Infer types for `HAVING` clauses
2023-04-08 15:58:06 +02:00
Simon Binder
bdac301866
Allow references to result column in group by too
2023-04-08 15:44:47 +02:00
Simon Binder
4e05067bd5
Don't assume nullable if no join syntax is known
2023-03-26 22:21:48 +02:00
Simon Binder
c38e9cc6c0
Fix false-positive trigger syntax error ( #2360 )
2023-03-26 21:44:12 +02:00
Simon Binder
1c662ebb1a
Analysis support for sqlite 3.41.0
2023-02-22 23:05:17 +01:00
Simon Binder
4b83810a17
Fix `CAST` always being non-nullable
2023-01-06 21:14:24 +01:00
Simon Binder
1d7e656e30
Support cast to enum types
2023-01-06 16:53:04 +01:00
Simon Binder
bc325dd31c
Support cast to drift-specific types
2023-01-06 15:10:03 +01:00
Simon Binder
6e173e8c08
Don't require tokens for some AST classes
2022-12-30 20:46:18 +01:00
Simon Binder
e2265eb597
Add `DriftAny` type to wrap `ANY` in strit tables
2022-12-18 18:55:17 +01:00
Simon Binder
fe3566429f
Migrate more analyzer tests
2022-10-30 19:41:59 +01:00
Simon Binder
ee66465d47
Avoid leading underscores for local identifiers
2022-08-31 00:59:19 +02:00
Simon Binder
33c13e2422
Fix resolving around subqueries in FROM ( #2010 )
2022-08-22 23:21:54 +02:00
Simon Binder
8f6878292a
Migrate to `package:lints`
2022-08-13 23:33:05 +02:00
Simon Binder
6c0e27b24c
SQL analysis for text datetimes
2022-07-24 19:19:18 +02:00
Simon Binder
c9bd7236c6
Resolve `unixepoch` SQL function as datetime
2022-06-16 18:29:13 +02:00
Simon Binder
6a6d1268c4
Fix sum type inference ( #1871 )
2022-05-30 17:13:12 +02:00
Simon Binder
a6b7bf9aaa
Version check for new joins
2022-05-26 23:29:58 +02:00
Simon Binder
d330c9b001
sqlparser: Support new syntax for `IS` expressions
2022-05-26 22:24:41 +02:00
Simon Binder
6ee4fd8153
Two more tests on scopes
2022-05-26 21:21:54 +02:00
Simon Binder
e503bc68a5
New implementation for reference scopes
2022-05-25 23:32:15 +02:00
Simon Binder
98163103d5
Lint for distinct aggregate with more than one arg
2022-05-08 09:05:23 +02:00
Simon Binder
645489a21c
Fix resolving parameters to `MAX`/`MIN` ( #1790 )
2022-04-05 20:50:18 +02:00
Simon Binder
da212944ff
Replace old website and repository links
2022-03-13 15:52:15 +01:00
Simon Binder
c9e22bf8d2
Parse non-window aggregate expressions
2022-03-08 10:58:40 +01:00
Simon Binder
9c80fb047b
Fix nullability propagation for type analysis
2022-03-02 16:06:30 +01:00
Simon Binder
9ec7465fca
Migrate rest of `drift_dev` to null safety
2022-02-26 22:20:17 +01:00
Simon Binder
93d328f056
Rename `moor` to `drift` in `sqlparser`
2022-02-26 21:38:28 +01:00
Simon Binder
6bb870458f
Analysis for sqlite 3.38
2022-02-23 22:06:42 +01:00
Simon Binder
36815c0b88
Merge pull request #1638 from LeFrosch/develop
...
Support for nested queries like (#1634 )
2022-01-31 13:21:24 +01:00
Simon Binder
45af68851d
More lints for trigger bodies ( #1656 )
2022-01-26 22:03:40 +01:00
Simon Binder
130517473b
Accept any type name for strict drift tables
2022-01-25 13:21:40 +01:00
Simon Binder
aa38ab42f2
More lenient `strict` column type handling
2022-01-24 17:49:10 +01:00