search

yugabyte / yb-tools

Tools for YugabyteDB database maintenance and support
Apache License 2.0
19 stars 18 forks source link

querymonitor.pl - Table ID format in tables and tablecol #114

Closed eugeneckim closed 5 months ago

eugeneckim commented 7 months ago

https://yugabyte.slack.com/archives/C06SS4M0XBJ/p1711904060926739

sqlite>  Select tables.name as tbl, isPartitionKey,  isClusteringKey , columnOrder , sortOrder ,tablecol.name as col   FROM tables left join tablecol on id=replace(tableid,'-','') WHERE tbl like 'custacctrole%';
tbl           isPartitionKey  isClusteringKey  columnOrder  sortOrder  col
------------  --------------  ---------------  -----------  ---------  --------------------
custacctrole  1                                             NONE       custid
custacctrole                  1                1            ASC        acctid
custacctrole                  1                2            ASC        roletitle
custacctrole                                   3            NONE       preferredcontact
custacctrole                                   4            NONE       sequencenumber
custacctrole                                   5            NONE       reportingtaxpayer
custacctrole                                   6            NONE       roledetails
custacctrole                                   7            NONE       lastupdatedtimestamp
na6vj commented 5 months ago

Fixed 2024-06-12 by commit f9e8b9c9f926fbe0c0a1770e4408c81e97f58694 (Pending pull request)