Version: 0.0.3
pgdesigner convert produces semantically incorrect FK actions when importing MicroOLAP pgDesigner .pdd files. The numeric action codes stored in PDD are decoded using the wrong mapping — specifically, codes 0 and 3 appear to be swapped relative to what MicroOLAP's own SQL generator emits.
Steps to reproduce:
- Take any .pdd file containing <REFERENCE ... OnDelete="0" OnUpdate="0">
- Run pgdesigner convert schema.pdd -o schema.pgd
- Run pgdesigner generate schema.pgd -o schema.sql
- Inspect the generated ALTER TABLE ... ADD CONSTRAINT ... FOREIGN KEY statements
Version: 0.0.3
pgdesigner convert produces semantically incorrect FK actions when importing MicroOLAP pgDesigner .pdd files. The numeric action codes stored in PDD are decoded using the wrong mapping — specifically, codes 0 and 3 appear to be swapped relative to what MicroOLAP's own SQL generator emits.
Steps to reproduce: