Summary of Info Mart Schema Changes
The following tables summarize Genesys Info Mart schema changes between 8.5 releases.
Query: SELECT `cargo__PDMTable`.`_pageName` AS `Table`,`cargo__PDMColumn`.`colName` AS `Column`,IF((`cargo__PDMTable`.`introduced` IS NOT NULL),`cargo__PDMTable`.`introduced`,IF((`cargo__PDMColumn`.`modified` IS NOT NULL),`cargo__PDMColumn`.`introduced`,)) AS `Introduced in release`,IF((`cargo__PDMColumn__modified`.`_value` IS NOT NULL),`cargo__PDMColumn__modified`.`_value`,) AS `Modified in release` FROM `cargo__PDMTable` LEFT OUTER JOIN `cargo__PDMTable__modified` ON ((`cargo__PDMTable`.`_ID`=`cargo__PDMTable__modified`.`_rowID`)) LEFT OUTER JOIN `cargo__PDMColumn` ON ((`cargo__PDMTable`.`_pageName`=`cargo__PDMColumn`.`_pageName`)) LEFT OUTER JOIN `cargo__PDMColumn__modified` ON ((`cargo__PDMColumn`.`_ID`=`cargo__PDMColumn__modified`.`_rowID`)) WHERE `cargo__PDMTable`.`_pageName` LIKE "%Library:%:8.5DRAFT" ORDER BY `cargo__PDMTable`.`_pageName`,`cargo__PDMColumn`.`colName`,IF((`cargo__PDMTable`.`introduced` IS NOT NULL),`cargo__PDMTable`.`introduced`,IF(`cargo__PDMColumn__modified`.`_valueIS` NOT NULL),`cargo__PDMColumn`.`introduced`,)),IF((`cargo__PDMColumn__modified`.`_value` IS NOT NULL),`cargo__PDMColumn__modified`.`_value`,) LIMIT 100 Function: CargoSQLQuery::run Error: 1064 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 'NULL),`cargo__PDMColumn`.`introduced`,)),IF((`cargo__PDMColumn__modified`.`_va' at line 1 (127.0.0.1)