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 Components: Data Preview Affects Versions: 6.0.0 Environment: 5.5.3GA Designer on Linux Reporter: Greg Haber Assignee: Dan Florian Fix For: 6.0.0 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.