DELETE fails from sqlcli but not from SQL Studio

[Robert Klemme]

Hi again,

I see this error:

sqlcli=> DELETE FROM cr_admin.ag_url
> WHERE NOT EXISTS (
>      SELECT urlid
>        FROM cr_admin.url_cleanup
>       WHERE cr_admin.url_cleanup.urlid = cr_admin.ag_url.urlid
> )
> \g
* -4008: Unknown user name/password combination SQLSTATE: 08004
sqlcli=>

MaxDB 7.5.00.18

11:42:09 [MaxDB]: sqlcli -v
SQLCLI version 7.5.0 BUILD 018-123-079-776, the MaxDB interactive terminal.
Copyright 2000-2004 by SAP AG.

SQL

DELETE FROM cr_admin.ag_url
WHERE NOT EXISTS (
     SELECT urlid
       FROM cr_admin.url_cleanup
      WHERE cr_admin.url_cleanup.urlid = cr_admin.ag_url.urlid
)

DDL

CREATE TABLE ag_url
(
   urlid       FIXED(9)      CONSTRAINT pk_url PRIMARY KEY,
   url         VARCHAR(640)  NOT NULL,
   method      VARCHAR(25)   NOT NULL,
   contenttype VARCHAR(64)   NULL,
   filetype    VARCHAR(25)   NULL,
   siteid      FIXED(9)      NULL,
   hostid      FIXED(9)      NULL
);

CREATE OR REPLACE VIEW url_cleanup (urlid)
AS
SELECT urlid
  FROM ag_hourlymaster
UNION ALL
SELECT referrerid
  FROM ag_hourlymaster
UNION ALL
SELECT urlid
  FROM ag_exactaccess
UNION ALL
SELECT urlid
  FROM ag_billing
UNION ALL
SELECT urlid
  FROM ag_exact_stream

Underlying tables exist and some have data in them.

Do you suggest I file a bug report?

Kind regards

robert

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]