Hi Folks
I've encountered an SQL statement like:
select x from y where z in (1, 2, ...)
and where the () contains about 10,000 numbers of up to 5 digits each, so the
entire SQL statement is about 57,000 bytes long.
MySQL runs it without error, suggesting a 64 Kb limit on individual statements,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I've encountered an SQL statement like:
select x from y where z in (1, 2, ...)
and where the () contains about 10,000 numbers of up to 5 digits each,
so the entire SQL statement is about 57,000 bytes long.
MySQL runs it without error,
Greg Sabino Mullane [EMAIL PROTECTED] 11/16/04 07:54AM
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Your logic that because it worked, MySQL's limit must be 65kb may
be asbogus
as the PostgreSQL 32kb logic, but I don't know MySQL well enough to
say.
Lighten up Greg. Ron did say I
On Tue, 16 Nov 2004 12:54:07 -, Greg Sabino Mullane wrote:
Hi Greg
Your logic that because it worked, MySQL's limit must be 65kb may
be as bogus as the PostgreSQL 32kb logic, but I don't know MySQL
well enough to say.
Thanx for the info. I did admit I was guessing...
--
Cheers
Ron
On Tue, 16 Nov 2004 08:04:06 -0500, Hardy Merrill wrote:
Hi Hardy
Lighten up Greg. Ron did say I admit I'm guessing re the
statement length limits.
No offence taken here :-).
Sometimes it's necessary to be (a bit) deliberately provocative in order to
engender some sort of discussion...
--