Icon View Incident Report

Serious Serious
Reported By: Jon Lloyd Duerdoth
Reported On: 7/19/2000
For: Version 2.03 Build 1
# 605 SQL ALTER TABLE Statement Removes Encryption of Encrypted Tables

ALTER TABLE is removing the encryption from encrypted tables if the ENCRYPTED WITH clause is not present.


 SQLstr := 'Select * ' +
           '   into "new" ' +
           ' from "Funds"  ' +
           ' where FundYear = "1999" ' +
           ' order by FundID ' +
           ' encrypted with "xyz" ';
  with dbiqTable do begin  
    SQL.add(SQLstr);
    open;
    close;
    SQL.clear;
    SQLstr := 'Alter Table "new" ' +
              'add constraint "Dummy" PRIMARY KEY (FundID)';
    SQL.add(SQLstr);
    ExecSQL;
    end;



Comments Comments and Workarounds
The workaround is to always include the ENCRYPTED WITH clause.


Resolution Resolution
Fixed Problem on 7/20/2000 in version 2.04 build 1
Image