× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
ranarohitp(*) reported 2015-07-20T06:57:46Z  · tariqrahiman last modified 2015-07-29T21:38:50Z

Can not create a table using system generated script.


Priority Low
Complexity Unknown
Component DB - Sap Hana
Version 17.0
Product: Aqua Data Studio
Version: 17.0.0-dev-83
Build #: 44787
Build Date: 2015-Jul-19 09:54:42 PM
 
Operating Environment: Linux (3.13.0-57-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_40-b26
Memory: Max=3,501,195,264;  Total=1,140,850,688;  Free=1,031,191,008;  CPUs=8
 
1. Connect to SAP Hana database.
2. Expand Schemas object folder.
3. Expand your own schema & go to Tables object folder.
4. Right click on Tables object folder & select "Create Table" option.
5. In Create Table window:
  -Enter Table name.
  -Add one column having FLOAT datatype, and set precision value as 10
  - Add one more column having datatype as INTEGER.
6. Go to preview sql tab, you will observe that following script will be generated:
     CREATE TABLE "ASHU"."test_script"  ( 
     "c1" FLOAT(10),
     "c2" INTEGER 
     )
7. Click on create button, a new table will be created.
8. Go to table tree node, select table test_script. Right click on it and select "Script Object to New Window As" CREATE.
9. System will generate a Create Script.
10. Now execute the given script, you will observe that it will throw an error message:
    - "SAP DBTech JDBC: [7]: feature not supported: cannot create row table having load unit: C1 ".
11. When we execute a system generated script, table should be created.System is generating a wrong create script which is not allowing us to create a table. 

 

1 attachment

Issue #13540

Closed
Fixed
Resolved 2015-07-21T16:34:07Z
 
 
Completion
No due date
Fixed Build v17.0.0-dev-85
No time estimate

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