Issue Details (XML | Word | Printable)

Key: CORE-5987
Type: Bug Bug
Status: Open Open
Priority: Critical Critical
Assignee: Unassigned
Reporter: Dmitry Lendel
Votes: 0
Watchers: 3
Operations

If you were logged in you would be able to see more operations.
Firebird Core

String parameter works incorrect with "or" operator "arithmetic exception numeric overflow or string truncation"

Created: 17/Jan/19 05:08 PM   Updated: 18/Jan/19 09:48 AM
Component/s: API / Client Library
Affects Version/s: 2.5.8
Fix Version/s: None

Environment: Windows 7

QA Status: No test


 Description  « Hide
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"

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Mark Rotteveel added a comment - 18/Jan/19 09:48 AM
text=?text is invalid syntax. Please provide a reproducible program or script and specify the language used.