SQLiteadmin runs out of memory on query

This is the international (english) support forum for the SQLite Administrator developed and maintained by Orbmu2k.

Moderators: gto, EgonHugeist, Orbmu2k

Locked
Krischu
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 20.01.2012, 12:39

SQLiteadmin runs out of memory on query

Post by Krischu »

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:

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
Locked