<p>I guess 'partition' is a reserved word for mariadb, but db_unixodbc is not quoting the column names.</p>

<p>Is there any reason not to use db_mysql, afaik, it should work fine for mariadb and it does proper quotation of column names.</p>

<p>As for db_unixodbc, it may need a mod param to set the quotation character, because it is not the same for database servers.</p>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/kamailio/kamailio/issues/791#issuecomment-249515434">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AF36ZXAtOdS-_Owc4XunmexYSmm7a9vAks5qt4jXgaJpZM4KCg5F">mute the thread</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AF36ZQoQq2JjYX4nhXfVljs6McUKtRXRks5qt4jXgaJpZM4KCg5F.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
  <link itemprop="url" href="https://github.com/kamailio/kamailio/issues/791#issuecomment-249515434"></link>
  <meta itemprop="name" content="View Issue"></meta>
</div>
<meta itemprop="description" content="View this Issue on GitHub"></meta>
</div>

<script type="application/json" data-scope="inboxmarkup">{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/kamailio/kamailio","title":"kamailio/kamailio","subtitle":"GitHub repository","main_image_url":"https://cloud.githubusercontent.com/assets/143418/17495839/a5054eac-5d88-11e6-95fc-7290892c7bb5.png","avatar_image_url":"https://cloud.githubusercontent.com/assets/143418/15842166/7c72db34-2c0b-11e6-9aed-b52498112777.png","action":{"name":"Open in GitHub","url":"https://github.com/kamailio/kamailio"}},"updates":{"snippets":[{"icon":"PERSON","message":"@miconda in #791: I guess 'partition' is a reserved word for mariadb, but db_unixodbc is not quoting the column names.\r\n\r\nIs there any reason not to use db_mysql, afaik, it should work fine for mariadb and it does proper quotation of column names.\r\n\r\nAs for db_unixodbc, it may need a mod param to set the quotation character, because it is not the same for database servers."}],"action":{"name":"View Issue","url":"https://github.com/kamailio/kamailio/issues/791#issuecomment-249515434"}}}</script>