Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.4.7
-
None
-
Linux
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).