db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ян Программист <webautoma...@gmail.com>
Subject SHOW command in ij
Date Thu, 08 Apr 2010 14:31:07 GMT
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

Mime
View raw message