LibsqlError: SQLITE_ERROR: no such function: SQRT

Hi I'm trying to implement an SQLite command in libsql with the help of drizzle. I'm getting error SQRT function not available.

It seems SQLITE doesn't come with the functions by default. Is this the case with libSQL too? If so how can I get it working

CREATE VIEW view1 AS
    SELECT
        t.index_no,
        (
            (t.total - AVG(t.total) OVER()) / (
                                SELECT SQRT(AVG(t.total * t.total) - (AVG(t.total) * AVG(t.total)))
                FROM view2
            )
        ) as zscore
    FROM view2 AS t`);

CREATE VIEW view1 AS
    SELECT
        t.index_no,
        (
            (t.total - AVG(t.total) OVER()) / (
                                SELECT SQRT(AVG(t.total * t.total) - (AVG(t.total) * AVG(t.total)))
                FROM view2
            )
        ) as zscore
    FROM view2 AS t`);

Drizzle Team•3y ago

thuvasooriya

LibsqlError: SQLITE_ERROR: no such function: SQRT

CREATE VIEW view1 AS
    SELECT
        t.index_no,
        (
            (t.total - AVG(t.total) OVER()) / (
                                SELECT SQRT(AVG(t.total * t.total) - (AVG(t.total) * AVG(t.total)))
                FROM view2
            )
        ) as zscore
    FROM view2 AS t`);

CREATE VIEW view1 AS
    SELECT
        t.index_no,
        (
            (t.total - AVG(t.total) OVER()) / (
                                SELECT SQRT(AVG(t.total * t.total) - (AVG(t.total) * AVG(t.total)))
                FROM view2
            )
        ) as zscore
    FROM view2 AS t`);

LibsqlError: SQLITE_ERROR: no such function: SQRT

Similar Threads

LibsqlError: SQLITE_ERROR: no such function: SQRT

Similar Threads

Similar Threads

Similar Threads