Hi! I have spotted a strange behaviour of SAP DB (7.3.0.40 on Windows XP) I have created some tables, then put indexes on them (with multiple columns and single columns). And then, I tried to add another table (let's say B) which references the column in one of the tables created earlier (let's say table A)(foreign key with delete cascade). It was executed successfully but although it seems to work properly when I try to make select from system tables like DOMAIN.FOREIGNKEYCOLUMNS I can see this foreign key, but it states, that it references totally different column from table A. What's more, in order to check this behaviour on another instance (in this case 7.3.0.40 on Linux Red Hat), whenether I try to execute SELECT * FROM "DOMAIN"."FOREIGNKEYCOLUMNS" I get the following error: General error;-9205 POS(1) System error: AK Catalog information not found:00000000000002A8006000.
The same error is raised with SELECT * FROM "DOMAIN"."SHOW_FOREIGN_KEY" Any hints? Best regards, Marcin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
