Re: Maximum length of a query

Tom Lane wrote:
>
> "Matthew V." <deusmech(at)yahoo(dot)com> writes:
> > What is the maximum length of a query nowadays? Back in 1998, it was 8192
> > bytes,
>
> That was a long time ago ;-). There has been no hard-wired upper limit
> for several releases now.
>
> [ It's rather amusing to watch MySQL's crashme test trying to discover
> our maximum query length. At least on my machine, the Perl process
> running crashme hits the kernel's per-process memory limit and dies,
> while the backend it's talking to is still comfortably under the limit.
> I wonder whether MySQL regards that as a test failure ... ]

Well, it's our fault anyway. You cannot have a hardcoded limit in one
release and then, all of the sudden, out of nowhere go unlimited ... one
can claim that we crash crashme on purpose! OTOH, isn't that what the
name asks for?

I have to apologize at this point ... I did the same with TOAST ...
going unlimited without fair warning. Fortunately crashme never tested
for a maximum content length ;-)

Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #