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

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. Tomas V.V.Cox