Details

    Description

      This page from Markus Winand shows that numeric literals with undercore are SQL standard and partially work in some DBMSs:

      https://modern-sql.com/caniuse/T662

      Some people (including me) write 1 * 1000 * 1000 to make big values readable, but I can't say it's elegant. Underscores seem reasonably easy to implement, so please consider them.

      Attachments

        Activity

          I don't see it in SQL:2016, there is no T662 and the syntax for numbers is

          <unsigned integer> ::=
                <digit>...
           
          <digit> ::=
                0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
          

          serg Sergei Golubchik added a comment - I don't see it in SQL:2016, there is no T662 and the syntax for numbers is <unsigned integer> ::= <digit>...   <digit> ::= 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
          ralf.gebhardt Ralf Gebhardt added a comment -

          serg, is looks to be in SQL:2023 - https://en.wikipedia.org/wiki/SQL:2023

          ralf.gebhardt Ralf Gebhardt added a comment - serg , is looks to be in SQL:2023 - https://en.wikipedia.org/wiki/SQL:2023
          rohan.gupta Rohan Gupta added a comment -

          could this issue be assigned to me?

          rohan.gupta Rohan Gupta added a comment - could this issue be assigned to me?

          No, this Jira can only assign issues to people in the "developers" group. But it's just a formality, you don't need to care about that. If you want to try to implement that — you're very welcome to. Thank you!

          Just create a pull request.

          Also you can discuss how to approach this feature on the mailing list or on zulip. See https://mariadb.org/contribute/

          serg Sergei Golubchik added a comment - No, this Jira can only assign issues to people in the "developers" group. But it's just a formality, you don't need to care about that. If you want to try to implement that — you're very welcome to. Thank you! Just create a pull request. Also you can discuss how to approach this feature on the mailing list or on zulip. See https://mariadb.org/contribute/

          People

            Unassigned Unassigned
            f_razzoli Federico Razzoli
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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