[patch] Implement handling Firebird SQL_NULL data type
Original Reporter info from Mantis: luizamerico
-
Reporter name: Luiz Americo
Original Reporter info from Mantis: luizamerico
- Reporter name: Luiz Americo
Description:
Firebird introduced, in version 2.5, the SQL_NULL data type, when a param is checked if is NULL.
Its useful to create conditional sql expressions (see complete explanation of usage in 2.5 language update reference: https://firebirdsql.org/refdocs/langrefupd25-sqlnull.html and main language reference: https://firebirdsql.org/file/documentation/html/en/refdocs/fblangref25/firebird-25-language-reference.html#fblangref25-datatypes-special-sqlnull)
The patch just detects the SQL_NULL type and avoid allocating SQLData memory and throwing an error, since the other requirements (setting sqlind to 0 or -1 and SQLData to nil) are already done elsewhere.
I added a test. Enabled for Sqlite and Firebird but should work with other databases. I just did not have other databases to test.
Mantis conversion info:
- Mantis ID: 37646
- OS: Windows
- OS Build: 10
- Platform: i386
- Version: 3.3.1
- Fixed in version: 3.3.1
- Fixed in revision: 46756 (#24ea912f)
- Target version: 3.2.2