{"issue":{"milestone":{"title":"0.9.4","open_issues":0,"created_at":"2011-12-30T02:11:04Z","creator":{"login":"dynamobi-build","id":1123017,"url":"https://api.github.com/users/dynamobi-build","avatar_url":"https://secure.gravatar.com/avatar/cb215b3d786be20761071a562a56af64?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"cb215b3d786be20761071a562a56af64"},"state":"closed","due_on":null,"closed_issues":5,"number":8,"description":null,"url":"https://api.github.com/repos/dynamobi/dynamobi/milestones/8"},"title":"[LDB-240] should allow dynamic parameter directly beneath IS NULL","created_at":"2011-12-30T02:11:41Z","user":{"login":"dynamobi-build","id":1123017,"url":"https://api.github.com/users/dynamobi-build","avatar_url":"https://secure.gravatar.com/avatar/cb215b3d786be20761071a562a56af64?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"cb215b3d786be20761071a562a56af64"},"labels":[{"name":"LDB","url":"https://api.github.com/repos/dynamobi/dynamobi/labels/LDB","color":"e2b9bd"}],"updated_at":"2011-12-30T02:11:43Z","state":"closed","id":2685224,"closed_at":"2011-12-30T02:11:42Z","html_url":"https://github.com/dynamobi/dynamobi/issues/83","pull_request":{"patch_url":null,"html_url":null,"diff_url":null},"body":"<b><i>[reporter=\"slawo\", created=\"Sun, 27 Feb 2011 16:42:37 -0500 (GMT-05:00)\"]</i></b>\nWhen binding variables in JDBC LucidDB seems to get the operator precedence differently. Consider the following setup:\n<br/>\n\n<br/>\nCREATE SCHEMA \"TEST\";\n<br/>\nCREATE TABLE TEST.DIM_TEST(\n<br/>\n    TEST_ID BIGINT GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY,\n<br/>\n    TEST VARCHAR(100)\n<br/>\n);\n<br/>\n\n<br/>\nSELECT TEST_ID FROM TEST.DIM_TEST WHERE ( ( TEST = ? ) OR ( TEST IS NULL AND ? IS NULL ) );\n<br/>\n\n<br/>\nNow if the string 'test value' is bound to both parameters,  the query will fail with the error: Value 'test value' cannot be converted to parameter of type BOOLEAN\n<br/>\n\n<br/>\nNote: The behavior is correct if the string is put verbatim into the query\n<br/>\n\n<br/>\nI'm attaching a self-contained PDI 4.x transformation that will show the behavior.\n<br/>\n\n<br/>\nCheers\n<br/>\n\n<br/>\nSlawo","number":83,"url":"https://api.github.com/repos/dynamobi/dynamobi/issues/83","comments":1,"assignee":null},"comment":{"created_at":"2011-12-30T02:11:43Z","user":{"login":"dynamobi-build","id":1123017,"url":"https://api.github.com/users/dynamobi-build","avatar_url":"https://secure.gravatar.com/avatar/cb215b3d786be20761071a562a56af64?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"cb215b3d786be20761071a562a56af64"},"updated_at":"2011-12-30T02:11:43Z","id":3308625,"body":"<b><i>[author=\"slawo\", created=\"Sun, 27 Feb 2011 16:43:10 -0500 (GMT-05:00)\"]</i></b>\nAttaching PDI 4.x transformation to test","url":"https://api.github.com/repos/dynamobi/dynamobi/issues/comments/3308625"},"action":"created"}