Commit Graph

497 Commits (lauxjpn-md-change-test-1)
 

Author SHA1 Message Date
Laurents Meyer c6466ca15a
Update README.md 2 years ago
Laurents Meyer 485ac00e5e Return successful status if only MD files changed (because in those cases, no other CI runs). 2 years ago
Christopher Jolly ee8cfdb21f
Add option to configure the manner of mapping DateTimeOffset (#180)
* Add option to configure how to save/map a datetimeoffset i.e. as string or as a datetime
2 years ago
Christopher Jolly 472f6b4665 Remove Complex Navigations Shared classes from the tests. The table structure is too complex for Jet and goes over its limits. Not able to make work 2 years ago
Christopher Jolly 1c29984574
Improve handling of scalar subqueries in order by clause (#177)
* Add expression visitor to locate a scalar subquery. Handles finding deeper subqueries better than original code.
Also handle the case where the expression can be regarded as scalar (i.e. has a TOP 1 and projects only one field). In that case we rewrite the projections so that we take out any previously added projections as it is clear we are not needing it higher up in the SQL
2 years ago
Christopher Jolly 9e9ef1bd2b
Update dependencies to .Net/EF Core 8 RTM (#176)
* Update dependencies to the RTM version of .Net 8 and update the expected SQL queries with regards to any changes in the base tests
2 years ago
Christopher Jolly 0bfa24998f
Fix string methods related to LastOrDefault and Contains (#175)
* Fix string methods related to LastOrDefault and Contains
2 years ago
github-actions d7d4f90366 [GitHub Actions] Update green tests. 2 years ago
Christopher Jolly be944b3192 Fix some result sql differences between oledb and odbc 2 years ago
Christopher Jolly 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
Christopher Jolly 72868961c4 Remove green marked tests as we don't have that test class anymore 2 years ago
Christopher Jolly 4b295003a9 Minor updates 2 years ago
Christopher Jolly 8045af8570 Ensure all tests overriden in this class 2 years ago
Christopher Jolly 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
Christopher Jolly 59e9723548 Add sql checks on more tests for NullSemantics 2 years ago
Christopher Jolly 8bce980435 Fix more tests to no expect a tag line in the sql 2 years ago
Christopher Jolly 2f69290f44 Generate proper SQL for UPDATE and DELETE when we have multiple tables, select expression, joins 2 years ago
Christopher Jolly 21b07705ce Return empty list for state indices when having parsed an empty string 2 years ago
Christopher Jolly 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
Christopher Jolly 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
Christopher Jolly 4d026e975c Skip tests where Jet has no support 2 years ago
Christopher Jolly 1b7e72790c DateOnly/TimeOnly fields are added to hte expected sql 2 years ago
Christopher Jolly 6fe74929cf Remove tag lines/comments from the sql to be executed 2 years ago
Christopher Jolly 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
Christopher Jolly 4bdd001eda Add the default warning config in. Some of the defaults set warnings to throw instead of Log 2 years ago
Christopher Jolly 3d656dcdb9 Configure these without a connection string. These set up the connection later on 2 years ago
Christopher Jolly 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
Christopher Jolly 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
Christopher Jolly d9f2c8eb2c
Interception tests (#171)
* Allow unconfigured dataaccessproviderfactory and null connection string

* [GitHub Actions] Update green tests.

---------
2 years ago
Christopher Jolly b389b88705
Further built in types fixes (#170) 2 years ago
Christopher Jolly 6ccebae028
Db model factory updates (#166) 2 years ago
Laurents Meyer a95017e38b
Auto skip statements that are not supported by Jet. Track unsupported statements in log files. (#169) 2 years ago
Laurents Meyer 79a0f1b679
Add automatic crash detection to CI and repeat crashing test runs up to 3 times. (#164) 2 years ago
Laurents Meyer e7539ef509 Publish test results as GitHub Checks. 2 years ago
Laurents Meyer e7d8a02f70 Publish test results as GitHub Checks. 2 years ago
Laurents Meyer 53b0aee7d1
Publish test results as GitHub Checks. (#168) 2 years ago
Laurents Meyer 528df20e25 Publish test results as GitHub Checks. 2 years ago
Laurents Meyer c1a8d1d4e4 Publish test results as GitHub Checks. 2 years ago
Laurents Meyer 1332c941cd Fix auto commit handling for PR cases where the green tests files have not changed. 2 years ago
Laurents Meyer 6d9e20d380
Fix auto commit handling for PR cases where the green tests files have not changed. (#167) 2 years ago
Laurents Meyer f865ea4413 Fix auto commit handling for PR cases where the green tests files have not changed. 2 years ago
Laurents Meyer 0d140f2735 Revert "Update auto commit workflow file to skip pull requests without artifacts."
This reverts commit 0cfe5a8b58.
2 years ago
Laurents Meyer 0cfe5a8b58 Update auto commit workflow file to skip pull requests without artifacts. 2 years ago
Laurents Meyer 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
Laurents Meyer 42a0e3aa1f Add new auto commit workflow file to default branch. 2 years ago
Christopher Jolly 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
Christopher Jolly 88f0ba8df5
Fixes to the QueryBugsTest (#162)
* Ensure connection is closed before dropping the database/deleting the file

* Upgrade the QueryBugsTest
2 years ago
Laurents Meyer 1ba41b74d7
Ensure that tests that passed before still pass. (#161) 2 years ago
Laurents Meyer 2e23e60dad Remove duplicate string entry. 2 years ago
Laurents Meyer 49312c88c8 Remove statements that lead to massive test outputs after they have run. 2 years ago