cube-js / cube-js/cube

Mongo Query Not Generating Boolean Value

Open
#1,232 2 comments 0 reactions 0 assignees View on GitHub
driver:mongodb help wanted
Dominant language
Rust
Stars
20.8k
Forks
2.1k
Avg merge
1d 2h
Merged PRs (30d)
181

Description

**Describe the bug**
I am using the Vue cube.js client and I am using Mongo BI Connector as my datasource.

I have a boolean dimension in one of my cubes, but when I execute a query I get the following SQL generated:

```
SELECT * FROM `cube` WHERE (`cube.myBoolean` <> 'true'
OR `cube.myBoolean` IS NULL);
```

Note how the value it is comparing against is `'true'` and not `true`.

**Expected behavior**
I expect it to generate something like:

```
SELECT * FROM `cube` WHERE (`cube.myBoolean` <> true
OR `cube.myBoolean` IS NULL);
```

**Version:**
0.21.1

**Additional context**
This is a huge issue for me because my MongoDB has an index on that field, and this causes my index to not work. Is there any temporary workaround I can do until this gets fixed?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.