My Oracle Support Banner

Prepared Statements With Group Concat Fail: ERROR 1615 (HY000): Prepared statement needs to be re-prepared (Doc ID 2793172.1)

Last updated on JULY 20, 2021

Applies to:

MySQL Server - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

Prepared statements of queries containing GROUP_CONCAT clause can fail with:

 

Changes

The group_concat_max_len was set to a very high value.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.