[Bug 219661] databases/mysql-server: mysqli_store_result fails on even toy datasets

[bugzilla-noreply at freebsd.org]

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=219661

            Bug ID: 219661
           Summary: databases/mysql-server:  mysqli_store_result fails on
                    even toy datasets
           Product: Ports & Packages
           Version: Latest
          Hardware: amd64
                OS: Any
            Status: New
          Severity: Affects Many People
          Priority: ---
         Component: Individual Port(s)
          Assignee: freebsd-ports-bugs at FreeBSD.org
          Reporter: scratch65535 at att.net

10.3, 2017Q2  

(I'm actually using MariaDB 10.1.22, not MySQL)

I need to use mysqli_data_seek, and so have to use mysqli_store_result, which
didn't exist before the change to mysqli and so I don't know anything about it.

Store_result fails in this toy program: (the table keys_used is just strings
from the OSM database, 1 string per record, no string over 48 chars)

    $q = 'SELECT * from keys_used limit 10' ;
    echo 'Getting 10 records from keys_used'.cBR ;
    if ( mysqli_query($link,$q) )            // the query does work
        $dset = mysqli_store_result($link) ; // but the store_result does not. 
    if ( $dset) echo mysqli_num_rows($dset).' stored'.cBR ;
    else echo 'Store failed'.cBR ;
    die() ;

As far as I can tell from the Very Meager documentation available, it should
work.  But it doesn't, even with so small a result set.  I'll be quite happy if
I've simply misunderstood something.

-- 
You are receiving this mail because:
You are the assignee for the bug.