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

select count(*) shows errors, maybe it's invalid

    XMLWordPrintable

Details

    Description

      This select statement

      SELECT count(*) FROM asterisk.npadata n LEFT JOIN america.americarocks a ON a.number=n.did WHERE n.state='TX' AND wireless=0 AND (n.reachable=1 OR n.residential=1) AND a.recordtype='Residential';    
      

      should never produce thousands of warnings like this:

      show warnings
       Warning | 1292 | Truncated incorrect INTEGER value: ''
      

      (thousands of times)
      Both tables joined are RocksDB
      one of the joined fields is bigint(20) unsigned while the oher is varchar(50).

      Attachments

        Activity

          People

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