dbcompare /

Y N 0.0 0.0 10000 50 50 N Y 50000 Y N 1000 - 2010/10/18 16:43:24.649 - 2010/10/18 16:43:24.649 Need to correct table compare Add constants shouldn't be necessary 193 122 99 178 ENSEMBL.HOMO_SAPIENS_CORE_24_34_E ensembldb.ensembl.org MYSQL Native homo_sapiens_core_24_34e 3306 anonymous Encrypted EXTRA_OPTION_MYSQL.defaultFetchSize500 EXTRA_OPTION_MYSQL.useCursorFetchtrue FORCE_IDENTIFIERS_TO_LOWERCASEN FORCE_IDENTIFIERS_TO_UPPERCASEN IS_CLUSTEREDN PORT_NUMBER3306 QUOTE_ALL_FIELDSN STREAM_RESULTSY SUPPORTS_BOOLEAN_DATA_TYPEN USE_POOLINGN ENSEMBL.PAN_TROGLODYTES_CORE_36_3 ensembldb.ensembl.org MYSQL Native pan_troglodytes_core_36_3 3306 anonymous Encrypted EXTRA_OPTION_MYSQL.defaultFetchSize500 EXTRA_OPTION_MYSQL.useCursorFetchtrue FORCE_IDENTIFIERS_TO_LOWERCASEN FORCE_IDENTIFIERS_TO_UPPERCASEN IS_CLUSTEREDN PORT_NUMBER3306 QUOTE_ALL_FIELDSN STREAM_RESULTSY SUPPORTS_BOOLEAN_DATA_TYPEN USE_POOLINGN LOGGING ${LOGGING_HOSTNAME} MYSQL Native ${LOGGING_DATABASE} ${LOGGING_PORT} ${LOGGING_USERNAME} ${LOGGING_PASSWORD} FORCE_IDENTIFIERS_TO_LOWERCASEN FORCE_IDENTIFIERS_TO_UPPERCASEN IS_CLUSTEREDN PORT_NUMBER${LOGGING_PORT} QUOTE_ALL_FIELDSN STREAM_RESULTSY USE_POOLINGN Table CompareComparison StatisticsY Table CompareComparison Error DetailsY Tables to compareAdd constantsY Add constantsTable CompareY Add constants Constant Y 1 none ROW_WHERE_CLAUSE String -1 -1 REFERENCE_VALUE String -1 -1 COMPARE_VALUE String -1 -1

222 195 Y Comparison Statistics Dummy Y 1 none

499 148 Y Comparison Error Details Dummy Y 1 none

501 243 Y Table Compare TableCompare N 1 none ENSEMBL.HOMO_SAPIENS_CORE_24_34_E REFERENCE_SCHEMA_FIELD REFERENCE_TABLE_FIELD ENSEMBL.PAN_TROGLODYTES_CORE_36_3 COMPARE_SCHEMA_FIELD COMPARE_TABLE_FIELD KEY_FIELDS_FIELD EXCLUDE_FIELDS_FIELD nrErrors nrRecordsReferenceTable nrRecordsCompareTable nrErrorsLeftJoin nrErrorsInnerJoin nrErrorsRightJoin ROW_WHERE_CLAUSE REFERENCE_VALUE COMPARE_VALUE

354 194 Y Tables to compare DataGrid Y 1 none REFERENCE_SCHEMA_FIELD String 100 -1 REFERENCE_TABLE_FIELD String 100 -1 COMPARE_SCHEMA_FIELD String 100 -1 COMPARE_TABLE_FIELD String 100 -1 KEY_FIELDS_FIELD String 2000 -1 EXCLUDE_FIELDS_FIELD String 2000 -1 analysisanalysisanalysis_id attrib_typeattrib_typeattrib_type_id

102 195 Y Table Compare Comparison Error Details Y ${KFF_ERROR_COUNT_FIELD} ${KFF_ERROR_DESCRIPTIONS_FIELD} ${KFF_ERROR_FIELDS_FIELD} ${KFF_ERROR_CODES_FIELD} -1 -1 -1 N