From: Date: February 14 2005 6:10pm
Subject: ERROR 1037 caused by simple query
List-Archive: http://lists.mysql.com/win32/16578
Message-Id: <1108401009.4210db711f8fc@www.domainfactory-webmail.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit

Hi all,

I'm struggling to set up MySQL on WinXP, with limited success so far.  I want to
use it as the backend for an application that can use either MySQL, PostgreSQL,
or SQLite for data storage.

At least one query type generated by my app fails on MySQL on WinXP. The queries
are ok in MySQL 4.1.9 on FreeBSD, MySQL 4.0.23 on Linux, PostgreSQL on
Windows/Linux/FreeBSD, and SQLite on Windows/Linux/FreeBSD. They used to be ok
in MySQL 3.23 on Windows and other platforms too. However, on WinXP at least
MySQL 4.1.8 and 4.1.9 appear to be broke.

I've got a table with 33 columns. The following query retrieves the dataset with
the unique column value refdb_id=1 without problems:

mysql> SELECT DISTINCT * FROM t_refdb WHERE refdb_id='1' ORDER BY refdb_id;

The following query should retrieve the same dataset (all ids are >0), but it
fails:

mysql> SELECT DISTINCT * from t_refdb WHERE refdb_id<'2' ORDER BY refdb_id;
ERROR 1037 (HY001): Out of memory; restart server and try again (needed 217080 b
ytes)

The error is independent of the value of the comparison. <'10' or <'100' or even
>'10' all cause the same error (but in these cases the DISTINCT and ORDER BY
clauses would make sense, that's why I mention this).

If I leave out either the DISTINCT or the ORDER BY clause, the query works
again:

mysql> SELECT * FROM t_refdb WHERE refdb_id<'2' ORDER BY refdb_id;
mysql> SELECT DISTINCT * FROM t_refdb WHERE refdb_id<'2';

Once again, keep in mind that *all* of the above queries work with MySQL on
other platforms and with other database engines on all platforms.

Is there anything wrong with this type of queries?

Another oddity of the windows version is that the command line client mysql
appears to be limited to SQL queries of no more than 256 characters. I can't
enter more than that. This limitation is also missing elsewhere.

Platform info: WinXP Professional Version 2002, Service Pack 2, 256MB RAM, MySQL
Versions 4.1.8 or 4.1.9, set up for a developer box with MyISAM tables only,
UTF8 as default encoding, other values left to their defaults to the best of my
knowledge.

Any clues?

regards,
Markus

-- 
Markus Hoenicka
markus.hoenicka@stripped
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de