Procedure with SQL-89 SELECT COUNT(*) gets different MD5 value on each compile

« Go Back


Article Number000062739
EnvironmentProduct: OpenEdge
Version: All supported versions
OS: All supported platforms
Other: SQL-89, ABL
Question/Problem Description
Procedure with SQL-89 SELECT statement(s) gets different MD5 value on each compile.

Code did not change between compilations.

Different MD5 values are generated on each compile even if the code did not change.

Other embedded SQL statements also trigger this issue.
Steps to ReproduceAttached file contains code that demonstrates the issue.
It assumes a connection to a sports2000 database.
Clarifying Information
Error Message
Defect/Enhancement NumberDefect PSC00338899 / OCTA-3224
The exact cause is not known at this time.
None at this time.

Please note that embedded SQL is a deprecated feature since OpenEdge 10.0A (released in 2003). Customers are advised to replace SQL statements with the equivalent ABL code.
References to other documentation:

Progress article(s):
000032839, "Will SQL-89 syntax be supported in OpenEdge 10.x?"
Last Modified Date8/27/2018 11:38 AM

Did this article resolve your question/issue?


Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025