You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by Ян Программист <we...@gmail.com> on 2010/04/08 16:31:07 UTC
SHOW command in ij
I tried to use SHOW, but had following bug:
ij> show tables;
TABLE_SCHEM |TABLE_NAME |REMARKS
------------------------------------------------------------------------
SYS |SYSALIASES |
SYS |SYSCHECKS |
SYS |SYSCOLPERMS |
SYS |SYSCOLUMNS |
SYS |SYSCONGLOMERATES |
SYS |SYSCONSTRAINTS |
SYS |SYSDEPENDS |
SYS |SYSFILES |
SYS |SYSFOREIGNKEYS |
SYS |SYSKEYS |
SYS |SYSROLES |
SYS |SYSROUTINEPERMS |
SYS |SYSSCHEMAS |
SYS |SYSSTATEMENTS |
SYS |SYSSTATISTICS |
SYS |SYSTABLEPERMS |
SYS |SYSTABLES |
SYS |SYSTRIGGERS |
SYS |SYSVIEWS |
SYSIBM |SYSDUMMY1 |
APP |RESTAURANTS |
Выбрано строк: 21
ij> show indexes in RESTAURANTS;
ОШИБКА IJ: Не существует таблицы с именем null
ij> show indexes in restaurants;
ОШИБКА IJ: Не существует таблицы с именем null
Any suggestions? I haven't understood - is there no equivalent to EXPLAIN in
SQL syntax of Derby?!
About DERBY-3973. Here are my results:
....
CREATE TRIGGER TRIG2 AFTER DELETE ON FLIGHTS FOR EACH STATEMENT
INSERT INTO FLIGHTS_HISTORY (STATUS) VALUES ('INSERTED FROM TRIG2');
COMMIT;
Вставлено/обновлено/удалено строк: 0
ij> > > Вставлено/обновлено/удалено строк: 0
ij> ij> > > > > > > Вставлено/обновлено/удалено строк: 0
ij> > > Вставлено/обновлено/удалено строк: 0
ij> > > Вставлено/обновлено/удалено строк: 0
ij> > > Вставлено/обновлено/удалено строк: 0
ij> ij> > > > > > > > > > Вставлено/обновлено/удалено строк: 0
ij> > > Вставлено/обновлено/удалено строк: 0
ij> > > > > Вставлено/обновлено/удалено строк: 0
ij> ij> > > > > > > > > > > > > > Вставлено/обновлено/удалено строк: 0
ij> > Вставлено/обновлено/удалено строк: 0
ij> > Вставлено/обновлено/удалено строк: 0
ij> > > > Вставлено/обновлено/удалено строк: 0
ij> > > Вставлено/обновлено/удалено строк: 0
ij> ij> > > > > > > > > > Вставлено/обновлено/удалено строк: 0
ij> > > > > Вставлено/обновлено/удалено строк: 0
ij> > > > > > > Вставлено/обновлено/удалено строк: 0
ij> ij> > > > > > > > > > > Вставлено/обновлено/удалено строк: 0
ij> ij> > > > > > > > > > > > > > > Вставлено/обновлено/удалено строк: 0
ij> ij> > Вставлено/обновлено/удалено строк: 0
ij> > Вставлено/обновлено/удалено строк: 0
ij> select t.table_schem, t.table_name, c.column_name, c.type_name from
table( getTables( null, '%', '%' ) ) t, table( getColumns( null, '%', '%',
'%') ) c where c.table_schem = t.table_schem and c.table_name = t.table_name
and t.table_type = 'TABLE'
ij> > ;
TABLE_SCHEM
|TABLE_NAME
|COLUMN_NAME
|TYPE_NAME
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
APP
|AIRLINES
|AIRLINE
|CHAR
APP
|AIRLINES
|AIRLINE_FULL
|VARCHAR
APP
|AIRLINES
|BASIC_RATE
|DOUBLE
APP
|AIRLINES
|DISTANCE_DISCOUNT
|DOUBLE
APP
|AIRLINES
|BUSINESS_LEVEL_FACTOR
|DOUBLE
APP
|AIRLINES
|FIRSTCLASS_LEVEL_FACTOR
|DOUBLE
APP
|AIRLINES
|ECONOMY_SEATS
|INTEGER
APP
|AIRLINES
|BUSINESS_SEATS
|INTEGER
APP
|AIRLINES
|FIRSTCLASS_SEATS
|INTEGER
APP
|CITIES
|CITY_ID
|INTEGER
APP
|CITIES
|CITY_NAME
|VARCHAR
APP
|CITIES
|COUNTRY
|VARCHAR
APP
|CITIES
|AIRPORT
|VARCHAR
APP
|CITIES
|LANGUAGE
|VARCHAR
APP
|CITIES
|COUNTRY_ISO_CODE
|CHAR
APP
|COUNTRIES
|COUNTRY
|VARCHAR
APP
|COUNTRIES
|COUNTRY_ISO_CODE
|CHAR
APP
|COUNTRIES
|REGION
|VARCHAR
APP
|FLIGHTAVAILABILITY
|FLIGHT_ID
|CHAR
APP
|FLIGHTAVAILABILITY
|SEGMENT_NUMBER
|INTEGER
APP
|FLIGHTAVAILABILITY
|FLIGHT_DATE
|DATE
APP
|FLIGHTAVAILABILITY
|ECONOMY_SEATS_TAKEN
|INTEGER
APP
|FLIGHTAVAILABILITY
|BUSINESS_SEATS_TAKEN
|INTEGER
APP
|FLIGHTAVAILABILITY
|FIRSTCLASS_SEATS_TAKEN
|INTEGER
APP
|FLIGHTS
|FLIGHT_ID
|CHAR
APP
|FLIGHTS
|SEGMENT_NUMBER
|INTEGER
APP
|FLIGHTS
|ORIG_AIRPORT
|CHAR
APP
|FLIGHTS
|DEPART_TIME
|TIME
APP
|FLIGHTS
|DEST_AIRPORT
|CHAR
APP
|FLIGHTS
|ARRIVE_TIME
|TIME
APP
|FLIGHTS
|MEAL
|CHAR
APP
|FLIGHTS
|FLYING_TIME
|DOUBLE
APP
|FLIGHTS
|MILES
|INTEGER
APP
|FLIGHTS
|AIRCRAFT
|VARCHAR
APP
|FLIGHTS_HISTORY
|FLIGHT_ID
|CHAR
APP
|FLIGHTS_HISTORY
|SEGMENT_NUMBER
|INTEGER
APP
|FLIGHTS_HISTORY
|ORIG_AIRPORT
|CHAR
APP
|FLIGHTS_HISTORY
|DEPART_TIME
|TIME
APP
|FLIGHTS_HISTORY
|DEST_AIRPORT
|CHAR
APP
|FLIGHTS_HISTORY
|ARRIVE_TIME
|TIME
APP
|FLIGHTS_HISTORY
|MEAL
|CHAR
APP
|FLIGHTS_HISTORY
|FLYING_TIME
|DOUBLE
APP
|FLIGHTS_HISTORY
|MILES
|INTEGER
APP
|FLIGHTS_HISTORY
|AIRCRAFT
|VARCHAR
APP
|FLIGHTS_HISTORY
|STATUS
|VARCHAR
APP
|MAPS
|AREA
|DECIMAL
APP
|MAPS
|REGION
|VARCHAR
APP
|MAPS
|MAP_NAME
|VARCHAR
APP
|MAPS
|MAP_ID
|INTEGER
APP
|MAPS
|PHOTO_FORMAT
|VARCHAR
APP
|MAPS
|PICTURE
|BLOB
John
Re: SHOW command in ij
Posted by Ян Программист <we...@gmail.com>.
Man, that's it! Thanks. Here you are:
ij> show indexes from restaurants;
TABLE_NAME |COLUMN_NAME |NON_U&|TYPE|ASC&|CARDINA&|PAGES
----------------------------------------------------------------------------
Выбрано строк: 0
ij> describe restaurants;
COLUMN_NAME
|TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL&
------------------------------------------------------------------------------
ID |INTEGER |0 |10 |10 |NULL |NULL |YES
NAME |VARCHAR |NULL|NULL|20 |NULL |40 |YES
CITY |VARCHAR |NULL|NULL|50 |NULL |100 |YES
DESCRIBE command is what I needed. But I am a bit confused. COLUMN_DEF
appears to be NULL for all columns. ?! John
Re: SHOW command in ij
Posted by Ян Программист <we...@gmail.com>.
Yeap, but what is 'null' doing there?! Like it or not, it's a bug. A bad
exception description. Do you agree? John
Re: SHOW command in ij
Posted by Bryan Pendleton <bp...@gmail.com>.
> ij> show indexes in RESTAURANTS;
I think you want
show indexes from restaurants;
or possibly
describe restaurants;
The "in" syntax is used for showing tables/indexes in a different schema.
thanks,
bryan