For sys_template the columns sys_created_by, sys_created_on, sys_updated_by and sys_updated_on are not created

gflewis / sndml3

ServiceNow Data Mart Loader: an application to load SQL databases from ServiceNow

MIT License

30 stars 19 forks source link

For sys_template the columns sys_created_by, sys_created_on, sys_updated_by and sys_updated_on are not created #16

Closed gflewis closed 4 years ago

gflewis commented 4 years ago

These columns are not included when the table is created. However, if they are added manually (via alter table) then they will be populated.

gflewis commented 4 years ago

This issue has been traced to a defect in the method TableSchema.determineParentname(). If the table name begins with "sys_", then columns from the parent table are not included in the schema. This will be fixed in the next release.

gflewis commented 4 years ago

Fixed in 3.1.2