dbe3bf7e89
The DELETE statement in Jet doesn't take the TOP clause like SQL server. Limit the valid select expressions to those that do not use TOP. EF Core will then rewrite it into a WHERE EXISTS clause to use in the DELETE. Valid select expressions are able to be used directly in the DELETE/UPDATE
2 years ago
72868961c4
Remove green marked tests as we don't have that test class anymore
2 years ago
4b295003a9
Minor updates
2 years ago
8045af8570
Ensure all tests overriden in this class
2 years ago
2e4f22e30d
Remove JsonQuery and JsonUpdate tests as none work and will never work.
...
Add the base classes to the ignore list in the compliance test
2 years ago
59e9723548
Add sql checks on more tests for NullSemantics
2 years ago
8bce980435
Fix more tests to no expect a tag line in the sql
2 years ago
2f69290f44
Generate proper SQL for UPDATE and DELETE when we have multiple tables, select expression, joins
2 years ago
21b07705ce
Return empty list for state indices when having parsed an empty string
2 years ago
559cdc6d3c
Some updates to the migration/update sql. Main change is if we are doing an INSERT, if there is no values to be read back we don't have to follow it up with a 'SELECT @@ROWCOUNT'
2 years ago
c73f4a3013
Add the onDelete convention so that we match the behaviour of sql server when configuring self-referencing skip navigations. Ends up configured as ClientCascade instead of Cascade
2 years ago
4d026e975c
Skip tests where Jet has no support
2 years ago
1b7e72790c
DateOnly/TimeOnly fields are added to hte expected sql
2 years ago
6fe74929cf
Remove tag lines/comments from the sql to be executed
2 years ago
8f5be7fb89
Update types to expect the correct type. All these have converters that convert to a Long/Int64 which is mapped to decimal(20,0)
2 years ago
4bdd001eda
Add the default warning config in. Some of the defaults set warnings to throw instead of Log
2 years ago
3d656dcdb9
Configure these without a connection string. These set up the connection later on
2 years ago
caeb6db77b
Lift subqueries from the ORDER BY clause into their own projection ( #173 )
...
* Lift scalar subqueries out of order by and into a projection
* Add back in missed verifier for skip without order by in split query
* [GitHub Actions] Update green tests.
* Scalar expressions within a function or case expression, within the ORDER BY also need to be lifted
* [GitHub Actions] Update green tests.
---------
Co-authored-by: github-actions <github-actions@github.com>
2 years ago
7caea4dcdb
Provide a valid count argument to LEFT,RIGHT,MID ( #172 )
...
* Coalesce the result of LEN on a string to 0 when within a LEFT/RIGHT/MID function as it cannot take NULL for the count of characters
2 years ago
d9f2c8eb2c
Interception tests ( #171 )
...
* Allow unconfigured dataaccessproviderfactory and null connection string
* [GitHub Actions] Update green tests.
---------
2 years ago
b389b88705
Further built in types fixes ( #170 )
2 years ago
6ccebae028
Db model factory updates ( #166 )
2 years ago
a95017e38b
Auto skip statements that are not supported by Jet. Track unsupported statements in log files. ( #169 )
2 years ago
79a0f1b679
Add automatic crash detection to CI and repeat crashing test runs up to 3 times. ( #164 )
2 years ago
e7539ef509
Publish test results as GitHub Checks.
2 years ago
e7d8a02f70
Publish test results as GitHub Checks.
2 years ago
53b0aee7d1
Publish test results as GitHub Checks. ( #168 )
2 years ago
528df20e25
Publish test results as GitHub Checks.
2 years ago
c1a8d1d4e4
Publish test results as GitHub Checks.
2 years ago
1332c941cd
Fix auto commit handling for PR cases where the green tests files have not changed.
2 years ago
6d9e20d380
Fix auto commit handling for PR cases where the green tests files have not changed. ( #167 )
2 years ago
f865ea4413
Fix auto commit handling for PR cases where the green tests files have not changed.
2 years ago
0d140f2735
Revert "Update auto commit workflow file to skip pull requests without artifacts."
...
This reverts commit 0cfe5a8b58
2 years ago
0cfe5a8b58
Update auto commit workflow file to skip pull requests without artifacts.
2 years ago
746f727ec7
Fix auto commit for pull requests. ( #165 )
...
* Fix auto commit for pull requests by using multiple workflows.
* Cleanup green tests after #162 .
* [GitHub Actions] Update green tests.
---------
Co-authored-by: github-actions <github-actions@github.com>
2 years ago
42a0e3aa1f
Add new auto commit workflow file to default branch.
2 years ago
e70f682c0c
Fix BuiltInDataTypes tests ( #163 )
...
* Update the BuiltInDataTypes set of tests
* Update JetTypeMappingSource.cs
Add back `alphanumeric` as its line somehow got deleted
* Add Element Type Mapping check back in
2 years ago
88f0ba8df5
Fixes to the QueryBugsTest ( #162 )
...
* Ensure connection is closed before dropping the database/deleting the file
* Upgrade the QueryBugsTest
2 years ago
1ba41b74d7
Ensure that tests that passed before still pass. ( #161 )
2 years ago
2e23e60dad
Remove duplicate string entry.
2 years ago
49312c88c8
Remove statements that lead to massive test outputs after they have run.
2 years ago
de360e580a
Fix test database creation.
2 years ago
fcb97a4e63
Improve support for primitive collections and Json Types ( #159 )
2 years ago
d32eae0867
Update project in regards to new organization and CI. ( #160 )
2 years ago
c712906ae1
Move from AZDO to GitHub Actions. ( #148 )
...
* Move from AZDO to GitHub Actions.
* Fix Xunit test runner configuration.
* Ensure deterministic test order until test runs are stable.
* Update to use new organization settings.
* Remove obsolete AZDO pipelines file.
2 years ago
f873c02874
Merge branch 'master' of https://github.com/bubibubi/EntityFrameworkCore.Jet
2 years ago
53bdc99453
Upgrade DbContextPooling tests
2 years ago
9babf78263
Revert "Type MApping: a long gets mapped to integer in Jet" ( #151 )
...
This reverts commit 05b10ea856
2 years ago
0d5676a4e5
Merge pull request #158 from ChrisJollyAU/fixdecint64param
...
Fix using decimal and Int64 in parameters
2 years ago
d359492662
Use reflection so we don't have to reference Odbc or OleDb in main package
2 years ago
Christopher Jolly
Laurents Meyer