Changeset 91 for handler-socket-client-php/handler_socket.php

Timestamp:

12/20/2010 06:49:13 AM (15 years ago)

Author:

apokalyptik

Message:

Some things only work against InnoDB, they only corrupt other table types

File:

• handler-socket-client-php/handler_socket.php (modified) (3 diffs)

handler-socket-client-php/handler_socket.php

@@ -5 +5 @@
  *      // Tested with source compiled MySQL 5.1.54 and ahiguti-HandlerSocket-Plugin-for-MySQL-c865c53
  *      $hs = new handler_socket( '127.0.0.1', 9998, 9999 );
- *      $hs->index( 'tesst_db', 'test_table', 'PRIMARY', array('col1','col2','col3') );
- *      // Works as expected in my testing
+ *      // Works with InnoDB and MyISAM
+ *      $hs->index( 'test_db', 'test_table', 'PRIMARY', array('id','name','code') );
+ *      // Works with InnoDB
+ *      $hs->insert( 'PRIMARY', array( 1, 'FOO', 'F@' ) );
+ *      // Works with InnoDB and MyISAM
  *      $results = $hs->select('PRIMARY', '=', 1 );
- *      // Doesn't work as expected (reports success, corrupts column, repair table then drops the column)
- *      $hs->insert( 'PRIMARY', array( $col1, $col2, $col3 ) );
- *      // This does't work as expected (reports success, adds corrupted column, repair table drops the column)
- *      $hs->update( 'PRIMARY', '=', 1, array( $col1, $col2, $col3 ) );
- *      // Works as expected
+ *      // Works with InnoDB
+ *      $hs->update( 'PRIMARY', '=', 1, array( '1', 'FOO UPDATED AT '.time() ) );
+ *      // Works with InnoDB and MyISAM
  *      $hs->delete( 'PRIMARY', '=', 1 ); 
  *
@@ -110 +111 @@
 
     /*
-     * Update via comparison against a defined index (note: right now just seems to corrupt tables)
+     * Update via comparison against a defined index 
      *
      * @param $key string the defined index you wish to use, use "PRIMARY" fpr the primary key
@@ -140 +141 @@
         return $this->parse_response( $this->query( 'write', $request ), true );
     }
+
     /*
-     * Insert into a given table, using the key as a reference (note: right now just seems to corrupt tables)
+     * Insert into a given table, using the key as a reference
      *
      * @param $key string the defined index you wish to use, use "PRIMARY" fpr the primary key