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

            Assignee:
            bar Alexander Barkov
            Reporter:
            philip_38 Philip orleans
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: