Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 30 May 2017 17:33:59 +0000
From:      bugzilla-noreply@freebsd.org
To:        freebsd-ports-bugs@FreeBSD.org
Subject:   [Bug 219661] databases/mysql-server:  mysqli_store_result fails on even toy datasets
Message-ID:  <bug-219661-13@https.bugs.freebsd.org/bugzilla/>

next in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D219661

            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@FreeBSD.org
          Reporter: scratch65535@att.net

10.3, 2017Q2=20=20

(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, whi=
ch
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 =3D 'SELECT * from keys_used limit 10' ;
    echo 'Getting 10 records from keys_used'.cBR ;
    if ( mysqli_query($link,$q) )            // the query does work
        $dset =3D mysqli_store_result($link) ; // but the store_result does=
 not.=20
    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 happ=
y if
I've simply misunderstood something.

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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-219661-13>