Comparing more than 50 columns in PostgreSQL throws a PG error #397
Comments
|
This issue has been marked as stale because it has been open for 60 days with no activity. If you would like the issue to remain open, please comment on the issue and it will be added to the triage queue. Otherwise, it will be closed in 7 days. |
|
Hi team, Thank you, |
github-actions
bot
added
triage
and removed
stale
Thanks for reporting this @filipegan , we're not currently working on this but may in the future, in the meantime we'd happily accept a community contribution |
dlawin
added
enhancement
|
This issue has been marked as stale because it has been open for 60 days with no activity. If you would like the issue to remain open, please comment on the issue and it will be added to the triage queue. Otherwise, it will be closed in 7 days. |
|
Although we are closing this issue as stale, it's not gone forever. Issues can be reopened if there is renewed community interest. Just add a comment and it will be reopened for triage. |
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
The text was updated successfully, but these errors were encountered: