The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

SQL Anywhere Personal Server Version 11.0.1.2276 dbunload generates the following ALTER TABLE for a proxy table that was originally created on a Version 9 catalog table.

FWIW this is probably a pretty obscure bug feature, but it does cause Application Profiling to choke stop when it tries to create a profiling database.

CREATE EXISTING TABLE "p001"."proxy_V9_SYSCONSTRAINT" (
    "constraint_id"                  unsigned int NOT NULL
   ,"table_id"                       unsigned int NOT NULL
   ,"column_id"                      unsigned int NULL
   ,"index_id"                       unsigned int NULL
   ,"fkey_id"                        smallint NULL
   ,"constraint_type"                char(1) NOT NULL
   ,"constraint_name"                char(128) NOT NULL
) AT 'p001..SYS.SYSCONSTRAINT' LOCAL ONLY
go

ALTER TABLE "p001"."proxy_V9_SYSCONSTRAINT"
    ADD UNIQUE ( "table_id","constraint_name" )
go

***** SQL error: Feature 'Alter remote table' not implemented

Note: I did not create the UNIQUE constraint (how could I?) but it exists in the V11 system tables. I think under certain circumstances the CREATE EXISTING TABLE command creates local thingies like this for some reason, perhaps performance. Since a proxy table has no rows, ever, a local constraint makes no sense except as a hint for cross-database queries... AFAIK.

This may open a can of worms for dbunload... just how is it SUPPOSED to add these hints to the reload sql file?

asked 20 Oct '10, 12:53

Breck%20Carter's gravatar image

Breck Carter
26.6k418575824
accept rate: 21%

edited 20 Oct '10, 13:00


Yup, it's a bug that needs to be fixed. We will open a case for the issue and get the problem resolved.

permanent link

answered 20 Oct '10, 18:43

Karim%20Khamis's gravatar image

Karim Khamis
5.6k53870
accept rate: 40%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×101

question asked: 20 Oct '10, 12:53

question was seen: 872 times

last updated: 20 Oct '10, 18:43