Bug Report:
- Blacklist filter not ignoring #Tableau DDL query
Environment:
- MySQL Version: 8.4.4
- Maxwell Version: 1.44.0
- Storage/Producer: (e.g., Kafka)
Configuration (config.properties):
- I have the following blacklist filter configured to ignore internal Tableau temporary tables:
filter = blacklist: *.#Tableau.*
Problematic Query (from BinLog):
USE `_trig`;
CREATE TABLE `#Tableau_18_sid_00147EFD_2_Connect_CheckSelectIntoCap`
SELECT *
FROM (SELECT 1 AS COL) AS CHECKTEMP
LIMIT 0;
Issues:
- Crash: Maxwell fails with a ParseException because it cannot parse the CREATE TABLE ... SELECT syntax or the # prefix in the table name.
- Filter Failure: Maxwell ignores the blacklist and attempts to process the table anyway, leading to "Table not found" errors or unwanted data in the output stream.