SQLiteadmin runs out of memory on query
Posted: 20.01.2012, 15:41
When I open Sqliteadmin.exe (0.8.3.2.public beta) on Northwind.db3 (you know, this originally MS Access DB, later MSSQL sample database that consists of a Deli shop customer and product base) and I put a certain query:
as a result it takes several seconds with no result coming back but instead a box pops up, saying "out of memory". The program seem defunct from then on.
The query itself may appear to be not so senseful, but I'm using a complex query to find a bug example in another program.
--
Christoph
Code: Select all
select i.CustomerID, i.CompanyName, i.City, i.Country, k.OrderDate, k.OrderID, p.ProductID from Customers i, Orders k,'Order Details' p where i.Country in ( 'Germany', 'France', 'Spain');as a result it takes several seconds with no result coming back but instead a box pops up, saying "out of memory". The program seem defunct from then on.
The query itself may appear to be not so senseful, but I'm using a complex query to find a bug example in another program.
--
Christoph