d983323cd2570af1cf3971763d14ef2d88c06fe4 jcasper Wed Feb 19 17:00:19 2025 -0800 sqlTableSize needs to support tables with more than 2B rows (rarely, but it does), refs #35262 diff --git src/hg/oneShot/testSqlDbDotTable/testSqlDbDotTable.c src/hg/oneShot/testSqlDbDotTable/testSqlDbDotTable.c index 397be278684..3be597735ed 100644 --- src/hg/oneShot/testSqlDbDotTable/testSqlDbDotTable.c +++ src/hg/oneShot/testSqlDbDotTable/testSqlDbDotTable.c @@ -42,32 +42,32 @@ column = list->name; } printf("%s %s a %s column.\n", dbDotTable, (sqlColumnExists(conn, dbDotTable, column) ? "has" : "does not have"), column); struct sqlResult *sr = sqlDescribe(conn, dbDotTable); printf("%s returned %d columns from sqlDescribe.\n", dbDotTable, sqlCountColumns(sr)); sqlFreeResult(&sr); printf("%s %s a row where %s = 'chr1'\n", dbDotTable, (sqlRowExists(conn, dbDotTable, column, "chr1") ? "has" : "does not have"), column); printf("%s has %d columns.\n", dbDotTable, sqlCountColumnsInTable(conn, dbDotTable)); -printf("%s has %d rows IfExists.\n", dbDotTable, sqlTableSizeIfExists(conn, dbDotTable)); -printf("%s has %d rows.\n", dbDotTable, sqlTableSize(conn, dbDotTable)); +printf("%s has %ld rows IfExists.\n", dbDotTable, sqlTableSizeIfExists(conn, dbDotTable)); +printf("%s has %ld rows.\n", dbDotTable, sqlTableSize(conn, dbDotTable)); printf("%s data size is %lu.\n", dbDotTable, sqlTableDataSizeFromSchema(conn, db, dbDotTable)); printf("%s index size is %lu.\n", dbDotTable, sqlTableIndexSizeFromSchema(conn, db, dbDotTable)); printf("%s created like '%s'.\n", dbDotTable, sqlGetCreateTable(conn, dbDotTable)); printf("%s index of '%s' is %d.\n", dbDotTable, column, sqlFieldIndex(conn, dbDotTable, column)); printf("%s last updated %s (%lu).\n", dbDotTable, sqlTableUpdate(conn, dbDotTable), sqlTableUpdateTime(conn, dbDotTable)); printf("%s primary key is %s.\n", dbDotTable, sqlGetPrimaryKey(conn, dbDotTable)); struct slName *sample = sqlRandomSampleConn(conn, dbDotTable, column, 1);