Bug#32717969: Wrong result of execute prepare on 'smallint'

This problem may occur with prepared implicitly grouped SELECT
statements. When the WHERE clause is determined to be always false,
e.g. due to the actual parameter values, the result of some aggregate
functions may be picked up from the previous execution.

The reason for this is that the aggregator object for such functions
is not set up, instead the no_rows_in_result() function should be
called and set the null_value flag (at least when the aggregate function
is nullable). After inspection, it was observed that the SUM and the
GROUP_CONCAT functions missed the necessary no_rows_in_result()
implementations. These have now been implemented to call the clear()
function, which will set the null_value for the function result.

It was also detected that the NTILE function was always made nullable,
even though it can never return NULL unless the argument is NULL.
This problem was also fixed.

Reviewed by: Chaithra Gopala Reddy <[email protected]>

Change-Id: Ied8ab405a3afa520a23dd95d106f4ba7312a6f02

Bug#32717969: Wrong result of execute prepare on 'smallint'

This problem may occur with prepared implicitly grouped SELECT
statements. When the WHERE clause is determined to be always false,
e.g. due to the actual parameter values, the result of some aggregate
functions may be picked up from the previous execution.

The reason for this is that the aggregator object for such functions
is not set up, instead the no_rows_in_result() function should be
called and set the null_value flag (at least when the aggregate function
is nullable). After inspection, it was observed that the SUM and the
GROUP_CONCAT functions missed the necessary no_rows_in_result()
implementations. These have now been implemented to call the clear()
function, which will set the null_value for the function result.

It was also detected that the NTILE function was always made nullable,
even though it can never return NULL unless the argument is NULL.
This problem was also fixed.

Reviewed by: Chaithra Gopala Reddy <[email protected]>

Change-Id: Ied8ab405a3afa520a23dd95d106f4ba7312a6f02

Bug #32287863 BACKPORT THE PATCH FOR BUG #27874068 ADD SUPPORT FOR -D…

…CMAKE_BUILD_TYPE=RELEASE

Follow-up patch:
re-enable -O3 by default for RelWithDebInfo (and Release) builds on Linux.

Change-Id: Ica5190aa1d6f6539ad629d93c10e4a0fd0bcdd2d
(cherry picked from commit 6cde07847a05e12640806f005d9eb7d120440b89)

Bug #32287863 BACKPORT THE PATCH FOR BUG #27874068 ADD SUPPORT FOR -D…

…CMAKE_BUILD_TYPE=RELEASE

Follow-up patch:
re-enable -O3 by default for RelWithDebInfo (and Release) builds on Linux.

Change-Id: Ica5190aa1d6f6539ad629d93c10e4a0fd0bcdd2d

Bug #32628376 BACKPORT FIX OF BUG 32335263 TO 5.6+

PROBLEM
-------
If the query contains password in plain text,
we have the query re-written immediately after
parsing and password string is replaced. However,
there is a unsafe window before rewrite is done
and in such case we should not display the plain
text password.

Affected queries are
SHOW PROCESSLIST;
SELECT ... FROM information_schema.processlist;

Solution:
---------
Fix this is to avoid displaying the
query string till re-write is over.

#rb 26092
#rb 26070

Reviewed-by: Debarun Bannerjee <[email protected]>
Reviewed-by: Reviewed by: Dyre Tjeldvold <[email protected]>

(cherry picked from commit c7d0c5b6ee1cfc2a5328e9adf058857b43e0a091)

Bug #32628376 BACKPORT FIX OF BUG 32335263 TO 5.6+

PROBLEM
-------
If the query contains password in plain text,
we have the query re-written immediately after
parsing and password string is replaced. However,
there is a unsafe window before rewrite is done
and in such case we should not display the plain
text password.

Affected queries are
SHOW PROCESSLIST;
SELECT ... FROM information_schema.processlist;

Solution:
---------
Fix this is to avoid displaying the
query string till re-write is over.

#rb 26092
#rb 26070

Reviewed-by: Debarun Bannerjee <[email protected]>
Reviewed-by: Reviewed by: Dyre Tjeldvold <[email protected]>

(cherry picked from commit c7d0c5b6ee1cfc2a5328e9adf058857b43e0a091)

Update License Book for Server 5.6.51 release

Approved-by: Bjorn Munch <[email protected]>