<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div class=""><br class=""></div>Anyone else using MariaDB ? <div class=""><br class=""><div class="">We’re running mysql on our production servers, but I’m running a current version of Maria-DB on my development laptop. </div><div class=""><br class=""></div><div class="">While investigating the unescaped ampersand in reports issue, I discovered I’m getting errors running some reports. </div><div class="">Resource List Report says:</div><div class=""><br class=""></div><div class=""><span style="caret-color: rgb(51, 238, 51); color: rgb(51, 238, 51); font-family: monospace; font-size: 13px; white-space: pre; background-color: rgb(51, 51, 51);" class="">Generating report
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'portion,
number as extent_number,
extent_type_id as extent_type,
contai' at line 2</span></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">And by trying that select statement in the command line, it appears that “portion” must now be a keyword in MariaDB.</div><div class=""><br class=""></div><div class="">This generates an error:</div><div class=""><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Menlo; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures;" class=""><font size="2" class="">MariaDB [archivesspace]> select portion_id as portion from extent;</font></span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Menlo; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures;" class=""><font size="2" class="">ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'portion from extent' at line 1</font></span></div></div><div class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class=""></span></div><div class=""><br class=""></div><div class="">But this works:</div><div class=""><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Menlo; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures;" class=""><font size="2" class="">MariaDB [archivesspace]> select portion_id as `portion` from extent;</font></span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Menlo; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><font size="2" class="">+---------+</font></span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Menlo; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><font size="2" class="">| portion |</font></span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Menlo; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><font size="2" class="">+---------+</font></span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Menlo; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><font size="2" class="">| 924 |</font></span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Menlo; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><font size="2" class="">| 924 |</font></span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Menlo; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><font size="2" class="">| 924 |</font></span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Menlo; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><font size="2" class="">| 924 |</font></span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Menlo; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><font size="2" class="">| 924 |</font></span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Menlo; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><font size="2" class="">| 924 |</font></span></div></div><div class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class=""></span></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><a href="https://github.com/archivesspace/archivesspace/blob/master/reports/custom/extent_subreport.rb#L17" class="">https://github.com/archivesspace/archivesspace/blob/master/reports/custom/extent_subreport.rb#L17</a></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">“Portion” no listed here:</div><div class=""><a href="https://mariadb.com/kb/en/library/reserved-words/" class="">https://mariadb.com/kb/en/library/reserved-words/</a></div><div class=""><br class=""></div><div class="">But this list in source code is canonical source:</div><div class=""><a href="https://github.com/MariaDB/server/blob/10.5/sql/lex.h#L474" class="">https://github.com/MariaDB/server/blob/10.5/sql/lex.h#L474</a></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div></div></body></html>