Re: BUG with "LOAD DATA" query in mysql DB Pear !

["Tomas V.V.Cox" <cox@idecnet.com>] > Stig Sæther Bakken wrote: > > > > ["Tomas V.V.Cox" <cox@idecnet.com>] > > > Nicolas Guilhot wrote: > > > > > > > > I was trying to execute a "LOAD DATA" query with mysql Pear class, and > > > > the > > > > query always returned a DBError. It seems that "LOAD DATA" should be > > > > an > > > > action query and it isn't not present in the action query regex in DB.php. > > > > Tell me if I'm wrong !! > > > > > > > > > > As load data seems to be Mysql specific, I think we should move from > > > using isManip to ereg SELECT in mysql::simpleQuery() as pgsql does. If > > > noone submits the fix I'll do it tomorrow. > > > > Please include all the query "verbs" returning data that MySQL > > supports in addition to SELECT, such as SHOW. > > Reviewing the documentation I notice that the php mysql_query function > will return 3 kinds of data: true, false or resource id. So perhaps a > better solution to find where to return a DB_result for mysql.php could > be if "is_resource". > > Anyway, if noone can confirm this, the statements I found that returns > data (from > > http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#USE) > are: > SELECT|SHOW|DESCRIBE|EXPLAIN|CHECK|ANALYZE|BACKUP|RESTORE|REPAIR > Please notify me if I'm wrong. I can confirm this, so you don't need to use DB::isManip in DB_mysql::simpleQuery. - Stig -- Stig Sæther Bakken <ssb@fast.no> Fast Search & Transfer ASA, Trondheim, Norway