[JBoss JIRA] Assigned: (TEIIDDES-110) Preview does not allow leaving fields null for nullable columns in an access pattern
by Dan Florian (JIRA)
[ https://jira.jboss.org/jira/browse/TEIIDDES-110?page=com.atlassian.jira.p... ]
Dan Florian reassigned TEIIDDES-110:
------------------------------------
Assignee: Dan Florian (was: Barry LaFond)
> Preview does not allow leaving fields null for nullable columns in an access pattern
> ------------------------------------------------------------------------------------
>
> Key: TEIIDDES-110
> URL: https://jira.jboss.org/jira/browse/TEIIDDES-110
> Project: Teiid Designer
> Issue Type: Bug
> Environment: 5.5.3GA Designer on Linux
> Reporter: Greg Haber
> Assignee: Dan Florian
> Attachments: oracleTest_20081210_1.zip
>
>
> If an access pattern contains a nullable column (and this probably also holds for procedure input parameters), then Preview doesn't have an option to leave the value blank (to specify null). If you enter the string "null" into the field for that column, it will send the string "null". Not sure on how semantics of this should work (whether leaving the field blank should be the equivalent of specifying null, or whether we should use the string "null", or whether there should be a checkbox for saying that the value is null), so whatever makes sense.
> However regardless on how the UI works this should result in a WHERE colname IS NULL criteria in the resulting query.
> I know we aren't trying to tackle all edge cases with preview, but this is a common case with web service parameters (it is common to have required and nillable parameters).
> This one depends on JBEDSP-855 getting resolved first.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
16 years, 9 months