You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Description
I am seeing a problem when connecting to cube sql api using ORMs. I tried connecting to it with Knex, however, it fails to connect with knex not being able to infer the postgres version. This is happening because knex runs the select version() query and expects the returned rows to have column names / keys as version which is what happens on actual postgres. However, cube returns the version with the column name / key as version() and hence the ORM fails initialization. Images attached
To Reproduce
Make a small project and install knex and pg libraries into it. Try connecting to cube sql api and running a query. Fails with a parseVersion hint in the stack trace
Expected behavior
Should connect and run queries without problems
Screenshots
Minimally reproducible Cube Schema
Any schema
The text was updated successfully, but these errors were encountered:
igorlukanin
changed the title
SELECT VERSION() returns "version()" as coiumn name on sql apiSELECT VERSION() returns "version()" as column name in the SQL API
Nov 6, 2024
Description
I am seeing a problem when connecting to cube sql api using ORMs. I tried connecting to it with Knex, however, it fails to connect with knex not being able to infer the postgres version. This is happening because knex runs the
select version()
query and expects the returned rows to have column names / keys asversion
which is what happens on actual postgres. However, cube returns the version with the column name / key asversion()
and hence the ORM fails initialization. Images attachedTo Reproduce
Make a small project and install knex and pg libraries into it. Try connecting to cube sql api and running a query. Fails with a parseVersion hint in the stack trace
Expected behavior
Should connect and run queries without problems
Screenshots
Minimally reproducible Cube Schema
Any schema
The text was updated successfully, but these errors were encountered: