Add support for flat views in MySQL

orbeon / orbeon-forms

Orbeon Forms is an open source web forms solution. It includes an XForms engine, the Form Builder web-based form editor, and the Form Runner runtime.

http://www.orbeon.com/

GNU Lesser General Public License v2.1

514 stars 221 forks source link

Add support for flat views in MySQL #6284

Closed obruchez closed 5 months ago

obruchez commented 5 months ago

Following #1069, add support for flat views in MySQL.

Think about how flat views could be implemented in SQLite as well (XML functions are not supported, though).

obruchez commented 5 months ago

Only the base flat views (no repetition) are now supported in MySQL, as only basic XML functions are available (no way to extract repeated XML nodes currently). MySQL is just slightly better than SQLite in this regard. If flat views are ever supported in a more complete way in MySQL (and supported at all in SQLite), we'll probably have to explicitly manage "flat tables" from the code.