Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9913

ignore, workaround found

    XMLWordPrintable

Details

    Description

      Here's the problem: CAD software accessing MariaDB needs columns returned as "number" (so that it can do ">" ">=" etc), but when the number is greater than 1000,
      the locale inserts a comma (1,000) that results in the number being passed to subcomponents and interpreted as "1". Using a mysql function that removes "," from the number results in returning a "string" to the application, so numeric comparisons stop working correctly.

      There are several possible solutions, but one of the simplest is to be able to alter the locale table to set the thousands_sep to an empty string, OR to be able to add rows to the locale table (so that one could copy the en_US row, with the thousands_sep value changed, for example).

      There are other possible solutions, but adding flexibility to locale settings would be beneficial in other contexts.

      Attachments

        Activity

          People

            serg Sergei Golubchik
            celane Charles Lane
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.