Login
[x]
Log in using an account from:
Fedora Account System
Red Hat Associate
Red Hat Customer
Or login using a Red Hat Bugzilla account
Forgot Password
Login:
Hide Forgot
Create an Account
Red Hat Bugzilla – Attachment 598527 Details for
Bug 832816
Review Request: mckoi - Open Source Java SQL Database
[?]
New
Simple Search
Advanced Search
My Links
Browse
Requests
Reports
Current State
Search
Tabular reports
Graphical reports
Duplicates
Other Reports
User Changes
Plotly Reports
Bug Status
Bug Severity
Non-Defaults
|
Product Dashboard
Help
Page Help!
Bug Writing Guidelines
What's new
Browser Support Policy
5.0.4.rh83 Release notes
FAQ
Guides index
User guide
Web Services
Contact
Legal
This site requires JavaScript to be enabled to function correctly, please enable it.
runLocalTest result.txt
result.txt (text/plain), 48.50 KB, created by
gil cattaneo
on 2012-07-16 22:16:13 UTC
(
hide
)
Description:
runLocalTest result.txt
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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 832816
: 598527