Gustav Brock
gustav at cactus.dk
Fri Oct 29 16:21:26 CDT 2010
Hi Shamil
Nasty.
Does this happen as well if you use DataTable adapters?
/gustav
>>> shamil at smsconsulting.spb.ru 29-10-2010 19:43 >>>
Hi All,
Yes, the issue was with IN clause - here is the test solution:
http://northwind.codeplex.com/releases/view/26600#DownloadId=162049
It has tow tests of the same join SQL with and without using IN clause.
Below is the sample output of the test case using IN clause - it fails.
When IN clause isn't used then it works OK.
F:\Temp6\OleDbProviderTest\Bin>OleDbProviderTest.exe 1
+ ******** OleDbConnection Test ********* +
1st arg = 1 - test case
2nd arg = 100 max cycles qty
Test case #1: use IN '' clause
Test case #2: DO NOT use IN '' clause
+ ************* TEST SQL **************** +
SELECT
Order.OrderID, Order.OrderDate,
Customer.CompanyName, Employee.FirstName,
Employee.LastName, Product.ProductName,
OrderDetail.Quantity, Category.CategoryName
FROM Customer
INNER JOIN ((select * from Employee IN ''
[;Database=F:\Temp6\OleDbProvider
Test\Bin\Northwind.NET.mdb]) as Employee
INNER JOIN (((select * from Category IN ''
[;Database=F:\Temp6\OleDbProvide
rTest\Bin\Northwind.NET.mdb]) as Category
INNER JOIN (select * from Product IN ''
[;Database=F:\Temp6\OleDbProviderTes
t\Bin\Northwind.NET.mdb]) as Product ON Category.CategoryID =
Product.CategoryID
)
INNER JOIN ((select * from [Order] IN ''
[;Database=F:\Temp6\OleDbProviderTe
st\Bin\Northwind.NET.mdb]) as [Order]
INNER JOIN (select * from OrderDetail IN ''
[;Database=F:\Temp6\OleDbProvid
erTest\Bin\Northwind.NET.mdb]) as OrderDetail
ON Order.OrderID = OrderDetail.OrderID)
ON Product.ProductID = OrderDetail.ProductID)
ON Employee.EmployeeID = Order.EmployeeID)
ON Customer.CustomerId = Order.CustomerId
ORDER BY Order.OrderDate DESC
- ************* TEST SQL **************** -
29/10/2010 21:36:31: 1. ThreadCount = 9
29/10/2010 21:36:32: 2. ThreadCount = 18
29/10/2010 21:36:32: 3. ThreadCount = 21
29/10/2010 21:36:33: 4. ThreadCount = 26
29/10/2010 21:36:33: 5. ThreadCount = 31
29/10/2010 21:36:33: 6. ThreadCount = 33
29/10/2010 21:36:34: 7. ThreadCount = 36
29/10/2010 21:36:34: 8. ThreadCount = 38
29/10/2010 21:36:34: 9. ThreadCount = 37
29/10/2010 21:36:35: 10. ThreadCount = 33
29/10/2010 21:36:35: 11. ThreadCount = 36
29/10/2010 21:36:36: 12. ThreadCount = 40
29/10/2010 21:36:36: 13. ThreadCount = 44
29/10/2010 21:36:36: 14. ThreadCount = 46
29/10/2010 21:36:37: 15. ThreadCount = 45
29/10/2010 21:36:37: 16. ThreadCount = 52
29/10/2010 21:36:37: 17. ThreadCount = 57
29/10/2010 21:36:38: 18. ThreadCount = 61
29/10/2010 21:36:38: 19. ThreadCount = 60
29/10/2010 21:36:38: 20. ThreadCount = 65
TestConnection.ERROR:Unspecified error
TestConnection.ERROR:Unspecified error
TestConnection.ERROR:Unspecified error
TestConnection.ERROR:Cannot open any more databases.
TestConnection.ERROR:Cannot open any more databases.
29/10/2010 21:36:39: 21. ThreadCount = 61
TestConnection.ERROR:Cannot open any more databases.
29/10/2010 21:36:39: 22. ThreadCount = 63
TestConnection.ERROR:Unspecified error
29/10/2010 21:36:39: 23. ThreadCount = 63
TestConnection.ERROR:Unspecified error
TestConnection.ERROR:Unspecified error
TestConnection.ERROR:Unspecified error
TestConnection.ERROR:Cannot open any more databases.
29/10/2010 21:36:40: 24. ThreadCount = 62
TestConnection.ERROR:Cannot open any more databases.
TestConnection.ERROR:Unspecified error
TestConnection.ERROR:Cannot open any more databases.
29/10/2010 21:36:40: 25. ThreadCount = 62
TestConnection.ERROR:Cannot open any more databases.
TestConnection.ERROR:Cannot open any more databases.
TestConnection.ERROR:Unspecified error
29/10/2010 21:36:40: 26. ThreadCount = 63
TestConnection.ERROR:Unspecified error
TestConnection.ERROR:Cannot open any more databases.
TestConnection.ERROR:Cannot open any more databases.
29/10/2010 21:36:41: 27. ThreadCount = 61
29/10/2010 21:36:41: 28. ThreadCount = 64
TestConnection.ERROR:Unspecified error
TestConnection.ERROR:Unspecified error
TestConnection.ERROR:Unspecified error
TestConnection.ERROR:Cannot open any more databases.
TestConnection.ERROR:Cannot open any more databases.
29/10/2010 21:36:41: 29. ThreadCount = 62
TestConnection.ERROR:Unspecified error
29/10/2010 21:36:42: 30. ThreadCount = 63
TestConnection.ERROR:Unspecified error
TestConnection.ERROR:Unspecified error
TestConnection.ERROR:Cannot open any more databases.
29/10/2010 21:36:42: 31. ThreadCount = 62
TestConnection.ERROR:Cannot open any more databases.
29/10/2010 21:36:42: 32. ThreadCount = 55
TestConnection.ERROR:Cannot open any more databases.
29/10/2010 21:36:43: 33. ThreadCount = 56
StartTime = 29/10/2010 21:36:31, EndTime = 29/10/2010 21:36:43
OK, TotalCount = 297, ElapsedTime = 0.0032 hours, ErrCount = 31
Press any key to quit...
TestConnection.ERROR:Cannot open any more databases.
Thank you.
--
Shamil