View Incident Report

Serious

Reported By: Elevate Software
Reported On: 8/31/2000
For: Version 2.03 Build 1

# 618 SQL CREATE TABLE Statement Creating Fields With Incorrect Lengths Sometimes

The SQL CREATE TABLE statement is creating string fields with incorrect lengths. The following SQL statement will create the last field as CHAR(12), not CHAR(13).

CREATE TABLE "bancos2.DAT" (
       "BANCO_KEY" FLOAT NOT NULL,
"CODIGO_BANCO" CHARACTER(30) NOT NULL,
       "NOME_BANCO" CHARACTER(50),
"NUMERO_BANCO" CHARACTER(5),
       NOCASE PRIMARY KEY ("BANCO_KEY") COMPRESS FULL
       LANGUAGE "Portuguese (Brazilian)" SORT "Default Order"
       ENCRYPTED WITH "xywz"
       USER MAJOR VERSION 2
       USER MINOR VERSION 5);

Resolution

Fixed Problem on 8/31/2000 in version 2.04 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap