Filter on oracle driver · cube-js/cube#3538

(1 评论) (0 反应) (0 负责人)Rust (19,563 star) (1,965 fork)batch import

driver:oraclehelp wanted

描述

Describe the bug when using playground react app, with oracle 18c DB, i got errors on request ' Illegal variable name/number'

To Reproduce install the cubejs playground with oracle DB

Expected behavior return request

Additional info 1- when using filter "contains", i've got || ? || unstead of || :"?" || 2- the alias generated it got used ` caracter that also generated errors 3- the connection is not closed when an error is thrown

to avoid these issues , i did a workround on updating the query variable on oracle driver and closing correctly with finally and release

贡献者指南

技术栈: typescriptnodejsreactsql
领域: backenddatabase
议题类型: bug
难度: 3
预计时间: 1-3 hours
活动状态: stale
清晰度: mostly clear
前置要求: Oracle SQL basicsNode.js environmentCube.js driver development
新手友好度: 40
研究方向: Investigate the Oracle driver implementation in the cube.js repository (likely under packages/cubejs oracle driver). Focus on the query building logic for filters and alias generation. Also review how connections are closed in error cases. Check if there are any existing tests for the Oracle driver to reproduce the issue.