View Revisions: Issue #6637

All RevisionsBack to Issue
Summary 0006637: Add support for Derby boolean data types
Revision 2025-02-10 21:27 by pbelov
Steps To Reproduce -- Derby (Apache DB)
CREATE TABLE APP.RANDOM_INT_BOOLEAN(
    clint INT NOT NULL,
    clboolean BOOLEAN ,
    PRIMARY KEY (clint)
);


INSERT INTO APP.RANDOM_INT_BOOLEAN2 VALUES(1,NULL, 'test1');
INSERT INTO APP.RANDOM_INT_BOOLEAN2 VALUES(2,FALSE, 'test2');
INSERT INTO APP.RANDOM_INT_BOOLEAN2 VALUES(3,TRUE, 'test3');

select * from APP.RANDOM_INT_BOOLEAN;

select * from sym_trigger where source_table_name = 'RANDOM_INT_BOOLEAN';

select * from sym_data where table_name = 'RANDOM_INT_BOOLEAN';
Revision 2025-02-08 16:20 by pbelov
Steps To Reproduce -- Derby (Apache DB)
CREATE TABLE APP.RANDOM_INT_BOOLEAN(
    clint INT NOT NULL,
    clboolean BOOLEAN ,
    PRIMARY KEY (clint)
);

select * from APP.RANDOM_INT_BOOLEAN;

select * from sym_trigger where source_table_name = 'RANDOM_INT_BOOLEAN';

select * from sym_data where table_name = 'RANDOM_INT_BOOLEAN';
Revision 2024-11-06 18:08 by emiller
Steps To Reproduce