FairCom DB V12 Updates

Insert Statements with Scalar Values and Subqueries Now Supported

FairCom DB SQL has been enhanced to handle mixing scalar values and a subquery in an INSERT INTO statement. A script similar to the following now succeeds:

create table source (f1 char(10));

insert into source values ('aaa');

create table dest (f1 integer, f2 char(10));

insert into dest values(1, (select f1 from source));