I am using Magento Community 1.7.0.2. 

Recently I decided to turn on 'Use Flat Catalog Category' and 'Use Flat Catalog Category' options in my store. All images on my frontend that were using 'image' attribute disappeared (they were replaced by default image placeholder). All images that are displayed with 'small\_image' or 'thumbnail' attribute displays correctly.

I looked into catalog\_product\_flat\_1 table and there is no 'image' column there (but there 'image\_label' column...). I looked into the flat indexer code and was able to print the SQL statement that is using to get all attributes that are inserted into flat table:

```
SELECT `main_table`.*, `additional_table`.* 
FROM `eav_attribute` AS `main_table` 
INNER JOIN `catalog_eav_attribute` AS `additional_table` 
ON additional_table.attribute_id = main_table.attribute_id 
WHERE (main_table.entity_type_id = :entity_id) AND (main_table.backend_type = 'static'     
OR additional_table.is_used_for_promo_rules = 1 OR additional_table.used_in_product_listing = 1 OR additional_table.used_for_sort_by = 1 
OR main_table.attribute_code IN('sku', 'type_id', 'name', 'status', 'visibility', 'price', 'weight', 'url_path', 'url_key', 'thumbnail', 'small_image', 
'tax_class_id', 'special_from_date', 'special_to_date', 'special_price', 'cost', 'is_recurring', 'recurring_profile', 'msrp_enabled', 'msrp',
'msrp_display_actual_price_type', 'enable_googlecheckout', 'gift_message_available', 'price_view', 'price_type', 'shipment_type', 'weight_type', 
'sku_type', 'links_purchased_separately', 'links_title', 'short_description', 'image_label', 'thumbnail_label', 'small_image_label', 'news_from_date',
'news_to_date', 'created_at', 'updated_at', 'required_options'))

```

As you can see no 'image' attribute on the list.

The 'image' attribute is used in frontend in default Magento distribution, so I'm wondering is this a bug?