Changes of Revision 91
| [-] | Changed | cego.changes |
|
1 2 -------------------------------------------------------------------3 +Mon Feb 3 19:26:19 UTC 2014 - cs@linux-administrator.com4 +5 +- Update to version 2.20.3 6 +7 +-------------------------------------------------------------------8 Sun Jan 26 20:18:41 UTC 2014 - cs@linux-administrator.com9 10 - Update to version 2.20.111 |
||
| [-] | Changed | cego.spec ^ |
|
8 1 2 Name: cego3 -Version: 2.20.14 +Version: 2.20.35 Release: 16 Group: Productivity/Databases7 Summary: Cego relational database8 |
||
| [+] | Deleted | cego-2.20.1.tar.bz2/samples/chkdb/bla ^ |
| @@ -1,2766 +0,0 @@ -Table t1 does not exist -ok ( 0.000 s ) -Table t1 created -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -1 tuples inserted -ok ( 0.000 s ) -+-----------+ -| AGGR | -| count(*) | -+-----------+ -| 639 | -+-----------+ -ok ( 0.002 s ) -+-----------+ -| AGGR | -| count(*) | -+-----------+ -| 522 | -+-----------+ -ok ( 0.000 s ) -B Setting up post node for node 52 107 to value 52 108 -A Setting up post node for node 52 107 to value 52 110 -A Setting up post node for node 52 110 to value 52 108 -A Setting up post node for node 52 107 to value 52 111 -A Setting up post node for node 52 111 to value 52 110 -A Setting up post node for node 52 107 to value 52 112 -A Setting up post node for node 52 112 to value 52 111 - Setting postnode for 113 to 0 because i=4 and ne=4 -A Setting up post node for node 52 108 to value 52 113 -A Setting up post node for node 52 113 to value 0 0 -A Setting up post node for node 52 107 to value 52 114 -A Setting up post node for node 52 114 to value 52 112 -A Setting up post node for node 52 107 to value 52 115 -A Setting up post node for node 52 115 to value 52 114 -A Setting up post node for node 52 107 to value 52 116 -A Setting up post node for node 52 116 to value 52 115 -A Setting up post node for node 52 107 to value 52 117 -A Setting up post node for node 52 117 to value 52 116 -A Setting up post node for node 52 107 to value 52 118 -A Setting up post node for node 52 118 to value 52 117 -A Setting up post node for node 52 107 to value 52 119 -A Setting up post node for node 52 119 to value 52 118 -A Setting up post node for node 52 107 to value 52 120 -A Setting up post node for node 52 120 to value 52 119 - Setting postnode for 121 to 0 because i=12 and ne=12 -A Setting up post node for node 52 113 to value 52 121 -A Setting up post node for node 52 121 to value 0 0 -A Setting up post node for node 52 107 to value 52 122 -A Setting up post node for node 52 122 to value 52 120 -A Setting up post node for node 52 122 to value 52 123 -A Setting up post node for node 52 123 to value 52 120 -A Setting up post node for node 52 122 to value 52 124 -A Setting up post node for node 52 124 to value 52 123 -A Setting up post node for node 52 122 to value 52 125 -A Setting up post node for node 52 125 to value 52 124 -A Setting up post node for node 52 122 to value 52 126 -A Setting up post node for node 52 126 to value 52 125 -A Setting up post node for node 52 122 to value 52 127 -A Setting up post node for node 52 127 to value 52 126 -A Setting up post node for node 52 122 to value 52 128 -A Setting up post node for node 52 128 to value 52 127 -A Setting up post node for node 52 122 to value 52 131 -A Setting up post node for node 52 131 to value 52 128 -A Setting up post node for node 52 122 to value 52 132 -A Setting up post node for node 52 132 to value 52 131 -A Setting up post node for node 52 113 to value 52 133 -A Setting up post node for node 52 133 to value 52 121 -A Setting up post node for node 52 108 to value 52 134 -A Setting up post node for node 52 134 to value 52 113 -A Setting up post node for node 52 122 to value 52 135 -A Setting up post node for node 52 135 to value 52 132 -A Setting up post node for node 52 107 to value 52 136 -A Setting up post node for node 52 136 to value 52 122 -A Setting up post node for node 52 122 to value 52 137 -A Setting up post node for node 52 137 to value 52 135 -A Setting up post node for node 52 122 to value 52 138 -A Setting up post node for node 52 138 to value 52 137 -A Setting up post node for node 52 122 to value 52 139 -A Setting up post node for node 52 139 to value 52 138 - Setting postnode for 140 to 0 because i=12 and ne=12 -A Setting up post node for node 52 121 to value 52 140 -A Setting up post node for node 52 140 to value 0 0 -A Setting up post node for node 52 122 to value 52 141 -A Setting up post node for node 52 141 to value 52 139 -A Setting up post node for node 52 122 to value 52 142 -A Setting up post node for node 52 142 to value 52 141 -A Setting up post node for node 52 122 to value 52 143 -A Setting up post node for node 52 143 to value 52 142 -A Setting up post node for node 52 122 to value 52 145 -A Setting up post node for node 52 145 to value 52 143 -A Setting up post node for node 52 122 to value 52 146 -A Setting up post node for node 52 146 to value 52 145 -A Setting up post node for node 52 122 to value 52 147 -A Setting up post node for node 52 147 to value 52 146 -A Setting up post node for node 52 122 to value 52 148 -A Setting up post node for node 52 148 to value 52 147 -A Setting up post node for node 52 108 to value 52 149 -A Setting up post node for node 52 149 to value 52 134 -A Setting up post node for node 52 122 to value 52 150 -A Setting up post node for node 52 150 to value 52 148 -A Setting up post node for node 52 122 to value 52 151 -A Setting up post node for node 52 151 to value 52 150 -A Setting up post node for node 52 121 to value 52 152 -A Setting up post node for node 52 152 to value 52 140 -A Setting up post node for node 52 133 to value 52 153 -A Setting up post node for node 52 153 to value 52 121 -A Setting up post node for node 52 113 to value 52 154 -A Setting up post node for node 52 154 to value 52 133 -A Setting up post node for node 52 122 to value 52 155 -A Setting up post node for node 52 155 to value 52 151 -A Setting up post node for node 52 122 to value 52 156 -A Setting up post node for node 52 156 to value 52 155 -A Setting up post node for node 52 107 to value 52 157 -A Setting up post node for node 52 157 to value 52 136 -A Setting up post node for node 52 122 to value 52 158 -A Setting up post node for node 52 158 to value 52 156 -A Setting up post node for node 52 108 to value 52 160 -A Setting up post node for node 52 160 to value 52 149 -A Setting up post node for node 52 122 to value 52 161 -A Setting up post node for node 52 161 to value 52 158 -A Setting up post node for node 52 122 to value 52 162 -A Setting up post node for node 52 162 to value 52 161 -A Setting up post node for node 52 122 to value 52 163 -A Setting up post node for node 52 163 to value 52 162 -A Setting up post node for node 52 136 to value 52 164 -A Setting up post node for node 52 164 to value 52 122 -A Setting up post node for node 52 122 to value 52 165 -A Setting up post node for node 52 165 to value 52 163 -A Setting up post node for node 52 108 to value 52 166 -A Setting up post node for node 52 166 to value 52 160 -A Setting up post node for node 52 122 to value 52 167 -A Setting up post node for node 52 167 to value 52 165 -A Setting up post node for node 52 122 to value 52 168 -A Setting up post node for node 52 168 to value 52 167 -A Setting up post node for node 52 121 to value 52 169 -A Setting up post node for node 52 169 to value 52 152 -A Setting up post node for node 52 133 to value 52 171 -A Setting up post node for node 52 171 to value 52 153 -A Setting up post node for node 52 152 to value 52 172 -A Setting up post node for node 52 172 to value 52 140 -A Setting up post node for node 52 113 to value 52 173 -A Setting up post node for node 52 173 to value 52 154 -A Setting up post node for node 52 122 to value 52 174 -A Setting up post node for node 52 174 to value 52 168 -A Setting up post node for node 52 122 to value 52 175 -A Setting up post node for node 52 175 to value 52 174 -A Setting up post node for node 52 107 to value 52 176 -A Setting up post node for node 52 176 to value 52 157 -A Setting up post node for node 52 108 to value 52 178 -A Setting up post node for node 52 178 to value 52 166 -A Setting up post node for node 52 122 to value 52 179 -A Setting up post node for node 52 179 to value 52 175 -A Setting up post node for node 52 122 to value 52 180 -A Setting up post node for node 52 180 to value 52 179 -A Setting up post node for node 52 136 to value 52 181 -A Setting up post node for node 52 181 to value 52 164 -A Setting up post node for node 52 133 to value 52 182 -A Setting up post node for node 52 182 to value 52 171 -A Setting up post node for node 52 152 to value 52 183 -A Setting up post node for node 52 183 to value 52 172 -A Setting up post node for node 52 122 to value 52 184 -A Setting up post node for node 52 184 to value 52 180 -A Setting up post node for node 52 108 to value 52 185 -A Setting up post node for node 52 185 to value 52 178 -A Setting up post node for node 52 122 to value 52 186 -A Setting up post node for node 52 186 to value 52 184 -A Setting up post node for node 52 121 to value 52 187 -A Setting up post node for node 52 187 to value 52 169 -A Setting up post node for node 52 113 to value 52 188 -A Setting up post node for node 52 188 to value 52 173 -A Setting up post node for node 52 152 to value 52 189 -A Setting up post node for node 52 189 to value 52 183 -A Setting up post node for node 52 133 to value 52 190 -A Setting up post node for node 52 190 to value 52 182 -A Setting up post node for node 52 122 to value 52 192 -A Setting up post node for node 52 192 to value 52 186 -A Setting up post node for node 52 107 to value 52 193 -A Setting up post node for node 52 193 to value 52 176 -A Setting up post node for node 52 108 to value 52 194 -A Setting up post node for node 52 194 to value 52 185 -A Setting up post node for node 52 122 to value 52 195 -A Setting up post node for node 52 195 to value 52 192 -A Setting up post node for node 52 122 to value 52 196 -A Setting up post node for node 52 196 to value 52 195 -A Setting up post node for node 52 136 to value 52 197 -A Setting up post node for node 52 197 to value 52 181 -A Setting up post node for node 52 152 to value 52 199 -A Setting up post node for node 52 199 to value 52 189 -A Setting up post node for node 52 122 to value 52 200 -A Setting up post node for node 52 200 to value 52 196 -A Setting up post node for node 52 108 to value 52 201 -A Setting up post node for node 52 201 to value 52 194 -Dumping btree ... -Root Page is 52 130 -####### NODE ####### -NumEntries=7 FileId=52 PageId=130 -Child : 52,109 -Key 0 : 56 -Child : 52,198 -Key 1 : 56 -Child : 52,177 -Key 2 : 56 -Child : 52,159 -Key 3 : 56 -Child : 52,144 -Key 4 : 56 -Child : 52,129 -Key 5 : 75 -Child : 52,170 -Key 6 : 156 -Child : 52,191 -################## - ####### NODE ####### - NumEntries=11 FileId=52 PageId=109 - Child : 52,107 - Key 0 : 15 - Child : 52,193 - Key 1 : 15 - Child : 52,176 - Key 2 : 15 - Child : 52,157 - Key 3 : 15 - Child : 52,136 - Key 4 : 19 - Child : 52,197 - Key 5 : 19 - Child : 52,181 - Key 6 : 19 - Child : 52,164 - Key 7 : 19 - Child : 52,122 - Key 8 : 56 - Child : 52,200 - Key 9 : 56 - Child : 52,196 - Key 10 : 56 - Child : 52,195 - ################## - ------- LEAF ------- - NumEntries=12 FileId=52 PageId=107 - Entry 0 : 15 [52,3,200] - Entry 1 : 15 [52,8,164] - Entry 2 : 15 [52,13,20] - Entry 3 : 15 [52,26,20] - Entry 4 : 15 [52,95,200] - Entry 5 : 15 [52,100,200] - Entry 6 : 15 [52,105,200] - Entry 7 : 15 [52,103,92] - Entry 8 : 15 [52,98,92] - Entry 9 : 15 [52,78,92] - Entry 10 : 15 [52,83,92] - Entry 11 : 15 [52,88,92] - Next Page : 52 193 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=193 - Entry 0 : 15 [52,93,92] - Entry 1 : 15 [52,90,200] - Entry 2 : 15 [52,85,200] - Entry 3 : 15 [52,80,200] - Entry 4 : 15 [52,58,128] - Entry 5 : 15 [52,64,56] - Entry 6 : 15 [52,69,200] - Next Page : 52 176 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=176 - Entry 0 : 15 [52,75,128] - Entry 1 : 15 [52,72,164] - Entry 2 : 15 [52,67,20] - Entry 3 : 15 [52,61,92] - Entry 4 : 15 [52,35,20] - Entry 5 : 15 [52,41,164] - Entry 6 : 15 [52,50,20] - Next Page : 52 157 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=157 - Entry 0 : 15 [52,55,164] - Entry 1 : 15 [52,52,200] - Entry 2 : 15 [52,45,164] - Entry 3 : 15 [52,39,92] - Entry 4 : 15 [52,21,164] - Entry 5 : 15 [52,17,92] - Entry 6 : 15 [52,28,92] - Next Page : 52 136 - -------------------- - ------- LEAF ------- - NumEntries=9 FileId=52 PageId=136 - Entry 0 : 15 [52,32,164] - Entry 1 : 19 [52,31,200] - Entry 2 : 19 [52,25,56] - Entry 3 : 19 [52,20,200] - Entry 4 : 19 [52,102,128] - Entry 5 : 19 [52,105,20] - Entry 6 : 19 [52,85,20] - Entry 7 : 19 [52,90,20] - Entry 8 : 19 [52,95,20] - Next Page : 52 197 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=197 - Entry 0 : 19 [52,100,20] - Entry 1 : 19 [52,97,128] - Entry 2 : 19 [52,92,128] - Entry 3 : 19 [52,87,128] - Entry 4 : 19 [52,66,56] - Entry 5 : 19 [52,71,200] - Entry 6 : 19 [52,77,128] - Next Page : 52 181 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=181 - Entry 0 : 19 [52,82,128] - Entry 1 : 19 [52,80,20] - Entry 2 : 19 [52,74,164] - Entry 3 : 19 [52,69,20] - Entry 4 : 19 [52,38,128] - Entry 5 : 19 [52,52,20] - Entry 6 : 19 [52,57,164] - Next Page : 52 164 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=164 - Entry 0 : 19 [52,63,92] - Entry 1 : 19 [52,60,128] - Entry 2 : 19 [52,54,200] - Entry 3 : 19 [52,49,56] - Entry 4 : 19 [52,3,20] - Entry 5 : 19 [52,7,200] - Entry 6 : 19 [52,16,128] - Next Page : 52 122 - -------------------- - ------- LEAF ------- - NumEntries=9 FileId=52 PageId=122 - Entry 0 : 19 [52,12,56] - Entry 1 : 19 [52,7,20] - Entry 2 : 56 [52,17,164] - Entry 3 : 56 [52,18,20] - Entry 4 : 56 [52,104,128] - Entry 5 : 56 [52,106,92] - Entry 6 : 56 [52,101,164] - Entry 7 : 56 [52,102,20] - Entry 8 : 56 [52,104,20] - Next Page : 52 200 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=200 - Entry 0 : 56 [52,104,92] - Entry 1 : 56 [52,104,56] - Entry 2 : 56 [52,103,200] - Entry 3 : 56 [52,101,200] - Entry 4 : 56 [52,98,200] - Entry 5 : 56 [52,99,56] - Entry 6 : 56 [52,99,128] - Next Page : 52 196 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=196 - Entry 0 : 56 [52,101,128] - Entry 1 : 56 [52,101,92] - Entry 2 : 56 [52,99,92] - Entry 3 : 56 [52,99,20] - Entry 4 : 56 [52,94,92] - Entry 5 : 56 [52,96,92] - Entry 6 : 56 [52,96,164] - Next Page : 52 195 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=195 - Entry 0 : 56 [52,97,20] - Entry 1 : 56 [52,96,200] - Entry 2 : 56 [52,96,128] - Entry 3 : 56 [52,94,128] - Entry 4 : 56 [52,91,128] - Entry 5 : 56 [52,91,200] - Entry 6 : 56 [52,93,200] - Next Page : 52 192 - -------------------- - ####### NODE ####### - NumEntries=10 FileId=52 PageId=198 - Child : 52,195 - Key 0 : 56 - Child : 52,192 - Key 1 : 56 - Child : 52,186 - Key 2 : 56 - Child : 52,184 - Key 3 : 56 - Child : 52,180 - Key 4 : 56 - Child : 52,179 - Key 5 : 56 - Child : 52,175 - Key 6 : 56 - Child : 52,174 - Key 7 : 56 - Child : 52,168 - Key 8 : 56 - Child : 52,167 - Key 9 : 56 - Child : 52,165 - ################## - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=195 - Entry 0 : 56 [52,97,20] - Entry 1 : 56 [52,96,200] - Entry 2 : 56 [52,96,128] - Entry 3 : 56 [52,94,128] - Entry 4 : 56 [52,91,128] - Entry 5 : 56 [52,91,200] - Entry 6 : 56 [52,93,200] - Next Page : 52 192 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=192 - Entry 0 : 56 [52,94,56] - Entry 1 : 56 [52,94,20] - Entry 2 : 56 [52,92,20] - Entry 3 : 56 [52,91,164] - Entry 4 : 56 [52,87,20] - Entry 5 : 56 [52,89,20] - Entry 6 : 56 [52,89,92] - Next Page : 52 186 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=186 - Entry 0 : 56 [52,91,92] - Entry 1 : 56 [52,89,128] - Entry 2 : 56 [52,89,56] - Entry 3 : 56 [52,88,200] - Entry 4 : 56 [52,84,56] - Entry 5 : 56 [52,84,128] - Entry 6 : 56 [52,86,128] - Next Page : 52 184 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=184 - Entry 0 : 56 [52,86,200] - Entry 1 : 56 [52,86,164] - Entry 2 : 56 [52,86,92] - Entry 3 : 56 [52,84,92] - Entry 4 : 56 [52,81,92] - Entry 5 : 56 [52,81,164] - Entry 6 : 56 [52,82,20] - Next Page : 52 180 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=180 - Entry 0 : 56 [52,84,20] - Entry 1 : 56 [52,83,200] - Entry 2 : 56 [52,81,200] - Entry 3 : 56 [52,81,128] - Entry 4 : 56 [52,76,200] - Entry 5 : 56 [52,78,200] - Entry 6 : 56 [52,79,56] - Next Page : 52 179 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=179 - Entry 0 : 56 [52,79,128] - Entry 1 : 56 [52,79,92] - Entry 2 : 56 [52,79,20] - Entry 3 : 56 [52,77,20] - Entry 4 : 56 [52,75,164] - Entry 5 : 56 [52,76,20] - Entry 6 : 56 [52,76,92] - Next Page : 52 175 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=175 - Entry 0 : 56 [52,76,164] - Entry 1 : 56 [52,76,128] - Entry 2 : 56 [52,76,56] - Entry 3 : 56 [52,75,200] - Entry 4 : 56 [52,73,56] - Entry 5 : 56 [52,73,128] - Entry 6 : 56 [52,73,200] - Next Page : 52 174 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=174 - Entry 0 : 56 [52,74,56] - Entry 1 : 56 [52,74,20] - Entry 2 : 56 [52,73,164] - Entry 3 : 56 [52,73,92] - Entry 4 : 56 [52,70,164] - Entry 5 : 56 [52,71,20] - Entry 6 : 56 [52,71,92] - Next Page : 52 168 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=168 - Entry 0 : 56 [52,73,20] - Entry 1 : 56 [52,72,200] - Entry 2 : 56 [52,71,56] - Entry 3 : 56 [52,70,200] - Entry 4 : 56 [52,68,56] - Entry 5 : 56 [52,68,128] - Entry 6 : 56 [52,70,56] - Next Page : 52 167 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=167 - Entry 0 : 56 [52,70,128] - Entry 1 : 56 [52,70,92] - Entry 2 : 56 [52,70,20] - Entry 3 : 56 [52,68,92] - Entry 4 : 56 [52,65,164] - Entry 5 : 56 [52,67,92] - Entry 6 : 56 [52,67,164] - Next Page : 52 165 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=165 - Entry 0 : 56 [52,68,20] - Entry 1 : 56 [52,67,200] - Entry 2 : 56 [52,67,128] - Entry 3 : 56 [52,67,56] - Entry 4 : 56 [52,64,128] - Entry 5 : 56 [52,64,200] - Entry 6 : 56 [52,65,56] - Next Page : 52 163 - -------------------- - ####### NODE ####### - NumEntries=10 FileId=52 PageId=177 - Child : 52,165 - Key 0 : 56 - Child : 52,163 - Key 1 : 56 - Child : 52,162 - Key 2 : 56 - Child : 52,161 - Key 3 : 56 - Child : 52,158 - Key 4 : 56 - Child : 52,156 - Key 5 : 56 - Child : 52,155 - Key 6 : 56 - Child : 52,151 - Key 7 : 56 - Child : 52,150 - Key 8 : 56 - Child : 52,148 - Key 9 : 56 - Child : 52,147 - ################## - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=165 - Entry 0 : 56 [52,68,20] - Entry 1 : 56 [52,67,200] - Entry 2 : 56 [52,67,128] - Entry 3 : 56 [52,67,56] - Entry 4 : 56 [52,64,128] - Entry 5 : 56 [52,64,200] - Entry 6 : 56 [52,65,56] - Next Page : 52 163 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=163 - Entry 0 : 56 [52,65,128] - Entry 1 : 56 [52,65,92] - Entry 2 : 56 [52,65,20] - Entry 3 : 56 [52,64,164] - Entry 4 : 56 [52,62,20] - Entry 5 : 56 [52,62,92] - Entry 6 : 56 [52,62,164] - Next Page : 52 162 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=162 - Entry 0 : 56 [52,64,92] - Entry 1 : 56 [52,62,200] - Entry 2 : 56 [52,62,128] - Entry 3 : 56 [52,62,56] - Entry 4 : 56 [52,59,128] - Entry 5 : 56 [52,59,200] - Entry 6 : 56 [52,61,128] - Next Page : 52 161 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=161 - Entry 0 : 56 [52,61,200] - Entry 1 : 56 [52,61,164] - Entry 2 : 56 [52,60,20] - Entry 3 : 56 [52,59,164] - Entry 4 : 56 [52,57,20] - Entry 5 : 56 [52,58,164] - Entry 6 : 56 [52,59,20] - Next Page : 52 158 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=158 - Entry 0 : 56 [52,59,92] - Entry 1 : 56 [52,59,56] - Entry 2 : 56 [52,58,200] - Entry 3 : 56 [52,57,56] - Entry 4 : 56 [52,55,200] - Entry 5 : 56 [52,56,56] - Entry 6 : 56 [52,56,128] - Next Page : 52 156 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=156 - Entry 0 : 56 [52,56,200] - Entry 1 : 56 [52,56,164] - Entry 2 : 56 [52,56,92] - Entry 3 : 56 [52,56,20] - Entry 4 : 56 [52,53,92] - Entry 5 : 56 [52,53,164] - Entry 6 : 56 [52,54,20] - Next Page : 52 155 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=155 - Entry 0 : 56 [52,54,92] - Entry 1 : 56 [52,54,56] - Entry 2 : 56 [52,53,200] - Entry 3 : 56 [52,53,128] - Entry 4 : 56 [52,50,200] - Entry 5 : 56 [52,51,56] - Entry 6 : 56 [52,51,128] - Next Page : 52 151 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=151 - Entry 0 : 56 [52,53,56] - Entry 1 : 56 [52,53,20] - Entry 2 : 56 [52,51,92] - Entry 3 : 56 [52,51,20] - Entry 4 : 56 [52,48,164] - Entry 5 : 56 [52,49,20] - Entry 6 : 56 [52,50,92] - Next Page : 52 150 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=150 - Entry 0 : 56 [52,50,164] - Entry 1 : 56 [52,50,128] - Entry 2 : 56 [52,50,56] - Entry 3 : 56 [52,48,200] - Entry 4 : 56 [52,47,128] - Entry 5 : 56 [52,47,200] - Entry 6 : 56 [52,48,56] - Next Page : 52 148 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=148 - Entry 0 : 56 [52,48,128] - Entry 1 : 56 [52,48,92] - Entry 2 : 56 [52,48,20] - Entry 3 : 56 [52,47,164] - Entry 4 : 56 [52,46,92] - Entry 5 : 56 [52,46,164] - Entry 6 : 56 [52,47,20] - Next Page : 52 147 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=147 - Entry 0 : 56 [52,47,92] - Entry 1 : 56 [52,47,56] - Entry 2 : 56 [52,46,200] - Entry 3 : 56 [52,46,128] - Entry 4 : 56 [52,44,92] - Entry 5 : 56 [52,44,164] - Entry 6 : 56 [52,45,200] - Next Page : 52 146 - -------------------- - ####### NODE ####### - NumEntries=10 FileId=52 PageId=159 - Child : 52,147 - Key 0 : 56 - Child : 52,146 - Key 1 : 56 - Child : 52,145 - Key 2 : 56 - Child : 52,143 - Key 3 : 56 - Child : 52,142 - Key 4 : 56 - Child : 52,141 - Key 5 : 56 - Child : 52,139 - Key 6 : 56 - Child : 52,138 - Key 7 : 56 - Child : 52,137 - Key 8 : 56 - Child : 52,135 - Key 9 : 56 - Child : 52,132 - ################## - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=147 - Entry 0 : 56 [52,47,92] - Entry 1 : 56 [52,47,56] - Entry 2 : 56 [52,46,200] - Entry 3 : 56 [52,46,128] - Entry 4 : 56 [52,44,92] - Entry 5 : 56 [52,44,164] - Entry 6 : 56 [52,45,200] - Next Page : 52 146 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=146 - Entry 0 : 56 [52,46,56] - Entry 1 : 56 [52,46,20] - Entry 2 : 56 [52,44,200] - Entry 3 : 56 [52,44,128] - Entry 4 : 56 [52,43,56] - Entry 5 : 56 [52,43,128] - Entry 6 : 56 [52,43,200] - Next Page : 52 145 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=145 - Entry 0 : 56 [52,44,56] - Entry 1 : 56 [52,44,20] - Entry 2 : 56 [52,43,164] - Entry 3 : 56 [52,43,92] - Entry 4 : 56 [52,42,20] - Entry 5 : 56 [52,42,92] - Entry 6 : 56 [52,42,164] - Next Page : 52 143 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=143 - Entry 0 : 56 [52,43,20] - Entry 1 : 56 [52,42,200] - Entry 2 : 56 [52,42,128] - Entry 3 : 56 [52,42,56] - Entry 4 : 56 [52,39,164] - Entry 5 : 56 [52,40,20] - Entry 6 : 56 [52,40,92] - Next Page : 52 142 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=142 - Entry 0 : 56 [52,41,200] - Entry 1 : 56 [52,40,128] - Entry 2 : 56 [52,40,56] - Entry 3 : 56 [52,39,200] - Entry 4 : 56 [52,37,128] - Entry 5 : 56 [52,37,200] - Entry 6 : 56 [52,38,56] - Next Page : 52 141 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=141 - Entry 0 : 56 [52,39,128] - Entry 1 : 56 [52,38,92] - Entry 2 : 56 [52,38,20] - Entry 3 : 56 [52,37,164] - Entry 4 : 56 [52,36,92] - Entry 5 : 56 [52,36,164] - Entry 6 : 56 [52,37,20] - Next Page : 52 139 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=139 - Entry 0 : 56 [52,37,92] - Entry 1 : 56 [52,37,56] - Entry 2 : 56 [52,36,200] - Entry 3 : 56 [52,36,128] - Entry 4 : 56 [52,35,56] - Entry 5 : 56 [52,35,128] - Entry 6 : 56 [52,35,200] - Next Page : 52 138 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=138 - Entry 0 : 56 [52,36,56] - Entry 1 : 56 [52,36,20] - Entry 2 : 56 [52,35,164] - Entry 3 : 56 [52,35,92] - Entry 4 : 56 [52,32,200] - Entry 5 : 56 [52,33,56] - Entry 6 : 56 [52,33,128] - Next Page : 52 137 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=137 - Entry 0 : 56 [52,33,200] - Entry 1 : 56 [52,33,164] - Entry 2 : 56 [52,33,92] - Entry 3 : 56 [52,33,20] - Entry 4 : 56 [52,30,164] - Entry 5 : 56 [52,31,20] - Entry 6 : 56 [52,31,92] - Next Page : 52 135 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=135 - Entry 0 : 56 [52,31,164] - Entry 1 : 56 [52,31,128] - Entry 2 : 56 [52,31,56] - Entry 3 : 56 [52,30,200] - Entry 4 : 56 [52,29,128] - Entry 5 : 56 [52,29,200] - Entry 6 : 56 [52,30,56] - Next Page : 52 132 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=132 - Entry 0 : 56 [52,30,128] - Entry 1 : 56 [52,30,92] - Entry 2 : 56 [52,30,20] - Entry 3 : 56 [52,29,164] - Entry 4 : 56 [52,27,56] - Entry 5 : 56 [52,28,164] - Entry 6 : 56 [52,29,20] - Next Page : 52 131 - -------------------- - ####### NODE ####### - NumEntries=10 FileId=52 PageId=144 - Child : 52,132 - Key 0 : 56 - Child : 52,131 - Key 1 : 56 - Child : 52,128 - Key 2 : 56 - Child : 52,127 - Key 3 : 56 - Child : 52,126 - Key 4 : 56 - Child : 52,125 - Key 5 : 56 - Child : 52,124 - Key 6 : 56 - Child : 52,123 - Key 7 : 56 - Child : 52,120 - Key 8 : 56 - Child : 52,119 - Key 9 : 56 - Child : 52,118 - ################## - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=132 - Entry 0 : 56 [52,30,128] - Entry 1 : 56 [52,30,92] - Entry 2 : 56 [52,30,20] - Entry 3 : 56 [52,29,164] - Entry 4 : 56 [52,27,56] - Entry 5 : 56 [52,28,164] - Entry 6 : 56 [52,29,20] - Next Page : 52 131 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=131 - Entry 0 : 56 [52,29,92] - Entry 1 : 56 [52,29,56] - Entry 2 : 56 [52,28,200] - Entry 3 : 56 [52,28,128] - Entry 4 : 56 [52,25,20] - Entry 5 : 56 [52,26,92] - Entry 6 : 56 [52,26,164] - Next Page : 52 128 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=128 - Entry 0 : 56 [52,27,20] - Entry 1 : 56 [52,26,200] - Entry 2 : 56 [52,26,128] - Entry 3 : 56 [52,26,56] - Entry 4 : 56 [52,23,200] - Entry 5 : 56 [52,24,56] - Entry 6 : 56 [52,24,128] - Next Page : 52 127 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=127 - Entry 0 : 56 [52,24,200] - Entry 1 : 56 [52,24,164] - Entry 2 : 56 [52,24,92] - Entry 3 : 56 [52,24,20] - Entry 4 : 56 [52,22,164] - Entry 5 : 56 [52,23,20] - Entry 6 : 56 [52,23,92] - Next Page : 52 126 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=126 - Entry 0 : 56 [52,23,164] - Entry 1 : 56 [52,23,128] - Entry 2 : 56 [52,23,56] - Entry 3 : 56 [52,22,200] - Entry 4 : 56 [52,20,128] - Entry 5 : 56 [52,21,200] - Entry 6 : 56 [52,22,56] - Next Page : 52 125 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=125 - Entry 0 : 56 [52,22,128] - Entry 1 : 56 [52,22,92] - Entry 2 : 56 [52,22,20] - Entry 3 : 56 [52,20,164] - Entry 4 : 56 [52,19,92] - Entry 5 : 56 [52,19,164] - Entry 6 : 56 [52,20,20] - Next Page : 52 124 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=124 - Entry 0 : 56 [52,20,92] - Entry 1 : 56 [52,20,56] - Entry 2 : 56 [52,19,200] - Entry 3 : 56 [52,19,128] - Entry 4 : 56 [52,18,56] - Entry 5 : 56 [52,18,128] - Entry 6 : 56 [52,18,200] - Next Page : 52 123 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=123 - Entry 0 : 56 [52,19,56] - Entry 1 : 56 [52,19,20] - Entry 2 : 56 [52,18,164] - Entry 3 : 56 [52,18,92] - Entry 4 : 56 [52,17,200] - Entry 5 : 56 [52,17,128] - Entry 6 : 56 [52,16,92] - Next Page : 52 120 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=120 - Entry 0 : 56 [52,16,56] - Entry 1 : 56 [52,16,20] - Entry 2 : 56 [52,15,128] - Entry 3 : 56 [52,15,164] - Entry 4 : 56 [52,15,200] - Entry 5 : 56 [52,15,92] - Entry 6 : 56 [52,15,56] - Next Page : 52 119 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=119 - Entry 0 : 56 [52,15,20] - Entry 1 : 56 [52,14,200] - Entry 2 : 56 [52,14,92] - Entry 3 : 56 [52,14,128] - Entry 4 : 56 [52,14,164] - Entry 5 : 56 [52,14,56] - Entry 6 : 56 [52,14,20] - Next Page : 52 118 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=118 - Entry 0 : 56 [52,13,200] - Entry 1 : 56 [52,13,164] - Entry 2 : 56 [52,13,56] - Entry 3 : 56 [52,13,92] - Entry 4 : 56 [52,13,128] - Entry 5 : 56 [52,11,92] - Entry 6 : 56 [52,11,164] - Next Page : 52 117 - -------------------- - ####### NODE ####### - NumEntries=13 FileId=52 PageId=129 - Child : 52,118 - Key 0 : 56 - Child : 52,117 - Key 1 : 56 - Child : 52,116 - Key 2 : 56 - Child : 52,115 - Key 3 : 56 - Child : 52,114 - Key 4 : 56 - Child : 52,112 - Key 5 : 56 - Child : 52,111 - Key 6 : 56 - Child : 52,110 - Key 7 : 56 - Child : 52,108 - Key 8 : 75 - Child : 52,201 - Key 9 : 75 - Child : 52,194 - Key 10 : 75 - Child : 52,185 - Key 11 : 75 - Child : 52,178 - Key 12 : 75 - Child : 52,166 - ################## - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=118 - Entry 0 : 56 [52,13,200] - Entry 1 : 56 [52,13,164] - Entry 2 : 56 [52,13,56] - Entry 3 : 56 [52,13,92] - Entry 4 : 56 [52,13,128] - Entry 5 : 56 [52,11,92] - Entry 6 : 56 [52,11,164] - Next Page : 52 117 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=117 - Entry 0 : 56 [52,12,20] - Entry 1 : 56 [52,11,200] - Entry 2 : 56 [52,11,128] - Entry 3 : 56 [52,11,56] - Entry 4 : 56 [52,10,56] - Entry 5 : 56 [52,11,20] - Entry 6 : 56 [52,10,128] - Next Page : 52 116 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=116 - Entry 0 : 56 [52,10,200] - Entry 1 : 56 [52,10,164] - Entry 2 : 56 [52,10,92] - Entry 3 : 56 [52,10,20] - Entry 4 : 56 [52,9,20] - Entry 5 : 56 [52,9,200] - Entry 6 : 56 [52,9,92] - Next Page : 52 115 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=115 - Entry 0 : 56 [52,9,164] - Entry 1 : 56 [52,9,128] - Entry 2 : 56 [52,9,56] - Entry 3 : 56 [52,8,200] - Entry 4 : 56 [52,0,20] - Entry 5 : 56 [52,0,56] - Entry 6 : 56 [52,6,128] - Next Page : 52 114 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=114 - Entry 0 : 56 [52,7,128] - Entry 1 : 56 [52,7,164] - Entry 2 : 56 [52,6,200] - Entry 3 : 56 [52,6,164] - Entry 4 : 56 [52,5,92] - Entry 5 : 56 [52,5,164] - Entry 6 : 56 [52,6,20] - Next Page : 52 112 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=112 - Entry 0 : 56 [52,6,92] - Entry 1 : 56 [52,6,56] - Entry 2 : 56 [52,5,200] - Entry 3 : 56 [52,5,128] - Entry 4 : 56 [52,4,56] - Entry 5 : 56 [52,4,128] - Entry 6 : 56 [52,4,200] - Next Page : 52 111 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=111 - Entry 0 : 56 [52,5,56] - Entry 1 : 56 [52,5,20] - Entry 2 : 56 [52,4,164] - Entry 3 : 56 [52,4,92] - Entry 4 : 56 [52,0,128] - Entry 5 : 56 [52,0,200] - Entry 6 : 56 [52,2,92] - Next Page : 52 110 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=110 - Entry 0 : 56 [52,4,20] - Entry 1 : 56 [52,2,164] - Entry 2 : 56 [52,2,200] - Entry 3 : 56 [52,2,128] - Entry 4 : 56 [52,1,56] - Entry 5 : 56 [52,1,128] - Entry 6 : 56 [52,1,200] - Next Page : 52 108 - -------------------- - ------- LEAF ------- - NumEntries=8 FileId=52 PageId=108 - Entry 0 : 56 [52,2,56] - Entry 1 : 56 [52,2,20] - Entry 2 : 56 [52,1,164] - Entry 3 : 56 [52,1,92] - Entry 4 : 56 [52,1,20] - Entry 5 : 56 [52,0,164] - Entry 6 : 56 [52,0,92] - Entry 7 : 75 [52,105,92] - Next Page : 52 201 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=201 - Entry 0 : 75 [52,104,164] - Entry 1 : 75 [52,102,200] - Entry 2 : 75 [52,99,164] - Entry 3 : 75 [52,100,92] - Entry 4 : 75 [52,102,56] - Entry 5 : 75 [52,97,200] - Entry 6 : 75 [52,97,56] - Next Page : 52 194 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=194 - Entry 0 : 75 [52,95,92] - Entry 1 : 75 [52,94,164] - Entry 2 : 75 [52,90,92] - Entry 3 : 75 [52,92,56] - Entry 4 : 75 [52,92,200] - Entry 5 : 75 [52,89,164] - Entry 6 : 75 [52,87,200] - Next Page : 52 185 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=185 - Entry 0 : 75 [52,87,56] - Entry 1 : 75 [52,85,92] - Entry 2 : 75 [52,82,56] - Entry 3 : 75 [52,82,200] - Entry 4 : 75 [52,84,164] - Entry 5 : 75 [52,80,92] - Entry 6 : 75 [52,79,164] - Next Page : 52 178 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=178 - Entry 0 : 75 [52,77,200] - Entry 1 : 75 [52,77,56] - Entry 2 : 75 [52,72,56] - Entry 3 : 75 [52,74,92] - Entry 4 : 75 [52,75,20] - Entry 5 : 75 [52,71,128] - Entry 6 : 75 [52,69,92] - Next Page : 52 166 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=166 - Entry 0 : 75 [52,68,164] - Entry 1 : 75 [52,66,128] - Entry 2 : 75 [52,63,20] - Entry 3 : 75 [52,63,164] - Entry 4 : 75 [52,65,200] - Entry 5 : 75 [52,60,200] - Entry 6 : 75 [52,60,56] - Next Page : 52 160 - -------------------- - ####### NODE ####### - NumEntries=10 FileId=52 PageId=170 - Child : 52,166 - Key 0 : 75 - Child : 52,160 - Key 1 : 75 - Child : 52,149 - Key 2 : 75 - Child : 52,134 - Key 3 : 75 - Child : 52,113 - Key 4 : 92 - Child : 52,188 - Key 5 : 92 - Child : 52,173 - Key 6 : 92 - Child : 52,154 - Key 7 : 92 - Child : 52,133 - Key 8 : 156 - Child : 52,190 - Key 9 : 672 - Child : 52,182 - ################## - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=166 - Entry 0 : 75 [52,68,164] - Entry 1 : 75 [52,66,128] - Entry 2 : 75 [52,63,20] - Entry 3 : 75 [52,63,164] - Entry 4 : 75 [52,65,200] - Entry 5 : 75 [52,60,200] - Entry 6 : 75 [52,60,56] - Next Page : 52 160 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=160 - Entry 0 : 75 [52,58,20] - Entry 1 : 75 [52,57,92] - Entry 2 : 75 [52,52,92] - Entry 3 : 75 [52,54,128] - Entry 4 : 75 [52,55,56] - Entry 5 : 75 [52,51,164] - Entry 6 : 75 [52,49,128] - Next Page : 52 149 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=149 - Entry 0 : 75 [52,45,56] - Entry 1 : 75 [52,41,56] - Entry 2 : 75 [52,34,128] - Entry 3 : 75 [52,38,200] - Entry 4 : 75 [52,40,164] - Entry 5 : 75 [52,34,20] - Entry 6 : 75 [52,32,56] - Next Page : 52 134 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=134 - Entry 0 : 75 [52,27,200] - Entry 1 : 75 [52,27,92] - Entry 2 : 75 [52,16,200] - Entry 3 : 75 [52,21,56] - Entry 4 : 75 [52,25,128] - Entry 5 : 75 [52,12,128] - Entry 6 : 75 [52,8,56] - Next Page : 52 113 - -------------------- - ------- LEAF ------- - NumEntries=13 FileId=52 PageId=113 - Entry 0 : 75 [52,7,92] - Entry 1 : 75 [52,3,92] - Entry 2 : 92 [52,3,164] - Entry 3 : 92 [52,12,200] - Entry 4 : 92 [52,93,56] - Entry 5 : 92 [52,98,56] - Entry 6 : 92 [52,103,56] - Entry 7 : 92 [52,105,164] - Entry 8 : 92 [52,100,164] - Entry 9 : 92 [52,95,164] - Entry 10 : 92 [52,75,92] - Entry 11 : 92 [52,80,164] - Entry 12 : 92 [52,85,164] - Next Page : 52 188 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=188 - Entry 0 : 92 [52,90,164] - Entry 1 : 92 [52,88,56] - Entry 2 : 92 [52,83,56] - Entry 3 : 92 [52,78,56] - Entry 4 : 92 [52,55,128] - Entry 5 : 92 [52,61,56] - Entry 6 : 92 [52,66,200] - Next Page : 52 173 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=173 - Entry 0 : 92 [52,72,128] - Entry 1 : 92 [52,69,164] - Entry 2 : 92 [52,64,20] - Entry 3 : 92 [52,58,92] - Entry 4 : 92 [52,32,128] - Entry 5 : 92 [52,39,56] - Entry 6 : 92 [52,45,128] - Next Page : 52 154 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=154 - Entry 0 : 92 [52,52,164] - Entry 1 : 92 [52,49,200] - Entry 2 : 92 [52,41,128] - Entry 3 : 92 [52,34,200] - Entry 4 : 92 [52,17,56] - Entry 5 : 92 [52,21,128] - Entry 6 : 92 [52,25,200] - Next Page : 52 133 - -------------------- - ------- LEAF ------- - NumEntries=13 FileId=52 PageId=133 - Entry 0 : 92 [52,28,56] - Entry 1 : 92 [52,8,128] - Entry 2 : 156 [52,78,164] - Entry 3 : 156 [52,81,56] - Entry 4 : 156 [52,93,164] - Entry 5 : 156 [52,98,164] - Entry 6 : 156 [52,103,164] - Entry 7 : 156 [52,106,56] - Entry 8 : 156 [52,101,56] - Entry 9 : 156 [52,96,56] - Entry 10 : 156 [52,83,164] - Entry 11 : 156 [52,86,56] - Entry 12 : 156 [52,88,164] - Next Page : 52 190 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=190 - Entry 0 : 156 [52,91,56] - Entry 1 : 672 [52,8,20] - Entry 2 : 672 [52,87,164] - Entry 3 : 672 [52,92,164] - Entry 4 : 672 [52,90,56] - Entry 5 : 672 [52,85,56] - Entry 6 : 672 [52,25,92] - Next Page : 52 182 - -------------------- - ------- LEAF ------- - NumEntries=12 FileId=52 PageId=182 - Entry 0 : 672 [52,74,200] - Entry 1 : 672 [52,82,164] - Entry 2 : 672 [52,80,56] - Entry 3 : 672 [52,77,164] - Entry 4 : 672 [52,95,56] - Entry 5 : 672 [52,100,56] - Entry 6 : 672 [52,105,56] - Entry 7 : 672 [52,102,164] - Entry 8 : 672 [52,97,164] - Entry 9 : 672 [52,55,20] - Entry 10 : 672 [52,60,164] - Entry 11 : 672 [52,66,92] - Next Page : 52 171 - -------------------- - ####### NODE ####### - NumEntries=11 FileId=52 PageId=191 - Child : 52,182 - Key 0 : 672 - Child : 52,171 - Key 1 : 672 - Child : 52,153 - Key 2 : 672 - Child : 52,121 - Key 3 : 1234 - Child : 52,187 - Key 4 : 1234 - Child : 52,169 - Key 5 : 1234 - Child : 52,152 - Key 6 : 4556 - Child : 52,199 - Key 7 : 9376 - Child : 52,189 - Key 8 : 9376 - Child : 52,183 - Key 9 : 9376 - Child : 52,172 - Key 10 : 9376 - Child : 52,140 - ################## - ------- LEAF ------- - NumEntries=12 FileId=52 PageId=182 - Entry 0 : 672 [52,74,200] - Entry 1 : 672 [52,82,164] - Entry 2 : 672 [52,80,56] - Entry 3 : 672 [52,77,164] - Entry 4 : 672 [52,95,56] - Entry 5 : 672 [52,100,56] - Entry 6 : 672 [52,105,56] - Entry 7 : 672 [52,102,164] - Entry 8 : 672 [52,97,164] - Entry 9 : 672 [52,55,20] - Entry 10 : 672 [52,60,164] - Entry 11 : 672 [52,66,92] - Next Page : 52 171 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=171 - Entry 0 : 672 [52,72,20] - Entry 1 : 672 [52,69,56] - Entry 2 : 672 [52,63,128] - Entry 3 : 672 [52,57,200] - Entry 4 : 672 [52,32,20] - Entry 5 : 672 [52,38,164] - Entry 6 : 672 [52,45,20] - Next Page : 52 153 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=153 - Entry 0 : 672 [52,52,56] - Entry 1 : 672 [52,49,92] - Entry 2 : 672 [52,41,20] - Entry 3 : 672 [52,34,92] - Entry 4 : 672 [52,27,164] - Entry 5 : 672 [52,21,20] - Entry 6 : 672 [52,12,92] - Next Page : 52 121 - -------------------- - ------- LEAF ------- - NumEntries=13 FileId=52 PageId=121 - Entry 0 : 672 [52,16,164] - Entry 1 : 672 [52,7,56] - Entry 2 : 672 [52,3,56] - Entry 3 : 1234 [52,27,128] - Entry 4 : 1234 [52,92,92] - Entry 5 : 1234 [52,97,92] - Entry 6 : 1234 [52,102,92] - Entry 7 : 1234 [52,104,200] - Entry 8 : 1234 [52,99,200] - Entry 9 : 1234 [52,94,200] - Entry 10 : 1234 [52,74,128] - Entry 11 : 1234 [52,79,200] - Entry 12 : 1234 [52,84,200] - Next Page : 52 187 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=187 - Entry 0 : 1234 [52,89,200] - Entry 1 : 1234 [52,87,92] - Entry 2 : 1234 [52,82,92] - Entry 3 : 1234 [52,77,92] - Entry 4 : 1234 [52,54,164] - Entry 5 : 1234 [52,60,92] - Entry 6 : 1234 [52,66,20] - Next Page : 52 169 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=169 - Entry 0 : 1234 [52,71,164] - Entry 1 : 1234 [52,68,200] - Entry 2 : 1234 [52,63,56] - Entry 3 : 1234 [52,57,128] - Entry 4 : 1234 [52,51,200] - Entry 5 : 1234 [52,34,56] - Entry 6 : 1234 [52,40,200] - Next Page : 52 152 - -------------------- - ------- LEAF ------- - NumEntries=9 FileId=52 PageId=152 - Entry 0 : 4556 [52,78,128] - Entry 1 : 4556 [52,81,20] - Entry 2 : 4556 [52,83,128] - Entry 3 : 4556 [52,88,128] - Entry 4 : 4556 [52,103,128] - Entry 5 : 4556 [52,106,20] - Entry 6 : 4556 [52,93,128] - Entry 7 : 4556 [52,96,20] - Entry 8 : 4556 [52,98,128] - Next Page : 52 199 - -------------------- - ------- LEAF ------- - NumEntries=9 FileId=52 PageId=199 - Entry 0 : 4556 [52,101,20] - Entry 1 : 4556 [52,91,20] - Entry 2 : 4556 [52,86,20] - Entry 3 : 9376 [52,98,20] - Entry 4 : 9376 [52,103,20] - Entry 5 : 9376 [52,105,128] - Entry 6 : 9376 [52,100,128] - Entry 7 : 9376 [52,95,128] - Entry 8 : 9376 [52,52,128] - Next Page : 52 189 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=189 - Entry 0 : 9376 [52,93,20] - Entry 1 : 9376 [52,90,128] - Entry 2 : 9376 [52,88,20] - Entry 3 : 9376 [52,85,128] - Entry 4 : 9376 [52,49,164] - Entry 5 : 9376 [52,45,92] - Entry 6 : 9376 [52,17,20] - Next Page : 52 183 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=183 - Entry 0 : 9376 [52,75,56] - Entry 1 : 9376 [52,83,20] - Entry 2 : 9376 [52,80,128] - Entry 3 : 9376 [52,78,20] - Entry 4 : 9376 [52,55,92] - Entry 5 : 9376 [52,61,20] - Entry 6 : 9376 [52,66,164] - Next Page : 52 172 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=172 - Entry 0 : 9376 [52,72,92] - Entry 1 : 9376 [52,69,128] - Entry 2 : 9376 [52,63,200] - Entry 3 : 9376 [52,58,56] - Entry 4 : 9376 [52,41,92] - Entry 5 : 9376 [52,39,20] - Entry 6 : 9376 [52,21,92] - Next Page : 52 140 - -------------------- - ------- LEAF ------- - NumEntries=7 FileId=52 PageId=140 - Entry 0 : 9376 [52,34,164] - Entry 1 : 9376 [52,32,92] - Entry 2 : 9376 [52,28,20] - Entry 3 : 9376 [52,25,164] - Entry 4 : 9376 [52,12,164] - Entry 5 : 9376 [52,8,92] - Entry 6 : 9376 [52,3,128] - Next Page : 0 0 - -------------------- -+++++++++++++++++++++++++++++++++++++++++++++ -BTree b1 created -ok ( 0.011 s ) -+-----------+ -| AGGR | -| count(*) | -+-----------+ -| 522 | -+-----------+ -ok ( 0.001 s ) -Batch done | ||
| [+] | Deleted | cego-2.20.1.tar.bz2/samples/chkdb/bt1.sql ^ |
| @@ -1,8 +0,0 @@ -drop if exists table sysmt_user; -create table sysmt_user(usrid int not null, - dbuser string(100) not null, - password string(100), - usermail string(100)); - -create primary btree on sysmt_user(usrid); -create unique btree sysmt_user_i1 on sysmt_user(dbuser); | ||
| [+] | Deleted | cego-2.20.1.tar.bz2/samples/chkdb/bt2.sql ^ |
| @@ -1,3 +0,0 @@ -insert into sysmt_user ( usrid, dbuser, password, usermail ) values ( 0, 'admin', '205qjDWdAOD5Q', 'nomail'); -insert into sysmt_user ( usrid, dbuser, password, usermail ) values ( 1, 'lemke', 'VxlvSgomYNe8s', 'nomail'); - | ||
| [+] | Deleted | cego-2.20.1.tar.bz2/samples/chkdb/bt3.sql ^ |
| @@ -1 +0,0 @@ -select dbuser from sysmt_user where usrid = 1; | ||
| [+] | Deleted | cego-2.20.1.tar.bz2/samples/chkdb/x.sql ^ |
| @@ -1,866 +0,0 @@ --- --- ### Advanced btree checks --- - -drop if exists table t1; -create table t1 ( a int ); - -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 1256 ); -insert into t1 values ( 5631 ); -insert into t1 values ( 754 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 1922 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 1256 ); -insert into t1 values ( 5631 ); -insert into t1 values ( 754 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 1922 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 1256 ); -insert into t1 values ( 5631 ); -insert into t1 values ( 754 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 1922 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 1256 ); -insert into t1 values ( 5631 ); -insert into t1 values ( 754 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 1922 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 1256 ); -insert into t1 values ( 5631 ); -insert into t1 values ( 754 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 1922 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 1256 ); -insert into t1 values ( 5631 ); -insert into t1 values ( 754 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 1922 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 1256 ); -insert into t1 values ( 5631 ); -insert into t1 values ( 754 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 1922 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 1256 ); -insert into t1 values ( 5631 ); -insert into t1 values ( 754 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 1922 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); -insert into t1 values ( 1256 ); -insert into t1 values ( 5631 ); -insert into t1 values ( 754 ); -insert into t1 values ( 1234 ); -insert into t1 values ( 1922 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 4556 ); -insert into t1 values ( 156 ); -insert into t1 values ( 56 ); - -select count(*) from t1; -select count(*) from t1 where a < 100; -create btree b1 on t1(a); -select count(*) from t1 where a < 100; - --- check fur any buffer fix leaks --- show pool; | ||
| [+] | Deleted | cego-2.20.1.tar.bz2/samples/chkdb/x2.sql ^ |
| @@ -1,39 +0,0 @@ -drop if exists table t1; -create table t1 ( a int ); - -insert into t1 values ( 56 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 75 ); -insert into t1 values ( 75 ); -insert into t1 values ( 1234 ); - - - -select count(*) from t1; -select count(*) from t1 where a < 100; -create btree b1 on t1(a); -select count(*) from t1 where a < 100; - --- delete from t1 where a = 124; --- delete from t1 where a = 570; --- delete from t1 where a = 50; - - | ||
| [+] | Deleted | cego-2.20.1.tar.bz2/samples/chkdb/x3.sql ^ |
| @@ -1,65 +0,0 @@ -drop if exists table t1; -create table t1 ( a int ); - -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 9376 ); -insert into t1 values ( 92 ); -insert into t1 values ( 15 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 19 ); -insert into t1 values ( 672 ); -insert into t1 values ( 75 ); -insert into t1 values ( 56 ); -insert into t1 values ( 56 ); -insert into t1 values ( 19 ); - - - - -select count(*) from t1; -select count(*) from t1 where a < 100; -create btree b1 on t1(a); -select count(*) from t1 where a < 100; - --- delete from t1 where a = 124; --- delete from t1 where a = 570; --- delete from t1 where a = 50; - - | ||
| [+] | Changed | cego-2.20.3.tar.bz2/configure ^ |
| @@ -1,6 +1,6 @@ #! /bin/sh # Guess values for system-dependent variables and create Makefiles. -# Generated by GNU Autoconf 2.69 for Cego 2.20.1. +# Generated by GNU Autoconf 2.69 for Cego 2.20.3. # # Report bugs to <lemke@lemke-it.com>. # @@ -590,8 +590,8 @@ # Identity of this package. PACKAGE_NAME='Cego' PACKAGE_TARNAME='cego' -PACKAGE_VERSION='2.20.1' -PACKAGE_STRING='Cego 2.20.1' +PACKAGE_VERSION='2.20.3' +PACKAGE_STRING='Cego 2.20.3' PACKAGE_BUGREPORT='lemke@lemke-it.com' PACKAGE_URL='' @@ -1326,7 +1326,7 @@ # Omit some internal or obsolete options to make the list less imposing. # This message is too long to be a string in the A/UX 3.1 sh. cat <<_ACEOF -\`configure' configures Cego 2.20.1 to adapt to many kinds of systems. +\`configure' configures Cego 2.20.3 to adapt to many kinds of systems. Usage: $0 [OPTION]... [VAR=VALUE]... @@ -1396,7 +1396,7 @@ if test -n "$ac_init_help"; then case $ac_init_help in - short | recursive ) echo "Configuration of Cego 2.20.1:";; + short | recursive ) echo "Configuration of Cego 2.20.3:";; esac cat <<\_ACEOF @@ -1507,7 +1507,7 @@ test -n "$ac_init_help" && exit $ac_status if $ac_init_version; then cat <<\_ACEOF -Cego configure 2.20.1 +Cego configure 2.20.3 generated by GNU Autoconf 2.69 Copyright (C) 2012 Free Software Foundation, Inc. @@ -2051,7 +2051,7 @@ This file contains any messages produced by compilers while running configure, to aid debugging if configure makes a mistake. -It was created by Cego $as_me 2.20.1, which was +It was created by Cego $as_me 2.20.3, which was generated by GNU Autoconf 2.69. Invocation command line was $ $0 $@ @@ -2914,7 +2914,7 @@ # Define the identity of the package. PACKAGE='cego' - VERSION='2.20.1' + VERSION='2.20.3' cat >>confdefs.h <<_ACEOF @@ -16776,7 +16776,7 @@ # report actual input values of CONFIG_FILES etc. instead of their # values after options handling. ac_log=" -This file was extended by Cego $as_me 2.20.1, which was +This file was extended by Cego $as_me 2.20.3, which was generated by GNU Autoconf 2.69. Invocation command line was CONFIG_FILES = $CONFIG_FILES @@ -16842,7 +16842,7 @@ cat >>$CONFIG_STATUS <<_ACEOF || ac_write_fail=1 ac_cs_config="`$as_echo "$ac_configure_args" | sed 's/^ //; s/[\\""\`\$]/\\\\&/g'`" ac_cs_version="\\ -Cego config.status 2.20.1 +Cego config.status 2.20.3 configured by $0, generated by GNU Autoconf 2.69, with options \\"\$ac_cs_config\\" | ||
| [+] | Changed | cego-2.20.3.tar.bz2/configure.ac ^ |
| @@ -2,7 +2,7 @@ # Process this file with autoconf to produce a configure script. AC_PREREQ([2.69]) -AC_INIT([Cego], [2.20.1], [lemke@lemke-it.com]) +AC_INIT([Cego], [2.20.3], [lemke@lemke-it.com]) AM_INIT_AUTOMAKE([-Wall -Werror foreign]) AC_CONFIG_SRCDIR([config.h.in]) AC_CONFIG_HEADERS([config.h]) | ||
| [+] | Changed | cego-2.20.3.tar.bz2/samples/cgplustest/Makefile ^ |
| @@ -164,13 +164,13 @@ ETAGS = etags CTAGS = ctags DISTFILES = $(DIST_COMMON) $(DIST_SOURCES) $(TEXINFOS) $(EXTRA_DIST) -ACLOCAL = ${SHELL} /Users/lemke/work/cego-2.20.1/missing aclocal-1.14 +ACLOCAL = ${SHELL} /Users/lemke/work/cego-2.20.3/missing aclocal-1.14 AMTAR = $${TAR-tar} AM_DEFAULT_VERBOSITY = 1 AR = ar -AUTOCONF = ${SHELL} /Users/lemke/work/cego-2.20.1/missing autoconf -AUTOHEADER = ${SHELL} /Users/lemke/work/cego-2.20.1/missing autoheader -AUTOMAKE = ${SHELL} /Users/lemke/work/cego-2.20.1/missing automake-1.14 +AUTOCONF = ${SHELL} /Users/lemke/work/cego-2.20.3/missing autoconf +AUTOHEADER = ${SHELL} /Users/lemke/work/cego-2.20.3/missing autoheader +AUTOMAKE = ${SHELL} /Users/lemke/work/cego-2.20.3/missing automake-1.14 AWK = awk CC = gcc CCDEPMODE = depmode=gcc3 @@ -210,7 +210,7 @@ LIPO = lipo LN_S = ln -s LTLIBOBJS = -MAKEINFO = ${SHELL} /Users/lemke/work/cego-2.20.1/missing makeinfo +MAKEINFO = ${SHELL} /Users/lemke/work/cego-2.20.3/missing makeinfo MANIFEST_TOOL = : MKDIR_P = ../.././install-sh -c -d NM = /usr/bin/nm @@ -222,21 +222,21 @@ PACKAGE = cego PACKAGE_BUGREPORT = lemke@lemke-it.com PACKAGE_NAME = Cego -PACKAGE_STRING = Cego 2.20.1 +PACKAGE_STRING = Cego 2.20.3 PACKAGE_TARNAME = cego PACKAGE_URL = -PACKAGE_VERSION = 2.20.1 +PACKAGE_VERSION = 2.20.3 PATH_SEPARATOR = : RANLIB = ranlib SED = /usr/bin/sed SET_MAKE = SHELL = /bin/sh STRIP = strip -VERSION = 2.20.1 -abs_builddir = /Users/lemke/work/cego-2.20.1/samples/cgplustest -abs_srcdir = /Users/lemke/work/cego-2.20.1/samples/cgplustest -abs_top_builddir = /Users/lemke/work/cego-2.20.1 -abs_top_srcdir = /Users/lemke/work/cego-2.20.1 +VERSION = 2.20.3 +abs_builddir = /Users/lemke/work/cego-2.20.3/samples/cgplustest +abs_srcdir = /Users/lemke/work/cego-2.20.3/samples/cgplustest +abs_top_builddir = /Users/lemke/work/cego-2.20.3 +abs_top_srcdir = /Users/lemke/work/cego-2.20.3 ac_ct_AR = ar ac_ct_CC = gcc ac_ct_CXX = g++ @@ -266,7 +266,7 @@ htmldir = ${docdir} includedir = ${prefix}/include infodir = ${datarootdir}/info -install_sh = ${SHELL} /Users/lemke/work/cego-2.20.1/install-sh +install_sh = ${SHELL} /Users/lemke/work/cego-2.20.3/install-sh libdir = ${exec_prefix}/lib libexecdir = ${exec_prefix}/libexec localedir = ${datarootdir}/locale | ||
| [+] | Changed | cego-2.20.3.tar.bz2/samples/cgwraptest/Makefile ^ |
| @@ -164,13 +164,13 @@ ETAGS = etags CTAGS = ctags DISTFILES = $(DIST_COMMON) $(DIST_SOURCES) $(TEXINFOS) $(EXTRA_DIST) -ACLOCAL = ${SHELL} /Users/lemke/work/cego-2.20.1/missing aclocal-1.14 +ACLOCAL = ${SHELL} /Users/lemke/work/cego-2.20.3/missing aclocal-1.14 AMTAR = $${TAR-tar} AM_DEFAULT_VERBOSITY = 1 AR = ar -AUTOCONF = ${SHELL} /Users/lemke/work/cego-2.20.1/missing autoconf -AUTOHEADER = ${SHELL} /Users/lemke/work/cego-2.20.1/missing autoheader -AUTOMAKE = ${SHELL} /Users/lemke/work/cego-2.20.1/missing automake-1.14 +AUTOCONF = ${SHELL} /Users/lemke/work/cego-2.20.3/missing autoconf +AUTOHEADER = ${SHELL} /Users/lemke/work/cego-2.20.3/missing autoheader +AUTOMAKE = ${SHELL} /Users/lemke/work/cego-2.20.3/missing automake-1.14 AWK = awk CC = gcc CCDEPMODE = depmode=gcc3 @@ -210,7 +210,7 @@ LIPO = lipo LN_S = ln -s LTLIBOBJS = -MAKEINFO = ${SHELL} /Users/lemke/work/cego-2.20.1/missing makeinfo +MAKEINFO = ${SHELL} /Users/lemke/work/cego-2.20.3/missing makeinfo MANIFEST_TOOL = : MKDIR_P = ../.././install-sh -c -d NM = /usr/bin/nm @@ -222,21 +222,21 @@ PACKAGE = cego PACKAGE_BUGREPORT = lemke@lemke-it.com PACKAGE_NAME = Cego -PACKAGE_STRING = Cego 2.20.1 +PACKAGE_STRING = Cego 2.20.3 PACKAGE_TARNAME = cego PACKAGE_URL = -PACKAGE_VERSION = 2.20.1 +PACKAGE_VERSION = 2.20.3 PATH_SEPARATOR = : RANLIB = ranlib SED = /usr/bin/sed SET_MAKE = SHELL = /bin/sh STRIP = strip -VERSION = 2.20.1 -abs_builddir = /Users/lemke/work/cego-2.20.1/samples/cgwraptest -abs_srcdir = /Users/lemke/work/cego-2.20.1/samples/cgwraptest -abs_top_builddir = /Users/lemke/work/cego-2.20.1 -abs_top_srcdir = /Users/lemke/work/cego-2.20.1 +VERSION = 2.20.3 +abs_builddir = /Users/lemke/work/cego-2.20.3/samples/cgwraptest +abs_srcdir = /Users/lemke/work/cego-2.20.3/samples/cgwraptest +abs_top_builddir = /Users/lemke/work/cego-2.20.3 +abs_top_srcdir = /Users/lemke/work/cego-2.20.3 ac_ct_AR = ar ac_ct_CC = gcc ac_ct_CXX = g++ @@ -266,7 +266,7 @@ htmldir = ${docdir} includedir = ${prefix}/include infodir = ${datarootdir}/info -install_sh = ${SHELL} /Users/lemke/work/cego-2.20.1/install-sh +install_sh = ${SHELL} /Users/lemke/work/cego-2.20.3/install-sh libdir = ${exec_prefix}/lib libexecdir = ${exec_prefix}/libexec localedir = ${datarootdir}/locale | ||
| [+] | Changed | cego-2.20.3.tar.bz2/samples/chkdb/chkblow ^ |
| @@ -1,3 +1,3 @@ #!/bin/bash DBHOST=`hostname` -../../src/cgblow --mode=insert --server=$DBHOST --port=2200 --iset=i:400000,s:8 --table=t1 --tableset=TS1 --user=lemke/lemke --append --interval=1000 --count=120000 --protocol=serial $@ +../../src/cgblow --mode=insert --server=$DBHOST --port=2200 --iset=i:400000,s:8 --table=t1 --tableset=TS1 --user=lemke/lemke --interval=1000 --count=500000 --protocol=serial $@ | ||
| [+] | Changed | cego-2.20.3.tar.bz2/samples/chkdb/chkbtree ^ |
| @@ -1,16 +1,12 @@ #!/bin/sh +../../src/cgclt --server=bigmac.local --port=2200 --tableset=TS1 --user=lemke/lemke --logfile=clt.log --protocol=serial --batchfile=chkbtree1.sql -DBUSER=lemke -DBPWD=lemke +while true +do + ../../src/cgblow --mode=insert --server=bigmac.local --port=2200 --iset=i:400000,s:8 --table=t1 --tableset=TS1 --user=lemke/lemke --append --interval=1000 --count=10000 --protocol=serial $@ + ../../src/cgclt --server=bigmac.local --port=2200 --tableset=TS1 --user=lemke/lemke --logfile=clt.log --protocol=serial --batchfile=chkbtree2.sql -CEGO=../../src/cego -CGCLT=../../src/cgclt - -$CEGO --mode=batch --dbxml=./db/chkdb.xml --user=lemke/lemke --poolsize=1000 --batchfile=bt1.sql --tableset=TS1 - -$CEGO --mode=batch --dbxml=./db/chkdb.xml --user=lemke/lemke --poolsize=1000 --batchfile=bt2.sql --tableset=TS1 - -$CEGO --mode=batch --dbxml=./db/chkdb.xml --user=lemke/lemke --poolsize=1000 --batchfile=bt3.sql --tableset=TS1 +done | ||
| [+] | Added | cego-2.20.3.tar.bz2/samples/chkdb/chkbtree.sql ^ |
| @@ -0,0 +1,2 @@ +drop if exists table t1; +create table t1 ( a int, b string(50)); | ||
| [+] | Added | cego-2.20.3.tar.bz2/samples/chkdb/chkbtree1.sql ^ |
| @@ -0,0 +1,2 @@ +drop if exists table t1; +create table t1 (a int , b string(50)); | ||
| [+] | Added | cego-2.20.3.tar.bz2/samples/chkdb/chkbtree2.sql ^ |
| @@ -0,0 +1,11 @@ +select count(*) from t1; +select count(*) from t1 where a < 1000; +select count(*) from t1 where a > 1000; + +create btree b1 on t1(a); +select count(*) from t1 where a < 1000; +select count(*) from t1 where a > 1000; +drop btree b1; + +-- select count(*) from t1; +-- show pool; | ||
| [+] | Changed | cego-2.20.3.tar.bz2/samples/chkdb/chkup ^ |
| @@ -4,7 +4,7 @@ export CGEXESHELL CEGOPROG=../../src/cego -POOLSIZE=5000 +POOLSIZE=3000 if [ $# -eq 0 ] then | ||
| [+] | Changed | cego-2.20.3.tar.bz2/samples/chkdb/mkdb ^ |
| @@ -13,7 +13,7 @@ ############### DBXML=./db/chkdb.xml DBNAME=chkdb -# PAGESIZE=256 +# PAGESIZE=200 # PAGESIZE=16384 # PAGESIZE=131072 # PAGESIZE=32768 @@ -105,7 +105,7 @@ TMPSIZE=30000 LOGFILESIZE=1000000 LOGFILENUM=3 - APPSIZE=30000 + APPSIZE=20000 SORTAREASIZE=10000000 DBUSER=lemke DBPWD=lemke | ||
| [+] | Changed | cego-2.20.3.tar.bz2/src/CegoBTreeManager.cc ^ |
| @@ -204,7 +204,8 @@ leafRight.setFileId(newPage.getFileId()); leafRight.setPageId(newPage.getPageId()); leafRight.setSchema(&_btreeSchema, _keyLen); - + + // cout << "NEW LEAF NODE " << newPage.getPageId() << endl; // cout << "Splitting leaf page .." << endl; leafLeft.split(leafRight); @@ -246,11 +247,31 @@ nodeLeft.setPtr(propPage.getChunkEntry(), propPage.getChunkLen()); nodeLeft.setFileId(propPage.getFileId()); nodeLeft.setPageId(propPage.getPageId()); + + nodeLeft.setNextFileId(propPage.getNextFileId()); + nodeLeft.setNextPageId(propPage.getNextPageId()); + + // cout << "Propagating to page " << nodeLeft.getPageId() << " ==>> Follow up is " << nodeLeft.getNextPageId() << endl; nodeLeft.setSchema(&_btreeSchema, _keyLen); + + // before propagation, we have to find out the follow up leaf page of the current node + + int lastFileId, lastPageId, nextFileId, nextPageId; + nodeLeft.getLastChildPointer(lastFileId, lastPageId); + if ( lastFileId && lastPageId ) + { + CegoBufferPage lastPage; + _pDBMng->bufferFix(lastPage, _tabSetId, lastFileId, lastPageId, CegoBufferPool::NOSYNC, _pObjMng->getLockHandler()); + nextFileId = lastPage.getNextFileId(); + nextPageId = lastPage.getNextPageId(); + _pDBMng->bufferUnfix(lastPage, false, _pObjMng->getLockHandler()); + } + + ListT<CegoBTreeNode> modNodeList; - if ( nodeLeft.propagate(propValue, propLeft, propRight, modNodeList) == false ) + if ( nodeLeft.propagate(propValue, propLeft, propRight, nextFileId, nextPageId, modNodeList) == false ) { propLeft = nodeLeft; @@ -270,14 +291,31 @@ propRight.setFileId(newPage.getFileId()); propRight.setPageId(newPage.getPageId()); propRight.setSchema(&_btreeSchema, _keyLen); + + // cout << "NEW NODE " << newPage.getPageId() << endl; + // cout << "Num Entries before split = " << propLeft.numEntries() << endl; propLeft.split(propRight); - propValue = propLeft.getMax(); - - // cout << "!!!!!!!!!!! Decrease entries for page " << nodeLeft.getPageId() << " !!!!!!!!!" << endl; - // propLeft.decEntries(); - // cout << "!!!!!!!!!!! New value is " << nodeLeft.numEntries() << " !!!!!!!!!" << endl; + // Setting up follow up node page + + // cout << "Setting up follow up page for " << propLeft.getPageId() << " to " << propRight.getPageId() << endl; + + CegoBufferPage modPage; + _pDBMng->bufferFix(modPage, _tabSetId, propLeft.getFileId(), propLeft.getPageId(), CegoBufferPool::NOSYNC, _pObjMng->getLockHandler()); + modPage.setNextFileId(propRight.getFileId()); + modPage.setNextPageId(propRight.getPageId()); + propLeft.setNextFileId(propRight.getFileId()); + propLeft.setNextPageId(propRight.getPageId()); + _pDBMng->bufferUnfix(modPage, true, _pObjMng->getLockHandler()); + + + // cout << "Num Entries after split = " << propLeft.numEntries() << " + " << propRight.numEntries() << endl; + // propLeft.printNode(0); + // propRight.printNode(0); + + propValue = propLeft.getMax(); + // add new node CegoBTreeValue iv1 = addNode.getMin(); CegoBTreeValue iv2 = propRight.getMin(); @@ -295,39 +333,52 @@ } else - { - // cout << "Node page after propagation " << endl; - // propNode.printNode(); + { + isPropagated = true; + } - /* + + // Setting up follow up node page + + + if ( propPage.getNextFileId() && propPage.getNextPageId() ) + { - if ( leafLeft.getNextFileId() && leafLeft.getNextPageId() ) - { - leafRight.setNextFileId(leafLeft.getNextFileId()); - leafRight.setNextPageId(leafLeft.getNextPageId()); - newPage.setNextFileId(leafLeft.getNextFileId()); - newPage.setNextPageId(leafLeft.getNextPageId()); - } - - leafLeft.setNextFileId(newPage.getFileId()); - leafLeft.setNextPageId(newPage.getPageId()); - bp.setNextFileId(newPage.getFileId()); - bp.setNextPageId(newPage.getPageId()); - */ - + // cout << "XXX Setting up first pointer for follow up page " << propPage.getNextFileId() << "/" << propPage.getNextPageId() + // << " of page " << propPage.getFileId() << "/" << propPage.getPageId() << endl; - isPropagated = true; - } - // set up next page information + CegoBufferPage nodePageA; + CegoBufferPage nodePageB; + CegoBTreeNode nodeA; + CegoBTreeNode nodeB; + int nodeFileId, nodePageId; + + _pDBMng->bufferFix(nodePageA, _tabSetId, propPage.getFileId(), propPage.getPageId(), CegoBufferPool::NOSYNC, _pObjMng->getLockHandler()); + nodeA.setPtr(nodePageA.getChunkEntry(), nodePageA.getChunkLen()); + nodeA.setType(CegoBTreeNode::NODE); + nodeA.setSchema(&_btreeSchema, _keyLen); + + _pDBMng->bufferFix(nodePageB, _tabSetId, propPage.getNextFileId(), propPage.getNextPageId(), CegoBufferPool::NOSYNC, _pObjMng->getLockHandler()); + nodeB.setPtr(nodePageB.getChunkEntry(), nodePageB.getChunkLen()); + nodeB.setType(CegoBTreeNode::NODE); + nodeB.setSchema(&_btreeSchema, _keyLen); + nodeA.getLastChildPointer(nodeFileId, nodePageId); + + // cout << "Setting first node to " << nodeFileId << "/" << nodePageId << endl; + nodeB.setFirstChildPointer(nodeFileId, nodePageId); + _pDBMng->bufferUnfix(nodePageA, true, _pObjMng->getLockHandler()); + _pDBMng->bufferUnfix(nodePageB, true, _pObjMng->getLockHandler()); + } + CegoBTreeNode* pModNode = modNodeList.First(); while ( pModNode ) { // cout << "A Setting up post node for node " << pModNode->getFileId() << " " << pModNode->getPageId() - // << " to value " << pModNode->getNextFileId() << " " << pModNode->getNextPageId() << endl; + // << " to value " << pModNode->getNextFileId() << " " << pModNode->getNextPageId() << endl; CegoBufferPage modPage; @@ -344,7 +395,7 @@ else // root node reached, adding new root { - // cout << "Adding new root page .." << endl; + // cout << "ADDING new root page .." << endl; CegoBufferPage rootPage; _pObjMng->getNewFilePage(rootPage, _tabSetId, CegoObject::BTREE, true, doAppend); @@ -370,9 +421,20 @@ rootNode.setFileId(rootPage.getFileId()); rootNode.setPageId(rootPage.getPageId()); rootNode.setSchema(&_btreeSchema, _keyLen); + + int lastFileId, lastPageId, nextFileId, nextPageId; + rootNode.getLastChildPointer(lastFileId, lastPageId); + if ( lastFileId && lastPageId ) + { + CegoBufferPage lastPage; + _pDBMng->bufferFix(lastPage, _tabSetId, lastFileId, lastPageId, CegoBufferPool::NOSYNC, _pObjMng->getLockHandler()); + nextFileId = lastPage.getNextFileId(); + nextPageId = lastPage.getNextPageId(); + _pDBMng->bufferUnfix(lastPage, false, _pObjMng->getLockHandler()); + } ListT<CegoBTreeNode> modNodeList; - rootNode.propagate(propValue, propLeft, propRight, modNodeList); + rootNode.propagate(propValue, propLeft, propRight, nextFileId, nextPageId, modNodeList); CegoBTreeNode* pModNode = modNodeList.First(); @@ -380,7 +442,7 @@ { // cout << "B Setting up post node for node " << pModNode->getFileId() << " " << pModNode->getPageId() - // << " to value " << pModNode->getNextFileId() << " " << pModNode->getNextPageId() << endl; + // << " to value " << pModNode->getNextFileId() << " " << pModNode->getNextPageId() << endl; CegoBufferPage modPage; @@ -719,13 +781,21 @@ } } -void CegoBTreeManager::freeBTree() +int CegoBTreeManager::freeBTree() { - freeNodePages(_pBTO->getDataFileId(), _pBTO->getDataPageId()); + int firstLeafFileId = 0, firstLeafPageId = 0; + bool isFirst = true; + int pageCount = freeNodePages(_pBTO->getDataFileId(), _pBTO->getDataPageId(), firstLeafFileId, firstLeafPageId, isFirst); + + // cout << "Freeing leaf pages starting with " << firstLeafFileId << "/" << firstLeafPageId << endl; + pageCount += freeLeafPages(firstLeafFileId, firstLeafPageId); + + // cout << "Freed " << pageCount << " pages " << endl; + return pageCount; } -void CegoBTreeManager::freeNodePages(int fileId, int pageId) +int CegoBTreeManager::freeNodePages(int fileId, int pageId, int& firstLeafFileId, int& firstLeafPageId, bool& isFirst) { int pageCount = 0; @@ -747,14 +817,51 @@ traceNode.reset(); while ( traceNode.nextChildPointer(childFid, childPid) ) { - freeNodePages(childFid, childPid); + pageCount += freeNodePages(childFid, childPid, firstLeafFileId, firstLeafPageId, isFirst); } + + // cout << "Freeing node page " << fileId << "/" << pageId << endl; + _pDBMng->bufferRelease(bp, _pObjMng->getLockHandler()); } + else + { + pageCount++; - _pDBMng->bufferRelease(bp, _pObjMng->getLockHandler()); + if ( isFirst ) + { + firstLeafFileId = fileId; + firstLeafPageId = pageId; + isFirst=false; + } + _pDBMng->bufferUnfix(bp, true, _pObjMng->getLockHandler()); + } + + return pageCount; } +int CegoBTreeManager::freeLeafPages(int fileId, int pageId) +{ + int pageCount = 0; + + while ( fileId && pageId ) + { + // cout << "Freeing leaf page " << fileId << "/" << pageId << endl; + + CegoBufferPage bp; + _pDBMng->bufferFix(bp, _tabSetId, fileId, pageId, CegoBufferPool::NOSYNC, _pObjMng->getLockHandler()); + fileId=bp.getNextFileId(); + pageId=bp.getNextPageId(); + pageCount++; + + _pDBMng->bufferRelease(bp, _pObjMng->getLockHandler()); + } + + return pageCount; + +} + + int CegoBTreeManager::getNumPages() { return countNodePages(_pBTO->getDataFileId(), _pBTO->getDataPageId()); | ||
| [+] | Changed | cego-2.20.3.tar.bz2/src/CegoBTreeManager.h ^ |
| @@ -66,7 +66,7 @@ int getNumPages(); - void freeBTree(); + int freeBTree(); char checkIndex(int tabSetId, const Chain& indexName, CegoObject::ObjectType idxType); @@ -74,7 +74,9 @@ private: int countNodePages(int fileId, int pageId); - void freeNodePages(int fileId, int pageId); + int freeNodePages(int fileId, int pageId, int& firstLeafFileId, int& firstLeafPageId, bool& isFirst); + int freeLeafPages(int firstLeafFileId, int firstLeafPageId); + CegoBTreeObject* _pBTO; CegoObjectManager* _pObjMng; | ||
| [+] | Changed | cego-2.20.3.tar.bz2/src/CegoBTreeNode.cc ^ |
| @@ -397,7 +397,7 @@ memcpy(pKey, iv.getPtr(), _keyLen); char* pDP = (char*)((long)pKey + _keyLen); dp.encode(pDP); - + incEntries(); return true; } @@ -526,10 +526,11 @@ if ( node.getType() == LEAF ) { - p = (char*)((long)_pI + sizeof(int) + 2 * sizeof(int) + i * getEntrySize()); - int fileId, pageId; + p = (char*)((long)_pI + sizeof(int) + 2 * sizeof(int) + i * getEntrySize()); + + // Getting previous node char* pp = p - getEntrySize(); pp+=_keyLen; @@ -683,7 +684,7 @@ /* propagate - proofed version */ -bool CegoBTreeNode::propagate(const CegoBTreeValue& iv, const CegoBTreeNode& leftNode, const CegoBTreeNode& rightNode, ListT<CegoBTreeNode>& modNodeList) +bool CegoBTreeNode::propagate(const CegoBTreeValue& iv, const CegoBTreeNode& leftNode, const CegoBTreeNode& rightNode, int nextFileId, int nextPageId, ListT<CegoBTreeNode>& modNodeList) { if ( _nt == LEAF ) @@ -781,9 +782,9 @@ if ( rightNode.getType() == LEAF ) { - p = (char*)((long)_pI + sizeof(int) + 2 * sizeof(int) + i * getEntrySize()); - int fileId, pageId; + + p = (char*)((long)_pI + sizeof(int) + 2 * sizeof(int) + i * getEntrySize()); // Getting previous node char* pp = p - getEntrySize(); @@ -817,9 +818,10 @@ } else { - // cout << " Setting postnode for " << rightNode.getPageId() << " to 0 because i=" << i << " and ne=" << ne << endl; - postNode.setNextFileId(0); - postNode.setNextPageId(0); + + // cout << " Setting postnode for " << postNode.getPageId() << " to postnode of page " << nextPageId << endl; + postNode.setNextFileId(nextFileId); + postNode.setNextPageId(nextPageId); } modNodeList.Insert(postNode); } @@ -1093,6 +1095,41 @@ } +void CegoBTreeNode::getLastChildPointer(int &fileId, int &pageId) const +{ + + if ( _nt == LEAF ) + throw Exception(EXLOC, Chain("Invalid method for node type")); + + if ( numEntries() == 0 ) + { + fileId = 0; + pageId = 0; + } + else + { + char *p = (char*)((long)_pI + sizeof(int) + numEntries() * getEntrySize()); + + memcpy(&fileId, p, sizeof(int)); + p+=sizeof(int); + memcpy(&pageId, p, sizeof(int)); + } +} + +void CegoBTreeNode::setFirstChildPointer(int fileId, int pageId) +{ + + if ( _nt == LEAF ) + throw Exception(EXLOC, Chain("Invalid method for node type")); + + char *p = (char*)((long)_pI + sizeof(int)); + + memcpy(p, &fileId, sizeof(int)); + p+=sizeof(int); + memcpy(p, &pageId, sizeof(int)); + +} + bool CegoBTreeNode::rightChild(CegoBTreeValue& val) { | ||
| [+] | Changed | cego-2.20.3.tar.bz2/src/CegoBTreeNode.h ^ |
| @@ -72,6 +72,7 @@ bool deleteValue(const CegoBTreeValue& iv, const CegoDataPointer& dp); bool valueExists(const CegoBTreeValue& iv); bool addNode(const CegoBTreeValue& iv, const CegoBTreeNode& node, ListT<CegoBTreeNode>& modNodeList); + bool propagate(const CegoBTreeValue& iv, const CegoBTreeNode& leftNode, const CegoBTreeNode& rightNode, int nextFileId, int nextPageId, ListT<CegoBTreeNode>& modNodeList); void split(CegoBTreeNode& n); @@ -81,8 +82,6 @@ void incEntries(); void decEntries(); - bool propagate(const CegoBTreeValue& iv, const CegoBTreeNode& leftNode, const CegoBTreeNode& rightNode, ListT<CegoBTreeNode>& modNodeList); - CegoBTreeNode& operator = (const CegoBTreeNode& n); void printNode(int level = 0); @@ -90,6 +89,9 @@ void reset(); bool nextChildPointer(int& fileId, int &pageId); + void getLastChildPointer(int& fileId, int &pageId) const; + void setFirstChildPointer(int fileId, int pageId); + bool rightChild(CegoBTreeValue& val); bool nextValue(CegoBTreeValue& val, CegoDataPointer& dp); | ||
| [+] | Changed | cego-2.20.3.tar.bz2/src/CegoBufferPage.cc ^ |
| @@ -93,7 +93,7 @@ memcpy(_pagePtr, &ph, PAGEHEAD); - if ( t != BLOB ) + if ( t == TABLE || t == TUPLE ) { int* ePtr = (int*)((long)_pagePtr + PAGEHEAD); *ePtr = 0; | ||
| [+] | Changed | cego-2.20.3.tar.bz2/src/CegoBufferPool.cc ^ |
| @@ -154,7 +154,6 @@ int hashId = calcHash(fileId, pageId); - void* bufPtr = (void*)((long)base + BUFFERPOOLHEAD + hashId * ( BUFFERHEAD + _pageSize )); bool isFixed = false; @@ -426,7 +425,6 @@ } - void CegoBufferPool::emptyFix(CegoBufferPage &bp, int tabSetId, FixMode m, CegoFileHandler::FileType ft, CegoLockHandler *pLockHandle, bool doAppend) { @@ -442,7 +440,9 @@ int fbmSize=0; allocatePage(tabSetId, ft, fileId, pageId, pLockHandle, fbm, fbmSize, doAppend); - + + // cout << "Allocated page " << fileId << "/" << pageId << endl; + if ( fbmSize > 0 ) { logBM(tabSetId, fileId, fbm, fbmSize); @@ -529,7 +529,7 @@ int fbmSize=0; unsigned* fbm; - + releasePage(bp.getFileId(), bp.getPageId(), pLockHandle, fbm, fbmSize); if ( fbmSize > 0 ) @@ -623,7 +623,7 @@ BufferHead bh; memcpy(&bh, bufPtr, sizeof(BufferHead)); - if (bh.isDirty != 0 && bh.tabSetId == tabSetId ) + if ( bh.isOccupied != NOT_OCCUPIED && bh.isDirty != 0 && bh.tabSetId == tabSetId ) { if ( isBackup(bh.fileId) ) @@ -720,7 +720,7 @@ { - if ( bh.isDirty != 0 ) + if ( bh.isOccupied != NOT_OCCUPIED && bh.isDirty != 0 ) { _numDiskWrite++; | ||
| [+] | Changed | cego-2.20.3.tar.bz2/src/CegoFileHandler.cc ^ |
| @@ -403,7 +403,10 @@ void CegoFileHandler::writePage(int fileId, int pageId, int fixStat, char* pageData, CegoLockHandler *pLockHandle) { - + + // if ( isClaimed(fileId, pageId, pLockHandle) == false ) + // cout << "WRITE PAGE " << pageId << " IS NOT CLAIMED" << endl; + // cout << "Write page " << fileId << " " << pageId << endl; File* pF; @@ -451,6 +454,10 @@ void CegoFileHandler::readPage(int fileId, int pageId, int& tabSetId, int& fixStat, char* pageData, CegoLockHandler *pLockHandle) { + + // if ( isClaimed(fileId, pageId, pLockHandle) == false ) + // cout << "READ PAGE " << pageId << "IS NOT CLAIMED" << endl; + File *pF; try @@ -595,6 +602,8 @@ pF->seek(2*sizeof(int) + sizeof(FileType)); k = 0; + // we reset the append postion to zero, so next allocation with append = true will search from the beginning + _appendPos[fid] = 0; } else { @@ -707,9 +716,11 @@ void CegoFileHandler::releasePage(int fileId, int pageId, CegoLockHandler *pLockHandle, unsigned* &fbm, int& fbmSize) { + // cout << "Releasing pageId " << pageId << endl; + File* pF; pF = getHandle(fileId); - + pLockHandle->lockDataFile(fileId, CegoLockHandler::WRITE); try @@ -744,17 +755,24 @@ unsigned f = ~(~0 << 1); f = f << bmoffset; - // printBitMap(f); - // printBitMap(bm); + + // cout << "Bitmap before " << endl; + // printBitMap(bm); + + // printBitMap(f); bm = bm & ~f; + + // cout << "Bitmap after " << endl; // printBitMap(bm); - + + // cout << "Write to pos " << sizeof(int) + sizeof(FileType) + sizeof(int) + ( bmid * sizeof(int)) << endl; + pF->seek(sizeof(int) + sizeof(FileType) + sizeof(int) + ( bmid * sizeof(int))); pF->writeByte((char*)&bm, sizeof(unsigned)); if ( _buMask[fileId] ) _fbmMask[fileId] = true; - + pLockHandle->unlockDataFile(fileId); } @@ -763,6 +781,7 @@ pLockHandle->unlockDataFile(fileId); throw Exception(EXLOC, "Cannot release page", e); } + } /* returns the number of total pages for the given fileId */ | ||
| [+] | Changed | cego-2.20.3.tar.bz2/src/CegoObjectManager.cc ^ |
| @@ -860,7 +860,7 @@ btoe.decode(pE); CegoBTreeManager btreeMng(this, &btoe); - btreeMng.freeBTree(); + int freedPages = btreeMng.freeBTree(); bp.freeEntry(pE); | ||
| [+] | Changed | cego-2.20.3.tar.bz2/src/CegoTableManager.cc ^ |
| @@ -3472,7 +3472,7 @@ #endif removeObject(tabSetId, tableName, CegoObject::TABLE); - + // create log entry CegoLogRecord lr; lr.setObjectInfo(tableName, type); @@ -3523,6 +3523,7 @@ void CegoTableManager::dropBTree(int tabSetId, const Chain& btreeName) { + CegoObject::ObjectType btType; if ( objectExists(tabSetId, btreeName, CegoObject::BTREE) ) @@ -3809,24 +3810,19 @@ { CegoBTreeValue iv; iv.valueFromSchema(&schema, len); - - btreeMng.insertBTree(sysEntry, dp, iv, tid); - - // cout << "Dumping btree ..." << endl; - // btreeMng.dumpBTree(); - // cout << "+++++++++++++++++++++++++++++++++++++++++++++" << endl; - + btreeMng.insertBTree(sysEntry, dp, iv, tid); moreTuple = getNextTuple(pC, schema, dp); } btreeMng.unfixRoot(); - + + // cout << "Dumping btree ..." << endl; // btreeMng.dumpBTree(); // cout << "+++++++++++++++++++++++++++++++++++++++++++++" << endl; - + if ( _isAborted ) { | ||