Simon Binder
2777ca47e1
Don't allow aliases for sources in `IN` expression
2024-04-24 18:59:10 +02:00
Simon Binder
fefae6dd44
Merge remote-tracking branch 'origin/develop' into geopoly
2024-04-22 22:56:37 +02:00
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
Nikita Dauhashei
78387a3610
Merge branch 'simolus3:develop' into develop
2024-04-10 18:33:06 +02:00
Nikita Dauhashei
15001364c2
add geopoly support
2024-04-10 18:31:44 +02:00
Simon Binder
43b7f72bad
sqlparser: Fix parsing binary literals
2024-04-06 14:48:55 +02:00
Simon Binder
29303100b8
Support custom names for drift views
2024-03-08 18:14:48 +01:00
Simon Binder
4fa75cb30b
Fix new analysis warnings from Dart 3.3
2024-02-19 21:46:55 +01:00
Simon Binder
2bc01adeaa
Support table function syntax for virtual tables
...
Closes #2877
2024-02-03 18:28:23 +01:00
Simon Binder
b6fbfdbab9
sqlparser support for jsonb
2024-01-17 22:39:55 +01:00
Simon Binder
f9fa123e4a
Forbid unqualified access to aliases in triggers
2024-01-01 19:18:04 +01:00
Simon Binder
08ceb939bc
Include `NULL` constraints in node->sql
2023-12-12 21:46:58 +01:00
tibotix
ff11a2a757
Add trailing commas for readability
2023-11-17 18:04:21 +01:00
tibotix
26fd4bf11e
Add node_to_text tests for MultiColumnSetComponent
2023-11-17 18:00:58 +01:00
tibotix
deaf58c5fb
Add/Update TestCases for all introduced changes
2023-11-17 01:49:37 +01:00
tibotix
f128f05e1e
Add MultiColumnSetComponent to support column-name-list update syntax
...
This commit refactors the SetComponent into an abstract interface and introduces
two separate classes `SingleColumnSetComponent` and `MultiColumnSetComponent`, as
well as related methods such as `visitSingleColumnSetComponent` / `visitMultiColumnSetComponent`.
All Visitors were updated accordingly, and logic for parsing / type-resolving / linting were added
too. The only thing missing is type-resolving for the case where rowValue is of type SubQuery,
i.e.
`UPDATE demo SET (a,b)=(SELECT 2,3)`.
2023-11-17 01:42:39 +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
7f0488056c
Add more tests for custom types
2023-10-07 21:52:48 +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
83885791c7
Fix parser crashes around `CREATE`
2023-08-12 22:33:54 +02:00
Simon Binder
0ed132f642
Fix crash at trailing comma in FROM clause
2023-08-09 15:24:10 +02:00
Simon Binder
cc83a58d89
Report invalid statements in parseMultiple
2023-07-21 21:07:55 +02:00
Simon Binder
625eacf5f1
Add parseMultiple API to sqlparser ( #2519 )
2023-07-16 00:29:29 +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
6bb2c3d2c5
Support named constructors for rows in drift file
2023-04-23 16:21:31 +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
a988b38ec1
Improve error message for invalid column name
2023-04-16 18:37:34 +02:00
Simon Binder
99abaae2f1
Fix infinite loop in trigger parser
2023-04-14 11:47:15 +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
849f245f53
Warn about invalid custom foreign key constraint
2023-03-13 22:30:14 +01:00
Simon Binder
1c662ebb1a
Analysis support for sqlite 3.41.0
2023-02-22 23:05:17 +01:00
Simon Binder
e2136236d9
Improve error messages for keyword functions
2023-02-08 10:52:48 +01:00
Simon Binder
7175b83d2b
Add missing space when formatting window functions
2023-01-20 18:14:37 +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
e562cb9d21
Support type converters in queries
2023-01-05 23:04:36 +01:00