From: Mark R. <ma...@la...> - 2012-08-29 17:45:42
|
On 25-8-2012 11:49, Mark Rotteveel wrote: > I have a question about handling NULL in XSQLVAR: > > Is it required to have sqldata set to null, or is setting sqlind to -1 > sufficient? The reason I am asking is > http://tracker.firebirdsql.org/browse/JDBC-271. > > When doing "SELECT cast(? as varchar(1)) FROM rdb$database" with the > parameter set to NULL with sqldata being non-null and sqlind = -1, the > query will return an empty string. > > If on the other hand you do > INSERT INTO single_varchar (varcharcolumn) VALUES (?) > with the same parameter data, followed by: > SELECT varcharcolumn FROM single_varchar > > you will get NULL back. > > Is Jaybird doing it wrong and/or is this a bug with parameter handling > in Firebird when the parameter is part of the select fields? Can this be caused by http://tracker.firebirdsql.org/browse/CORE-3475? -- Mark Rotteveel |