Ticket #135 (new defect)

Opened 3 months ago

Model names which are reserved sql words cause some queries to fail.

Reported by: james.kilbride@gd-ais.com Assigned to: pmjones
Priority: critical Component: code
Keywords: Model Cc:

Description

Model names which are reserved sql words cause some queries to fail even if the table name set in the model is not a reserved word. This is caused by the fact that the select queries are aliasing the table name by the model name, rather than the table name in the model. Either an 'alias_name' item should be set or model's named for 'reserved words' should cause solar to complain rather than getting all the way to the database. Preference would be for Solar to use the table name set on the class if one already exists for the alias.

Attachments


Add/Change #135 (Model names which are reserved sql words cause some queries to fail.)