[php-src] Issue #15432: PHP crashes when processing a MySQL DB query with a new Vector format introduced in MySQL 9.0
| From: | richloh | Date: | Thu, 15 Aug 2024 18:58:00 +0000 |
| Subject: | [php-src] Issue #15432: PHP crashes when processing a MySQL DB query with a new Vector format introduced in MySQL 9.0 | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-247506@lists.php.net to get a copy of this message | ||
Issue: https://github.com/php/php-src/issues/15432
Author: richloh
### Description
In MySQL version 9, Oracle [added support for vector data
types](https://dev.mysql.com/doc/refman/9.0/en/vector.html).
These are needed for AI-operations and eliminate the need for dedicated vector databases like
Weaviate or Pinecone. Postgres also has a similar feature.
When viewing a Mysql response with a vector data type, php crashes.
## Steps to reproduce the behavior:
### 1. Spin up any mysql database with version 9, e.g. using
```
docker run --rm \
--name mysql-container \
-e MYSQL_ROOT_PASSWORD="" \
-e ALLOW_EMPTY_PASSWORD=yes \
-e MYSQL_DATABASE=test \
-p 3306:3306 \
bitnami/mysql:9.0
```
### 2. Run the mysql query
Run the mysql query
SELECT STRING_TO_VECTOR("[1.05, -17.8, 32]"). This
returns a vector in the new binary Mysql 9 vector format.
Here some sample code for this:
```
<?php
$conn = new mysqli("127.0.0.1", "root", "", "test");
echo $conn->query('SELECT STRING_TO_VECTOR("[1.05, -17.8,
32]")')->fetch_assoc();
```
### 3. Observe output
This is the output that is returned by PHP 8.3.3:
```
PHP Warning: mysqli::query(): Unknown type 242 sent by the server. Please send a report to the
developers in /home/richard/enneo/test/db.php on line 9
PHP Stack trace:
PHP 1. {main}() /home/richard/enneo/test/db.php:0
PHP 2. mysqli->query($query = 'SELECT STRING_TO_VECTOR("[1.05, -17.8,
32]")') /home/richard/enneo/test/db.php:9
Warning: mysqli::query(): Unknown type 242 sent by the server. Please send a report to the
developers in /home/richard/enneo/test/db.php on line 9
Call Stack:
0.0001 489424 1. {main}() /home/richard/enneo/test/db.php:0
0.0013 531656 2. mysqli->query($query = 'SELECT STRING_TO_VECTOR("[1.05,
-17.8, 32]")') /home/richard/enneo/test/db.php:9
zend_mm_heap corrupted
fish: Job 1, 'php db.php' terminated by signal SIGABRT (Abort)
```
## Expected output
A php data variable that holds the results, preferrably an array of floats with an array length that
matches the vector length.
The native mysql client also has this type of output (as of v9).
### PHP Version
PHP 8.3.3
### Operating System
Ubuntu 22.04