src/ports/postgres/modules/linear_systems/test/dense_linear_sytems.sql_in

/* -----------------------------------------------------------------------------
 * Test Dense Linear Systems
 * -------------------------------------------------------------------------- */

DROP TABLE IF EXISTS linear_system_test_data;
CREATE TABLE "Linear_systems_test_data" (
    id INTEGER NOT NULL,
    "A" DOUBLE PRECISION[],
    b DOUBLE PRECISION
);

INSERT INTO "Linear_systems_test_data"(id, "A", b) VALUES
(0, ARRAY[1,0,0], 20),
(1, ARRAY[0,1,0], 15),
(2, ARRAY[0,0,1], 20);


-- Note: This install check is meant to check that all the functions exposed to
-- the user work.

-- Checks for the function usage
select linear_solver_dense('help');
select linear_solver_dense('usage');


-- CHECK : Make sure all possible default calls work
drop table if exists result_table;
select linear_solver_dense(
       '"Linear_systems_test_data"',
       'result_table',
       'id',
       '"A"',
       'b',
        NULL,
       'direct',
       'algorithm=llt'
       );

drop table if exists result_table;
select linear_solver_dense(
       '"Linear_systems_test_data"',
       'result_table',
       'id',
       '"A"',
       'b',
        NULL,
       'direct'
       );

drop table if exists result_table;
select linear_solver_dense(
       '"Linear_systems_test_data"',
       'result_table',
       'id',
       '"A"',
       'b',
        NULL
       );

drop table if exists result_table;
select linear_solver_dense(
       '"Linear_systems_test_data"',
       'result_table',
       'id',
       '"A"',
       'b'
       );
drop table if exists result_table;