DISTINCT broken in views2

I have a page view displaying some nodes by taxonomy. When I have distinct checked views spits out the following error:
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT(node.nid), node.title AS node_title, node.created AS node_created' at line 1 query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS DISTINCT(node.nid), node.title AS node_title, node.created AS node_created FROM cms_node node LEFT JOIN cms_term_node term_node ON node.vid = term_node.vid LEFT JOIN cms_term_data term_data ON term_node.tid = term_data.tid WHERE (term_data.vid in ('2', '3')) AND (node.vid IN ( SELECT tn.vid FROM cms_term_node tn LEFT JOIN cms_term_hierarchy th ON th.tid = tn.tid LEFT JOIN cms_term_hierarchy th1 ON th.parent = th1.tid WHERE tn.tid = 35 OR th1.tid = 35 )) ORDER BY node_created DESC ) count_alias in /var/www/halslist.com/public_html/sites/all/modules/views/includes/view.inc on line 699.

Here is the query from the views preview:
SELECT DISTINCT(node.nid) AS nid,
node.title AS node_title,
node.created AS node_created
FROM cms_node node
LEFT JOIN cms_term_node term_node ON node.vid = term_node.vid
LEFT JOIN cms_term_data term_data ON term_node.tid = term_data.tid
WHERE (term_data.vid in ('2', '3')) AND (node.vid IN (
SELECT tn.vid FROM cms_term_node tn
LEFT JOIN cms_term_hierarchy th ON th.tid = tn.tid
LEFT JOIN cms_term_hierarchy th1 ON th.parent = th1.tid
WHERE tn.tid = 35
OR th1.tid = 35
))
ORDER BY node_created DESC

And here is the exported view:

$view = new view;
$view->name = 'taxonomy_term';
$view->description = 'A view to emulate Drupal core\'s handling of taxonomy/term; it also emulates Views 1\'s handling by having two possible feeds.';
$view->tag = 'default';
$view->view_php = '';
$view->base_table = 'node';
$view->is_cacheable = FALSE;
$view->api_version = 2;
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->override_option('fields', array(
'title' => array(
'label' => '',
'link_to_node' => 1,
'exclude' => 0,
'id' => 'title',
'table' => 'node',
'field' => 'title',
'relationship' => 'none',
),
));
$handler->override_option('sorts', array(
'created' => array(
'order' => 'DESC',
'granularity' => 'second',
'id' => 'created',
'table' => 'node',
'field' => 'created',
'relationship' => 'none',
),
));
$handler->override_option('arguments', array(
'term_node_tid_depth' => array(
'default_action' => 'ignore',
'style_plugin' => 'default_summary',
'style_options' => array(),
'wildcard' => 'all',
'wildcard_substitution' => 'All',
'title' => '',
'default_argument_type' => 'fixed',
'default_argument' => '',
'validate_type' => 'none',
'validate_fail' => 'not found',
'depth' => '1',
'break_phrase' => 0,
'set_breadcrumb' => 1,
'id' => 'term_node_tid_depth',
'table' => 'node',
'field' => 'term_node_tid_depth',
'override' => array(
'button' => 'Override',
),
'relationship' => 'none',
'default_options_div_prefix' => '',
'default_argument_user' => 0,
'default_argument_fixed' => '',
'default_argument_php' => '',
'validate_argument_node_type' => array(
'ed_classified' => 0,
'forum' => 0,
'housing' => 0,
'jobs' => 0,
'page' => 0,
'personals' => 0,
'sale_items' => 0,
'services' => 0,
'story' => 0,
),
'validate_argument_node_access' => 0,
'validate_argument_nid_type' => 'nid',
'validate_argument_vocabulary' => array(
'1' => 0,
'2' => 0,
'3' => 0,
),
'validate_argument_type' => 'tid',
'validate_argument_php' => '',
),
));
$handler->override_option('filters', array(
'vid' => array(
'operator' => 'in',
'value' => array(
'2' => '2',
'3' => '3',
),
'group' => '0',
'exposed' => FALSE,
'expose' => array(
'operator' => 'vid_op',
'label' => 'Type',
'use_operator' => 0,
'identifier' => 'vid',
'optional' => 1,
'single' => 1,
'remember' => 1,
'reduce' => 0,
),
'id' => 'vid',
'table' => 'term_data',
'field' => 'vid',
'override' => array(
'button' => 'Override',
),
'relationship' => 'none',
),
'tid' => array(
'operator' => 'or',
'value' => array(),
'group' => '0',
'exposed' => TRUE,
'expose' => array(
'use_operator' => 0,
'operator' => 'tid_op',
'identifier' => 'tid',
'label' => 'Category',
'optional' => 1,
'single' => 1,
'remember' => 0,
'reduce' => 0,
),
'type' => 'select',
'vid' => '2',
'id' => 'tid',
'table' => 'term_node',
'field' => 'tid',
'hierarchy' => 1,
'relationship' => 'none',
'reduce_duplicates' => 0,
),
));
$handler->override_option('access', array(
'type' => 'none',
'role' => array(),
'perm' => '',
));
$handler->override_option('empty', 'Were sorry but there are no classifieds in that category. Why don\'t you Create One?');
$handler->override_option('empty_format', '1');
$handler->override_option('use_ajax', TRUE);
$handler->override_option('use_pager', '1');
$handler->override_option('distinct', 1);
$handler = $view->new_display('page', 'Page', 'page');
$handler->override_option('path', 'taxonomy/term/%');
$handler->override_option('menu', array(
'type' => 'none',
'title' => '',
'weight' => 0,
'name' => 'navigation',
));
$handler->override_option('tab_options', array(
'type' => 'none',
'title' => '',
'weight' => 0,
));
$handler = $view->new_display('feed', 'Core feed', 'feed');
$handler->override_option('items_per_page', 15);
$handler->override_option('style_plugin', 'rss');
$handler->override_option('style_options', array(
'mission_description' => FALSE,
'description' => '',
));
$handler->override_option('row_plugin', 'node_rss');
$handler->override_option('row_options', array(
'item_length' => 'default',
));
$handler->override_option('path', 'taxonomy/term/%/%/feed');
$handler->override_option('menu', array(
'type' => 'none',
'title' => '',
'weight' => 0,
'name' => 'navigation',
));
$handler->override_option('tab_options', array(
'type' => 'none',
'title' => '',
'weight' => 0,
));
$handler->override_option('displays', array(
'page' => 'page',
'default' => 0,
));
$handler->override_option('sitename_title', FALSE);
$handler = $view->new_display('feed', 'Views 1 feed', 'feed_1');
$handler->override_option('items_per_page', 15);
$handler->override_option('style_plugin', 'rss');
$handler->override_option('style_options', array(
'mission_description' => FALSE,
'description' => '',
));
$handler->override_option('row_plugin', 'node_rss');
$handler->override_option('row_options', array(
'item_length' => 'default',
));
$handler->override_option('path', 'taxonomy/term/%/feed');
$handler->override_option('menu', array(
'type' => 'none',
'title' => '',
'weight' => 0,
'name' => 'navigation',
));
$handler->override_option('tab_options', array(
'type' => 'none',
'title' => '',
'weight' => 0,
));
$handler->override_option('displays', array());
$handler->override_option('sitename_title', FALSE);