#12526: Modifying existing SP in Informix gives "A syntax error has occurred."

tariqrahiman reported 2014-09-26T19:41:20Z · last modified 2014-11-10T08:44:54Z

Modifying existing SP in Informix gives "A syntax error has occurred."

Dev	deepalisalve
QA	tariqrahiman

Priority	Major
Complexity	Unknown

Component	Editor - Procedure
Version	15.0

Version: 15.0.7-9

Build #: 40378

Build Date: 2014-Sep-26 10:49:06 AM

Modifying existing SP in Informix gives "A syntax error has occurred."

1. Navigate to Informix Server 9.4 at 11.36

2. Go to multi database

3. Expand Procedures

4. Right click on proc_hello_world, select Alter Procedure and click Alter

5. You can see that you get error "A syntax error has occurred."

If you open SQL Log, you can see that the drop statement SQL is incorrect:

Drop PROCEDURE informix.proc_hello_world(varcha())

THis is broken since ADS v15

This works fine in ADS v14

This works fine in ADS v12

4 attachments

Screen Shot 2014-09-26 at 12.34.35 PM.png

2014-09-26T19:41:20Z

122 KB
Screen Shot 2014-09-26 at 12.37.17 PM.png

2014-09-26T19:41:20Z

99 KB
error.png

2014-11-07T12:18:53Z

104 KB
16.0.0-dev-30.png

2014-11-10T08:42:14Z

100 KB

All Comments (4) Change History

ivangron 2014-09-26T21:10:32Z

accidental use of || when && required on script param check.

Issue introduced by accident 1/7/2014 by me.

Now fixed

tariqrahiman 2014-09-26T22:41:33Z

Verified in ADS v15.0.7-10

deepalisalve 2014-11-07T12:18:37Z · (edited)

This issue is still present in ADS 16.0.0-dev-21 and patch 15.0.10
Please refer attached screenshot "error.png".

deepalisalve 2014-11-10T08:44:54Z · (edited)

Verified in Patch 15.0.10 and ADS 16.0.0-dev-30.
For user created stored procedures it works fine and for existing procedures we dont have DBA permission.
Refer screenshot "16.0.0-dev-30.png".

Search Tips

Aqua Data Studio / nhilam

Modifying existing SP in Informix gives "A syntax error has occurred."

4 attachments

Issue #12526

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Modifying existing SP in Informix gives "A syntax error has occurred."

4 attachments

Issue #12526

Completion