Project

General

Profile

Bug #9765

SQL cannot compare bigint with character varying

Added by Andreea Bârzu over 1 year ago. Updated over 1 year ago.

Status:
New
Priority:
Normal
Assignee:
-
Target version:
-
Start date:
Due date:
% Done:

0%

billable:
No
vendor_id:
GCD
case_num:
version_reported:
version_resolved:
reviewer:
production:
No
env_name:
topics:

mn.df (756 Bytes) Andreea Bârzu, 03/11/2025 10:52 AM

History

#1 Updated by Andreea Bârzu over 1 year ago

A testcase for this issue (with the attached .df):

create slnominal.
assign slnominal.slno-account = "6500" 
       slnominal.slno-type = "vat".
def var t as char.
t = 'for each slnominal where lookup (slnominal.slno-account, "6500") <> "".'.
def var q as handle.
create query q.
q:SET-BUFFERS(BUFFER slnominal:HANDLE).
q:QUERY-PREPARE(t).
q:query-open.
q:GET-NEXT().
message slnominal.slno-type.

This issue was first reported in #9688-9.

Also available in: Atom PDF