juhyunkwon / php-handlersocket

Automatically exported from code.google.com/p/php-handlersocket
BSD 3-Clause "New" or "Revised" License
0 stars 0 forks source link

don't search for INDEX #5

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
CREATE TABLE test (
 `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(128) ,
   PRIMARY KEY (`id`),
  KEY `name` (`title`),
);
[code]
$hs->openIndex(1, $dbname, $table, HandlerSocket::PRIMARY, 'id,title);
$hs->executeSingle(1, '=', array('123'), 1, 0); // OK

// don't search for any INDEX
$hs->openIndex(2, $dbname, $table, 'name', 'id,title);
$hs->executeSingle(2, '=', array('name1'), 1, 0); // null , but record with 
title='name1' exist
[/code]

Original issue reported on code.google.com by akalend on 2 Feb 2011 at 7:52