Skip to main content

Search

Welcome to Tibero GTS!

Error 7080 Occurs When Changing Column Type

Document Type | Troubleshooting

Category | Administration/Configuration

Applicable Product Versions | 5SP1FS01, 5SP1FS02, 5SP1FS03, 5SP1FS04, 5SP1FS06, 6FS01, 6FS02,                                       6FS03, 6FS04, 6FS05, 6FS06, 6FS07

Error Code | 7080 

Document Number | TADTS001

 

Issue

This explains the 7080 error message that may occur when changing a column type.
Note
7080 error message: Specified column ‘ ’ must be empty before changing datatypes.
This issue is resolved in Tibero 7 FS02; for earlier versions, please refer to the solution below.
 

Tibero6 FS07_CS_2005

This can occur when changing a column type from Varchar(byte) to varchar(char).
SQL> create table t2 (c1 varchar(20 char));

Table 'T2' created.


SQL>
SQL> insert into t2 values('abcdefghij');


1 row inserted.


SQL> commit;


Commit completed.


SQL> alter table t2 modify(c1 varchar(1000 byte));
TBR-7080: Specified column 'T2'.'C1' must be empty before changing datatypes.

 

Cause

Tibero6 FS07_CS_2005 and earlier versions

This occurs when the character length semantics specified for a varchar column at table creation differ from those used when performing a modify column on that same column, and the table contains data.

 

Solutions

Change the column to use the same character length semantics as specified when the table was created.
 
The example solution below applies to the symptom example shown above.
alter table t2 modify(c1 varchar(1000 char));
>> Table 'T2' altered.
Note
This error does not occur if the table contains no data. 

 

 

 

Related to