[Treebase-devel] Matrix nchar, ntax vs counted rows and columns

[Vladimir G. <vga...@ne...>]

Bill,
Here are all the matrices (also attached) in the post-migration  
instance that have a discrepancy between their ntax and the number of  
associated matrixrows, or between nchar and the number of associated  
matrixcolumns.

  matrix_id |     tb_matrixid      |      nexusfilename       |  
published | ntax | rows_counted | nchar | columns_counted
-----------+----------------------+-------------------------- 
+-----------+------+--------------+-------+-----------------
       4090 | M1728                | M1728.nex                |  
f         |      |           26 |    30 |              30
       4150 |                      | withstates.nex           |  
f         |      |            7 |       |              28
       4374 | M4524                | M4524.nex                |  
f         |      |          205 | 11335 |           11335
       4050 |                      | 18S-28S                  |  
f         |      |           72 |       |            1818
       4098 | M64c1x28x96c16c00c36 | M64c1x28x96c16c00c36.nex |  
f         |      |           46 |    84 |              84
       4110 |                      | M2496.nex                |  
f         |      |           34 | 16837 |           16837
       4622 | M4460                | M4460.nex                |  
f         |      |           54 |  9173 |            9173
       4092 | M2056                | M2056.nex                |  
f         |      |           49 |   161 |             161
       4070 |                      | zztip                    |  
f         |      |           12 |       |             542
       4095 | M2767                | M2767.nex                |  
f         |      |           66 |   806 |             806
       4091 | M1729                | M1729.nex                |  
f         |      |           46 |    30 |              30
       4099 | M76c1x29x96c15c31c23 | M76c1x29x96c15c31c23.nex |  
f         |      |           15 |    31 |              31
       4130 |                      | 12Tx432C.nex             |  
f         |      |           12 |       |             432
       4096 | M62c1x28x96c15c56c19 | M62c1x28x96c15c56c19.nex |  
f         |      |           72 |    82 |              82
       4094 | M2765                | M2765.nex                |  
f         |      |           74 |  2266 |            2266
       4093 | M2313                | M2313.nex                |  
f         |      |           43 |  1902 |            1902
       4097 | M644                 | M644.nex                 |  
f         |      |           28 |    86 |              86
(17 rows)

I believe, all these predate the migration.  Let me know what to do:  
scrape them all out, update their nchar, ntax to the counts, or do  
something case-by-case.

Here is the query used for the report:

select m.matrix_id, m.tb_matrixid, m.nexusfilename, m.published,
        m.nTax, r.rows_counted,
        nChar,  c.columns_counted
from matrix as m,
      (select matrix_id, count(*) as rows_counted
       from matrixrow group by matrix_id) as r,
      (select matrix_id, count(*) as columns_counted
       from matrixcolumn group by matrix_id) as c
where m.matrix_id = r.matrix_id and m.matrix_id = c.matrix_id
   and ((m.ntax is null or m.ntax <> r.rows_counted) or
        (m.nchar is null or m.nchar <> c.columns_counted))