Comparing more than 50 columns in PostgreSQL throws a PG error #397
Description
Describe the bug
We are comparing a table in Oracle and Postgres.
That table has more than 100 columns, and when we included all the needed columns in the columns key of our toml file, we got an execution error saying:
[09:36:47] ERROR - cannot pass more than 100 arguments to a function
LINE 1: SELECT count(*), sum(('x' || substring(md5(concat(coalesce(c...
- The command or code you used
data-diff -k artefactkey --conf c3_validation.toml --run pctxevnt --json -w "PROCESSING_SEQ = '100'"
- The toml file
[database.pg]
driver = "postgresql"
host = "xx"
database = "xx"
user = "xx"
password = "xx"
[database.oracle]
driver = "oracle"
host = "xx"
database = "xx"
user = "xx"
password = "xx"
[run.default]
verbose=true
debug=true
limit=10
[run.pctxevnt]
columns=['SOURCE_ARTEFACT_SEQ', 'START_PERIOD_DT', 'ARTEFACT_SEQ', 'ARTEFACT_TYPE_SEQ', 'ARTEFACT_GROUP_SEQ', 'ARTEFACT_CTX_SEQ', 'ARTEFACTKEY', 'MATURITY', 'GN1', 'GN2', 'GN3', 'GN4', 'GN5', 'GN6', 'GN7', 'GN8', 'GN9', 'GN10', 'GN11', 'GN12', 'GN13', 'GN14', 'GN15', 'GN16', 'GN17', 'GN18', 'GN19', 'GN20', 'GN21', 'GN22', 'GN23', 'GN24', 'GN25', 'GN26', 'GN27', 'GN28', 'GN29', 'GN30'
, 'GA1', 'GA2', 'GA3', 'GA4', 'GA5', 'GA6', 'GA7', 'GA8', 'GA9', 'GA10', 'GA11', 'GA12', 'GA13', 'GA14', 'GA15', 'GA16', 'GA17', 'GA18', 'GA19', 'GA20', 'GA21', 'GA22', 'GA23' ]
1.database="oracle"
1.table="PCTX_EVENT"
2.database="pg"
2.table="pctx_event"
- The run output + error you're getting. (including tracestack)
[09:42:19] DEBUG - Applied run configuration: {'debug': True, 'limit': 10, 'columns': ['SOURCE_ARTEFACT_SEQ', 'START_PERIOD_DT', 'ARTEFACT_SEQ', 'ARTEFACT_TYPE_SEQ', 'ARTEFACT_GROUP_SEQ', 'ARTEFACT_CTX_SEQ', 'ARTEFACTKEY', 'MATURITY', 'GN1', 'GN2', 'GN3', 'GN4', 'GN5', 'GN6', 'GN7', 'GN8', 'GN9', 'GN10', 'GN11', 'GN12', 'GN13', 'GN14', 'GN15', 'GN16', 'GN17', 'GN18', 'GN19', 'GN20', 'GN21', 'GN22', 'GN23', 'GN24', 'GN25', 'GN26', 'GN27', 'GN28', 'GN29', 'GN30', 'GA1', 'GA2', 'GA3', 'GA4', 'GA5', 'GA6', 'GA7', 'GA8', 'GA9', 'GA10', 'GA11', 'GA12', 'GA13', 'GA14', 'GA15', 'GA16', 'GA17', 'GA18', 'GA19', 'GA20', 'GA21', 'GA22', 'GA23'], 'database1': {'driver': 'oracle', 'host': '', 'database': '', 'user': '', 'password': ''}, 'table1': 'PCTX_EVENT', 'database2': {'driver': 'postgresql', 'host': '', 'database': '', 'user': '', 'password': '*'}, 'table2': 'pctx_event'}
[09:42:19] INFO - [Oracle] Starting a threadpool, size=1.
[09:42:19] DEBUG - Running SQL (Oracle): ALTER SESSION SET TIME_ZONE = 'UTC'
[09:42:20] INFO - [PostgreSQL] Starting a threadpool, size=1.
[09:42:20] DEBUG - Running SQL (PostgreSQL): SET TIME ZONE 'UTC'
[09:42:20] DEBUG - Running SQL (Oracle): SELECT column_name, data_type, 6 as datetime_precision, data_precision as numeric_precision, data_scale as numeric_scale FROM ALL_TAB_COLUMNS WHERE table_name = 'PCTX_EVENT' AND owner = ''
[09:42:20] DEBUG - Running SQL (PostgreSQL): SELECT column_name, data_type, datetime_precision, numeric_precision, numeric_scale FROM information_schema.columns WHERE table_name = 'pctx_event' AND table_schema = ''
[09:42:21] DEBUG - [Oracle] Schema = {'GA41': ('GA41', 'VARCHAR2', 6, None, None), 'GA42': ('GA42', 'VARCHAR2', 6, None, None), 'GA43': ('GA43', 'VARCHAR2', 6, None, None), 'GA44': ('GA44', 'VARCHAR2', 6, None, None), 'GA45': ('GA45', 'VARCHAR2', 6, None, None), 'GA46': ('GA46', 'VARCHAR2', 6, None, None), 'GA47': ('GA47', 'VARCHAR2', 6, None, None), 'GA48': ('GA48', 'VARCHAR2', 6, None, None), 'GA49': ('GA49', 'VARCHAR2', 6, None, None), 'GA50': ('GA50', 'VARCHAR2', 6, None, None), 'GA51': ('GA51', 'VARCHAR2', 6, None, None), 'GA52': ('GA52', 'VARCHAR2', 6, None, None), 'GA53': ('GA53', 'VARCHAR2', 6, None, None), 'GA54': ('GA54', 'VARCHAR2', 6, None, None), 'GA55': ('GA55', 'VARCHAR2', 6, None, None), 'GA56': ('GA56', 'VARCHAR2', 6, None, None), 'GA57': ('GA57', 'VARCHAR2', 6, None, None), 'GA58': ('GA58', 'VARCHAR2', 6, None, None), 'GA59': ('GA59', 'VARCHAR2', 6, None, None), 'GA60': ('GA60', 'VARCHAR2', 6, None, None), 'GA61': ('GA61', 'VARCHAR2', 6, None, None), 'GA62': ('GA62', 'VARCHAR2', 6, None, None), 'GA63': ('GA63', 'VARCHAR2', 6, None, None), 'GA64': ('GA64', 'VARCHAR2', 6, None, None), 'GA65': ('GA65', 'VARCHAR2', 6, None, None), 'GA66': ('GA66', 'VARCHAR2', 6, None, None), 'GA67': ('GA67', 'VARCHAR2', 6, None, None), 'GA68': ('GA68', 'VARCHAR2', 6, None, None), 'GA69': ('GA69', 'VARCHAR2', 6, None, None), 'GA70': ('GA70', 'VARCHAR2', 6, None, None), 'GA71': ('GA71', 'VARCHAR2', 6, None, None), 'GA72': ('GA72', 'VARCHAR2', 6, None, None), 'GA73': ('GA73', 'VARCHAR2', 6, None, None), 'GA74': ('GA74', 'VARCHAR2', 6, None, None), 'GA75': ('GA75', 'VARCHAR2', 6, None, None), 'GA76': ('GA76', 'VARCHAR2', 6, None, None), 'GA77': ('GA77', 'VARCHAR2', 6, None, None), 'GA78': ('GA78', 'VARCHAR2', 6, None, None), 'GA79': ('GA79', 'VARCHAR2', 6, None, None), 'GA80': ('GA80', 'VARCHAR2', 6, None, None), 'GA81': ('GA81', 'VARCHAR2', 6, None, None), 'GA82': ('GA82', 'VARCHAR2', 6, None, None), 'GA83': ('GA83', 'VARCHAR2', 6, None, None), 'GA84': ('GA84', 'VARCHAR2', 6, None, None), 'GA85': ('GA85', 'VARCHAR2', 6, None, None), 'GA86': ('GA86', 'VARCHAR2', 6, None, None), 'GA87': ('GA87', 'VARCHAR2', 6, None, None), 'GA88': ('GA88', 'VARCHAR2', 6, None, None), 'GA89': ('GA89', 'VARCHAR2', 6, None, None), 'GA90': ('GA90', 'VARCHAR2', 6, None, None), 'GA91': ('GA91', 'VARCHAR2', 6, None, None), 'GA92': ('GA92', 'VARCHAR2', 6, None, None), 'GA93': ('GA93', 'VARCHAR2', 6, None, None), 'GA94': ('GA94', 'VARCHAR2', 6, None, None), 'GA95': ('GA95', 'VARCHAR2', 6, None, None), 'GA96': ('GA96', 'VARCHAR2', 6, None, None), 'GA97': ('GA97', 'VARCHAR2', 6, None, None), 'GA98': ('GA98', 'VARCHAR2', 6, None, None), 'GA99': ('GA99', 'VARCHAR2', 6, None, None), 'GA100': ('GA100', 'VARCHAR2', 6, None, None), 'GD1': ('GD1', 'DATE', 6, None, None), 'GD2': ('GD2', 'DATE', 6, None, None), 'GD3': ('GD3', 'DATE', 6, None, None), 'GD4': ('GD4', 'DATE', 6, None, None), 'GD5': ('GD5', 'DATE', 6, None, None), 'GD6': ('GD6', 'DATE', 6, None, None), 'GD7': ('GD7', 'DATE', 6, None, None), 'GD8': ('GD8', 'DATE', 6, None, None), 'GD9': ('GD9', 'DATE', 6, None, None), 'GD10': ('GD10', 'DATE', 6, None, None), 'GD11': ('GD11', 'DATE', 6, None, None), 'GD12': ('GD12', 'DATE', 6, None, None), 'GD13': ('GD13', 'DATE', 6, None, None), 'GD14': ('GD14', 'DATE', 6, None, None), 'GD15': ('GD15', 'DATE', 6, None, None), 'GD16': ('GD16', 'DATE', 6, None, None), 'GD17': ('GD17', 'DATE', 6, None, None), 'GD18': ('GD18', 'DATE', 6, None, None), 'GD19': ('GD19', 'DATE', 6, None, None), 'GD20': ('GD20', 'DATE', 6, None, None), 'GB1': ('GB1', 'NUMBER', 6, 1, 0), 'GB2': ('GB2', 'NUMBER', 6, 1, 0), 'GB3': ('GB3', 'NUMBER', 6, 1, 0), 'GB4': ('GB4', 'NUMBER', 6, 1, 0), 'GB5': ('GB5', 'NUMBER', 6, 1, 0), 'GB6': ('GB6', 'NUMBER', 6, 1, 0), 'GB7': ('GB7', 'NUMBER', 6, 1, 0), 'GB8': ('GB8', 'NUMBER', 6, 1, 0), 'GB9': ('GB9', 'NUMBER', 6, 1, 0), 'GB10': ('GB10', 'NUMBER', 6, 1, 0), 'GB11': ('GB11', 'NUMBER', 6, 1, 0), 'GB12': ('GB12', 'NUMBER', 6, 1, 0), 'GB13': ('GB13', 'NUMBER', 6, 1, 0), 'GB14': ('GB14', 'NUMBER', 6, 1, 0), 'GB15': ('GB15', 'NUMBER', 6, 1, 0), 'GB16': ('GB16', 'NUMBER', 6, 1, 0), 'GB17': ('GB17', 'NUMBER', 6, 1, 0), 'GB18': ('GB18', 'NUMBER', 6, 1, 0), 'GB19': ('GB19', 'NUMBER', 6, 1, 0), 'GB20': ('GB20', 'NUMBER', 6, 1, 0), 'STAGERECORD_SEQ': ('STAGERECORD_SEQ', 'NUMBER', 6, None, None), 'SOURCE_ARTEFACT_SEQ': ('SOURCE_ARTEFACT_SEQ', 'VARCHAR2', 6, None, None), 'RUN_SEQ': ('RUN_SEQ', 'VARCHAR2', 6, None, None), 'ARTEFACT_SEQ': ('ARTEFACT_SEQ', 'VARCHAR2', 6, None, None), 'ARTEFACT_TYPE_SEQ': ('ARTEFACT_TYPE_SEQ', 'VARCHAR2', 6, None, None), 'ARTEFACT_GROUP_SEQ': ('ARTEFACT_GROUP_SEQ', 'VARCHAR2', 6, None, None), 'ARTEFACT_CTX_SEQ': ('ARTEFACT_CTX_SEQ', 'VARCHAR2', 6, None, None), 'PROCESSING_DATE': ('PROCESSING_DATE', 'DATE', 6, None, None), 'PROCESSING_SEQ': ('PROCESSING_SEQ', 'VARCHAR2', 6, None, None), 'PERIOD_SEQ': ('PERIOD_SEQ', 'VARCHAR2', 6, None, None), 'START_PERIOD_DT': ('START_PERIOD_DT', 'DATE', 6, None, None), 'END_PERIOD_DT': ('END_PERIOD_DT', 'DATE', 6, None, None), 'ARTEFACTKEY': ('ARTEFACTKEY', 'VARCHAR2', 6, None, None), 'EFFECTIVE_DATE': ('EFFECTIVE_DATE', 'DATE', 6, None, None), 'CREATION_DATE': ('CREATION_DATE', 'DATE', 6, None, None), 'MATURITY': ('MATURITY', 'NUMBER', 6, None, None), 'GN1': ('GN1', 'NUMBER', 6, 25, 10), 'GN2': ('GN2', 'NUMBER', 6, 25, 10), 'GN3': ('GN3', 'NUMBER', 6, 25, 10), 'GN4': ('GN4', 'NUMBER', 6, 25, 10), 'GN5': ('GN5', 'NUMBER', 6, 25, 10), 'GN6': ('GN6', 'NUMBER', 6, 25, 10), 'GN7': ('GN7', 'NUMBER', 6, 25, 10), 'GN8': ('GN8', 'NUMBER', 6, 25, 10), 'GN9': ('GN9', 'NUMBER', 6, 25, 10), 'GN10': ('GN10', 'NUMBER', 6, 25, 10), 'GN11': ('GN11', 'NUMBER', 6, 25, 10), 'GN12': ('GN12', 'NUMBER', 6, 25, 10), 'GN13': ('GN13', 'NUMBER', 6, 25, 10), 'GN14': ('GN14', 'NUMBER', 6, 25, 10), 'GN15': ('GN15', 'NUMBER', 6, 25, 10), 'GN16': ('GN16', 'NUMBER', 6, 25, 10), 'GN17': ('GN17', 'NUMBER', 6, 25, 10), 'GN18': ('GN18', 'NUMBER', 6, 25, 10), 'GN19': ('GN19', 'NUMBER', 6, 25, 10), 'GN20': ('GN20', 'NUMBER', 6, 25, 10), 'GN21': ('GN21', 'NUMBER', 6, 25, 10), 'GN22': ('GN22', 'NUMBER', 6, 25, 10), 'GN23': ('GN23', 'NUMBER', 6, 25, 10), 'GN24': ('GN24', 'NUMBER', 6, 25, 10), 'GN25': ('GN25', 'NUMBER', 6, 25, 10), 'GN26': ('GN26', 'NUMBER', 6, 25, 10), 'GN27': ('GN27', 'NUMBER', 6, 25, 10), 'GN28': ('GN28', 'NUMBER', 6, 25, 10), 'GN29': ('GN29', 'NUMBER', 6, 25, 10), 'GN30': ('GN30', 'NUMBER', 6, 25, 10), 'GA1': ('GA1', 'VARCHAR2', 6, None, None), 'GA2': ('GA2', 'VARCHAR2', 6, None, None), 'GA3': ('GA3', 'VARCHAR2', 6, None, None), 'GA4': ('GA4', 'VARCHAR2', 6, None, None), 'GA5': ('GA5', 'VARCHAR2', 6, None, None), 'GA6': ('GA6', 'VARCHAR2', 6, None, None), 'GA7': ('GA7', 'VARCHAR2', 6, None, None), 'GA8': ('GA8', 'VARCHAR2', 6, None, None), 'GA9': ('GA9', 'VARCHAR2', 6, None, None), 'GA10': ('GA10', 'VARCHAR2', 6, None, None), 'GA11': ('GA11', 'VARCHAR2', 6, None, None), 'GA12': ('GA12', 'VARCHAR2', 6, None, None), 'GA13': ('GA13', 'VARCHAR2', 6, None, None), 'GA14': ('GA14', 'VARCHAR2', 6, None, None), 'GA15': ('GA15', 'VARCHAR2', 6, None, None), 'GA16': ('GA16', 'VARCHAR2', 6, None, None), 'GA17': ('GA17', 'VARCHAR2', 6, None, None), 'GA18': ('GA18', 'VARCHAR2', 6, None, None), 'GA19': ('GA19', 'VARCHAR2', 6, None, None), 'GA20': ('GA20', 'VARCHAR2', 6, None, None), 'GA21': ('GA21', 'VARCHAR2', 6, None, None), 'GA22': ('GA22', 'VARCHAR2', 6, None, None), 'GA23': ('GA23', 'VARCHAR2', 6, None, None), 'GA24': ('GA24', 'VARCHAR2', 6, None, None), 'GA25': ('GA25', 'VARCHAR2', 6, None, None), 'GA26': ('GA26', 'VARCHAR2', 6, None, None), 'GA27': ('GA27', 'VARCHAR2', 6, None, None), 'GA28': ('GA28', 'VARCHAR2', 6, None, None), 'GA29': ('GA29', 'VARCHAR2', 6, None, None), 'GA30': ('GA30', 'VARCHAR2', 6, None, None), 'GA31': ('GA31', 'VARCHAR2', 6, None, None), 'GA32': ('GA32', 'VARCHAR2', 6, None, None), 'GA33': ('GA33', 'VARCHAR2', 6, None, None), 'GA34': ('GA34', 'VARCHAR2', 6, None, None), 'GA35': ('GA35', 'VARCHAR2', 6, None, None), 'GA36': ('GA36', 'VARCHAR2', 6, None, None), 'GA37': ('GA37', 'VARCHAR2', 6, None, None), 'GA38': ('GA38', 'VARCHAR2', 6, None, None), 'GA39': ('GA39', 'VARCHAR2', 6, None, None), 'GA40': ('GA40', 'VARCHAR2', 6, None, None), 'APPROVED_BY': ('APPROVED_BY', 'VARCHAR2', 6, None, None), 'APPROVED_STATUS': ('APPROVED_STATUS', 'VARCHAR2', 6, None, None), 'APPROVED_DATETIME': ('APPROVED_DATETIME', 'DATE', 6, None, None), 'PCTX_TRACE_SEQ': ('PCTX_TRACE_SEQ', 'CLOB', 6, None, None)}
[09:42:21] DEBUG - [PostgreSQL] Schema = {'stagerecord_seq': ('stagerecord_seq', 'numeric', None, 25, 0), 'source_artefact_seq': ('source_artefact_seq', 'character varying', None, None, None), 'run_seq': ('run_seq', 'character varying', None, None, None), 'artefact_seq': ('artefact_seq', 'character varying', None, None, None), 'artefact_type_seq': ('artefact_type_seq', 'character varying', None, None, None), 'artefact_group_seq': ('artefact_group_seq', 'character varying', None, None, None), 'artefact_ctx_seq': ('artefact_ctx_seq', 'character varying', None, None, None), 'processing_date': ('processing_date', 'timestamp without time zone', 0, None, None), 'processing_seq': ('processing_seq', 'character varying', None, None, None), 'period_seq': ('period_seq', 'character varying', None, None, None), 'start_period_dt': ('start_period_dt', 'timestamp without time zone', 0, None, None), 'end_period_dt': ('end_period_dt', 'timestamp without time zone', 0, None, None), 'artefactkey': ('artefactkey', 'character varying', None, None, None), 'effective_date': ('effective_date', 'timestamp without time zone', 0, None, None), 'creation_date': ('creation_date', 'timestamp without time zone', 0, None, None), 'maturity': ('maturity', 'numeric', None, 25, 0), 'gn1': ('gn1', 'numeric', None, 25, 10), 'gn2': ('gn2', 'numeric', None, 25, 10), 'gn3': ('gn3', 'numeric', None, 25, 10), 'gn4': ('gn4', 'numeric', None, 25, 10), 'gn5': ('gn5', 'numeric', None, 25, 10), 'gn6': ('gn6', 'numeric', None, 25, 10), 'gn7': ('gn7', 'numeric', None, 25, 10), 'gn8': ('gn8', 'numeric', None, 25, 10), 'gn9': ('gn9', 'numeric', None, 25, 10), 'gn10': ('gn10', 'numeric', None, 25, 10), 'gn11': ('gn11', 'numeric', None, 25, 10), 'gn12': ('gn12', 'numeric', None, 25, 10), 'gn13': ('gn13', 'numeric', None, 25, 10), 'gn14': ('gn14', 'numeric', None, 25, 10), 'gn15': ('gn15', 'numeric', None, 25, 10), 'gn16': ('gn16', 'numeric', None, 25, 10), 'gn17': ('gn17', 'numeric', None, 25, 10), 'gn18': ('gn18', 'numeric', None, 25, 10), 'gn19': ('gn19', 'numeric', None, 25, 10), 'gn20': ('gn20', 'numeric', None, 25, 10), 'gn21': ('gn21', 'numeric', None, 25, 10), 'gn22': ('gn22', 'numeric', None, 25, 10), 'gn23': ('gn23', 'numeric', None, 25, 10), 'gn24': ('gn24', 'numeric', None, 25, 10), 'gn25': ('gn25', 'numeric', None, 25, 10), 'gn26': ('gn26', 'numeric', None, 25, 10), 'gn27': ('gn27', 'numeric', None, 25, 10), 'gn28': ('gn28', 'numeric', None, 25, 10), 'gn29': ('gn29', 'numeric', None, 25, 10), 'gn30': ('gn30', 'numeric', None, 25, 10), 'ga1': ('ga1', 'character varying', None, None, None), 'ga2': ('ga2', 'character varying', None, None, None), 'ga3': ('ga3', 'character varying', None, None, None), 'ga4': ('ga4', 'character varying', None, None, None), 'ga5': ('ga5', 'character varying', None, None, None), 'ga6': ('ga6', 'character varying', None, None, None), 'ga7': ('ga7', 'character varying', None, None, None), 'ga8': ('ga8', 'character varying', None, None, None), 'ga9': ('ga9', 'character varying', None, None, None), 'ga10': ('ga10', 'character varying', None, None, None), 'ga11': ('ga11', 'character varying', None, None, None), 'ga12': ('ga12', 'character varying', None, None, None), 'ga13': ('ga13', 'character varying', None, None, None), 'ga14': ('ga14', 'character varying', None, None, None), 'ga15': ('ga15', 'character varying', None, None, None), 'ga16': ('ga16', 'character varying', None, None, None), 'ga17': ('ga17', 'character varying', None, None, None), 'ga18': ('ga18', 'character varying', None, None, None), 'ga19': ('ga19', 'character varying', None, None, None), 'ga20': ('ga20', 'character varying', None, None, None), 'ga21': ('ga21', 'character varying', None, None, None), 'ga22': ('ga22', 'character varying', None, None, None), 'ga23': ('ga23', 'character varying', None, None, None), 'ga24': ('ga24', 'character varying', None, None, None), 'ga25': ('ga25', 'character varying', None, None, None), 'ga26': ('ga26', 'character varying', None, None, None), 'ga27': ('ga27', 'character varying', None, None, None), 'ga28': ('ga28', 'character varying', None, None, None), 'ga29': ('ga29', 'character varying', None, None, None), 'ga30': ('ga30', 'character varying', None, None, None), 'ga31': ('ga31', 'character varying', None, None, None), 'ga32': ('ga32', 'character varying', None, None, None), 'ga33': ('ga33', 'character varying', None, None, None), 'ga34': ('ga34', 'character varying', None, None, None), 'ga35': ('ga35', 'character varying', None, None, None), 'ga36': ('ga36', 'character varying', None, None, None), 'ga37': ('ga37', 'character varying', None, None, None), 'ga38': ('ga38', 'character varying', None, None, None), 'ga39': ('ga39', 'character varying', None, None, None), 'ga40': ('ga40', 'character varying', None, None, None), 'ga41': ('ga41', 'character varying', None, None, None), 'ga42': ('ga42', 'character varying', None, None, None), 'ga43': ('ga43', 'character varying', None, None, None), 'ga44': ('ga44', 'character varying', None, None, None), 'ga45': ('ga45', 'character varying', None, None, None), 'ga46': ('ga46', 'character varying', None, None, None), 'ga47': ('ga47', 'character varying', None, None, None), 'ga48': ('ga48', 'character varying', None, None, None), 'ga49': ('ga49', 'character varying', None, None, None), 'ga50': ('ga50', 'character varying', None, None, None), 'ga51': ('ga51', 'character varying', None, None, None), 'ga52': ('ga52', 'character varying', None, None, None), 'ga53': ('ga53', 'character varying', None, None, None), 'ga54': ('ga54', 'character varying', None, None, None), 'ga55': ('ga55', 'character varying', None, None, None), 'ga56': ('ga56', 'character varying', None, None, None), 'ga57': ('ga57', 'character varying', None, None, None), 'ga58': ('ga58', 'character varying', None, None, None), 'ga59': ('ga59', 'character varying', None, None, None), 'ga60': ('ga60', 'character varying', None, None, None), 'ga61': ('ga61', 'character varying', None, None, None), 'ga62': ('ga62', 'character varying', None, None, None), 'ga63': ('ga63', 'character varying', None, None, None), 'ga64': ('ga64', 'character varying', None, None, None), 'ga65': ('ga65', 'character varying', None, None, None), 'ga66': ('ga66', 'character varying', None, None, None), 'ga67': ('ga67', 'character varying', None, None, None), 'ga68': ('ga68', 'character varying', None, None, None), 'ga69': ('ga69', 'character varying', None, None, None), 'ga70': ('ga70', 'character varying', None, None, None), 'ga71': ('ga71', 'character varying', None, None, None), 'ga72': ('ga72', 'character varying', None, None, None), 'ga73': ('ga73', 'character varying', None, None, None), 'ga74': ('ga74', 'character varying', None, None, None), 'ga75': ('ga75', 'character varying', None, None, None), 'ga76': ('ga76', 'character varying', None, None, None), 'ga77': ('ga77', 'character varying', None, None, None), 'ga78': ('ga78', 'character varying', None, None, None), 'ga79': ('ga79', 'character varying', None, None, None), 'ga80': ('ga80', 'character varying', None, None, None), 'ga81': ('ga81', 'character varying', None, None, None), 'ga82': ('ga82', 'character varying', None, None, None), 'ga83': ('ga83', 'character varying', None, None, None), 'ga84': ('ga84', 'character varying', None, None, None), 'ga85': ('ga85', 'character varying', None, None, None), 'ga86': ('ga86', 'character varying', None, None, None), 'ga87': ('ga87', 'character varying', None, None, None), 'ga88': ('ga88', 'character varying', None, None, None), 'ga89': ('ga89', 'character varying', None, None, None), 'ga90': ('ga90', 'character varying', None, None, None), 'ga91': ('ga91', 'character varying', None, None, None), 'ga92': ('ga92', 'character varying', None, None, None), 'ga93': ('ga93', 'character varying', None, None, None), 'ga94': ('ga94', 'character varying', None, None, None), 'ga95': ('ga95', 'character varying', None, None, None), 'ga96': ('ga96', 'character varying', None, None, None), 'ga97': ('ga97', 'character varying', None, None, None), 'ga98': ('ga98', 'character varying', None, None, None), 'ga99': ('ga99', 'character varying', None, None, None), 'ga100': ('ga100', 'character varying', None, None, None), 'gd1': ('gd1', 'timestamp without time zone', 0, None, None), 'gd2': ('gd2', 'timestamp without time zone', 0, None, None), 'gd3': ('gd3', 'timestamp without time zone', 0, None, None), 'gd4': ('gd4', 'timestamp without time zone', 0, None, None), 'gd5': ('gd5', 'timestamp without time zone', 0, None, None), 'gd6': ('gd6', 'timestamp without time zone', 0, None, None), 'gd7': ('gd7', 'timestamp without time zone', 0, None, None), 'gd8': ('gd8', 'timestamp without time zone', 0, None, None), 'gd9': ('gd9', 'timestamp without time zone', 0, None, None), 'gd10': ('gd10', 'timestamp without time zone', 0, None, None), 'gd11': ('gd11', 'timestamp without time zone', 0, None, None), 'gd12': ('gd12', 'timestamp without time zone', 0, None, None), 'gd13': ('gd13', 'timestamp without time zone', 0, None, None), 'gd14': ('gd14', 'timestamp without time zone', 0, None, None), 'gd15': ('gd15', 'timestamp without time zone', 0, None, None), 'gd16': ('gd16', 'timestamp without time zone', 0, None, None), 'gd17': ('gd17', 'timestamp without time zone', 0, None, None), 'gd18': ('gd18', 'timestamp without time zone', 0, None, None), 'gd19': ('gd19', 'timestamp without time zone', 0, None, None), 'gd20': ('gd20', 'timestamp without time zone', 0, None, None), 'gb1': ('gb1', 'numeric', None, 1, 0), 'gb2': ('gb2', 'numeric', None, 1, 0), 'gb3': ('gb3', 'numeric', None, 1, 0), 'gb4': ('gb4', 'numeric', None, 1, 0), 'gb5': ('gb5', 'numeric', None, 1, 0), 'gb6': ('gb6', 'numeric', None, 1, 0), 'gb7': ('gb7', 'numeric', None, 1, 0), 'gb8': ('gb8', 'numeric', None, 1, 0), 'gb9': ('gb9', 'numeric', None, 1, 0), 'gb10': ('gb10', 'numeric', None, 1, 0), 'gb11': ('gb11', 'numeric', None, 1, 0), 'gb12': ('gb12', 'numeric', None, 1, 0), 'gb13': ('gb13', 'numeric', None, 1, 0), 'gb14': ('gb14', 'numeric', None, 1, 0), 'gb15': ('gb15', 'numeric', None, 1, 0), 'gb16': ('gb16', 'numeric', None, 1, 0), 'gb17': ('gb17', 'numeric', None, 1, 0), 'gb18': ('gb18', 'numeric', None, 1, 0), 'gb19': ('gb19', 'numeric', None, 1, 0), 'gb20': ('gb20', 'numeric', None, 1, 0), 'approved_by': ('approved_by', 'character varying', None, None, None), 'approved_status': ('approved_status', 'character varying', None, None, None), 'approved_datetime': ('approved_datetime', 'timestamp without time zone', 0, None, None), 'pctx_trace_seq': ('pctx_trace_seq', 'text', None, None, None)}
[09:42:21] DEBUG - Available mutual columns: {'ga3', 'gb11', 'ga92', 'start_period_dt', 'ga8', 'gn8', 'ga21', 'ga39', 'ga89', 'end_period_dt', 'ga6', 'ga20', 'gb8', 'maturity', 'ga50', 'gd16', 'ga31', 'ga68', 'gn29', 'ga86', 'artefact_seq', 'ga98', 'gd6', 'ga22', 'gb7', 'gd12', 'ga27', 'ga73', 'ga10', 'gd15', 'ga55', 'gb1', 'gn15', 'gb20', 'approved_datetime', 'ga79', 'ga82', 'gn9', 'ga97', 'gb19', 'ga58', 'ga35', 'ga11', 'ga37', 'gn18', 'ga44', 'gn19', 'ga41', 'ga23', 'ga76', 'ga70', 'ga47', 'ga80', 'ga94', 'ga85', 'gn10', 'gn30', 'ga83', 'gb5', 'ga66', 'gb14', 'ga77', 'gn5', 'ga40', 'ga51', 'ga93', 'gd17', 'gn27', 'ga91', 'gn12', 'gb18', 'gn28', 'approved_status', 'ga36', 'pctx_trace_seq', 'ga9', 'ga30', 'gn21', 'ga17', 'gb4', 'ga16', 'ga12', 'effective_date', 'ga61', 'ga64', 'gd4', 'gd5', 'gb17', 'processing_date', 'artefactkey', 'gd11', 'run_seq', 'ga28', 'ga99', 'artefact_ctx_seq', 'gd3', 'ga24', 'gn2', 'ga71', 'gn7', 'ga87', 'gb15', 'ga63', 'ga57', 'gn16', 'gn14', 'gd7', 'gn6', 'ga14', 'ga43', 'ga34', 'ga60', 'gd10', 'gd18', 'gd2', 'ga69', 'gb2', 'ga59', 'ga13', 'gn25', 'ga100', 'gb3', 'ga26', 'ga25', 'ga29', 'ga95', 'stagerecord_seq', 'period_seq', 'ga15', 'gd9', 'ga7', 'ga96', 'gn23', 'ga53', 'ga75', 'ga48', 'gn26', 'gn13', 'ga90', 'gd20', 'ga38', 'ga42', 'ga45', 'ga67', 'ga78', 'ga65', 'ga52', 'ga72', 'gn20', 'ga33', 'processing_seq', 'gb16', 'ga54', 'ga2', 'gn1', 'ga32', 'ga46', 'ga49', 'artefact_group_seq', 'gd8', 'gn22', 'gn11', 'gd19', 'ga19', 'creation_date', 'gn24', 'gd1', 'ga74', 'gn4', 'ga5', 'ga18', 'ga88', 'ga84', 'ga1', 'gn17', 'artefact_type_seq', 'ga81', 'ga4', 'ga56', 'gd13', 'approved_by', 'ga62', 'gn3', 'gb9', 'source_artefact_seq', 'gb10', 'gd14', 'gb12', 'gb6', 'gb13'}
[09:42:21] INFO - Diffing using columns: key=('artefactkey',) update=None extra=('gn14', 'ga3', 'gn10', 'start_period_dt', 'gn30', 'ga8', 'gn8', 'gn6', 'ga14', 'ga21', 'ga6', 'ga20', 'gn5', 'maturity', 'gn27', 'gn20', 'gn12', 'gn28', 'ga2', 'gn29', 'gn1', 'gn21', 'ga9', 'artefact_seq', 'ga17', 'ga13', 'gn25', 'artefact_group_seq', 'ga16', 'ga12', 'gn22', 'gn11', 'ga19', 'ga22', 'gn24', 'gn4', 'ga5', 'ga10', 'ga18', 'ga1', 'gn17', 'artefact_type_seq', 'gn15', 'artefact_ctx_seq', 'ga15', 'gn9', 'ga4', 'gn2', 'ga11', 'gn3', 'gn18', 'ga7', 'gn7', 'source_artefact_seq', 'gn19', 'gn23', 'gn26', 'ga23', 'gn13', 'gn16').
[09:42:21] INFO - Using algorithm 'hashdiff'.
[09:42:21] DEBUG - Running SQL (Oracle): SELECT CAST(TRIM("SOURCE_ARTEFACT_SEQ") AS VARCHAR(36)), CAST(TRIM("ARTEFACT_SEQ") AS VARCHAR(36)), CAST(TRIM("ARTEFACT_TYPE_SEQ") AS VARCHAR(36)), CAST(TRIM("ARTEFACT_GROUP_SEQ") AS VARCHAR(36)), CAST(TRIM("ARTEFACT_CTX_SEQ") AS VARCHAR(36)), CAST(TRIM("ARTEFACTKEY") AS VARCHAR(36)), CAST(TRIM("GA1") AS VARCHAR(36)), CAST(TRIM("GA2") AS VARCHAR(36)), CAST(TRIM("GA3") AS VARCHAR(36)), CAST(TRIM("GA4") AS VARCHAR(36)), CAST(TRIM("GA5") AS VARCHAR(36)), CAST(TRIM("GA6") AS VARCHAR(36)), CAST(TRIM("GA7") AS VARCHAR(36)), CAST(TRIM("GA8") AS VARCHAR(36)), CAST(TRIM("GA9") AS VARCHAR(36)), CAST(TRIM("GA10") AS VARCHAR(36)), CAST(TRIM("GA11") AS VARCHAR(36)), CAST(TRIM("GA12") AS VARCHAR(36)), CAST(TRIM("GA13") AS VARCHAR(36)), CAST(TRIM("GA14") AS VARCHAR(36)), CAST(TRIM("GA15") AS VARCHAR(36)), CAST(TRIM("GA16") AS VARCHAR(36)), CAST(TRIM("GA17") AS VARCHAR(36)), CAST(TRIM("GA18") AS VARCHAR(36)), CAST(TRIM("GA19") AS VARCHAR(36)), CAST(TRIM("GA20") AS VARCHAR(36)), CAST(TRIM("GA21") AS VARCHAR(36)), CAST(TRIM("GA22") AS VARCHAR(36)), CAST(TRIM("GA23") AS VARCHAR(36)) FROM "PCTX_EVENT" WHERE (PROCESSING_SEQ = '100') FETCH NEXT 64 ROWS ONLY
[09:42:21] DEBUG - Mixed Alphanum/Non-Alphanum values detected in column PCTX_EVENT.GA5. It cannot be used as a key.
[09:42:21] DEBUG - Mixed Alphanum/Non-Alphanum values detected in column PCTX_EVENT.GA17. It cannot be used as a key.
[09:42:21] DEBUG - Mixed Alphanum/Non-Alphanum values detected in column PCTX_EVENT.GA20. It cannot be used as a key.
[09:42:21] DEBUG - [Oracle] Schema = {'SOURCE_ARTEFACT_SEQ': String_VaryingAlphanum(), 'ARTEFACT_SEQ': String_VaryingAlphanum(), 'ARTEFACT_TYPE_SEQ': String_VaryingAlphanum(), 'ARTEFACT_GROUP_SEQ': String_VaryingAlphanum(), 'ARTEFACT_CTX_SEQ': String_VaryingAlphanum(), 'START_PERIOD_DT': UnknownColType(text='DATE'), 'ARTEFACTKEY': String_VaryingAlphanum(), 'MATURITY': Decimal(precision=0), 'GN1': Decimal(precision=10), 'GN2': Decimal(precision=10), 'GN3': Decimal(precision=10), 'GN4': Decimal(precision=10), 'GN5': Decimal(precision=10), 'GN6': Decimal(precision=10), 'GN7': Decimal(precision=10), 'GN8': Decimal(precision=10), 'GN9': Decimal(precision=10), 'GN10': Decimal(precision=10), 'GN11': Decimal(precision=10), 'GN12': Decimal(precision=10), 'GN13': Decimal(precision=10), 'GN14': Decimal(precision=10), 'GN15': Decimal(precision=10), 'GN16': Decimal(precision=10), 'GN17': Decimal(precision=10), 'GN18': Decimal(precision=10), 'GN19': Decimal(precision=10), 'GN20': Decimal(precision=10), 'GN21': Decimal(precision=10), 'GN22': Decimal(precision=10), 'GN23': Decimal(precision=10), 'GN24': Decimal(precision=10), 'GN25': Decimal(precision=10), 'GN26': Decimal(precision=10), 'GN27': Decimal(precision=10), 'GN28': Decimal(precision=10), 'GN29': Decimal(precision=10), 'GN30': Decimal(precision=10), 'GA1': Text(), 'GA2': String_VaryingAlphanum(), 'GA3': String_VaryingAlphanum(), 'GA4': String_VaryingAlphanum(), 'GA5': Text(), 'GA6': Text(), 'GA7': Text(), 'GA8': Text(), 'GA9': String_VaryingAlphanum(), 'GA10': String_VaryingAlphanum(), 'GA11': Text(), 'GA12': Text(), 'GA13': String_VaryingAlphanum(), 'GA14': Text(), 'GA15': Text(), 'GA16': String_VaryingAlphanum(), 'GA17': Text(), 'GA18': String_VaryingAlphanum(), 'GA19': String_VaryingAlphanum(), 'GA20': Text(), 'GA21': Text(), 'GA22': String_VaryingAlphanum(), 'GA23': Text()}
[09:42:21] DEBUG - Running SQL (PostgreSQL): SELECT TRIM("source_artefact_seq"), TRIM("artefact_seq"), TRIM("artefact_type_seq"), TRIM("artefact_group_seq"), TRIM("artefact_ctx_seq"), TRIM("artefactkey"), TRIM("ga1"), TRIM("ga2"), TRIM("ga3"), TRIM("ga4"), TRIM("ga5"), TRIM("ga6"), TRIM("ga7"), TRIM("ga8"), TRIM("ga9"), TRIM("ga10"), TRIM("ga11"), TRIM("ga12"), TRIM("ga13"), TRIM("ga14"), TRIM("ga15"), TRIM("ga16"), TRIM("ga17"), TRIM("ga18"), TRIM("ga19"), TRIM("ga20"), TRIM("ga21"), TRIM("ga22"), TRIM("ga23") FROM "pctx_event" WHERE (PROCESSING_SEQ = '100') LIMIT 64
[09:42:21] DEBUG - Mixed Alphanum/Non-Alphanum values detected in column pctx_event.ga20. It cannot be used as a key.
[09:42:21] DEBUG - [PostgreSQL] Schema = {'source_artefact_seq': String_VaryingAlphanum(), 'artefact_seq': String_VaryingAlphanum(), 'artefact_type_seq': String_VaryingAlphanum(), 'artefact_group_seq': String_VaryingAlphanum(), 'artefact_ctx_seq': String_VaryingAlphanum(), 'start_period_dt': Timestamp(precision=0, rounds=True), 'artefactkey': String_VaryingAlphanum(), 'maturity': Decimal(precision=0), 'gn1': Decimal(precision=10), 'gn2': Decimal(precision=10), 'gn3': Decimal(precision=10), 'gn4': Decimal(precision=10), 'gn5': Decimal(precision=10), 'gn6': Decimal(precision=10), 'gn7': Decimal(precision=10), 'gn8': Decimal(precision=10), 'gn9': Decimal(precision=10), 'gn10': Decimal(precision=10), 'gn11': Decimal(precision=10), 'gn12': Decimal(precision=10), 'gn13': Decimal(precision=10), 'gn14': Decimal(precision=10), 'gn15': Decimal(precision=10), 'gn16': Decimal(precision=10), 'gn17': Decimal(precision=10), 'gn18': Decimal(precision=10), 'gn19': Decimal(precision=10), 'gn20': Decimal(precision=10), 'gn21': Decimal(precision=10), 'gn22': Decimal(precision=10), 'gn23': Decimal(precision=10), 'gn24': Decimal(precision=10), 'gn25': Decimal(precision=10), 'gn26': Decimal(precision=10), 'gn27': Decimal(precision=10), 'gn28': Decimal(precision=10), 'gn29': Decimal(precision=10), 'gn30': Decimal(precision=10), 'ga1': Text(), 'ga2': String_VaryingAlphanum(), 'ga3': String_VaryingAlphanum(), 'ga4': String_VaryingAlphanum(), 'ga5': Text(), 'ga6': Text(), 'ga7': Text(), 'ga8': Text(), 'ga9': String_VaryingAlphanum(), 'ga10': String_VaryingAlphanum(), 'ga11': Text(), 'ga12': Text(), 'ga13': String_VaryingAlphanum(), 'ga14': Text(), 'ga15': Text(), 'ga16': String_VaryingAlphanum(), 'ga17': String_VaryingAlphanum(), 'ga18': String_VaryingAlphanum(), 'ga19': String_VaryingAlphanum(), 'ga20': Text(), 'ga21': Text(), 'ga22': String_VaryingAlphanum(), 'ga23': Text()}
[09:42:21] DEBUG - Running SQL (Oracle): SELECT cast(min("ARTEFACTKEY") as varchar(1024)), cast(max("ARTEFACTKEY") as varchar(1024)) FROM "PCTX_EVENT" WHERE (PROCESSING_SEQ = '100')
[09:42:21] DEBUG - Running SQL (PostgreSQL): SELECT min("artefactkey")::varchar, max("artefactkey")::varchar FROM "pctx_event" WHERE (PROCESSING_SEQ = '100')
[09:42:21] INFO - Diffing segments at key-range: 1243457304AC20200701..RSPAPERBILL20200714. size: table1 <= 736274738506125847299084470481284782, table2 <= 736274738506125847299084470481284782
[09:42:21] INFO - . Diffing segment 1/32, key-range: 1243457304AC20200701..1siLaF_7Ky_xUOUOOiQZ, size <= 736274738506125847299084470481284782
[09:42:21] DEBUG - Running SQL (Oracle): SELECT count(), sum(to_number(substr(standard_hash((coalesce(cast(coalesce(cast("ARTEFACTKEY" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN14", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA3" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN10", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("START_PERIOD_DT" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN30", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA8" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN8", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN6", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA14" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA21" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA6" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA20" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN5", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("MATURITY", 'FM99999999999999999999999999999999999999'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN27", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN20", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN12", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN28", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA2" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN29", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN1", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN21", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA9" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("ARTEFACT_SEQ" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA17" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA13" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN25", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("ARTEFACT_GROUP_SEQ" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA16" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA12" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN22", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN11", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA19" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA22" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN24", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN4", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA5" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA10" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA18" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA1" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN17", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("ARTEFACT_TYPE_SEQ" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN15", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("ARTEFACT_CTX_SEQ" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA15" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN9", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA4" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN2", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA11" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN3", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN18", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA7" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN7", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("SOURCE_ARTEFACT_SEQ" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN19", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN23", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN26", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA23" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN13", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN16", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '')), 'MD5'), 18), 'xxxxxxxxxxxxxxx')) FROM "PCTX_EVENT" WHERE ("ARTEFACTKEY" >= '1243457304AC20200701') AND ("ARTEFACTKEY" < '1siLaF_7Ky_xUOUOOiQZ') AND (PROCESSING_SEQ = '100')
[09:42:21] DEBUG - Running SQL (PostgreSQL): SELECT count(), sum(('x' || substring(md5(concat(coalesce(coalesce("artefactkey"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn14"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga3"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn10"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce(to_char("start_period_dt"::timestamp(0), 'YYYY-mm-dd HH24:MI:SS.US'), '')::varchar, ''), '|', coalesce(coalesce("gn30"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga8"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn8"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn6"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga14"::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga21"::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga6"::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga20"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn5"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("maturity"::decimal(38, 0)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn27"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn20"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn12"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn28"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga2"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn29"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn1"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn21"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga9"::varchar, '')::varchar, ''), '|', coalesce(coalesce("artefact_seq"::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga17"::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga13"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn25"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("artefact_group_seq"::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga16"::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga12"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn22"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn11"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga19"::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga22"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn24"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn4"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga5"::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga10"::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga18"::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga1"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn17"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("artefact_type_seq"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn15"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("artefact_ctx_seq"::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga15"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn9"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga4"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn2"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga11"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn3"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn18"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga7"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn7"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("source_artefact_seq"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn19"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn23"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn26"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga23"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn13"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn16"::decimal(38, 10)::varchar, '')::varchar, ''))), 18))::bit(60)::bigint) FROM "pctx_event" WHERE ("artefactkey" >= '1243457304AC20200701') AND ("artefactkey" < '1siLaF_7Ky_xUOUOOiQZ') AND (PROCESSING_SEQ = '100')
[09:42:21] INFO - . Diffing segment 2/32, key-range: 1siLaF_7Ky_xUOUOOiQZ..2hLd5Q0Ber gvlvlmIq4, size <= 736274738506125847299084470481284782
[09:42:21] DEBUG - Running SQL (Oracle): SELECT count(), sum(to_number(substr(standard_hash((coalesce(cast(coalesce(cast("ARTEFACTKEY" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN14", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA3" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN10", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("START_PERIOD_DT" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN30", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA8" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN8", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN6", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA14" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA21" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA6" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA20" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN5", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("MATURITY", 'FM99999999999999999999999999999999999999'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN27", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN20", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN12", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN28", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA2" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN29", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN1", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN21", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA9" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("ARTEFACT_SEQ" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA17" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA13" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN25", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("ARTEFACT_GROUP_SEQ" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA16" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA12" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN22", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN11", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA19" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA22" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN24", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN4", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA5" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA10" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA18" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA1" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN17", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("ARTEFACT_TYPE_SEQ" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN15", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("ARTEFACT_CTX_SEQ" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA15" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN9", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA4" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN2", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA11" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN3", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN18", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA7" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN7", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("SOURCE_ARTEFACT_SEQ" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN19", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN23", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN26", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(cast("GA23" as varchar(1024)), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN13", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '') || '|' || coalesce(cast(coalesce(to_char("GN16", 'FM99999999999999999999999999990.9999999990'), '') as varchar(1024)), '')), 'MD5'), 18), 'xxxxxxxxxxxxxxx')) FROM "PCTX_EVENT" WHERE ("ARTEFACTKEY" >= '1siLaF_7Ky_xUOUOOiQZ') AND ("ARTEFACTKEY" < '2hLd5Q0Ber gvlvlmIq4') AND (PROCESSING_SEQ = '100')
[09:42:21] DEBUG - Running SQL (PostgreSQL): SELECT count(), sum(('x' || substring(md5(concat(coalesce(coalesce("artefactkey"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn14"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga3"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn10"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce(to_char("start_period_dt"::timestamp(0), 'YYYY-mm-dd HH24:MI:SS.US'), '')::varchar, ''), '|', coalesce(coalesce("gn30"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga8"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn8"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn6"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga14"::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga21"::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga6"::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga20"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn5"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("maturity"::decimal(38, 0)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn27"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn20"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn12"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn28"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga2"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn29"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn1"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn21"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga9"::varchar, '')::varchar, ''), '|', coalesce(coalesce("artefact_seq"::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga17"::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga13"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn25"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("artefact_group_seq"::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga16"::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga12"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn22"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn11"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga19"::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga22"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn24"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn4"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga5"::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga10"::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga18"::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga1"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn17"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("artefact_type_seq"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn15"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("artefact_ctx_seq"::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga15"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn9"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga4"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn2"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga11"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn3"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn18"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga7"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn7"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("source_artefact_seq"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn19"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn23"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn26"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("ga23"::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn13"::decimal(38, 10)::varchar, '')::varchar, ''), '|', coalesce(coalesce("gn16"::decimal(38, 10)::varchar, '')::varchar, ''))), 18))::bit(60)::bigint) FROM "pctx_event" WHERE ("artefactkey" >= '1siLaF_7Ky_xUOUOOiQZ') AND ("artefactkey" < '2hLd5Q0Ber gvlvlmIq4') AND (PROCESSING_SEQ = '100')
[09:42:23] INFO - . Diffing segment 3/32, key-range: 2hLd5Q0Ber gvlvlmIq4..3Wzvb_TFzjPRM8M88uEb, size <= 736274738506125847299084470481284782
[09:42:23] ERROR - cannot pass more than 100 arguments to a function
LINE 1: SELECT count(*), sum(('x' || substring(md5(concat(coalesce(c...
^
Traceback (most recent call last):
File "/home/carrot/.cache/pypoetry/virtualenvs/c3-data-diff-1cD53cJJ-py3.11/bin/data-diff", line 8, in
sys.exit(main())
^^^^^^
File "/home/carrot/.cache/pypoetry/virtualenvs/c3-data-diff-1cD53cJJ-py3.11/lib/python3.11/site-packages/click/core.py", line 1130, in call
return self.main(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/carrot/.cache/pypoetry/virtualenvs/c3-data-diff-1cD53cJJ-py3.11/lib/python3.11/site-packages/click/core.py", line 1055, in main
rv = self.invoke(ctx)
^^^^^^^^^^^^^^^^
File "/home/carrot/.cache/pypoetry/virtualenvs/c3-data-diff-1cD53cJJ-py3.11/lib/python3.11/site-packages/click/core.py", line 1404, in invoke
return ctx.invoke(self.callback, **ctx.params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/carrot/.cache/pypoetry/virtualenvs/c3-data-diff-1cD53cJJ-py3.11/lib/python3.11/site-packages/click/core.py", line 760, in invoke
return __callback(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/carrot/.cache/pypoetry/virtualenvs/c3-data-diff-1cD53cJJ-py3.11/lib/python3.11/site-packages/data_diff/main.py", line 268, in main
return _data_diff(**kw)
^^^^^^^^^^^^^^^^
File "/home/carrot/.cache/pypoetry/virtualenvs/c3-data-diff-1cD53cJJ-py3.11/lib/python3.11/site-packages/data_diff/main.py", line 458, in _data_diff
for op, values in diff_iter:
File "/home/carrot/.cache/pypoetry/virtualenvs/c3-data-diff-1cD53cJJ-py3.11/lib/python3.11/site-packages/data_diff/diff_tables.py", line 95, in iter
for i in self.diff:
File "/home/carrot/.cache/pypoetry/virtualenvs/c3-data-diff-1cD53cJJ-py3.11/lib/python3.11/site-packages/data_diff/diff_tables.py", line 252, in _diff_tables_wrapper
raise error
File "/home/carrot/.cache/pypoetry/virtualenvs/c3-data-diff-1cD53cJJ-py3.11/lib/python3.11/site-packages/data_diff/diff_tables.py", line 225, in _diff_tables_wrapper
yield from self._diff_tables_root(table1, table2, info_tree)
File "/home/carrot/.cache/pypoetry/virtualenvs/c3-data-diff-1cD53cJJ-py3.11/lib/python3.11/site-packages/data_diff/thread_utils.py", line 68, in iter
raise self._exception
File "/home/carrot/.cache/pypoetry/virtualenvs/c3-data-diff-1cD53cJJ-py3.11/lib/python3.11/site-packages/data_diff/thread_utils.py", line 56, in _worker
res = fn(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^
File "/home/carrot/.cache/pypoetry/virtualenvs/c3-data-diff-1cD53cJJ-py3.11/lib/python3.11/site-packages/data_diff/hashdiff_tables.py", line 153, in _diff_segments
(count1, checksum1), (count2, checksum2) = self._threaded_call("count_and_checksum", [table1, table2])
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/carrot/.cache/pypoetry/virtualenvs/c3-data-diff-1cD53cJJ-py3.11/lib/python3.11/site-packages/data_diff/diff_tables.py", line 51, in _threaded_call
return list(self._thread_map(methodcaller(func), iterable))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.11/concurrent/futures/_base.py", line 619, in result_iterator
yield _result_or_cancel(fs.pop())
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.11/concurrent/futures/_base.py", line 317, in _result_or_cancel
return fut.result(timeout)
^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.11/concurrent/futures/_base.py", line 449, in result
return self.__get_result()
^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.11/concurrent/futures/_base.py", line 401, in __get_result
raise self._exception
File "/usr/lib/python3.11/concurrent/futures/thread.py", line 58, in run
result = self.fn(*self.args, **self.kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/carrot/.cache/pypoetry/virtualenvs/c3-data-diff-1cD53cJJ-py3.11/lib/python3.11/site-packages/data_diff/table_segment.py", line 173, in count_and_checksum
count, checksum = self.database.query(q, tuple)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/carrot/.cache/pypoetry/virtualenvs/c3-data-diff-1cD53cJJ-py3.11/lib/python3.11/site-packages/sqeleton/databases/base.py", line 345, in query
res = self._query(sql_code)
^^^^^^^^^^^^^^^^^^^^^
File "/home/carrot/.cache/pypoetry/virtualenvs/c3-data-diff-1cD53cJJ-py3.11/lib/python3.11/site-packages/sqeleton/databases/base.py", line 547, in _query
return r.result()
^^^^^^^^^^
File "/usr/lib/python3.11/concurrent/futures/_base.py", line 456, in result
return self.__get_result()
^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.11/concurrent/futures/_base.py", line 401, in __get_result
raise self._exception
File "/usr/lib/python3.11/concurrent/futures/thread.py", line 58, in run
result = self.fn(self.args, **self.kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/carrot/.cache/pypoetry/virtualenvs/c3-data-diff-1cD53cJJ-py3.11/lib/python3.11/site-packages/sqeleton/databases/base.py", line 553, in _query_in_worker
return self._query_conn(self.thread_local.conn, sql_code)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/carrot/.cache/pypoetry/virtualenvs/c3-data-diff-1cD53cJJ-py3.11/lib/python3.11/site-packages/sqeleton/databases/base.py", line 505, in _query_conn
return apply_query(callback, sql_code)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/carrot/.cache/pypoetry/virtualenvs/c3-data-diff-1cD53cJJ-py3.11/lib/python3.11/site-packages/sqeleton/databases/base.py", line 109, in apply_query
return callback(sql_code)
^^^^^^^^^^^^^^^^^^
File "/home/carrot/.cache/pypoetry/virtualenvs/c3-data-diff-1cD53cJJ-py3.11/lib/python3.11/site-packages/sqeleton/databases/base.py", line 493, in _query_cursor
c.execute(sql_code)
psycopg2.errors.TooManyArguments: cannot pass more than 100 arguments to a function
LINE 1: SELECT count(), sum(('x' || substring(md5(concat(coalesce(c...
Describe the environment
This is running on Ubuntu 20.04 and data-diff version 0.4.0