SQL Bug?

I'm new here, so pl. let me know if I'm doing something wrong.

I'd been seeing a recurring SQL SELECT error message every time I updated the directory settings. Also noticed that the node counts were not displaying.

I traced it to the function and the SQL queries:

        $result = db_query(db_rewrite_sql('SELECT t.tid, n.nid FROM {term_node} t JOIN {node} n ON t.nid = n.nid WHERE n.status = 1', 't', 'tid'));
  

which I changed to:

        $result = db_query(db_rewrite_sql('SELECT t.tid, n.nid FROM {term_node} t LEFT JOIN {node} n ON t.nid = n.nid WHERE n.status = 1', 't', 'tid'));
  

essentially adding the LEFT keyword to JOIN.

I tried this first with the official release version and then with the dev version with identical results.

Was this an oversight, incorrect code version or a real bug?

Thanks