| Subject: | DBD::Ingres::st fetchrow_hashref failed: E_LQ000E No null indicator supplied with program variable. Null data ... can not be converted. |
DBD::Ingres::st fetchrow_hashref failed: E_LQ000E No null indicator
supplied with program variable.
Null data from column 13 can not be converted. [for Statement
"SELECT * FROM sii_tests
LEFT JOIN sii_test_results
ON sii_test_results.sii_tests_id = sii_tests.id
"]
Tables are:
CREATE SEQUENCE sii_tests_seq;
CREATE TABLE sii_tests (
id INTEGER NOT NULL DEFAULT sii_tests_seq.nextval,
table VARCHAR(127) NOT NULL,
column_name VARCHAR(127) NOT NULL,
rule_id BIGINT NOT NULL,
test_order BIGINT NOT NULL,
for_valuation TINYINT NOT NULL,
impact_level SMALLINT NOT NULL,
description VARCHAR(32000) NOT NULL,
sql VARCHAR(32000) ,
sii_tests_function_id INTEGER ,
function_args VARCHAR(255) ,
notes VARCHAR(32000),
UNIQUE( id ),
PRIMARY KEY( table, rule_id),
CONSTRAINT sii_test2function
FOREIGN KEY (sii_tests_function_id)
REFERENCES sii_test_functions(id)
ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT sii_test2table
FOREIGN KEY (table)
REFERENCES sii_dict_tables( internal_name )
ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT sii_test2table_column
FOREIGN KEY (table, column_name)
REFERENCES sii_dict_columns( sii_dict_tables_internal_name,
internal_name )
ON DELETE RESTRICT ON UPDATE CASCADE
)
CREATE SEQUENCE sii_test_results_seq;
CREATE TABLE sii_test_results (
id INTEGER NOT NULL DEFAULT sii_test_results_seq.nextval,
db_alias VARCHAR(127) NOT NULL,
sii_tests_table VARCHAR(127) NOT NULL,
sii_tests_column_name VARCHAR(127) NOT NULL,
sii_tests_id INTEGER NOT NULL,
result VARCHAR(32000),
PRIMARY KEY( id ),
CONSTRAINT sii_result2test
FOREIGN KEY (sii_tests_id)
REFERENCES sii_tests(id)
ON DELETE RESTRICT ON UPDATE CASCADE
)