Unable to run "where" querries with mysql DB

1

Hi Team,
I have connected to a mysql db successfully. I can pull from tables using the select * from table
eg.(SELECT * FROM DB.cablew.“CM_DAY_TOT”) but when I add a where clause, I get this error:
Source ‘DB’ returned error ‘(conn=1536727) Display width out of range for column ‘cast_as_char’ (max = 8192)’

Any Idea why this is the case?

2

@agriffith This looks like an error from the server side. Any chance you can send the profile?

3

55ea2d0c-9a74-4d20-b739-e72f011e1e91.zip (15.7 KB)

Sure. I have uploaded the profile.

4

@agriffith looks like the pushdown is incorrect, can you please run the below 2 SQL’s directly on MySql?

SELECT `CM_STATUS_DAY_FACTS`.`PTIME`, `CM_STATUS_DAY_FACTS`.`PATH_1`, `CM_STATUS_DAY_FACTS`.`PATH_2`, `CM_STATUS_DAY_FACTS`.`PATH_3`, `CM_STATUS_DAY_FACTS`.`PATH_4`, `CM_STATUS_DAY_FACTS`.`HUB_ID`, `CM_STATUS_DAY_FACTS`.`CMTS_ID`, `CM_STATUS_DAY_FACTS`.`CABLE_MAC`, CAST('20B82B29BF64' AS CHAR(65536)) AS `CM_MAC`, `CM_STATUS_DAY_FACTS`.`START_TIME`, `CM_STATUS_DAY_FACTS`.`END_TIME`, `CM_STATUS_DAY_FACTS`.`SAMPLES`, `CM_STATUS_DAY_FACTS`.`ONLINE_COUNT`, `CM_STATUS_DAY_FACTS`.`REG_STATUS_LAST`, `CM_STATUS_DAY_FACTS`.`RESET_COUNTS`
FROM `cabletica`.`CM_STATUS_DAY_FACTS`
WHERE `CM_STATUS_DAY_FACTS`.`CM_MAC` = '20B82B29BF64'

SELECT `CM_STATUS_DAY_FACTS`.`PTIME`, `CM_STATUS_DAY_FACTS`.`PATH_1`, `CM_STATUS_DAY_FACTS`.`PATH_2`, `CM_STATUS_DAY_FACTS`.`PATH_3`, `CM_STATUS_DAY_FACTS`.`PATH_4`, `CM_STATUS_DAY_FACTS`.`HUB_ID`, `CM_STATUS_DAY_FACTS`.`CMTS_ID`, `CM_STATUS_DAY_FACTS`.`CABLE_MAC`, CAST('20B82B29BF64' AS CHAR(1000)) AS `CM_MAC`, `CM_STATUS_DAY_FACTS`.`START_TIME`, `CM_STATUS_DAY_FACTS`.`END_TIME`, `CM_STATUS_DAY_FACTS`.`SAMPLES`, `CM_STATUS_DAY_FACTS`.`ONLINE_COUNT`, `CM_STATUS_DAY_FACTS`.`REG_STATUS_LAST`, `CM_STATUS_DAY_FACTS`.`RESET_COUNTS`
FROM `cabletica`.`CM_STATUS_DAY_FACTS`
WHERE `CM_STATUS_DAY_FACTS`.`CM_MAC` = '20B82B29BF64'

Can we also get the create table DDL for cabletica.CM_STATUS_DAY_FACTS please?