Description
My table are created with boolean fields. And the "IDCST" INT64 NOT NULL, was created Numeric(18,0)
Whem open in heidiSQL...
CREATE TABLE "CST" (
"IDCST" INT64 NOT NULL,
"CODIGOCST" VARCHAR NOT NULL,
"DESCRICAO" VARCHAR NOT NULL,
"INDIBSCBS" UNKNOWN NOT NULL,
"INDREDBC" UNKNOWN NOT NULL,
"INDREDALIQ" UNKNOWN NOT NULL,
"INDTRANSFCRED" UNKNOWN NOT NULL,
"INDDIF" UNKNOWN NOT NULL,
"INDAJUSTECOMPET" UNKNOWN NOT NULL,
"INDIBSCBSMONO" UNKNOWN NOT NULL,
"INDCREDPRESIBSZFM" UNKNOWN NOT NULL,
"PUBLICACAO" TIMESTAMP NOT NULL,
"INICIOVIGENCIA" TIMESTAMP NOT NULL,
"FIMVIGENCIA" TIMESTAMP
);
HeidiSQL version and OS
lastversion
Database server version
Firebird 4.0
Reproduction recipe
Error/Backtrace
Description
My table are created with boolean fields. And the "IDCST" INT64 NOT NULL, was created Numeric(18,0)
Whem open in heidiSQL...
CREATE TABLE "CST" (
"IDCST" INT64 NOT NULL,
"CODIGOCST" VARCHAR NOT NULL,
"DESCRICAO" VARCHAR NOT NULL,
"INDIBSCBS" UNKNOWN NOT NULL,
"INDREDBC" UNKNOWN NOT NULL,
"INDREDALIQ" UNKNOWN NOT NULL,
"INDTRANSFCRED" UNKNOWN NOT NULL,
"INDDIF" UNKNOWN NOT NULL,
"INDAJUSTECOMPET" UNKNOWN NOT NULL,
"INDIBSCBSMONO" UNKNOWN NOT NULL,
"INDCREDPRESIBSZFM" UNKNOWN NOT NULL,
"PUBLICACAO" TIMESTAMP NOT NULL,
"INICIOVIGENCIA" TIMESTAMP NOT NULL,
"FIMVIGENCIA" TIMESTAMP
);
HeidiSQL version and OS
lastversion
Database server version
Firebird 4.0
Reproduction recipe
Error/Backtrace