Error in SQL "#case_in_period" should be "#cases_in_periods"

[azimov]

See attached error. errorReport 3.R.txt

Looking through the source code there are references to a table "#cases_in_periods" plural not "#cases_in_period" singular like in this error message on this line:

SelfControlledCaseSeries/inst/sql/CreateCases.sql

Line 110 in a4a281a

FROM #cases_in_period cases

SelfControlledCaseSeries/inst/sql/CreateCases.sql at a4a281a · OHDSI/SelfControlledCaseSeries
An R package for performing Self-Controlled Case Series (SCCS) analyses in an observational database in the OMOP Common Data Model. - OHDSI/SelfControlledCaseSeries
[11:40] Gilbert, James [JANUS]
The reference above is here:

SelfControlledCaseSeries/inst/sql/CreateCases.sql

Line 79 in a4a281a

INTO #cases_in_periods

SelfControlledCaseSeries/inst/sql/CreateCases.sql at a4a281a · OHDSI/SelfControlledCaseSeries
An R package for performing Self-Controlled Case Series (SCCS) analyses in an observational database in the OMOP Common Data Model. - OHDSI/SelfControlledCaseSeries

Not sure on steps to reproduce it but I have a PR incoming

[azimov]

To confirm the reproducibility of this bug - call getDbSccsData with a study start date and end date as well as nesting the cohort inside an indication cohort. The fix should allow this process to continue