500 SQL breaks, ORA-01795: maximum number of expressions in a list is 1000: tell client in a 400

VEuPathDB / EdaSubsettingService

A REST service to provide data and subsetting in the Exploratory Data Analysis Workspace

Apache License 2.0

0 stars 0 forks source link

500 SQL breaks, ORA-01795: maximum number of expressions in a list is 1000: tell client in a 400 #131

Open aurreco-uga opened 7 months ago

aurreco-uga commented 7 months ago

a filter with too many values selected, it breaks when trying to see another variable (i shared the UD with dmgaldi@upenn.edu and this is the analysis) https://clinepidb.org/analysis/KntD0mj

bobular commented 6 months ago

Sorry, this comment was better placed here

aurreco-uga commented 4 months ago

@dmgaldi could we add the error in the response to the client? Caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000