https://bugs.documentfoundation.org/show_bug.cgi?id=163996
--- Comment #5 from Robert Großkopf <[email protected]> --- Created attachment 197750 --> https://bugs.documentfoundation.org/attachment.cgi?id=197750&action=edit Same queries in internal HSQLDB - works Please test the second attachment: Internal HSQLDB. All queries will work well in internal HSQLDB. Only query for String_parameter will work well in Firebird. You have to CAST date and integer parameters to VARCHAR and the other 2 queries will work also. This is a special bug of Base GUI together with internal driver of Firebird. It isn't a bug of Firebird, because Firebird doesn't know anything about the parameter. If you try to execute a query with direct SQL in HSQLDB there won't appear any ask for parameter. GUI will cut the whole code for parameters before sending the query. If you try the same with direct SQL in Firebird also the dialog for parameter won't appear. But it will throw an error: firebird_sdbc error: *Dynamic SQL Error *SQL error code = -206 *Column unknown *QSTRING *At line 1, column 42 caused by 'isc_dsql_prepare' The GUI won't cut the Code and tries to send the whole code to Firebird, which doesn't work. So: This is a special bug of the internal Firebird driver of LO, not a bug of Firebird and not a bug of every database, because other drivers will work well. -- You are receiving this mail because: You are the assignee for the bug.
