rumbin commented on issue #8411: Add support for database engine SAP Hana
URL: 
https://github.com/apache/incubator-superset/pull/8411#issuecomment-547567484
 
 
   FYI: There seems to be a bug when filtering on BOOLEAN values: There seems 
to be no way to enter the boolean value other than in a custom WHERE clause.
   
   When using the Filters field in Explore View with Filter Select enabled, it 
displays the `0` and `1` as available values, but won't let you actually pick 
and confirm one of them, since the Save button is grayed-out:
   
   
![image](https://user-images.githubusercontent.com/1220356/67796888-174a9600-fa81-11e9-937c-2feb0014dbc6.png)
   
   When trying the same using a Filter Chart in a Dashboard, the value 0 or 1 
is selectable, but the filtered charts contain no data, since the SQL query 
contains a WHERE predicate like `AND my_boolean_column IN (NULL)` instead of 
e.g.  `AND my_boolean_column IN (true)`.
   
   
![image](https://user-images.githubusercontent.com/1220356/67797642-6513ce00-fa82-11e9-83c9-3ace5fe82513.png)
   
   I.e., the conversion of HANA's true/false to its representation as 1/0 in 
Python and back to SQL code is not working as it should, yet.
   
   I don't know if such issues are supposed to be fixed in the initial PR, or 
if things like this may get addressed later on...
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
[email protected]


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to