Public bug reported:

Proof.

select count(distinct email) from aiki_users
        75766

on page http://www.openclipart.org/artists

883:

  <td class="metric">Total Artists</td>
  <td class="number">(#(inherent:121|select count(distinct email) from 
aiki_users)#)</td>

121:
   SQL: select count(id) from ocal_files where filename RLIKE '.svg' and 
upload_published = 1
   Content: [records_num]


renders:

Total Artists   80538 (without distinct)

** Affects: aikiframework
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Aiki
Framework Admins, which is subscribed to aikiframework.
https://bugs.launchpad.net/bugs/736057

Title:
  distinct don't work with inheried

Status in Aiki Framework:
  New

Bug description:
  Proof.

  select count(distinct email) from aiki_users
        75766

  on page http://www.openclipart.org/artists

  883:

    <td class="metric">Total Artists</td>
    <td class="number">(#(inherent:121|select count(distinct email) from 
aiki_users)#)</td>

  121:
     SQL: select count(id) from ocal_files where filename RLIKE '.svg' and 
upload_published = 1
     Content: [records_num]

  
  renders:

  Total Artists   80538 (without distinct)

_______________________________________________
Mailing list: https://launchpad.net/~aikiframework.admins
Post to     : aikiframework.admins@lists.launchpad.net
Unsubscribe : https://launchpad.net/~aikiframework.admins
More help   : https://help.launchpad.net/ListHelp

Reply via email to