#11960: Sybase ASE - Error is generate when we create table with segment 'system'.

kirtipbankar(*) reported 2014-04-28T12:34:42Z · last modified 2014-04-29T12:24:45Z

Sybase ASE - Error is generate when we create table with segment 'system'.

Dev	tariqrahiman
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	App - Visual Editing
Version	15.0

Aqua Data Studio 15.0.0-dev-252

Build #: 37537

Built on: 2014-Apr-25 04:30:08 PM

Operating Environment: Windows NT (unknown) (6.2, amd64) / Cp1252 / en / IN / Sun Microsystems Inc. 1.6.0_29-b11

Memory: Max=704,643,072; Total=296,943,616; Free=154,880,864; CPUs=8

Step to reproduce:-

1.Opened SQL log

2.Create table:

CREATE TABLE "dbo"."test_demo12" (

"c1" varchar(25) NULL,

"c2" varchar(25) NULL,

"c3" varchar(25) NULL

)

ON "system"

3.Go to storage tab,select segment 'system' from drop down list

4.Click on create button

Now you will observe that,Error is generate "Segment '"system"' does not exist."

When we create table with segment 'system' in ADS 15.0.0.dev-145, table is create successfully.

2 attachments

1.jpg

2014-04-28T12:34:42Z

517 KB
Screen Shot 2014-04-28 at 11.16.39 AM.png

2014-04-28T18:13:35Z

52 KB

All Comments (2) Change History

tariqrahiman 2014-04-28T18:17:30Z

See attached. See if segment named system is present in your Sybase ASE environment. Also when you ran the SQL on 15.0.0-dev-148 did you execute the same SQL ?

Does this occur in ADS 14 ? We have not done any changes since v14 on this.

kirtipbankar(*) 2014-04-29T12:24:45Z

Verified on ADS 14.0.11 it's working fine.
After ADS 15.0..dev-148 it is not working.

Search Tips

Aqua Data Studio / nhilam

Sybase ASE - Error is generate when we create table with segment 'system'.

2 attachments

Issue #11960

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Sybase ASE - Error is generate when we create table with segment 'system'.

2 attachments

Issue #11960

Completion