Cannot reproduce with FlameRobin 0.9.3 (hash 5ece15b) x64, Windows
1. Ran
CREATE TABLE RESULTA_LIGNES
(
ID_RESULT integer not null,
ID_PARAM_LIN integer not null,
RESULTA numeric(12,4),
EXP_R integer,
VALIDE char(1) not null,
OPER char(3) not null,
CONSTRAINT PK_RESULTA_LIGNES
PRIMARY KEY (ID_RESULT, ID_PARAM_LIN)
);
2. Extracted full ddl from table which seems to give the correct result:
CREATE TABLE RESULTA_LIGNES
(
ID_RESULT INTEGER NOT NULL,
ID_PARAM_LIN INTEGER NOT NULL,
RESULTA NUMERIC(12,4),
EXP_R INTEGER,
VALIDE CHAR(1) NOT NULL,
OPER CHAR(3) NOT NULL,
CONSTRAINT PK_RESULTA_LIGNES PRIMARY KEY (ID_RESULT,ID_PARAM_LIN)
);
GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE
ON RESULTA_LIGNES TO SYSDBA WITH GRANT OPTION;
Suggest issue be closed unless reporter has proof it still does not work.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Cannot reproduce with FlameRobin 0.9.3 (hash 5ece15b) x64, Windows
1. Ran
CREATE TABLE RESULTA_LIGNES
(
ID_RESULT integer not null,
ID_PARAM_LIN integer not null,
RESULTA numeric(12,4),
EXP_R integer,
VALIDE char(1) not null,
OPER char(3) not null,
CONSTRAINT PK_RESULTA_LIGNES
PRIMARY KEY (ID_RESULT, ID_PARAM_LIN)
);
2. Extracted full ddl from table which seems to give the correct result:
CREATE TABLE RESULTA_LIGNES
(
ID_RESULT INTEGER NOT NULL,
ID_PARAM_LIN INTEGER NOT NULL,
RESULTA NUMERIC(12,4),
EXP_R INTEGER,
VALIDE CHAR(1) NOT NULL,
OPER CHAR(3) NOT NULL,
CONSTRAINT PK_RESULTA_LIGNES PRIMARY KEY (ID_RESULT,ID_PARAM_LIN)
);
GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE
ON RESULTA_LIGNES TO SYSDBA WITH GRANT OPTION;
Suggest issue be closed unless reporter has proof it still does not work.
Thanks for testing it for us