Skip to content

The "percentile_cont" cannot be used. #1367

@LLMTesting-Ojiken

Description

@LLMTesting-Ojiken

DROP TABLE IF EXISTS t0;
CREATE TABLE t0
(
c1 REAL
);
INSERT INTO t0 (c1)
VALUES (1),
(3),
(5),
(7),
(9);
SELECT percentile_cont(c1, 0.5) FROM t0;

The results obtained by using the jar package and those in Maven are inconsistent.
When downloading the jar package and executing it in a database management software like DataGrip, the result is 5.
When using the jar package introduced in Maven, the result is [SQLITE_ERROR] SQL error or missing database (no such function: percentile_cont)

Version is 3.51.1

Metadata

Metadata

Assignees

No one assigned

    Labels

    questionFurther information is requested

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions