I have recently upgraded a 3rd party plugin (Bob Swift's SQL Plugin version 5.2.0) on our confluence 4.3.7 installation. The plugin macros prior to upgrade only worked within the bundled wiki-markup macro, the expectation was that after the upgrade these macro's would be migrated/converted to the native (xhtml) macro format.
Following the plugin upgrade we observed the macro xhtml migration was only partially successful. It appears that the xhtml auto migration works when the macro (in our instance sql-query) is not nested within other macros, and appears to fail (or possibly not considered for migration?) when the macro is nested within other macros.
See attached image for a visual example
As you can see (in the image) the top two sql-query macros that have been converted into xhtml, the third, which is encapsulated by the Cache, Section, Column and Chart macro fails to convert and can be seen as it's still encapsulated my the wiki-markup macro. In my Confluence instance I see other examples where the xhtml migration has failed and the macro is only encapsulated by one other macro (not four like in this example).
Our assumption is that the automated process(es) to migrate macros to xhtml format are failing to consider these macros are valid for migration when they are encapsulated within other macros. I raised this question directly with Bob Swift and he suggested opening a support ticket (we acknowledged that when the macros are not nested they migrate correctly).
NOTE: I can manually add an upgraded macro (xhtml) anywhere within the page (included nested levels) without an issue.
Many thanks for your support,