select sql error

Question

Question

wx fg · Jul 22, 2017

#Caché #SQL

hi

I execute sql like this: select * from DHC_PatBillDetails where PBD_PBO_ParRef>='2046121'

error message:

but the sql: select * from DHC_PatBillDetails where PBD_PBO_ParRef='2046121' can be executed successfully

why?

Discussion (5)1

Log in or sign up to continue

Brendan Bannon · Jul 22, 2017

This looks like a bug in InterSystems code. Can you please email this problem to the WRC: Support@intersystems.com

Please include this table, the parent table and the Version you are using.

1 0

Robert Cemper · Jul 22, 2017

If there is an index defined on PBD_PBO_ParRef is it correctly generated?
If not sure, do rebuild index from MgmtPortal.

2 0

score 0 · Answer 1 · 2017-07-23T23:08:30-04:00

there is no index on this column and I test for rebuilding all the index of this table but can't resolve this issue.

score 0 · Answer 2 · 2017-07-24T06:43:45-04:00

Did you open up an issue with the WRC as Brendan recommended? You should do this if you want this error fixed. You can do so by writing an email to support@intersystems.com. Please include your table definitions, including all parent/child references that you have (I suspect this is a grandchild table).

score 1 · Answer 3 · 2017-07-31T20:05:36-04:00

His,

It looks like the record you are trying to access does not conform to the global mapping of the class.

Make a comparison with the global data of a record that is returned in the query and with this one that is giving problem, so maybe you can see if there is any piece of record that returns error is in disagreement with the global mapping of the class.

Regards.