Details
-
Bug
-
Status: Closed
-
Must
-
Resolution: Fixed
-
None
-
None
Description
rank is an SQL reserved word since MySQL 8.0.2: but we are using it as a field name in the Diagnosis class.
Causes the below SQL error while trying to create a Visit Note via the OWA/UI;
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank) values ('09aafee4-c8a1-4f17-a185-c9e2cda72363', null, 1, null, '2021-10-31' at line 1
See discussion on this here.
Gliffy Diagrams
Attachments
Issue Links
- caused
-
TRUNK-6081 Add not null constraint to encounter_diagnosis.dx_rank column
-
- Closed
-
