Partial row read

[Andy Stec]

We're getting strange results when reading from Cassandra 2.0 in php using
this driver:

http://code.google.com/a/apache-extras.org/p/cassandra-pdo/


Here's the schema:

CREATE TABLE events (
  day text,
  last_event text,
  event_text text,
  mdn text,
  PRIMARY KEY ((day), last_event)
) WITH CLUSTERING ORDER BY (last_event DESC) AND
  bloom_filter_fp_chance=0.010000 AND
  caching='KEYS_ONLY' AND
  comment='' AND
  dclocal_read_repair_chance=0.100000 AND
  gc_grace_seconds=864000 AND
  index_interval=128 AND
  read_repair_chance=0.000000 AND
  replicate_on_write='true' AND
  populate_io_cache_on_flush='false' AND
  default_time_to_live=0 AND
  speculative_retry='99.0PERCENTILE' AND
  memtable_flush_period_in_ms=0 AND
  compaction={'class': 'SizeTieredCompactionStrategy'} AND
  compression={'sstable_compression': 'LZ4Compressor'};


Here's the database contents:

cqlsh:msa> SELECT * FROM events;
 day    | last_event          | event_text | mdn
--------+---------------------+------------+------------
 141121 | 2014-46-21 20:46:45 | event text | 8471111111
(1 rows)


Here's the simple program in php that reads the database:

<?php
$dsn = "cassandra:host=192.168.1.201;port=9160";
$db = new PDO ($dsn);
$db->exec ("USE msa");
$stmt = $db->query ("SELECT day, last_event, mdn, event_text FROM events");
if ($stmt === false)
{
   var_dump ($db->errorInfo ());
}
else
{
   $stmt->execute ();
   var_dump ($stmt->fetchAll());
}
?>

And this is the output the program produces.  Why is it not returning the
full row?


array(1) {
  [0]=>
  array(6) {
    ["day"]=>
    string(6) "141121"
    [0]=>
    string(6) "141121"
    [""]=>
    string(0) ""
    [1]=>
    string(0) ""
    [2]=>
    string(0) ""
    [3]=>
    string(0) ""
  }
}