Queries with LIMIT error

Greetings,

I am using version 4.1.7, at XP, Athlon XP 2.0 512 RAM 80GB HD,
accessing MySQL using VBMySQLDirect.dll at VBA (Word), the app crashes
when I use LIMIT queries at win98, the error report shows something
regarding LIBMYSQL.dll (same version as the server).

I just can't find what causes the error, some machines give it, others
not, the error occurs at the second SELECT, always one that uses LIMIT
1 at the query.

Any sugestions on how to make this work?

--=20
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

RE: Queries with LIMIT error

Upgrade to 4.1.11?
=20

> -----Original Message-----
> From: Daniel da Veiga [mailto:danieldaveiga@gmail.com]=20
> Posted At: Thursday, April 14, 2005 12:31 PM
> Posted To: MySQL
> Conversation: Queries with LIMIT error
> Subject: Queries with LIMIT error
> Importance: Low
>=20
> I am using version 4.1.7, at XP, Athlon XP 2.0 512 RAM 80GB HD,
> accessing MySQL using VBMySQLDirect.dll at VBA (Word), the app crashes
> when I use LIMIT queries at win98, the error report shows something
> regarding LIBMYSQL.dll (same version as the server).
>=20
=20

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: Queries with LIMIT error

After some time testing, YEAH, it worked!!!

Thanks PF, I didn't think that could be a bug, at least I couldn't
find the exact description at the change log, maybe a indirect bug
caused by the LIMIT clause and query cache, dunno, at least its fixed
now at 4.1.11.

Now all is working perfectly for about two weeks, no more crashes.

Thanks again,

On 4/14/05, PF: MySQL wrote:
> Upgrade to 4.1.11?
>=20
>=20
> > -----Original Message-----
> > From: Daniel da Veiga [mailto:danieldaveiga@gmail.com]
> > Posted At: Thursday, April 14, 2005 12:31 PM
> > Posted To: MySQL
> > Conversation: Queries with LIMIT error
> > Subject: Queries with LIMIT error
> > Importance: Low
> >
> > I am using version 4.1.7, at XP, Athlon XP 2.0 512 RAM 80GB HD,
> > accessing MySQL using VBMySQLDirect.dll at VBA (Word), the app crashes
> > when I use LIMIT queries at win98, the error report shows something
> > regarding LIBMYSQL.dll (same version as the server).
> >
>=20
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gma=
il.com
>=20
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org