Article

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

« Go Back

Information

 
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 example.zip 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
Cause
The exact cause is not known at this time.
Resolution
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.
Workaround
Notes
References to other documentation:

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


Feedback
 
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