Edit report at https://bugs.php.net/bug.php?id=62054&edit=1
ID: 62054
Updated by: php-bugs@lists.php.net
Reported by: s-php at ertel-net dot de
Summary: Column size is not reserved for all UNION
-Status: Feedback
+Status: No Feedback
Type: Bug
Package: MySQLi related
Operating System: Ubuntu
PHP Version: 5.3.13
New Comment:
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.
Previous Comments:
------------------------------------------------------------------------
[2012-07-02 18:47:42] s-php at ertel-net dot de
Sorry, column names changed. But I guess this should be no problem for you.
mysql> PREPARE x from "SELECT 'read' AS Action FROM friends UNION SELECT CASE
status WHEN 0 THEN 'request-received' WHEN 1 THEN 'confirmed' WHEN 2 THEN 'x'
END AS Action FROM friends";
Query OK, 0 rows affected (0.00 sec)
Statement prepared
mysql> execute x;
Field 1: `Action`
Catalog: `def`
Database: ``
Table: ``
Org_table: ``
Type: VAR_STRING
Collation: utf8_general_ci (33)
Length: 48
Max_length: 16
Decimals: 0
Flags:
+------------------+
| Action |
+------------------+
| read |
| confirmed |
| request-received |
| x |
+------------------+
4 rows in set (0.00 sec)
------------------------------------------------------------------------
[2012-07-02 13:36:15] u...@php.net
99% sure: Server bug, not a client issue.
Please, report column type information retrieved on the MySQL prompt when
preparing the statement using SQL PREPARE and then executing it. Log in to the
MySQL prompt using --column-type-info option to see the meta data reported by
the server.
------------------------------------------------------------------------
[2012-05-17 13:28:21] s-php at ertel-net dot de
Description:
------------
When I concatenate two queries with UNION an there are static strings in the
queries, mysqli only reserves a big enough variable for the strings in the
first query.
If there are static strings in the other queries after the UNION, the strings
are just cut off.
Test script:
---------------
$stmt = $this->mysqli->prepare("SELECT 'read' AS Action FROM tbl1
UNION
SELECT CASE status WHEN 0 THEN 'request-received' WHEN 1 THEN 'confirmed' WHEN
2 THEN 'x' END AS Action FROM tbl2");
$stmt->bind_result($action);
$stmt->execute();
while($stmt->fetch())
{
echo $action . " ";
}
Expected result:
----------------
expected output is: read request-received confirmed
Actual result:
--------------
actual output is: read request-recei confirmed
The "request-received" is cut off!
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=62054&edit=1
