You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
45 lines
2.0 KiB
Plaintext
45 lines
2.0 KiB
Plaintext
"`SELECT (SELECT TOP 1) FROM` is not supported by Jet."
|
|
---
|
|
"Can be supported after rearranging CROSS JOIN/JOIN expressions."
|
|
|
|
Currently, the following SQL is generated:
|
|
|
|
SELECT
|
|
FROM (`Orders` AS `o`,
|
|
`Orders` AS `o0`)
|
|
LEFT JOIN `Customers` AS `c` ON `o`.`CustomerID` = `c`.`CustomerID`)
|
|
LEFT JOIN `Customers` AS `c0` ON `o0`.`CustomerID` = `c0`.`CustomerID`
|
|
|
|
However, the following SQL is needed for Access to understand the query:
|
|
|
|
SELECT
|
|
FROM Orders AS o
|
|
LEFT JOIN Customers AS c ON o.CustomerID = c.CustomerID,
|
|
Orders AS o0
|
|
LEFT JOIN Customers AS c0 ON o0.CustomerID = c0.CustomerID
|
|
|
|
The same is true for INNER JOINs as well.
|
|
---
|
|
|
|
|
|
[Fact(Skip = "Probably unsupported by JET")]
|
|
[Fact(Skip = "Unsupported by JET")]
|
|
[Fact(Skip = "Unsupported by JET: subqueries supported only in FROM clause")]
|
|
[Fact(Skip = "Unsupported by JET: SELECT TOP 2 (SELECT TOP 1) returns 2 records")]
|
|
[Fact(Skip = "Unsupported by JET: SELECT ORDER BY (SELECT)")]
|
|
[Fact(Skip = "Unsupported by JET: SKIP TAKE is supported only in outer queries")]
|
|
[Fact(Skip = "Unsupported by JET: too complex query with DUAL")]
|
|
[Fact(Skip = "Unsupported by JET: DateTime does not support milliseconds")]
|
|
[Fact(Skip = "Unsupported by JET: SKIP TAKE DISTINCT")]
|
|
[Fact(Skip = "Assertion failed without evident reason")]
|
|
[Fact(Skip = "Unsupported by JET: Guid are supported indirectly")]
|
|
[Fact(Skip = "Unsupported by JET: Should be implemented by provider")]
|
|
[Fact(Skip = "Unsupported by JET: DateTimeOffset not fully supported")]
|
|
[Fact(Skip = "Unsupported by JET: CROSS JOIN and OTHER JOIN")]
|
|
[Fact(Skip = "Unsupported by JET: JOIN with unsupported ON PREDICATE")]
|
|
[Fact(Skip = "Unsupported by JET: operators on IMAGE and TEXT data types are not supported")]
|
|
[Fact(Skip = "Unsupported by JET: Data type unsupported")]
|
|
[Fact(Skip = "Unsupported by JET: rowversion unsupported")]
|
|
[Fact(Skip = "Unsupported by JET: nullable bit not supported")]
|
|
[Fact(Skip = "Unsupported by JET: JET behaviour requires that both columns in a composite foreign key are null")]
|
|
[Fact(Skip = "Unsupported by JET: OleDB does not support parallel transactions")] |