I don't recall the option, but it did install to a 5.1 directory. So all the existing processes need to point to the new toad.exe I presume.
There is one other issue. I've got a Teradata table set up to import raw data from a file TDP exports to. The table has an identity key set to no cycle so by default it generates the ID when one isn't present. If I attempt to load the table without including the ID TDP doesn't know what to do and the CPU spikes. So I included a ROW_NUM in the query output to make sure the ID exists and this gets written to a file and is unique. When I attempt to import the file it is encountering a duplication error and the rows specified in the error changes every time, yet the physical ID value is unique in the file that's being imported. The ID is just there to ensure there is duplication in the table, but it's still encountering problems when the PK is unique.
CREATE SET TABLE db.log_tmp ,FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
DEFAULT MERGEBLOCKRATIO
(
ID NUMBER(18,0) GENERATED ALWAYS AS IDENTITY (NO CYCLE),
USER_ID VARCHAR(255) CHARACTER SET Latin NOT CaseSpecific NOT NULL,
USER_GUID VARCHAR(100) CHARACTER SET Latin NOT CaseSpecific,
SERVER_NAME VARCHAR(255) CHARACTER SET Latin NOT CaseSpecific,
EVENT_NAME VARCHAR(100) CHARACTER SET Latin NOT CaseSpecific,
CREATE_DATE DATE Format 'yyyy-mm-dd' NOT NULL,
USER_PORTALS VARCHAR(100) CHARACTER SET Latin NOT CaseSpecific NOT NULL,
PROFILE_ID INTEGER NOT NULL
)
UNIQUE PRIMARY INDEX (ID)
