Bug #77073 [NEW]: empty orgtable column mysql 8
| From: | dvorak at logbookie dot eu | Date: | Sat, 27 Oct 2018 18:41:51 +0000 |
| Subject: | Bug #77073 [NEW]: empty orgtable column mysql 8 | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-217713@lists.php.net to get a copy of this message | ||
From: dvorak at logbookie dot eu
Operating system: debian 9
PHP version: 7.2.11
Package: MySQLi related
Bug Type: Bug
Bug description:empty orgtable column mysql 8
Description:
------------
7.2.11-2+0~20181015120801.9+stretch~1.gbp8105e0
mysql 8.12
execute this query:
SELECT
ST.* FROM information_schema.STATISTICS
ST WHERE
ST.TABLE_SCHEMA = 'global' AND
ST.TABLE_NAME = 'deploy' ORDER BY
ST.INDEX_NAME ASC, ST.SEQ_IN_INDEX ASC
execute \mysqli_fetch_fields( $result );
orgtable field is empty
Test script:
---------------
<?php
$connection = mysqli_connect( '127.0.0.1', 'root' );
$mysqliResult = mysqli_query( $connection, " SELECT ST.* FROM
information_schema.STATISTICS ST WHERE
ST.TABLE_SCHEMA =
'global' AND ST.TABLE_NAME = 'deploy' ORDER BY
ST.INDEX_NAME
ASC, ST.SEQ_IN_INDEX ASC" );
var_dump( \mysqli_fetch_fields( $mysqliResult ) );
Expected result:
----------------
filled orgtable column
Actual result:
--------------
empty orgtable column
--
Edit bug report at https://bugs.php.net/bug.php?id=77073&edit=1
--
Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=77073&r=trysnapshot54
Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=77073&r=trysnapshot55
Try a snapshot (trunk): https://bugs.php.net/fix.php?id=77073&r=trysnapshottrunk
Fixed in SVN: https://bugs.php.net/fix.php?id=77073&r=fixed
Fixed in release: https://bugs.php.net/fix.php?id=77073&r=alreadyfixed
Need backtrace: https://bugs.php.net/fix.php?id=77073&r=needtrace
Need Reproduce Script: https://bugs.php.net/fix.php?id=77073&r=needscript
Try newer version: https://bugs.php.net/fix.php?id=77073&r=oldversion
Not developer issue: https://bugs.php.net/fix.php?id=77073&r=support
Expected behavior: https://bugs.php.net/fix.php?id=77073&r=notwrong
Not enough info: https://bugs.php.net/fix.php?id=77073&r=notenoughinfo
Submitted twice: https://bugs.php.net/fix.php?id=77073&r=submittedtwice
register_globals: https://bugs.php.net/fix.php?id=77073&r=globals
PHP 4 support discontinued: https://bugs.php.net/fix.php?id=77073&r=php4
Daylight Savings: https://bugs.php.net/fix.php?id=77073&r=dst
IIS Stability: https://bugs.php.net/fix.php?id=77073&r=isapi
Install GNU Sed: https://bugs.php.net/fix.php?id=77073&r=gnused
Floating point limitations: https://bugs.php.net/fix.php?id=77073&r=float
No Zend Extensions: https://bugs.php.net/fix.php?id=77073&r=nozend
MySQL Configuration Error: https://bugs.php.net/fix.php?id=77073&r=mysqlcfg