fetchAllAssoc() is returning only first row

Question

I have a query like this:

  $product_classes = db_select('node_type', 't')->fields('t', array('name', 'type'))->condition('module','uc_product')
  ->execute()->fetchAllAssoc('orig_type', PDO::FETCH_ASSOC);

It will return an array with only first valid table row, however there are more valid rows.

If I use this query, without specified fields:

  $product_classes = db_select('node_type', 't')->fields('t')-:condition('module','uc_product')
  ->execute()->fetchAllAssoc('orig_type', PDO::FETCH_ASSOC);

It will return array with all the valid rows. It is a drupal bug?

Answer 1

The column name orig_type used in ->fetchAllAssoc('orig_type') must be included in

->fields('p', array('name', 'type', 'orig_type))

too, otherwise only one record will be returned.

Answer 2

Maybe the reason? "If the given key appears multiple times, later records will overwrite earlier ones." https://api.drupal.org/api/drupal/includes!database!database.inc/function/DatabaseStatementInterface%3A%3AfetchAllAssoc/7