[Firebird-devel] [FB-Tracker] Created: (CORE-5987) String parameter works incorrect with "or" operator "arithmetic exception numeric overflow or string truncation"
String parameter works incorrect with "or" operator "arithmetic exception
numeric overflow or string truncation"
Key: CORE-5987
URL: http://tracker.firebirdsql.org/browse/CORE-5987
Project: Firebird Core
Issue Type: Bug
Components: API / Client Library
Affects Versions: 2.5.8
Environment: Windows 7
Reporter: Dmitry Lendel
Priority: Critical
CREATE TABLE TEST (
TEXT VARCHAR(10))
insert into test (text) values ('111')
select * from test where text=?text
With param value '12345678912345678' no errors
select * from test where (text=?text or text=?text)
With param value '12345678912345678'
Error message is "arithmetic exception numeric overflow or string truncation"
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5986) Incorrect evaluation of NULL IS [NOT] {FALSE | TRUE}
Incorrect evaluation of NULL IS [NOT] {FALSE | TRUE}
Key: CORE-5986
URL: http://tracker.firebirdsql.org/browse/CORE-5986
Project: Firebird Core
Issue Type: Bug
Reporter: Adriano dos Santos Fernandes
- NULL IS {FALSE | TRUE} should be FALSE, but Firebird gives NULL
- NULL IS NOT {FALSE | TRUE} should be TRUE, but Firebird gives NULL
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Services API validation differences
> But approaches are so different that both should be supported. Absolutely. I'm creating the implementation for isc_action_svc_validate right now. It was just my personal curiosity. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Services API validation differences
On 1/17/19 2:38 PM, Jiří Činčura wrote: I.e. isc_action_svc_repair is services frontend for gfix utility (needs exclusive DB access, can repair broken DB) but isc_action_svc_validate is used for online validation. OK, so both do validation (in case of isc_spb_rpr_validate_db), it's just different approach, right? Yes. But approaches are so different that both should be supported. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Negative value for isc_spb_val_lock_timeout
On 1/17/19 2:29 PM, Jiří Činčura wrote: Hi *, it looks server accepts negative values for isc_spb_val_lock_timeout. Is that expected? Any negative value means unlimited by timeout lock Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Services API validation differences
> I.e. isc_action_svc_repair is services frontend for gfix utility (needs > exclusive DB access, can repair broken DB) but isc_action_svc_validate > is used for online validation. OK, so both do validation (in case of isc_spb_rpr_validate_db), it's just different approach, right? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Services API validation differences
On 1/17/19 1:41 PM, Jiří Činčura wrote: Hi, what's the difference between isc_action_svc_repair + isc_spb_rpr_validate_db and isc_action_svc_validate? #define isc_action_svc_repair 3 /* Starts database repair process on the server */ #define isc_action_svc_validate 30 // Starts database online validation I.e. isc_action_svc_repair is services frontend for gfix utility (needs exclusive DB access, can repair broken DB) but isc_action_svc_validate is used for online validation. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Negative value for isc_spb_val_lock_timeout
Hi *, it looks server accepts negative values for isc_spb_val_lock_timeout. Is that expected? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Services API validation differences
Hi, what's the difference between isc_action_svc_repair + isc_spb_rpr_validate_db and isc_action_svc_validate? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
