Subject How or Why Does this work and do ?
Author Uwe Oeder
I by accident mistyped an SQL query and it actually works on my Firebird
Final Release version. Just asking if this should be so and if yes what it
should do.

SELECT * FROM Country CountryAreaCode ;

Below is how the table should look like.

SQL> SHOW TABLE Country;
COUNTRYIDSQ INTEGER Not Null
COUNTRYNAME VARCHAR(50) Not Null
COUNTRYINTERNATIONLCODE VARCHAR(10) Not Null DEFAULT '00'
COUNTRYCODE VARCHAR(10) Not Null
COUNTRYAREACODE VARCHAR(10) Nullable
COUNTRYHELPNUMBER VARCHAR(8) Nullable
COUNTRYGMT FLOAT Not Null
CONSTRAINT INTEG_5:
Primary key (COUNTRYIDSQ)
CONSTRAINT INTEG_6:
Unique key (COUNTRYNAME)

Triggers on Table COUNTRY:
TRIGGENCOUNTRY, Sequence: 0, Type: BEFORE INSERT, Active