Bug 1271247 - Process instance variable log contains a single space instead of null value on Sybase
Summary: Process instance variable log contains a single space instead of null value o...
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: JBoss BPMS Platform 6
Classification: Retired
Component: Business Central
Version: 6.2.0
Hardware: Unspecified
OS: Unspecified
medium
high
Target Milestone: ---
: ---
Assignee: Maciej Swiderski
QA Contact: Tomas Livora
Tomas 'Sheldon' Radej
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2015-10-13 13:23 UTC by Tomas Livora
Modified: 2015-12-07 16:58 UTC (History)
3 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2015-12-07 16:58:40 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)

Description Tomas Livora 2015-10-13 13:23:42 UTC
Description of problem:
When you have a process instance with null process variable and you try to get its value while using Sybase database, you will get a single space character instead of null. Although it may not seem like a big deal when working with such value on the client side, imagine a process instance which contains check if the process variable is null (or empty). This condition will probably evaluate differently on Sybase than on other databases.

Version-Release number of selected component (if applicable):
6.2.0 ER3

Steps to Reproduce:
1. Run Business Central on Sybase database.
2. Run a business process with null variable.
3. Try to get this variable through REST API.

Actual results:
A single space is returned.

Expected results:
null value should be returned. The behavior should be the same regardless of which database is used.

Additional info:
This bug has been discovered using REST API but the problem is probably in the underlying jBPM engine.

Comment 1 Maciej Swiderski 2015-11-18 17:00:13 UTC
while I see your point that it might be confusing I don't see anyway to solve it. Mainly because there could be the opposite situation you described - a process variable is single space value and then it is not possible to recognize if this is null or not. 

I am afraid that this is (yet another) limitation of sybase that does return weird values. Since we do not have control over data access (done via jpa) meaning we cannot decide if shall deal with single space somehow or not.

I opt at closing this as won't fix, thoughts?

Comment 2 Tomas Livora 2015-11-18 17:18:08 UTC
I think it can be closed then. However, we should add a note about this strange behavior of Sybase to our documentation.


Note You need to log in before you can comment on or make changes to this bug.