× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2016-09-06T00:45:52Z  · last modified 2016-09-09T16:21:50Z

Incorrect SQL for Temporary tables in Informix 12.1


customer request
Priority Major
Complexity Unknown
Component App - Visual Editing
Version 17.0
Version: 17.0.8
Build #: 50876
Build Date: 2016-Aug-19 06:31:39 PM
 
Incorrect SQL for Temporary tables in Informix 12.1
 
1. Navigate to Informix v12.1 at AWS ending with IP ..1.69
2. go to Create Table, enter a table name and column name
3. Go to Storage Tab and enable Temporary under Options
4. Click on Create button and you get an error "A syntax error has occurred."
 
In the Create Table UI for Informix when a temp table is created in Informix, the syntax is currently “CREATE GLOBAL TEMPORARY TABLE” 
The SQL should be “CREATE TEMP TABLE”
 
Notes
1. Does not occur in ADS v16. See attached screenshot
2. Broken between ADS v17.0.0-alpha-18 and Build #: 45264 and Build Date: 2015-Aug-14 09:56:30 PM   
and 
Works fine in 17.0.0-alpha-12 and Build #: 45182 and Build Date: 2015-Aug-11 10:15:08 AM

3. Broken between an informix checkin between Aug 14 2015 and Aug 11 2015

2 attachments

Issue #14672

Closed
Fixed
Resolved 2016-09-06T15:07:47Z
 
 
Completion
No due date
Fixed Build ADS 17.0.8-2
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017