Submitted by: Stéphane Millien (smillien62)

Duplicates CORE1690

The command "SHOW TABLE <my_table>;" doesn't work with all tables from my database. Only on my linux server.
It works fine with "rdb$..." tables.
I have no problem with isql from my WinXP environment.

On linux (with PuTTY) :
SQL> set names UTF8;
SQL> connect localhost:photos-data user MILLIEN password ***;
Database: localhost:photos-data, User: MILLIEN
SQL> show table auteurs;
ID_AUTEUR (DOM_ID_AUTEUR) SMALLINT Not Null DEFAULT 0
AUTEUR (DOM_AUTEUR) VARCHAR(30) CHARACTER SET ISO8859_1 Not Null
COLLATE FR_FR
Statement failed, SQLCODE = -802
arithmetic exception, numeric overflow, or string truncation
Command error: show table auteurs
SQL>

On WinXP (with cmd.exe) on the same database :
SQL> set names DOS852;
SQL> connect victor:photos-data user millien password ***;
Database: victor:photos-data, User: millien
SQL> show table auteurs;
ID_AUTEUR (DOM_ID_AUTEUR) SMALLINT Not Null DEFAULT 0
AUTEUR (DOM_AUTEUR) VARCHAR(30) CHARACTER SET ISO8859_1 Not Null
COLLATE FR_FR
CONSTRAINT PK_AUTEURS:
Primary key (ID_AUTEUR) uses explicit ascending index IDX_PK_AUTEURS

Triggers on Table AUTEURS:
AUTEUR_AIU_10, Sequence: 10, Type: AFTER INSERT OR UPDATE, Active

--
Best regards,
Stéphane.