[Firebird-devel] [FB-Tracker] Created: (CORE-5987) String parameter works incorrect with "or" operator "arithmetic exception numeric overflow or string truncation"

[Dmitry Lendel (JIRA)]

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