Attachment 598527 Details for Bug 832816 – runLocalTest result.txt

runLocalTest result.txt

result.txt (text/plain), 48.50 KB, created by gil cattaneo on 2012-07-16 22:16:13 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: gil cattaneo

Created: 2012-07-16 22:16:13 UTC

Size: 48.50 KB

patch

obsolete

>Using JDBC Driver: com.mckoi.JDBCDriver
>Connection established to: jdbc:mckoi:local://./db.conf?create=true
>
>> CREATE TABLE AirCraft
>  (              id NUMERIC NOT NULL UNIQUE,
>               name VARCHAR(50),
>        description VARCHAR(9000000)
>  );
>+--------+
>| result |
>+--------+
>| 0      |
>+--------+
>
>> CREATE TABLE Customer
>  (              id NUMERIC NOT NULL UNIQUE,
>             number VARCHAR(50),
>               name VARCHAR(100),
>           address1 VARCHAR(250),
>           address2 VARCHAR(250),
>           address3 VARCHAR(250),
>           address4 VARCHAR(250)
>  );
>+--------+
>| result |
>+--------+
>| 0      |
>+--------+
>
>> CREATE TABLE Flight
>  (              id NUMERIC NOT NULL UNIQUE,
>             number VARCHAR(50),
>             "from" VARCHAR(150),
>               "to" VARCHAR(150),
>            departs VARCHAR(100),
>            arrives VARCHAR(100),
>        aircraft_id NUMERIC
>  );
>+--------+
>| result |
>+--------+
>| 0      |
>+--------+
>
>> CREATE TABLE Ticket
>  (              id NUMERIC NOT NULL UNIQUE,
>        customer_id NUMERIC,
>          flight_id NUMERIC,
>              price NUMERIC
>  );
>+--------+
>| result |
>+--------+
>| 0      |
>+--------+
>
>> CREATE TABLE BinaryTest
>  (              id NUMERIC NOT NULL UNIQUE,
>               name VARCHAR(250),
>         binary_col LONGVARBINARY,
>        binary_col2 LONGVARBINARY
>  );
>+--------+
>| result |
>+--------+
>| 0      |
>+--------+
>
>> CREATE TABLE MiscTest
>  (         test_col VARCHAR(250),
>            testcol2 VARCHAR(250)
>  );
>+--------+
>| result |
>+--------+
>| 0      |
>+--------+
>
>> CREATE TABLE DropTest ( test_col INTEGER );
>+--------+
>| result |
>+--------+
>| 0      |
>+--------+
>
>> DROP TABLE DropTest;
>+--------+
>| result |
>+--------+
>| 0      |
>+--------+
>
>> CREATE TABLE DropTest (
>            test_col VARCHAR(50),
>            test_col2 NUMERIC,
>            test_col3 VARCHAR(3000000)
>   );
>+--------+
>| result |
>+--------+
>| 0      |
>+--------+
>
>> DROP TABLE DropTest;
>+--------+
>| result |
>+--------+
>| 0      |
>+--------+
>
>> SHOW TABLES;
>+------------+-------------------------------------------------------+------------+
>| table_name | user_privs                                            | table_type |
>+------------+-------------------------------------------------------+------------+
>| AirCraft   | SELECT DELETE UPDATE INSERT REFERENCES USAGE COMPACT  | TABLE      |
>| BinaryTest | SELECT DELETE UPDATE INSERT REFERENCES USAGE COMPACT  | TABLE      |
>| Customer   | SELECT DELETE UPDATE INSERT REFERENCES USAGE COMPACT  | TABLE      |
>| Flight     | SELECT DELETE UPDATE INSERT REFERENCES USAGE COMPACT  | TABLE      |
>| MiscTest   | SELECT DELETE UPDATE INSERT REFERENCES USAGE COMPACT  | TABLE      |
>| Ticket     | SELECT DELETE UPDATE INSERT REFERENCES USAGE COMPACT  | TABLE      |
>+------------+-------------------------------------------------------+------------+
>
>> INSERT INTO BinaryTest
>       ( id, name, binary_col, binary_col2 )
>     VALUES
>       ( UNIQUEKEY('BinaryTest'), '\'Binary Test1\'', 'Is this stored as Binary?', 'Store this as binary please.' ),
>       ( UNIQUEKEY('BinaryTest'), '\'Binary Test2\'', 1000.43, 'Another test to see if this is stored as a binary.' )
>;
>+--------+
>| result |
>+--------+
>| 2      |
>+--------+
>
>> INSERT INTO MiscTest
>       ( test_col, testcol2 )
>     VALUES
>       ( 'test1', 'test2'  ),
>       ( 'test3', 'test4'  ),
>       ( 'A400', 'A200'    ),
>       ( 'A900', 'B433'    ),
>       ( 'D400', 'A200'    ),
>       ( 'U65900', 'B1433' ),
>       ( 'UA900', 'D'      ),
>       ( 'Z', ''           ),
>       ( '', 'C333'        )
>;
>+--------+
>| result |
>+--------+
>| 9      |
>+--------+
>
>> INSERT INTO MiscTest
>       ( testcol2 )
>     VALUES
>       ( 'JJII' ),
>       ( 'AFDD' )
>;
>+--------+
>| result |
>+--------+
>| 2      |
>+--------+
>
>> INSERT INTO AirCraft
>       ( id, name, description )
>     VALUES
>       ( UNIQUEKEY('AirCraft'), 'DC-10-A', 'DC-10 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-10-B', 'DC-10 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-10-C', 'DC-10 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-10-D', 'DC-10 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-10-E', 'DC-10 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-10-F', 'DC-10 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-10-G', 'DC-10 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-10-H', 'DC-10 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-10-I', 'DC-10 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-10-J', 'DC-10 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-10-K', 'DC-10 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-10-L', 'DC-10 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-10-M', 'DC-10 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-10-N', 'DC-10 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-10-O', 'DC-10 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-10-P', 'DC-10 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-12-A', 'DC-12 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-12-B', 'DC-12 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-12-C', 'DC-12 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-12-D', 'DC-12 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-12-E', 'DC-12 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-12-F', 'DC-12 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-12-Fa', 'DC-12 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-12-G', 'DC-12 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-12-H', 'DC-12 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-12-I', 'DC-12 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-12-J', 'DC-12 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-12-K', 'DC-12 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-12-L', 'DC-12 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-12-M', 'DC-12 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-12-N', 'DC-12 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-12-O', 'DC-12 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-12-Oa', 'DC-12 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'DC-12-P', 'DC-12 Passenger Plane' )
>;
>+--------+
>| result |
>+--------+
>| 34     |
>+--------+
>
>> INSERT INTO AirCraft
>       ( id, name, description )
>     VALUES
>       ( UNIQUEKEY('AirCraft'), 'AB0093-1', 'AB0093 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'AB0093-2', 'AB0093 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'AB0093-3', 'AB0093 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'AB0093-4', 'AB0093 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'AB0093-5', 'AB0093 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'AB0093-6', 'AB0093 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'AB0093-7', 'AB0093 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'AB0093-8', 'AB0093 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'AB0093-9', 'AB0093 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'AB0093-10', 'AB0093 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'AB0093-11', 'AB0093 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'AB0093-12', 'AB0093 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'AB0093-13', 'AB0093 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'AB0093-14', 'AB0093 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'AB0093-15', 'AB0093 Passenger Plane' ),
>       ( UNIQUEKEY('AirCraft'), 'AB0093-16', 'AB0093 Passenger Plane' )
>;
>+--------+
>| result |
>+--------+
>| 16     |
>+--------+
>
>> UPDATE AirCraft SET name = CONCAT(name, '-upd')
>     WHERE name LIKE 'DC-12-%'
>;
>+--------+
>| result |
>+--------+
>| 18     |
>+--------+
>
>> INSERT INTO Customer
>       ( id, number, name, address1, address2, address3, address4 )
>     VALUES
>       ( UNIQUEKEY('Customer'), CONCAT('0553', (id * 96), '-', ((id + 544) * 12)),
>            'Bobby Davis', '7 Main Road', '', '', '' ),
>       ( UNIQUEKEY('Customer'), CONCAT('0553', (id * 96), '-', ((id + 544) * 12)),
>            'Peter Lack', '19 Fredrickson Street', '', '', '' ),
>       ( UNIQUEKEY('Customer'), CONCAT('0553', (id * 96), '-', ((id + 544) * 12)),
>            'Bob Dobe', '911 Copitait Av.', '', '', '' ),
>       ( UNIQUEKEY('Customer'), CONCAT('0553', (id * 96), '-', ((id + 544) * 12)),
>            'Richard Daniel', '25 Broom Street', '', '', '' ),
>       ( UNIQUEKEY('Customer'), CONCAT('0553', (id * 96), '-', ((id + 544) * 12)),
>            'James Gresh', '1228 Davis Bv.', '', '', '' ),
>       ( UNIQUEKEY('Customer'), CONCAT('0553', (id * 96), '-', ((id + 544) * 12)),
>            'Ian Peterson', '9 Mig Flip St.', '', '', '' ),
>       ( UNIQUEKEY('Customer'), CONCAT('0553', (id * 96), '-', ((id + 544) * 12)),
>            'Tobias Downer', '96 Yemm Street', '', '', '' )
>;
>+--------+
>| result |
>+--------+
>| 7      |
>+--------+
>
>> INSERT INTO Flight
>       ( id, number, "from", "to", departs, arrives, aircraft_id )
>     VALUES
>       ( UNIQUEKEY('Flight'), 'EN-13', 'Manchester, England', 'Dublin, Ireland',
>         'September 1, 2001 13:15', 'September 1, 2001 15:20', 5 ),
>       ( UNIQUEKEY('Flight'), 'EN-15', 'Sheffield, England', 'Isle Of Wight, England',
>         'September 7, 2001 10:45', 'September 2, 2001 13:25', 8 ),
>       ( UNIQUEKEY('Flight'), 'KL-72', 'Paris, France', 'Tokyo, Japan',
>         'September 9, 2001 17:10', 'September 10, 2001 04:00', 13 ),
>       ( UNIQUEKEY('Flight'), 'DL-12', 'Melbourne, Australia', 'New York, USA',
>         'September 12, 2001 09:30', 'September 13, 2001 00:15', 15 ),
>       ( UNIQUEKEY('Flight'), 'WD-14', 'New York, USA', 'Amsterdam, Holland',
>         'September 13, 2001 00:45', 'September 13, 2001 11:10', 20 ),
>       ( UNIQUEKEY('Flight'), 'LL-90', 'Hong Kong, China', 'Calcutta, India',
>         'September 23, 2001 12:10', 'September 23, 2001 19:55', 3 ),
>       ( UNIQUEKEY('Flight'), 'DL-47', 'Cincinnati', 'London - Heathrow',
>         'October 2, 2001 02:15', 'October 2, 2001 11:15', 14 )
>;
>+--------+
>| result |
>+--------+
>| 7      |
>+--------+
>
>> INSERT INTO Ticket
>       ( id, customer_id, flight_id, price )
>     VALUES
>       ( UNIQUEKEY('Ticket'), 3, 2, 400.00 ),
>       ( UNIQUEKEY('Ticket'), 3, 1, 440.00 ),
>       ( UNIQUEKEY('Ticket'), 3, 3, 360.00 ),
>       ( UNIQUEKEY('Ticket'), 6, 2, 250.00 ),
>       ( UNIQUEKEY('Ticket'), 7, 1, 480.00 ),
>       ( UNIQUEKEY('Ticket'), 1, 4, 700.00 ),
>       ( UNIQUEKEY('Ticket'), 1, 5, 660.00 ),
>       ( UNIQUEKEY('Ticket'), 2, 7, 420.00 )
>;
>+--------+
>| result |
>+--------+
>| 8      |
>+--------+
>
>> SELECT * FROM AirCraft
>;
>+----+--------------+------------------------+
>| id | name         | description            |
>+----+--------------+------------------------+
>| 1  | DC-10-A      | DC-10 Passenger Plane  |
>| 2  | DC-10-B      | DC-10 Passenger Plane  |
>| 3  | DC-10-C      | DC-10 Passenger Plane  |
>| 4  | DC-10-D      | DC-10 Passenger Plane  |
>| 5  | DC-10-E      | DC-10 Passenger Plane  |
>| 6  | DC-10-F      | DC-10 Passenger Plane  |
>| 7  | DC-10-G      | DC-10 Passenger Plane  |
>| 8  | DC-10-H      | DC-10 Passenger Plane  |
>| 9  | DC-10-I      | DC-10 Passenger Plane  |
>| 10 | DC-10-J      | DC-10 Passenger Plane  |
>| 11 | DC-10-K      | DC-10 Passenger Plane  |
>| 12 | DC-10-L      | DC-10 Passenger Plane  |
>| 13 | DC-10-M      | DC-10 Passenger Plane  |
>| 14 | DC-10-N      | DC-10 Passenger Plane  |
>| 15 | DC-10-O      | DC-10 Passenger Plane  |
>| 16 | DC-10-P      | DC-10 Passenger Plane  |
>| 35 | AB0093-1     | AB0093 Passenger Plane |
>| 36 | AB0093-2     | AB0093 Passenger Plane |
>| 37 | AB0093-3     | AB0093 Passenger Plane |
>| 38 | AB0093-4     | AB0093 Passenger Plane |
>| 39 | AB0093-5     | AB0093 Passenger Plane |
>| 40 | AB0093-6     | AB0093 Passenger Plane |
>| 41 | AB0093-7     | AB0093 Passenger Plane |
>| 42 | AB0093-8     | AB0093 Passenger Plane |
>| 43 | AB0093-9     | AB0093 Passenger Plane |
>| 44 | AB0093-10    | AB0093 Passenger Plane |
>| 45 | AB0093-11    | AB0093 Passenger Plane |
>| 46 | AB0093-12    | AB0093 Passenger Plane |
>| 47 | AB0093-13    | AB0093 Passenger Plane |
>| 48 | AB0093-14    | AB0093 Passenger Plane |
>| 49 | AB0093-15    | AB0093 Passenger Plane |
>| 50 | AB0093-16    | AB0093 Passenger Plane |
>| 17 | DC-12-A-upd  | DC-12 Passenger Plane  |
>| 18 | DC-12-B-upd  | DC-12 Passenger Plane  |
>| 19 | DC-12-C-upd  | DC-12 Passenger Plane  |
>| 20 | DC-12-D-upd  | DC-12 Passenger Plane  |
>| 21 | DC-12-E-upd  | DC-12 Passenger Plane  |
>| 22 | DC-12-F-upd  | DC-12 Passenger Plane  |
>| 23 | DC-12-Fa-upd | DC-12 Passenger Plane  |
>| 24 | DC-12-G-upd  | DC-12 Passenger Plane  |
>| 25 | DC-12-H-upd  | DC-12 Passenger Plane  |
>| 26 | DC-12-I-upd  | DC-12 Passenger Plane  |
>| 27 | DC-12-J-upd  | DC-12 Passenger Plane  |
>| 28 | DC-12-K-upd  | DC-12 Passenger Plane  |
>| 29 | DC-12-L-upd  | DC-12 Passenger Plane  |
>| 30 | DC-12-M-upd  | DC-12 Passenger Plane  |
>| 31 | DC-12-N-upd  | DC-12 Passenger Plane  |
>| 32 | DC-12-O-upd  | DC-12 Passenger Plane  |
>| 33 | DC-12-Oa-upd | DC-12 Passenger Plane  |
>| 34 | DC-12-P-upd  | DC-12 Passenger Plane  |
>+----+--------------+------------------------+
>
>> SELECT * FROM AirCraft WHERE id < 0
>;
>+----+------+-------------+
>| id | name | description |
>+----+------+-------------+
>+----+------+-------------+
>
>> SELECT * FROM AirCraft WHERE id < 0 OR id > 1000
>;
>+----+------+-------------+
>| id | name | description |
>+----+------+-------------+
>+----+------+-------------+
>
>> SELECT CONCAT('a', 'BCD', 'EF', 1),
>          (5 + 10) * 20,
>          SIGN(-4333),
>          ROUND(4334.54493, 2),
>          LOWER('JIIKLDKF kfooeF'),
>          UPPER('kOFdsood oFpQQW'),
>          SUBSTRING('tubs', 0, 3)
>;
>+--------------------------+---------------+-------------+---------------------+--------------------------+--------------------------+-----------------------+
>| CONCAT('a','BCD','EF',1) | (5 + 10) * 20 | SIGN(-4333) | ROUND(4334.54493,2) | LOWER('JIIKLDKF kfooeF') | UPPER('kOFdsood oFpQQW') | SUBSTRING('tubs',0,3) |
>+--------------------------+---------------+-------------+---------------------+--------------------------+--------------------------+-----------------------+
>| aBCDEF1                  | 300           | -1          | 4334.54             | jiikldkf kfooef          | KOFDSOOD OFPQQW          | tub                   |
>+--------------------------+---------------+-------------+---------------------+--------------------------+--------------------------+-----------------------+
>
>> SELECT LEAST('a', 'b', 'A', 'B'),
>          GREATEST('h', 'H', 'l', 'L', '9', '3'),
>          LEAST(6, 8, 6, 3, 4, 1),
>          GREATEST(6, 8, 6, 3, 4, 1)
>;
>+------------------------+-----------------------------------+--------------------+-----------------------+
>| LEAST('a','b','A','B') | GREATEST('h','H','l','L','9','3') | LEAST(6,8,6,3,4,1) | GREATEST(6,8,6,3,4,1) |
>+------------------------+-----------------------------------+--------------------+-----------------------+
>| A                      | l                                 | 1                  | 8                     |
>+------------------------+-----------------------------------+--------------------+-----------------------+
>
>> SELECT TRIM(TRAILING 'a' FROM 'abbbbcaaaa'),
>          TRIM(LEADING 'a' FROM 'abbbbcaaaa'),
>          TRIM(BOTH 'a' FROM 'abbbbcaaaa'),
>          TRIM('abc' FROM 'abcabcabc'),
>          TRIM('abc' FROM 'abcabcababc'),
>          TRIM('ab' FROM 'abcabcababc'),
>          LTRIM('      yak   '),
>          RTRIM('      yak   '),
>          LENGTH(LTRIM('      yak   ')),
>          LENGTH(RTRIM('      yak   ')),
>          RTRIM('aaaaaayakaaa'),
>          TRIM('aaaaaayakaaa'),
>          TRIM('      yak   ')
>   ;
>+---------------------------------------+--------------------------------------+-----------------------------------+------------------------------------+--------------------------------------+-------------------------------------+-----------------------+-----------------------+-------------------------------+-------------------------------+-----------------------+-------------------------------------+-------------------------------------+
>| sql_trim('trailing','a','abbbbcaaaa') | sql_trim('leading','a','abbbbcaaaa') | sql_trim('both','a','abbbbcaaaa') | sql_trim('both','abc','abcabcabc') | sql_trim('both','abc','abcabcababc') | sql_trim('both','ab','abcabcababc') | LTRIM('      yak   ') | RTRIM('      yak   ') | LENGTH(LTRIM('      yak   ')) | LENGTH(RTRIM('      yak   ')) | RTRIM('aaaaaayakaaa') | sql_trim('both',' ','aaaaaayakaaa') | sql_trim('both',' ','      yak   ') |
>+---------------------------------------+--------------------------------------+-----------------------------------+------------------------------------+--------------------------------------+-------------------------------------+-----------------------+-----------------------+-------------------------------+-------------------------------+-----------------------+-------------------------------------+-------------------------------------+
>| abbbbc                                | bbbbcaaaa                            | bbbbc                             |                                    | ab                                   | cabcababc                           | yak                   |       yak             | 6                             | 12                            | aaaaaayakaaa          | aaaaaayakaaa                        | yak                                 |
>+---------------------------------------+--------------------------------------+-----------------------------------+------------------------------------+--------------------------------------+-------------------------------------+-----------------------+-----------------------+-------------------------------+-------------------------------+-----------------------+-------------------------------------+-------------------------------------+
>
>> SELECT *
>     FROM Customer
>;
>+----+--------------+----------------+-----------------------+----------+----------+----------+
>| id | number       | name           | address1              | address2 | address3 | address4 |
>+----+--------------+----------------+-----------------------+----------+----------+----------+
>| 1  | 055396-6540  | Bobby Davis    | 7 Main Road           |          |          |          |
>| 2  | 0553192-6552 | Peter Lack     | 19 Fredrickson Street |          |          |          |
>| 3  | 0553288-6564 | Bob Dobe       | 911 Copitait Av.      |          |          |          |
>| 4  | 0553384-6576 | Richard Daniel | 25 Broom Street       |          |          |          |
>| 5  | 0553480-6588 | James Gresh    | 1228 Davis Bv.        |          |          |          |
>| 6  | 0553576-6600 | Ian Peterson   | 9 Mig Flip St.        |          |          |          |
>| 7  | 0553672-6612 | Tobias Downer  | 96 Yemm Street        |          |          |          |
>+----+--------------+----------------+-----------------------+----------+----------+----------+
>
>> SELECT *
>     FROM BinaryTest
>;
>+----+----------------+------------+-------------+
>| id | name           | binary_col | binary_col2 |
>+----+----------------+------------+-------------+
>| 1  | 'Binary Test1' | [B@3a57aa  | [B@515a03   |
>| 2  | 'Binary Test2' | [B@ecb7a4  | [B@10c9c91  |
>+----+----------------+------------+-------------+
>
>> SELECT Customer.*, Ticket.price
>     FROM Customer, Ticket
>    WHERE Customer.id = Ticket.customer_id
>;
>+----+--------------+---------------+-----------------------+----------+----------+----------+--------+
>| id | number       | name          | address1              | address2 | address3 | address4 | price  |
>+----+--------------+---------------+-----------------------+----------+----------+----------+--------+
>| 1  | 055396-6540  | Bobby Davis   | 7 Main Road           |          |          |          | 700.00 |
>| 1  | 055396-6540  | Bobby Davis   | 7 Main Road           |          |          |          | 660.00 |
>| 2  | 0553192-6552 | Peter Lack    | 19 Fredrickson Street |          |          |          | 420.00 |
>| 3  | 0553288-6564 | Bob Dobe      | 911 Copitait Av.      |          |          |          | 400.00 |
>| 3  | 0553288-6564 | Bob Dobe      | 911 Copitait Av.      |          |          |          | 440.00 |
>| 3  | 0553288-6564 | Bob Dobe      | 911 Copitait Av.      |          |          |          | 360.00 |
>| 6  | 0553576-6600 | Ian Peterson  | 9 Mig Flip St.        |          |          |          | 250.00 |
>| 7  | 0553672-6612 | Tobias Downer | 96 Yemm Street        |          |          |          | 480.00 |
>+----+--------------+---------------+-----------------------+----------+----------+----------+--------+
>
>> SELECT Customer.name
>     FROM Customer
>    WHERE Customer.id IN ( SELECT customer_id FROM Ticket )
> ORDER BY Customer.name
>;
>+---------------+
>| name          |
>+---------------+
>| Bob Dobe      |
>| Bobby Davis   |
>| Ian Peterson  |
>| Peter Lack    |
>| Tobias Downer |
>+---------------+
>
>> SELECT Customer.name, Flight.number
>     FROM Customer LEFT OUTER JOIN Ticket ON Customer.id = Ticket.customer_id
>                   LEFT OUTER JOIN Flight ON Ticket.flight_id = Flight.id
> ORDER BY Customer.name
>;
>+----------------+--------+
>| name           | number |
>+----------------+--------+
>| Bob Dobe       | EN-13  |
>| Bob Dobe       | EN-15  |
>| Bob Dobe       | KL-72  |
>| Bobby Davis    | DL-12  |
>| Bobby Davis    | WD-14  |
>| Ian Peterson   | EN-15  |
>| James Gresh    | NULL   |
>| Peter Lack     | DL-47  |
>| Richard Daniel | NULL   |
>| Tobias Downer  | EN-13  |
>+----------------+--------+
>
>> SELECT Flight.number, Ticket.price
>     FROM Flight LEFT OUTER JOIN Ticket ON ( Flight.id = Ticket.flight_id )
> ORDER BY Flight.number
>;
>+--------+--------+
>| number | price  |
>+--------+--------+
>| DL-12  | 700.00 |
>| DL-47  | 420.00 |
>| EN-13  | 440.00 |
>| EN-13  | 480.00 |
>| EN-15  | 400.00 |
>| EN-15  | 250.00 |
>| KL-72  | 360.00 |
>| LL-90  | NULL   |
>| WD-14  | 660.00 |
>+--------+--------+
>
>> SELECT Flight.number, AVG(Ticket.price)
>     FROM Flight LEFT OUTER JOIN Ticket ON ( Flight.id = Ticket.flight_id )
> GROUP BY Flight.number
> ORDER BY Flight.number
>;
>+--------+-------------------+
>| number | AVG(Ticket.price) |
>+--------+-------------------+
>| DL-12  | 700.0000000000    |
>| DL-47  | 420.0000000000    |
>| EN-13  | 460.0000000000    |
>| EN-15  | 325.0000000000    |
>| KL-72  | 360.0000000000    |
>| LL-90  | NULL              |
>| WD-14  | 660.0000000000    |
>+--------+-------------------+
>
>> SHOW CONNECTIONS;
>+----------+---------------+-------------------------+-------------------------+
>| username | host_string   | last_command            | time_connected          |
>+----------+---------------+-------------------------+-------------------------+
>| test     | Local/Create/ | 2012-07-17 00:15:54.257 | 2012-07-17 00:15:53.139 |
>+----------+---------------+-------------------------+-------------------------+
>
>> SHOW STATUS;
>+-----------------------------------------------------------------------+---------+
>| name                                                                  | value   |
>+-----------------------------------------------------------------------+---------+
>| DataCellCache.avg_hash_get_mul_1000000                                | 1476196 |
>| DataCellCache.current_cache_size                                      | 134986  |
>| DataCellCache.current_node_count                                      | 1217    |
>| MasterTableDataSource.Hits.Delete.APP.AirCraft                        | 18      |
>| MasterTableDataSource.Hits.Delete.SYS_INFO.sUSRGrant                  | 2       |
>| MasterTableDataSource.Hits.Delete.SYS_INFO.sUSRSequenceInfo           | 2       |
>| MasterTableDataSource.Hits.Insert.APP.AirCraft                        | 68      |
>| MasterTableDataSource.Hits.Insert.APP.BinaryTest                      | 2       |
>| MasterTableDataSource.Hits.Insert.APP.Customer                        | 7       |
>| MasterTableDataSource.Hits.Insert.APP.Flight                          | 7       |
>| MasterTableDataSource.Hits.Insert.APP.MiscTest                        | 11      |
>| MasterTableDataSource.Hits.Insert.APP.Ticket                          | 8       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRDatabaseVars           | 1       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRFKeyInfo               | 3       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRForeignColumns         | 3       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRFunction               | 1       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRGrant                  | 77      |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRPKeyInfo               | 5       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRPassword               | 1       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRPrimaryColumns         | 5       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRSchemaInfo             | 3       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRSequenceInfo           | 27      |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRUniqueColumns          | 17      |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRUniqueInfo             | 12      |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRUserConnectPriv        | 2       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRUserPriv               | 1       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRView                   | 15      |
>| MasterTableDataSource.RootLocks.APP.AirCraft                          | 0       |
>| MasterTableDataSource.RootLocks.APP.BinaryTest                        | 0       |
>| MasterTableDataSource.RootLocks.APP.Customer                          | 0       |
>| MasterTableDataSource.RootLocks.APP.Flight                            | 0       |
>| MasterTableDataSource.RootLocks.APP.Ticket                            | 0       |
>| MasterTableDataSource.RootLocks.SYS_INFO.sUSRGrant                    | 0       |
>| MasterTableDataSource.RootLocks.SYS_INFO.sUSRPassword                 | 1       |
>| MultiVersionTableIndices.journal_entries.APP.AirCraft                 | 0       |
>| MultiVersionTableIndices.journal_entries.APP.BinaryTest               | 0       |
>| MultiVersionTableIndices.journal_entries.APP.Customer                 | 0       |
>| MultiVersionTableIndices.journal_entries.APP.Flight                   | 0       |
>| MultiVersionTableIndices.journal_entries.APP.MiscTest                 | 0       |
>| MultiVersionTableIndices.journal_entries.APP.Ticket                   | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRDatabaseVars    | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRFKeyInfo        | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRForeignColumns  | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRFunction        | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRGrant           | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRPKeyInfo        | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRPassword        | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRPrimaryColumns  | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRSchemaInfo      | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRSequenceInfo    | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRUniqueColumns   | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRUniqueInfo      | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRUserConnectPriv | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRUserPriv        | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRView            | 0       |
>| OpenTransactionList.count                                             | 1       |
>| Runtime.java.vendor: Oracle Corporation                               | 0       |
>| Runtime.java.version: 1.7.0_03-icedtea                                | 0       |
>| Runtime.java.vm.name: OpenJDK Server VM                               | 0       |
>| Runtime.memory.freeKB                                                 | 31695   |
>| Runtime.memory.totalKB                                                | 48512   |
>| Runtime.os.arch: i386                                                 | 0       |
>| Runtime.os.name: Linux                                                | 0       |
>| Runtime.os.version: 3.4.4-4.fc16.i686                                 | 0       |
>| Transaction.cleanup                                                   | 134     |
>| Transaction.count                                                     | 1       |
>+-----------------------------------------------------------------------+---------+
>
>> SHOW STATUS WHERE name LIKE 'IndexManager.column_accesses.%';
>+-----------------------------------------------------------------------+---------+
>| name                                                                  | value   |
>+-----------------------------------------------------------------------+---------+
>| DataCellCache.avg_hash_get_mul_1000000                                | 1476196 |
>| DataCellCache.current_cache_size                                      | 134986  |
>| DataCellCache.current_node_count                                      | 1217    |
>| MasterTableDataSource.Hits.Delete.APP.AirCraft                        | 18      |
>| MasterTableDataSource.Hits.Delete.SYS_INFO.sUSRGrant                  | 2       |
>| MasterTableDataSource.Hits.Delete.SYS_INFO.sUSRSequenceInfo           | 2       |
>| MasterTableDataSource.Hits.Insert.APP.AirCraft                        | 68      |
>| MasterTableDataSource.Hits.Insert.APP.BinaryTest                      | 2       |
>| MasterTableDataSource.Hits.Insert.APP.Customer                        | 7       |
>| MasterTableDataSource.Hits.Insert.APP.Flight                          | 7       |
>| MasterTableDataSource.Hits.Insert.APP.MiscTest                        | 11      |
>| MasterTableDataSource.Hits.Insert.APP.Ticket                          | 8       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRDatabaseVars           | 1       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRFKeyInfo               | 3       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRForeignColumns         | 3       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRFunction               | 1       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRGrant                  | 77      |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRPKeyInfo               | 5       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRPassword               | 1       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRPrimaryColumns         | 5       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRSchemaInfo             | 3       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRSequenceInfo           | 27      |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRUniqueColumns          | 17      |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRUniqueInfo             | 12      |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRUserConnectPriv        | 2       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRUserPriv               | 1       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRView                   | 15      |
>| MasterTableDataSource.RootLocks.APP.AirCraft                          | 0       |
>| MasterTableDataSource.RootLocks.APP.BinaryTest                        | 0       |
>| MasterTableDataSource.RootLocks.APP.Customer                          | 0       |
>| MasterTableDataSource.RootLocks.APP.Flight                            | 0       |
>| MasterTableDataSource.RootLocks.APP.Ticket                            | 0       |
>| MasterTableDataSource.RootLocks.SYS_INFO.sUSRGrant                    | 0       |
>| MasterTableDataSource.RootLocks.SYS_INFO.sUSRPassword                 | 1       |
>| MultiVersionTableIndices.journal_entries.APP.AirCraft                 | 0       |
>| MultiVersionTableIndices.journal_entries.APP.BinaryTest               | 0       |
>| MultiVersionTableIndices.journal_entries.APP.Customer                 | 0       |
>| MultiVersionTableIndices.journal_entries.APP.Flight                   | 0       |
>| MultiVersionTableIndices.journal_entries.APP.MiscTest                 | 0       |
>| MultiVersionTableIndices.journal_entries.APP.Ticket                   | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRDatabaseVars    | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRFKeyInfo        | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRForeignColumns  | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRFunction        | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRGrant           | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRPKeyInfo        | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRPassword        | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRPrimaryColumns  | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRSchemaInfo      | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRSequenceInfo    | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRUniqueColumns   | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRUniqueInfo      | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRUserConnectPriv | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRUserPriv        | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRView            | 0       |
>| OpenTransactionList.count                                             | 1       |
>| Runtime.java.vendor: Oracle Corporation                               | 0       |
>| Runtime.java.version: 1.7.0_03-icedtea                                | 0       |
>| Runtime.java.vm.name: OpenJDK Server VM                               | 0       |
>| Runtime.memory.freeKB                                                 | 31695   |
>| Runtime.memory.totalKB                                                | 48512   |
>| Runtime.os.arch: i386                                                 | 0       |
>| Runtime.os.name: Linux                                                | 0       |
>| Runtime.os.version: 3.4.4-4.fc16.i686                                 | 0       |
>| Transaction.cleanup                                                   | 135     |
>| Transaction.count                                                     | 1       |
>+-----------------------------------------------------------------------+---------+
>
>> SELECT * FROM MiscTest;
>+----------+----------+
>| test_col | testcol2 |
>+----------+----------+
>| test1    | test2    |
>| test3    | test4    |
>| A400     | A200     |
>| A900     | B433     |
>| D400     | A200     |
>| U65900   | B1433    |
>| UA900    | D        |
>| Z        |          |
>|          | C333     |
>| NULL     | JJII     |
>| NULL     | AFDD     |
>+----------+----------+
>
>> SELECT *
>     FROM MiscTest
>    WHERE test_col LIKE ''
>;
>+----------+----------+
>| test_col | testcol2 |
>+----------+----------+
>|          | C333     |
>+----------+----------+
>
>> SELECT *
>     FROM MiscTest
>    WHERE test_col LIKE 'A%'
>;
>+----------+----------+
>| test_col | testcol2 |
>+----------+----------+
>| A400     | A200     |
>| A900     | B433     |
>+----------+----------+
>
>> SELECT *
>     FROM MiscTest
>    WHERE test_col REGEX 'A.*'
>;
>+----------+----------+
>| test_col | testcol2 |
>+----------+----------+
>| A400     | A200     |
>| A900     | B433     |
>+----------+----------+
>
>> SELECT *
>     FROM MiscTest
>    WHERE test_col REGEX /.[0-9]*/
>;
>+----------+----------+
>| test_col | testcol2 |
>+----------+----------+
>| A400     | A200     |
>| A900     | B433     |
>| D400     | A200     |
>| U65900   | B1433    |
>| Z        |          |
>+----------+----------+
>
>> SELECT *
>     FROM MiscTest
>    WHERE test_col REGEX /.[0-9]*/ = true
>;
>+----------+----------+
>| test_col | testcol2 |
>+----------+----------+
>| A400     | A200     |
>| A900     | B433     |
>| D400     | A200     |
>| U65900   | B1433    |
>| Z        |          |
>+----------+----------+
>
>> SELECT *
>     FROM MiscTest
>    WHERE test_col REGEX /.[0-9]*/ = false
>;
>+----------+----------+
>| test_col | testcol2 |
>+----------+----------+
>| test1    | test2    |
>| test3    | test4    |
>| UA900    | D        |
>|          | C333     |
>+----------+----------+
>
>> SELECT * FROM MiscTest WHERE test_col IS NULL;
>+----------+----------+
>| test_col | testcol2 |
>+----------+----------+
>| NULL     | JJII     |
>| NULL     | AFDD     |
>+----------+----------+
>
>> SELECT * FROM MiscTest WHERE test_col IS NOT NULL;
>+----------+----------+
>| test_col | testcol2 |
>+----------+----------+
>|          | C333     |
>| A400     | A200     |
>| A900     | B433     |
>| D400     | A200     |
>| U65900   | B1433    |
>| UA900    | D        |
>| Z        |          |
>| test1    | test2    |
>| test3    | test4    |
>+----------+----------+
>
>> SELECT * FROM MiscTest WHERE test_col = NULL;
>+----------+----------+
>| test_col | testcol2 |
>+----------+----------+
>+----------+----------+
>
>> SELECT * FROM MiscTest WHERE test_col <> NULL;
>+----------+----------+
>| test_col | testcol2 |
>+----------+----------+
>+----------+----------+
>
>> SELECT * FROM MiscTest WHERE test_col >= NULL;
>+----------+----------+
>| test_col | testcol2 |
>+----------+----------+
>+----------+----------+
>
>> SELECT *, 1 / id = NULL FROM AirCraft WHERE description REGEX /dc.+/i ORDER BY 1 / id;
>+----+--------------+-----------------------+---------------+
>| id | name         | description           | 1 / id = NULL |
>+----+--------------+-----------------------+---------------+
>| 34 | DC-12-P-upd  | DC-12 Passenger Plane | NULL          |
>| 33 | DC-12-Oa-upd | DC-12 Passenger Plane | NULL          |
>| 32 | DC-12-O-upd  | DC-12 Passenger Plane | NULL          |
>| 31 | DC-12-N-upd  | DC-12 Passenger Plane | NULL          |
>| 30 | DC-12-M-upd  | DC-12 Passenger Plane | NULL          |
>| 29 | DC-12-L-upd  | DC-12 Passenger Plane | NULL          |
>| 28 | DC-12-K-upd  | DC-12 Passenger Plane | NULL          |
>| 27 | DC-12-J-upd  | DC-12 Passenger Plane | NULL          |
>| 26 | DC-12-I-upd  | DC-12 Passenger Plane | NULL          |
>| 25 | DC-12-H-upd  | DC-12 Passenger Plane | NULL          |
>| 24 | DC-12-G-upd  | DC-12 Passenger Plane | NULL          |
>| 23 | DC-12-Fa-upd | DC-12 Passenger Plane | NULL          |
>| 22 | DC-12-F-upd  | DC-12 Passenger Plane | NULL          |
>| 21 | DC-12-E-upd  | DC-12 Passenger Plane | NULL          |
>| 20 | DC-12-D-upd  | DC-12 Passenger Plane | NULL          |
>| 19 | DC-12-C-upd  | DC-12 Passenger Plane | NULL          |
>| 18 | DC-12-B-upd  | DC-12 Passenger Plane | NULL          |
>| 17 | DC-12-A-upd  | DC-12 Passenger Plane | NULL          |
>| 16 | DC-10-P      | DC-10 Passenger Plane | NULL          |
>| 15 | DC-10-O      | DC-10 Passenger Plane | NULL          |
>| 14 | DC-10-N      | DC-10 Passenger Plane | NULL          |
>| 13 | DC-10-M      | DC-10 Passenger Plane | NULL          |
>| 12 | DC-10-L      | DC-10 Passenger Plane | NULL          |
>| 11 | DC-10-K      | DC-10 Passenger Plane | NULL          |
>| 10 | DC-10-J      | DC-10 Passenger Plane | NULL          |
>| 9  | DC-10-I      | DC-10 Passenger Plane | NULL          |
>| 8  | DC-10-H      | DC-10 Passenger Plane | NULL          |
>| 7  | DC-10-G      | DC-10 Passenger Plane | NULL          |
>| 6  | DC-10-F      | DC-10 Passenger Plane | NULL          |
>| 5  | DC-10-E      | DC-10 Passenger Plane | NULL          |
>| 4  | DC-10-D      | DC-10 Passenger Plane | NULL          |
>| 3  | DC-10-C      | DC-10 Passenger Plane | NULL          |
>| 2  | DC-10-B      | DC-10 Passenger Plane | NULL          |
>| 1  | DC-10-A      | DC-10 Passenger Plane | NULL          |
>+----+--------------+-----------------------+---------------+
>
>> SELECT *, 1 / id AS inv FROM AirCraft ORDER BY inv;
>+----+--------------+------------------------+--------------+
>| id | name         | description            | inv          |
>+----+--------------+------------------------+--------------+
>| 50 | AB0093-16    | AB0093 Passenger Plane | 0.0200000000 |
>| 49 | AB0093-15    | AB0093 Passenger Plane | 0.0204081633 |
>| 48 | AB0093-14    | AB0093 Passenger Plane | 0.0208333333 |
>| 47 | AB0093-13    | AB0093 Passenger Plane | 0.0212765957 |
>| 46 | AB0093-12    | AB0093 Passenger Plane | 0.0217391304 |
>| 45 | AB0093-11    | AB0093 Passenger Plane | 0.0222222222 |
>| 44 | AB0093-10    | AB0093 Passenger Plane | 0.0227272727 |
>| 43 | AB0093-9     | AB0093 Passenger Plane | 0.0232558140 |
>| 42 | AB0093-8     | AB0093 Passenger Plane | 0.0238095238 |
>| 41 | AB0093-7     | AB0093 Passenger Plane | 0.0243902439 |
>| 40 | AB0093-6     | AB0093 Passenger Plane | 0.0250000000 |
>| 39 | AB0093-5     | AB0093 Passenger Plane | 0.0256410256 |
>| 38 | AB0093-4     | AB0093 Passenger Plane | 0.0263157895 |
>| 37 | AB0093-3     | AB0093 Passenger Plane | 0.0270270270 |
>| 36 | AB0093-2     | AB0093 Passenger Plane | 0.0277777778 |
>| 35 | AB0093-1     | AB0093 Passenger Plane | 0.0285714286 |
>| 34 | DC-12-P-upd  | DC-12 Passenger Plane  | 0.0294117647 |
>| 33 | DC-12-Oa-upd | DC-12 Passenger Plane  | 0.0303030303 |
>| 32 | DC-12-O-upd  | DC-12 Passenger Plane  | 0.0312500000 |
>| 31 | DC-12-N-upd  | DC-12 Passenger Plane  | 0.0322580645 |
>| 30 | DC-12-M-upd  | DC-12 Passenger Plane  | 0.0333333333 |
>| 29 | DC-12-L-upd  | DC-12 Passenger Plane  | 0.0344827586 |
>| 28 | DC-12-K-upd  | DC-12 Passenger Plane  | 0.0357142857 |
>| 27 | DC-12-J-upd  | DC-12 Passenger Plane  | 0.0370370370 |
>| 26 | DC-12-I-upd  | DC-12 Passenger Plane  | 0.0384615385 |
>| 25 | DC-12-H-upd  | DC-12 Passenger Plane  | 0.0400000000 |
>| 24 | DC-12-G-upd  | DC-12 Passenger Plane  | 0.0416666667 |
>| 23 | DC-12-Fa-upd | DC-12 Passenger Plane  | 0.0434782609 |
>| 22 | DC-12-F-upd  | DC-12 Passenger Plane  | 0.0454545455 |
>| 21 | DC-12-E-upd  | DC-12 Passenger Plane  | 0.0476190476 |
>| 20 | DC-12-D-upd  | DC-12 Passenger Plane  | 0.0500000000 |
>| 19 | DC-12-C-upd  | DC-12 Passenger Plane  | 0.0526315789 |
>| 18 | DC-12-B-upd  | DC-12 Passenger Plane  | 0.0555555556 |
>| 17 | DC-12-A-upd  | DC-12 Passenger Plane  | 0.0588235294 |
>| 16 | DC-10-P      | DC-10 Passenger Plane  | 0.0625000000 |
>| 15 | DC-10-O      | DC-10 Passenger Plane  | 0.0666666667 |
>| 14 | DC-10-N      | DC-10 Passenger Plane  | 0.0714285714 |
>| 13 | DC-10-M      | DC-10 Passenger Plane  | 0.0769230769 |
>| 12 | DC-10-L      | DC-10 Passenger Plane  | 0.0833333333 |
>| 11 | DC-10-K      | DC-10 Passenger Plane  | 0.0909090909 |
>| 10 | DC-10-J      | DC-10 Passenger Plane  | 0.1000000000 |
>| 9  | DC-10-I      | DC-10 Passenger Plane  | 0.1111111111 |
>| 8  | DC-10-H      | DC-10 Passenger Plane  | 0.1250000000 |
>| 7  | DC-10-G      | DC-10 Passenger Plane  | 0.1428571429 |
>| 6  | DC-10-F      | DC-10 Passenger Plane  | 0.1666666667 |
>| 5  | DC-10-E      | DC-10 Passenger Plane  | 0.2000000000 |
>| 4  | DC-10-D      | DC-10 Passenger Plane  | 0.2500000000 |
>| 3  | DC-10-C      | DC-10 Passenger Plane  | 0.3333333333 |
>| 2  | DC-10-B      | DC-10 Passenger Plane  | 0.5000000000 |
>| 1  | DC-10-A      | DC-10 Passenger Plane  | 1.0000000000 |
>+----+--------------+------------------------+--------------+
>
>> SHOW STATUS;
>+-----------------------------------------------------------------------+---------+
>| name                                                                  | value   |
>+-----------------------------------------------------------------------+---------+
>| DataCellCache.avg_hash_get_mul_1000000                                | 1548217 |
>| DataCellCache.current_cache_size                                      | 138760  |
>| DataCellCache.current_node_count                                      | 1299    |
>| MasterTableDataSource.Hits.Delete.APP.AirCraft                        | 18      |
>| MasterTableDataSource.Hits.Delete.SYS_INFO.sUSRGrant                  | 2       |
>| MasterTableDataSource.Hits.Delete.SYS_INFO.sUSRSequenceInfo           | 2       |
>| MasterTableDataSource.Hits.Insert.APP.AirCraft                        | 68      |
>| MasterTableDataSource.Hits.Insert.APP.BinaryTest                      | 2       |
>| MasterTableDataSource.Hits.Insert.APP.Customer                        | 7       |
>| MasterTableDataSource.Hits.Insert.APP.Flight                          | 7       |
>| MasterTableDataSource.Hits.Insert.APP.MiscTest                        | 11      |
>| MasterTableDataSource.Hits.Insert.APP.Ticket                          | 8       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRDatabaseVars           | 1       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRFKeyInfo               | 3       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRForeignColumns         | 3       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRFunction               | 1       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRGrant                  | 77      |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRPKeyInfo               | 5       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRPassword               | 1       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRPrimaryColumns         | 5       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRSchemaInfo             | 3       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRSequenceInfo           | 27      |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRUniqueColumns          | 17      |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRUniqueInfo             | 12      |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRUserConnectPriv        | 2       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRUserPriv               | 1       |
>| MasterTableDataSource.Hits.Insert.SYS_INFO.sUSRView                   | 15      |
>| MasterTableDataSource.RootLocks.APP.AirCraft                          | 0       |
>| MasterTableDataSource.RootLocks.APP.BinaryTest                        | 0       |
>| MasterTableDataSource.RootLocks.APP.Customer                          | 0       |
>| MasterTableDataSource.RootLocks.APP.Flight                            | 0       |
>| MasterTableDataSource.RootLocks.APP.MiscTest                          | 0       |
>| MasterTableDataSource.RootLocks.APP.Ticket                            | 0       |
>| MasterTableDataSource.RootLocks.SYS_INFO.sUSRGrant                    | 0       |
>| MasterTableDataSource.RootLocks.SYS_INFO.sUSRPassword                 | 1       |
>| MultiVersionTableIndices.journal_entries.APP.AirCraft                 | 0       |
>| MultiVersionTableIndices.journal_entries.APP.BinaryTest               | 0       |
>| MultiVersionTableIndices.journal_entries.APP.Customer                 | 0       |
>| MultiVersionTableIndices.journal_entries.APP.Flight                   | 0       |
>| MultiVersionTableIndices.journal_entries.APP.MiscTest                 | 0       |
>| MultiVersionTableIndices.journal_entries.APP.Ticket                   | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRDatabaseVars    | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRFKeyInfo        | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRForeignColumns  | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRFunction        | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRGrant           | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRPKeyInfo        | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRPassword        | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRPrimaryColumns  | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRSchemaInfo      | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRSequenceInfo    | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRUniqueColumns   | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRUniqueInfo      | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRUserConnectPriv | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRUserPriv        | 0       |
>| MultiVersionTableIndices.journal_entries.SYS_INFO.sUSRView            | 0       |
>| OpenTransactionList.count                                             | 1       |
>| Runtime.java.vendor: Oracle Corporation                               | 0       |
>| Runtime.java.version: 1.7.0_03-icedtea                                | 0       |
>| Runtime.java.vm.name: OpenJDK Server VM                               | 0       |
>| Runtime.memory.freeKB                                                 | 54209   |
>| Runtime.memory.totalKB                                                | 61248   |
>| Runtime.os.arch: i386                                                 | 0       |
>| Runtime.os.name: Linux                                                | 0       |
>| Runtime.os.version: 3.4.4-4.fc16.i686                                 | 0       |
>| Transaction.cleanup                                                   | 150     |
>| Transaction.count                                                     | 1       |
>+-----------------------------------------------------------------------+---------+
>
> --- FINISHED

Actions: View

Attachments on bug 832816: 598527