CNA genes endpoint discrepancy on public portal (clickhouse)

[alisman]

The following returns different counts for legacy and Clickhouse.

curl 'http://localhost:8082/api/cna-genes/fetch?' \
  -H 'Accept: application/json, text/javascript, */*; q=0.01' \
  -H 'Accept-Language: en-US,en;q=0.9' \
  -H 'Cache-Control: no-cache' \
  -H 'Connection: keep-alive' \
  -H 'Content-Type: application/json' \
  -H 'Cookie: _ga=GA1.1.1887007066.1710956751; _ga_5260NDGD6Z=GS1.1.1721930557.11.1.1721930574.0.0.0' \
  -H 'Origin: http://localhost:8082' \
  -H 'Pragma: no-cache' \
  -H 'Referer: http://localhost:8082/study/summary?id=acc_tcga_pan_can_atlas_2018' \
  -H 'Sec-Fetch-Dest: empty' \
  -H 'Sec-Fetch-Mode: cors' \
  -H 'Sec-Fetch-Site: same-origin' \
  -H 'User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36' \
  -H 'X-Requested-With: XMLHttpRequest' \
  -H 'sec-ch-ua: "Google Chrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"' \
  -H 'sec-ch-ua-mobile: ?0' \
  -H 'sec-ch-ua-platform: "macOS"' \
  --data-raw '{"studyIds":["acc_tcga_pan_can_atlas_2018"],"alterationFilter":{"copyNumberAlterationEventTypes":{"AMP":true,"HOMDEL":true},"mutationEventTypes":{"any":true},"structuralVariants":null,"includeDriver":true,"includeVUS":true,"includeUnknownOncogenicity":true,"includeUnknownTier":true,"includeGermline":true,"includeSomatic":true,"includeUnknownStatus":true,"tiersBooleanMap":{}}}'

[alisman]

To configure local portal for public db, use genie portal congfiguration but change the db name to cgds_public_v5 for both Clickhouse and MySQL

--enable_request_body_gzip_compression=true
--server.port=8082
--authenticate=false
--dat.method=none
--logging.level.org.springframework.web.servlet.DispatcherServlet=DEBUG
--spring.datasource.mysql.url=jdbc:mysql://rfc80db.cbioportal.org:3306/cgds_public_v5?zeroDateTimeBehavior=convertToNull&useSSL=false&allowPublicKeyRetrieval=true
--frontend.url=https://deploy-preview-4931--cbioportalfrontend.netlify.app/
--spring.datasource.mysql.username=cgds_user
--spring.datasource.mysql.password=rfc80dbuserpw5
--spring.datasource.mysql.driver-class-name=com.mysql.jdbc.Driver
--spring.datasource.clickhouse.url=jdbc:ch://mecgt250i0.us-east-1.aws.clickhouse.cloud:8443/cgds_public_v5?ssl=true&sslmode=STRICT
--spring.datasource.clickhouse.username=app_user
--spring.datasource.clickhouse.password=P@ssword1976
--spring.datasource.clickhouse.driver-class-name=com.clickhouse.jdbc.ClickHouseDriver
--redis.leader_address=redis://localhost:6379
--redis.follower_address=redis://localhost:6379
--redis.database=1
--redis.password=donk
--redis.ttl_mins=10000
--redis.clear_on_startup=true
--persistence.cache_type=redis
--logging.level.org.cbioportal.persistence.mybatisclickhouse=DEBUG

[haynescd]

I don't see any errors with this