column name automatically changed

Classic Servoy
1

In developer:
When I opened a Servoy 5.2.12 solution and its modules from svn into Servoy 6.1.0 then I did a database information sync.
I discovered that a column name has been automatically changed by this process:
table product had a column called ‘model’ (ever since Servoy 3.x) and did not change when migrated to Servoy 5.2.x
Now it is named ‘_model’.

This has causes errors because all calculations and methods and relations etc that use the column ‘model’ are unable to find it.
I checked in the PostgreSQL database and the column is still called ‘model’ there.

Why would this be changed automatically (and not simply flagged)?
Should I change the name back to model and see what happens?
I did check the reserved keywords and ‘model’ is reserved back in 5.2.x but no automatic changes are made. I did not try in Servoy 6.0.x.
I assume now that this automatic change is an ‘enforcer’ action and that other reserved words may suffer the same fate?

Servoy 6.1.0 build 1418
PostgreSql 9.1.4 x64
win 7 64 bit SP1
JRE 1.7.0_u3

2

Any advice on how to resolve the difference between the Servoy change column form ‘model’ to ‘_model’ but the Database remains using column name ‘model’?
There are lots of warnings saying that the ‘model’ does not exist rather than an error. Does this mean that Servoy is doing some automatic mapping?

3

Thomas Parry:
Any advice on how to resolve the difference between the Servoy change column form ‘model’ to ‘_model’ but the Database remains using column name ‘model’?
There are lots of warnings saying that the ‘model’ does not exist rather than an error. Does this mean that Servoy is doing some automatic mapping?

Please open a case so that we can investigate this issue.

4

case opened: SVY-2779