Hi,
I have problem with DevArt ODBC driver ofr MongoDB.
MongoDB ver 3.2
MS Excel
DevArt ODBC driver trial version
When i use Microsoft Query to build my sql (in MS Excel), it will return data only when i do not put any WHERE clause.
SELECT customer.account_id, customer.name, order.account_id, order.billing_id
FROM myDB.customer customer, myDB.order order
which will return all rows from both tables
But when i put WHERE clause:
SELECT customer.account_id, customer.name, order.account_id, order.billing_id
FROM myDB.customer customer, myDB.order order
WHERE customer.account_id = order.account_id
it will return empty rows although they have data with same account_id (both have account_id of 1,2,3)
WHERE customer.account_id = 1 also not working
Thanks in advance
ODBC driver for Mongo - WHERE clause always return empty
Re: ODBC driver for Mongo - WHERE clause always return empty
Thank you for the information.
We reproduced the issue and fixed it. This fix will be included in the next driver release. If you want to get this fix before the official release, please use the contact form at our site: https://www.devart.com/company/contactform.html and let us know that you need a trial of Devart ODBC driver for MongoDB. And we will send a night build to your email.
We reproduced the issue and fixed it. This fix will be included in the next driver release. If you want to get this fix before the official release, please use the contact form at our site: https://www.devart.com/company/contactform.html and let us know that you need a trial of Devart ODBC driver for MongoDB. And we will send a night build to your email.