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

Redundant warnings in LEFT(string,string)

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 5.3.12, 5.5.36, 10.0.9
    • 5.5(EOL)
    • None
    • None

    Description

      mysql>  select left('a','ca'); show warnings;
      +----------------+
      | left('a','ca') |
      +----------------+
      |                |
      +----------------+
      1 row in set, 2 warnings (0.00 sec)
       
      +---------+------+-----------------------------------------+
      | Level   | Code | Message                                 |
      +---------+------+-----------------------------------------+
      | Warning | 1292 | Truncated incorrect INTEGER value: 'ca' |
      | Warning | 1292 | Truncated incorrect INTEGER value: 'ca' |
      +---------+------+-----------------------------------------+
      2 rows in set (0.00 sec)

      Two warnings look redundant. One warning should be enough.

      Attachments

        Activity

          There are no comments yet on this issue.

          People

            bar Alexander Barkov
            bar Alexander Barkov
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.