LinqConnect Professional Version 4.4.383 (28-Nov-2013) - Incorrect DEFAULT value for System.Boolean
Posted: Thu 12 Dec 2013 13:43
Hello.
I use one model for many database type.
When generate database from model, for field with type System.Boolean generate incorrect SQL code for DEFAULT value.
If set DEFAULT value to False or True, generate code, like this:
PS: System.Boolean convert to NUMBER(1).
Must be:
For MySQL, PostgreSql, SQLite and MS SQL Server all ok.
Please fix it.
Thanks.
I use one model for many database type.
When generate database from model, for field with type System.Boolean generate incorrect SQL code for DEFAULT value.
If set DEFAULT value to False or True, generate code, like this:
PS: System.Boolean convert to NUMBER(1).
Code: Select all
--
-- Creating a table CEDATABASE."SpecialDays"
--
CREATE TABLE CEDATABASE."SpecialDays" (
"SpecialDaysId" NUMBER(10) NOT NULL,
"IsAnual" NUMBER(1) DEFAULT False NOT NULL,
"IsWorkingDay" NUMBER(1) DEFAULT True NOT NULL,
);
Code: Select all
"IsAnual" NUMBER(1) DEFAULT 0 NOT NULL,
"IsWorkingDay" NUMBER(1) DEFAULT 1 NOT NULL,
Please fix it.
Thanks.