View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0010156 | Taler | exchange | public | 2025-07-07 23:08 | 2025-07-08 14:35 |
| Reporter | Florian Dold | Assigned To | Florian Dold | ||
| Priority | high | Severity | major | Reproducibility | have not tried |
| Status | resolved | Resolution | fixed | ||
| Target Version | 1.0 stretch goals | ||||
| Summary | 0010156: harness test kyc-decision-events fails with SQL error | ||||
| Description | taler-harness run-integrationtests kyc-decision-events | ||||
| Additional Information | 2025-07-07T23:07:04.715639+0200 pq-233541(112YMKWA49QCGKEV6R3ZXWS1PM) DEBUG Preparing SQL statement `SELECT event_type AS name,COUNT(*) AS value FROM kyc_events WHERE event_type IN $1 AND event_timestamp >= $2 AND event_timestamp < $3 GROUP BY event_type;' as `select_aml_statistics' 2025-07-07T23:07:04.715698+0200 pq-233541(112YMKWA49QCGKEV6R3ZXWS1PM) ERROR PQprepare (`SELECT event_type AS name,COUNT(*) AS value FROM kyc_events WHERE event_type IN $1 AND event_timestamp >= $2 AND event_timestamp < $3 GROUP BY event_type;' as `select_aml_statistics') failed with error: ERROR: syntax error at or near "$1" LINE 1: ...T(*) AS value FROM kyc_events WHERE event_type IN $1 AND e... ^ | ||||
| Tags | No tags attached. | ||||
|
|
I fixed the SQL error, but the test still fails :-( |
|
|
Note that the API changed, I suspect you're expecting the old output syntax? |
|
|
Test passes again after adapting the test to the new response. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-07-07 23:08 | Florian Dold | New Issue | |
| 2025-07-07 23:08 | Florian Dold | Assigned To | => Florian Dold |
| 2025-07-07 23:08 | Florian Dold | Status | new => assigned |
| 2025-07-07 23:08 | Florian Dold | Assigned To | Florian Dold => Christian Grothoff |
| 2025-07-07 23:09 | Florian Dold | Priority | normal => high |
| 2025-07-07 23:09 | Florian Dold | Severity | minor => major |
| 2025-07-07 23:09 | Florian Dold | Target Version | => 1.0 stretch goals |
| 2025-07-08 01:07 | Christian Grothoff | Note Added: 0025440 | |
| 2025-07-08 01:07 | Christian Grothoff | Assigned To | Christian Grothoff => Florian Dold |
| 2025-07-08 01:07 | Christian Grothoff | Status | assigned => feedback |
| 2025-07-08 01:07 | Christian Grothoff | Note Added: 0025441 | |
| 2025-07-08 14:35 | Florian Dold | Status | feedback => resolved |
| 2025-07-08 14:35 | Florian Dold | Resolution | open => fixed |
| 2025-07-08 14:35 | Florian Dold | Note Added: 0025445 |
