Aikesheng Open Source Community
Nov 5, 2024 · Databases
Using WM_CONCAT in OceanBase 3.x: Restoring Order with NO_REWRITE Hint
This article explains how to replace Oracle's XMLAGG with OceanBase's WM_CONCAT, analyzes why the result order is lost in OceanBase 3.x, demonstrates reproduction steps, shows that adding a NO_REWRITE hint restores ordering, and provides the final SQL solution and notes for OceanBase 4.x.
HintOceanBaseSQL
0 likes · 9 min read