duplicate_count raise exception "ORA-00933:SQL command not properly ended" due to LIMIT keyword about soda-core

[tools-soda]

SAS-3218

[bastienboutonnet]

Hi @donttrickrick I'm sorry you're experiencing an issue.

In order for us to help more efficiently can you make sure you provide us with the full log of the scan you did (preferably coming from a run in verbose mode -V and/or the trace ID that is printed as one of the last lines from the logs.

[bastienboutonnet]

It would also be helpful to see how you defined the check that is currently not working, so a copy of the SodaCL for this check is what we need.

[donttrickrick]

@bastienboutonnet Sure.

In my project, there are only 3 files.

checks.yml

checks for system.dt:
  - row_count > 0
  - duplicate_count(day) = 0

configuration.yml

data_source ds:
  type: oracle
  username: system
  password: oracle123
  connectstring: "localhost:1521/ORCLCDB"

requirements.txt

soda-core
soda-core-oracle

The table is very simple. You can initialize it by this code.

CREATE TABLE dt (
    DAY VARCHAR2(50),
    DAY_OF_MONTH NUMBER
 );

-- example data
INSERT INTO dt (DAY, DAY_OF_MONTH) VALUES ('2024-01-01', 1 )

However, soda scan raise this exception
soda_exp.txt

Any suggestion is appropriated.