2004-01-04 03:07:23 Chris Studholme <Chris.Studholme@utoronto.ca>
  * updated version numbers
  M ModSQL/DriverConfig.java +3 -3
  M TODO +4 -6
  M modsql.java +1 -1

2004-01-04 03:01:20 Chris Studholme <Chris.Studholme@utoronto.ca>
  * updated documentation and version numbers
  M AsciiDatabase/Manager.java +2 -2
  M README +21 -19
  M SampleDatabase/Manager.java +2 -2
  M TODO +1 -2
  M TemporaryDatabase/Manager.java +2 -2
  M modsql.java +2 -2

2004-01-04 02:23:08 Chris Studholme <Chris.Studholme@utoronto.ca>
  * removed method not specified by interface and updated documentation
  M ModSQL/IndexTable.java +23 -5
  M ModSQL/IndexTable_Hash.java +43 -62
  M ModSQL/IndexTable_Sort.java +41 -59

2004-01-04 01:59:39 Chris Studholme <Chris.Studholme@utoronto.ca>
  * missing author tag
  M ModSQL/IndexTableEntry.java +3 -1
  M ModSQL/IndexTableRowset.java +3 -1

2004-01-04 01:41:25 Chris Studholme <Chris.Studholme@utoronto.ca>
  * documentation updates
  M ModSQL/DatabaseIndex.java +6 -4
  M ModSQL/DatabaseTable.java +46 -30
  M ModSQL/DatabaseTableBase.java +21 -22

2004-01-03 18:32:35 Chris Studholme <Chris.Studholme@utoronto.ca>
  * minor error in suggested code
  M UPGRADE +1 -1

2004-01-03 18:29:59 Chris Studholme <Chris.Studholme@utoronto.ca>
  * updated documentation
  M ModSQL/DatabaseManager.java +15 -9
  M ModSQL/IndexTableEntry.java +49 -4
  M ModSQL/IndexTableRowset.java +30 -6
  M ModSQL/MetaManager.java +96 -6

2004-01-03 17:54:11 Chris Studholme <Chris.Studholme@utoronto.ca>
  * removed doc link to DriverManager that doesn't seem to work
  M ModSQL/Driver.java +2 -2

2004-01-03 17:37:57 Chris Studholme <Chris.Studholme@utoronto.ca>
  * updated documentation
  M ModSQL/SelectTable.java +173 -34
  M ModSQL/TableReader.java +151 -19

2003-09-24 19:59:34 Chris Studholme <Chris.Studholme@utoronto.ca>
  * updated source documentation
  M Makefile +4 -0
  M ModSQL/Create.java +148 -67
  M ModSQL/Delete.java +53 -6
  M ModSQL/Drop.java +71 -9
  M ModSQL/Function.java +2 -2
  M ModSQL/Insert.java +118 -63
  M ModSQL/Select.java +112 -54
  M ModSQL/Update.java +53 -5

2003-07-09 06:59:49 Chris Studholme <Chris.Studholme@utoronto.ca>
  * use &lt; and &gt; in JavaDoc comments
  M ModSQL/Operator_Compare.java +2 -2

2003-07-09 06:54:49 Chris Studholme <Chris.Studholme@utoronto.ca>
  * updated JavaDoc comments
  M ModSQL/Aggregate_Count.java +23 -36
  M ModSQL/Aggregate_Math.java +30 -31
  M ModSQL/Aggregate_MinMax.java +27 -34
  M ModSQL/Function_Math.java +79 -5
  M ModSQL/Function_NVL.java +31 -22
  M ModSQL/Function_String.java +53 -1
  M ModSQL/Operator_Add.java +12 -36
  M ModSQL/Operator_Compare.java +54 -36
  M ModSQL/Operator_Concat.java +10 -34
  M ModSQL/Operator_Divide.java +12 -37
  M ModSQL/Operator_Exists.java +26 -49
  M ModSQL/Operator_In.java +46 -49
  M ModSQL/Operator_Is.java +14 -36
  M ModSQL/Operator_Like.java +14 -48
  M ModSQL/Operator_Logical.java +11 -31
  M ModSQL/Operator_Multiply.java +13 -36
  M ModSQL/Operator_Negate.java +17 -32
  M ModSQL/Operator_Not.java +17 -35

2003-06-03 05:40:21 Chris Studholme <Chris.Studholme@utoronto.ca>
  * possible optimizer bug to look into
  M TODO +4 -0

2003-05-29 08:04:29 Chris Studholme <Chris.Studholme@utoronto.ca>
  * finished changing canada.com to utoronto.ca
  M AsciiDatabase/AsciiReader.java +2 -2
  M AsciiDatabase/AsciiTable.java +8 -8
  M AsciiDatabase/Manager.java +2 -2
  M AsciiDatabase/RCFile.java +2 -2
  M SampleDatabase/AntiqueOwners_Row.java +2 -2
  M SampleDatabase/AntiqueOwners_Table.java +2 -2
  M SampleDatabase/Antiques_Row.java +2 -2
  M SampleDatabase/Antiques_Table.java +2 -2
  M SampleDatabase/EmployeeAddressTable_Row.java +2 -2
  M SampleDatabase/EmployeeAddressTable_Table.java +2 -2
  M SampleDatabase/EmployeeStatisticsTable_Row.java +2 -2
  M SampleDatabase/EmployeeStatisticsTable_Table.java +2 -2
  M SampleDatabase/Manager.java +2 -2
  M SampleDatabase/Orders_Row.java +2 -2
  M SampleDatabase/Orders_Table.java +2 -2
  M SampleDatabase/TableTemplate.java +2 -2
  M TODO +0 -1
  M TemporaryDatabase/Column.java +2 -2
  M TemporaryDatabase/Manager.java +2 -2
  M TemporaryDatabase/Table.java +2 -2
  M TemporaryDatabase/TableData.java +2 -2

2003-05-29 08:01:12 Chris Studholme <Chris.Studholme@utoronto.ca>
  * link to sun docs when creating JavaDoc documentation
  M Makefile +1 -1
  M tests/run-tests +1 -1

2003-05-29 07:55:43 Chris Studholme <Chris.Studholme@utoronto.ca>
  * added SQLExceptionWithCause and updated DatabaseException to use java v1.4
  * exception cause mechanism
  M ModSQL/DatabaseException.java +31 -14
  M ModSQL/Delete.java +1 -1
  M ModSQL/Function_String.java +2 -2
  M ModSQL/IndexTable_Hash.java +6 -10
  M ModSQL/IndexTable_Sort.java +6 -10
  M ModSQL/Insert.java +1 -1
  M ModSQL/Makefile +1 -1
  M ModSQL/Operator_Exists.java +1 -1
  M ModSQL/Operator_In.java +1 -1
  M ModSQL/PreparedStatement.java +2 -2
  M ModSQL/ResultSet.java +2 -2
  A ModSQL/SQLExceptionWithCause.java 
  M ModSQL/Select.java +5 -5
  M ModSQL/SelectTable.java +9 -16
  M ModSQL/Update.java +1 -1

2003-05-29 07:19:40 Chris Studholme <Chris.Studholme@utoronto.ca>
  * updated comments
  M ModSQL/Connection.java +16 -39
  M ModSQL/DatabaseMetaData.java +26 -21
  M ModSQL/Driver.java +26 -8
  M ModSQL/PreparedStatement.java +34 -18
  M ModSQL/ResultSet.java +13 -9
  M ModSQL/ResultSetMetaData.java +7 -4

2003-05-29 05:48:45 Chris Studholme <Chris.Studholme@utoronto.ca>
  * updated JavaDoc comments
  M ModSQL/DriverConfig.java +36 -6
  M ModSQL/EndOfTable.java +12 -4
  M ModSQL/Expression.java +13 -13
  M ModSQL/FunctionProvider.java +3 -3
  M ModSQL/LiteralTable.java +65 -45
  M ModSQL/NumberMath.java +1 -1
  M ModSQL/Query.java +10 -2
  M ModSQL/Table.java +51 -33

2003-05-29 04:58:40 Chris Studholme <Chris.Studholme@utoronto.ca>
  * updated comments
  M ModSQL/IndirectFunction.java +4 -4
  M ModSQL/Literal.java +1 -1
  M ModSQL/LiteralRow.java +54 -59
  M ModSQL/Operator.java +6 -10

2003-05-29 04:30:34 Chris Studholme <Chris.Studholme@utoronto.ca>
  * updated email address of author
  M modsql.c +1 -1
  M modsql.java +2 -2

2003-05-29 04:28:21 Chris Studholme <Chris.Studholme@utoronto.ca>
  * work on updating comments
  M ModSQL/AbstractAggregate.java +30 -21
  M ModSQL/Aggregate.java +5 -3
  M ModSQL/IndirectFunction.java +79 -76
  M ModSQL/Literal.java +63 -76
  M ModSQL/RowConstructor.java +38 -11

2003-05-29 04:28:11 Chris Studholme <Chris.Studholme@utoronto.ca>
  * fixed bug where columns are being checked for indexing over and over;
  * updated comments
  M ModSQL/ColumnValue.java +79 -92

2003-05-29 02:31:08 Chris Studholme <Chris.Studholme@utoronto.ca>
  * changed chris.studholme@canada.com to @utoronto.ca;
  * changed @exception to @throws;
  * started work on updating JavaDoc comments for all methods/classes
  M ModSQL/AbstractAggregate.java +2 -2
  M ModSQL/AbstractFunction.java +87 -100
  M ModSQL/Aggregate.java +2 -2
  M ModSQL/Aggregate_Count.java +2 -2
  M ModSQL/Aggregate_Math.java +2 -2
  M ModSQL/Aggregate_MinMax.java +2 -2
  M ModSQL/ColumnValue.java +13 -13
  M ModSQL/Connection.java +24 -24
  M ModSQL/Create.java +2 -2
  M ModSQL/DatabaseException.java +2 -2
  M ModSQL/DatabaseIndex.java +3 -3
  M ModSQL/DatabaseManager.java +10 -10
  M ModSQL/DatabaseMetaData.java +143 -143
  M ModSQL/DatabaseTable.java +17 -17
  M ModSQL/DatabaseTableBase.java +12 -12
  M ModSQL/Delete.java +2 -2
  M ModSQL/Driver.java +5 -5
  M ModSQL/DriverConfig.java +2 -2
  M ModSQL/Drop.java +2 -2
  M ModSQL/EndOfTable.java +2 -2
  M ModSQL/Expression.java +11 -11
  M ModSQL/Function.java +94 -58
  M ModSQL/FunctionProvider.java +2 -2
  M ModSQL/Function_Math.java +2 -2
  M ModSQL/Function_NVL.java +2 -2
  M ModSQL/Function_String.java +2 -2
  M ModSQL/IndexTable.java +1 -1
  M ModSQL/IndexTableEntry.java +1 -1
  M ModSQL/IndexTableRowset.java +1 -1
  M ModSQL/IndexTable_Hash.java +2 -2
  M ModSQL/IndexTable_Sort.java +2 -2
  M ModSQL/IndirectFunction.java +12 -13
  M ModSQL/Insert.java +2 -2
  M ModSQL/Literal.java +11 -13
  M ModSQL/LiteralRow.java +7 -7
  M ModSQL/LiteralTable.java +3 -3
  M ModSQL/MetaManager.java +2 -2
  M ModSQL/NumberMath.java +2 -2
  M ModSQL/Operator.java +2 -2
  M ModSQL/Operator_Add.java +12 -12
  M ModSQL/Operator_Compare.java +14 -14
  M ModSQL/Operator_Concat.java +6 -6
  M ModSQL/Operator_Divide.java +13 -13
  M ModSQL/Operator_Exists.java +6 -6
  M ModSQL/Operator_In.java +6 -6
  M ModSQL/Operator_Is.java +6 -6
  M ModSQL/Operator_Like.java +6 -6
  M ModSQL/Operator_Logical.java +22 -22
  M ModSQL/Operator_Multiply.java +12 -12
  M ModSQL/Operator_Negate.java +13 -13
  M ModSQL/Operator_Not.java +10 -10
  M ModSQL/PreparedStatement.java +61 -61
  M ModSQL/Query.java +2 -2
  M ModSQL/ResultSet.java +118 -118
  M ModSQL/ResultSetMetaData.java +22 -22
  M ModSQL/RowConstructor.java +2 -2
  M ModSQL/Select.java +11 -12
  M ModSQL/SelectTable.java +2 -2
  M ModSQL/Table.java +2 -2
  M ModSQL/TableReader.java +2 -2
  M ModSQL/Update.java +2 -2

2003-04-11 23:05:49 Chris Studholme <Chris.Studholme@utoronto.ca>
  * flush output stream when writing query results;
  * change references to canada.com to utoronto.ca (since canada.com is 
  * non-free)
  M ChangeLog +145 -145
  M README +1 -1
  M TODO +1 -0
  M modsql.java +4 -0

2003-04-11 23:03:23 Chris Studholme <Chris.Studholme@utoronto.ca>
  * allow +number as literal constant
  M ModSQL/Expression.java +12 -8

2003-04-04 04:56:42 Chris Studholme <Chris.Studholme@utoronto.ca>
  * slightly better SQL command summary help text
  M NEWS +1 -1
  M modsql.java +3 -2

2003-04-04 03:52:53 Chris Studholme <Chris.Studholme@utoronto.ca>
  * got rid of '-q' option (quiet) in favour of '-v' option (verbose) instead
  M modsql.java +20 -16

2003-04-03 20:08:58 Chris Studholme <Chris.Studholme@utoronto.ca>
  * added option '-q' to be quiet
  M NEWS +1 -0
  M modsql.java +13 -4

2003-04-03 19:58:08 Chris Studholme <Chris.Studholme@utoronto.ca>
  * bug fix: function parameters can be arbitrary expressions
  M ModSQL/Expression.java +1 -1

2003-04-03 04:46:52 Chris Studholme <Chris.Studholme@utoronto.ca>
  * fixed bug: missing q on end of $-q
  M modsql.java +8 -2

2003-04-03 04:46:24 Chris Studholme <Chris.Studholme@utoronto.ca>
  * fixed bug: incorrect promotion between integer and double
  M ModSQL/AbstractFunction.java +2 -1

2003-04-03 03:51:16 Chris Studholme <Chris.Studholme@utoronto.ca>
  * fixed bug: reading a column from stdin was broken
  M modsql.java +4 -1

2003-04-03 01:46:18 Chris Studholme <Chris.Studholme@utoronto.ca>
  * script doesn't work with standard bourne shell
  M tests/run-tests +1 -1

2003-04-03 01:17:47 Chris Studholme <Chris.Studholme@utoronto.ca>
  * bug fix: openIndex() should return DatabaseIndex object;
  * bug fix: opened tables are DatabaseTableBase, not DatabaseTable
  M AsciiDatabase/AsciiTable.java +1 -1
  M ModSQL/DatabaseTable.java +1 -1
  M ModSQL/IndexTable_Hash.java +0 -4
  M ModSQL/IndexTable_Sort.java +0 -4
  M ModSQL/SelectTable.java +1 -1
  M ModSQL/TableReader.java +1 -1
  M SampleDatabase/TableTemplate.java +1 -1
  M TemporaryDatabase/Table.java +1 -1

2003-04-02 23:08:51 Chris Studholme <Chris.Studholme@utoronto.ca>
  * updated ChangeLog, NEWS, and version numbers
  M AsciiDatabase/Manager.java +1 -1
  M ChangeLog +825 -0
  D ChangeLog.old 
  M ModSQL/DriverConfig.java +2 -2
  M NEWS +26 -0
  M SampleDatabase/Manager.java +1 -1
  M TemporaryDatabase/Manager.java +1 -1
  M modsql.java +1 -1

2003-04-02 20:31:58 Chris Studholme <Chris.Studholme@utoronto.ca>
  * more work on test compatibility with postgres
  M tests/book_queries.sql +3 -3
  M tests/book_queries11.sql +19 -12
  M tests/book_queries12.sql +14 -7
  M tests/book_queries16.sql +11 -11

2003-04-02 20:28:19 Chris Studholme <Chris.Studholme@utoronto.ca>
  * fixed bug: failed to reset having when doing grouping
  M ModSQL/Select.java +2 -0

2003-04-02 19:48:44 Chris Studholme <Chris.Studholme@utoronto.ca>
  * more work on getting tests to pass
  M tests/aggregate.sql +13 -8
  M tests/book_queries11.sql +1 -1
  M tests/book_queries16.sql +2 -1
  M tests/sample_database.sql +7 -4

2003-04-02 19:22:37 Chris Studholme <Chris.Studholme@utoronto.ca>
  * more work on making ModSQL act like PostgreSQL so tests can be compared
  M ModSQL/Create.java +3 -3
  M ModSQL/Drop.java +1 -1
  M TODO +10 -7
  M modsql.java +3 -7
  M tests/delete-test.sql +3 -3
  M tests/sample_database.sql +5 -5
  M tests/update-test.sql +3 -3

2003-04-02 19:08:30 Chris Studholme <Chris.Studholme@utoronto.ca>
  * minor alterations to tests so postgresql can execute them
  M tests/aggregate.sql +2 -0
  A tests/book_p.table 
  M tests/book_queries.sql +7 -26
  M tests/book_queries11.sql +6 -26
  M tests/book_queries12.sql +6 -26
  M tests/book_queries16.sql +8 -26
  A tests/book_s.table 
  A tests/book_sp.table 
  M tests/copy_from.sql +6 -4
  A tests/copy_from.table 
  M tests/delete-test.sql +6 -2
  M tests/sample_database.sql +1 -1
  M tests/update-test.sql +6 -2

2003-04-01 00:26:40 Chris Studholme <Chris.Studholme@utoronto.ca>
  * altered test output format
  M TODO +1 -0
  M tests/run-tests +1 -1

2003-04-01 00:22:21 Chris Studholme <Chris.Studholme@utoronto.ca>
  * fixed output of zero update count for insert/update/delete
  M TODO +3 -3
  M modsql.java +2 -1

2003-04-01 00:15:59 Chris Studholme <Chris.Studholme@utoronto.ca>
  * added support for squeezed fixed-width and delimited output;
  * various changes in method name case
  M TODO +0 -2
  M modsql.java +235 -77

2003-03-24 02:55:31 Chris Studholme <Chris.Studholme@utoronto.ca>
  * ensure column value are invalidated when opening a new table
  M ModSQL/TableReader.java +8 -2

2003-03-23 18:48:37 Chris Studholme <Chris.Studholme@utoronto.ca>
  * allow SQL style '--' comments in scripts
  M ModSQL/Select.java +1 -0
  M TODO +2 -1
  M modsql.java +32 -12
  M tests/aggregate.sql +0 -1
  M tests/any_all.sql +0 -1
  M tests/book_queries.sql +5 -2
  M tests/book_queries11.sql +9 -9
  M tests/book_queries12.sql +6 -6
  M tests/book_queries16.sql +3 -3
  M tests/copy_from.sql +0 -1
  M tests/create_insert.sql +0 -1
  M tests/sample_database.sql +5 -4

2003-03-23 18:15:05 Chris Studholme <Chris.Studholme@utoronto.ca>
  * made UPDATE and DELETE work
  M ModSQL/DatabaseIndex.java +4 -4
  M ModSQL/DatabaseTable.java +15 -25
  M ModSQL/DatabaseTableBase.java +19 -13
  M ModSQL/Delete.java +43 -4
  M ModSQL/TableReader.java +28 -0
  M ModSQL/Update.java +71 -8
  M TODO +1 -2
  M tests/book_queries.sql +9 -1
  A tests/delete-test.sql 
  A tests/update-test.sql 

2003-03-23 17:18:27 Chris Studholme <Chris.Studholme@utoronto.ca>
  * execute basic SELECT DISTINCT one-the-fly
  M ModSQL/Select.java +36 -12
  M TODO +1 -3

2003-03-23 16:57:50 Chris Studholme <Chris.Studholme@utoronto.ca>
  * bug fix: not invalidating column data in TableReader.reset();
  * bug fix: EXISTS and IN not checking table for isConstant and isAggregate
  M ModSQL/Operator_Exists.java +22 -2
  M ModSQL/Operator_In.java +35 -0
  M ModSQL/Select.java +14 -13
  M ModSQL/TableReader.java +34 -17
  M TODO +0 -1

2003-03-23 16:16:05 Chris Studholme <Chris.Studholme@utoronto.ca>
  * added optimize() and toString(boolean) methods to Query interface
  M ModSQL/Create.java +8 -0
  M ModSQL/Delete.java +10 -2
  M ModSQL/Drop.java +8 -0
  M ModSQL/Insert.java +18 -5
  M ModSQL/PreparedStatement.java +4 -6
  M ModSQL/Query.java +11 -1
  M ModSQL/Select.java +0 -1
  M ModSQL/Update.java +10 -1
  M TODO +1 -0

2003-03-23 00:34:01 Chris Studholme <Chris.Studholme@utoronto.ca>
  * implemented EXISTS operator (but I don't think it's working properly)
  M ModSQL/Expression.java +4 -1
  M ModSQL/Makefile +1 -1
  A ModSQL/Operator_Exists.java 
  M TODO +2 -2
  M tests/book_queries12.sql +10 -1

2003-03-23 00:14:18 Chris Studholme <Chris.Studholme@utoronto.ca>
  * moved most math routines for Number objects to NumberMath class
  M ModSQL/Expression.java +1 -1
  M ModSQL/Function_Math.java +7 -62
  M ModSQL/Makefile +1 -0
  A ModSQL/NumberMath.java 
  M ModSQL/Operator_Add.java +5 -39
  M ModSQL/Operator_Divide.java +2 -31
  M ModSQL/Operator_Multiply.java +4 -32
  M ModSQL/Operator_Negate.java +6 -26
  M TODO +2 -1

2003-03-21 19:28:19 Chris Studholme <Chris.Studholme@utoronto.ca>
  * chapter 16 queries from sql book
  A tests/book_queries16.sql 

2003-03-21 19:28:04 Chris Studholme <Chris.Studholme@utoronto.ca>
  * bug fix: scalars return null when no rows are available
  M ModSQL/Select.java +6 -4

2003-03-21 19:27:35 Chris Studholme <Chris.Studholme@utoronto.ca>
  * bug fix: misinterpretation of inequality for row constructors
  M ModSQL/Operator_Compare.java +42 -26

2003-03-21 18:24:41 Chris Studholme <Chris.Studholme@utoronto.ca>
  * more sql book queries (by chapter)
  M tests/book_queries.sql +0 -83
  A tests/book_queries11.sql 
  A tests/book_queries12.sql 

2003-03-21 05:23:22 Chris Studholme <Chris.Studholme@utoronto.ca>
  * started testing infrastructure
  A tests/aggregate.sql 
  A tests/any_all.sql 
  A tests/book_queries.sql 
  A tests/copy_from.sql 
  A tests/create_insert.sql 
  A tests/run-tests 
  A tests/sample_database.sql 

2003-03-21 05:20:04 Chris Studholme <Chris.Studholme@utoronto.ca>
  * bug fix: during column name lookup, don't check table name is alias exists
  M ModSQL/TableReader.java +9 -10

2003-03-21 04:58:38 Chris Studholme <Chris.Studholme@utoronto.ca>
  * fixed bug: failed to reset count/sum on reset()
  M ModSQL/Aggregate_Math.java +4 -4

2003-03-21 04:50:31 Chris Studholme <Chris.Studholme@utoronto.ca>
  * fixed bug: incorrect detection of aggregates in optimize()
  M ModSQL/Select.java +1 -1
  M TODO +2 -0

2003-03-21 03:30:22 Chris Studholme <Chris.Studholme@utoronto.ca>
  * bug: evaluateConstantParameters() was calling optimize()
  M ModSQL/AbstractFunction.java +0 -1
  M ModSQL/FunctionProvider.java +1 -1
  M ModSQL/Operator_In.java +16 -1
  M ModSQL/Select.java +1 -0

2003-03-21 00:31:09 Chris Studholme <Chris.Studholme@utoronto.ca>
  * made initial hashtable size a property in ModSQL.conf
  M ModSQL/AbstractAggregate.java +1 -3
  M ModSQL/DriverConfig.java +13 -4
  M ModSQL/ModSQL.conf +3 -0
  M ModSQL/Operator_In.java +1 -4
  M ModSQL/Select.java +2 -3
  M TODO +1 -5

2003-03-21 00:11:03 Chris Studholme <Chris.Studholme@utoronto.ca>
  * implemented IN/ALL/ANY/SOME operators
  M ModSQL/AbstractFunction.java +10 -0
  M ModSQL/LiteralTable.java +10 -0
  M ModSQL/Operator_Compare.java +35 -22
  M ModSQL/Operator_In.java +153 -115
  M ModSQL/Select.java +10 -0
  M ModSQL/Table.java +10 -0
  M TODO +0 -3

2003-03-20 17:58:30 Chris Studholme <Chris.Studholme@utoronto.ca>
  * much work on matched evaluate() methods
  M ModSQL/AbstractFunction.java +25 -8
  M ModSQL/Function.java +18 -3
  M ModSQL/Operator_Add.java +21 -19
  M ModSQL/Operator_Compare.java +272 -105
  M ModSQL/Operator_Concat.java +5 -34
  M ModSQL/Operator_Divide.java +6 -11
  M ModSQL/Operator_Logical.java +7 -23
  M ModSQL/Operator_Multiply.java +23 -27
  M ModSQL/Operator_Negate.java +4 -2
  M ModSQL/Operator_Not.java +6 -15
  M TODO +6 -8

2003-03-20 17:58:08 Chris Studholme <Chris.Studholme@utoronto.ca>
  * more flexible toString() methods
  M ModSQL/Insert.java +1 -1
  M ModSQL/LiteralRow.java +18 -0
  M ModSQL/LiteralTable.java +10 -3
  M ModSQL/Table.java +8 -0

2003-03-20 17:56:57 Chris Studholme <Chris.Studholme@utoronto.ca>
  * added matched evaluate to ColumnValue and support in TableReader
  M ModSQL/ColumnValue.java +10 -26
  M ModSQL/TableReader.java +30 -28

2003-03-19 19:28:52 Chris Studholme <Chris.Studholme@utoronto.ca>
  * implemented parameter ordering
  M ModSQL/AbstractAggregate.java +8 -32
  M ModSQL/AbstractFunction.java +46 -11
  M ModSQL/ColumnValue.java +1 -1
  M ModSQL/PreparedStatement.java +5 -1
  M ModSQL/Select.java +7 -2
  M ModSQL/TableReader.java +126 -17
  M TODO +0 -1

2003-03-19 17:20:19 Chris Studholme <Chris.Studholme@utoronto.ca>
  * added code to figure out which tables are used by a Function;
  * moved GroupByList to inner class of Select
  M ModSQL/AbstractAggregate.java +1 -1
  M ModSQL/ColumnValue.java +15 -4
  D ModSQL/GroupByList.java 
  M ModSQL/IndirectFunction.java +2 -2
  M ModSQL/Makefile +1 -1
  M ModSQL/Select.java +42 -1
  M ModSQL/TableReader.java +45 -8

2003-03-19 16:41:25 Chris Studholme <Chris.Studholme@utoronto.ca>
  * minor change in equals() for order_by comparitor
  M ModSQL/Select.java +4 -5

2003-03-19 07:29:48 Chris Studholme <Chris.Studholme@utoronto.ca>
  * implemented use of row constructors with IS operator
  M ModSQL/Operator_Is.java +59 -47
  M TODO +2 -2

2003-03-19 06:53:36 Chris Studholme <Chris.Studholme@utoronto.ca>
  * updated INSERT to work again
  M ModSQL/Insert.java +34 -94
  M TODO +1 -0

2003-03-19 05:55:03 Chris Studholme <Chris.Studholme@utoronto.ca>
  * ensure "VALUES ..." always returns a literal table
  M ModSQL/Expression.java +18 -15

2003-03-17 05:14:02 Chris Studholme <Chris.Studholme@utoronto.ca>
  * debugged table subqueries and tested single value subqueries
  M ModSQL/Expression.java +1 -1
  M ModSQL/LiteralRow.java +2 -2
  M ModSQL/Select.java +5 -7
  M ModSQL/SelectTable.java +6 -7
  M TODO +1 -4

2003-03-17 04:52:46 Chris Studholme <Chris.Studholme@utoronto.ca>
  * renamed numParameters() to getParameterCount();
  * simplified LiteralRow by extending AbstractFunction
  M ModSQL/AbstractFunction.java +18 -4
  M ModSQL/ColumnValue.java +1 -1
  M ModSQL/Expression.java +1 -1
  M ModSQL/Function.java +2 -2
  M ModSQL/IndirectFunction.java +5 -5
  M ModSQL/Literal.java +1 -1
  M ModSQL/LiteralRow.java +31 -225
  M ModSQL/Operator.java +7 -7
  M ModSQL/Operator_Add.java +1 -1
  M ModSQL/Operator_Logical.java +1 -1
  M ModSQL/Operator_Multiply.java +1 -1
  M ModSQL/Select.java +1 -1

2003-03-17 04:27:39 Chris Studholme <Chris.Studholme@utoronto.ca>
  * made sure all tables get opened (read) during queries
  M ModSQL/Select.java +22 -16
  M ModSQL/TableReader.java +0 -20

2003-03-17 02:15:50 Chris Studholme <Chris.Studholme@utoronto.ca>
  * made Select a row-constructor and finished implementing subqueries
  M ModSQL/Expression.java +4 -8
  M ModSQL/Select.java +149 -2

2003-03-17 02:00:10 Chris Studholme <Chris.Studholme@utoronto.ca>
  * work towards getting table subqueries working
  M ModSQL/Expression.java +1 -0
  M ModSQL/Makefile +1 -1
  M ModSQL/Select.java +9 -16
  M ModSQL/SelectTable.java +72 -53
  M TODO +1 -0

2003-03-13 01:53:52 Chris Studholme <Chris.Studholme@utoronto.ca>
  * all instance variables in TableReader are private
  * started work on SelectTable
  M ModSQL/ColumnValue.java +6 -8
  M ModSQL/Select.java +17 -10
  M ModSQL/SelectTable.java +17 -30
  M ModSQL/TableReader.java +21 -1
  M TODO +18 -16

2003-03-13 01:10:52 Chris Studholme <Chris.Studholme@utoronto.ca>
  * ensure we distinguish before first and after last, and
  * detect failure to read a row between next() calls (infinite loop)
  M ModSQL/TableReader.java +34 -31

2003-03-13 00:05:19 Chris Studholme <Chris.Studholme@utoronto.ca>
  * implemented standard SQL math functions
  M ModSQL/AbstractFunction.java +8 -2
  M ModSQL/Function.java +4 -2
  M ModSQL/Function_Math.java +200 -233
  M ModSQL/Makefile +1 -2
  M ModSQL/ModSQL.conf +1 -2
  M TODO +4 -2

2003-03-12 23:00:21 Chris Studholme <Chris.Studholme@utoronto.ca>
  * added method to (eventually) optimize parameter order (join order)
  M ModSQL/Select.java +2 -25
  M ModSQL/TableReader.java +10 -0

2003-03-12 22:30:26 Chris Studholme <Chris.Studholme@utoronto.ca>
  * implemented standard SQL string functions
  M ModSQL/Function_NVL.java +55 -70
  M ModSQL/Function_String.java +166 -243
  M ModSQL/Makefile +3 -3
  M ModSQL/ModSQL.conf +2 -2
  M TODO +2 -0

2003-03-12 20:47:13 Chris Studholme <Chris.Studholme@utoronto.ca>
  * moved RCFile class to AsciiDatabase package
  M AsciiDatabase/AsciiTable.java +0 -1
  M AsciiDatabase/Makefile +1 -1
  M AsciiDatabase/Manager.java +0 -1
  A AsciiDatabase/RCFile.java 
  M Makefile +1 -2
  M ModSQL/ModSQL.conf +1 -1

2003-03-12 20:40:41 Chris Studholme <Chris.Studholme@utoronto.ca>
  * oops, forgot to include this source file
  A ModSQL/Aggregate_Math.java 

2003-03-12 20:39:55 Chris Studholme <Chris.Studholme@utoronto.ca>
  * implemented remaining aggregate functions
  M ModSQL/AbstractAggregate.java +12 -5
  M ModSQL/Aggregate_Count.java +19 -25
  A ModSQL/Aggregate_MinMax.java 
  D ModSQL/Function_Aggregate.java 
  M ModSQL/Function_Math.java +0 -1
  M ModSQL/Function_NVL.java +0 -1
  M ModSQL/Function_String.java +0 -1
  M ModSQL/Makefile +7 -5
  M ModSQL/ModSQL.conf +2 -2
  D ModSQL/RowList.java 
  M ModSQL/Select.java +4 -6
  M TODO +7 -8

2003-03-12 19:22:53 Chris Studholme <Chris.Studholme@utoronto.ca>
  * renamed DatabaseFunction to Function
  M AsciiDatabase/Manager.java +1 -1
  M ModSQL/AbstractFunction.java +11 -11
  M ModSQL/Aggregate.java +2 -2
  M ModSQL/Aggregate_Count.java +2 -2
  M ModSQL/ColumnValue.java +4 -4
  D ModSQL/DatabaseFunction.java 
  M ModSQL/DatabaseManager.java +1 -1
  M ModSQL/Delete.java +1 -1
  M ModSQL/Expression.java +21 -21
  M ModSQL/Function.java +171 -473
  M ModSQL/FunctionProvider.java +4 -4
  M ModSQL/GroupByList.java +4 -4
  M ModSQL/IndirectFunction.java +5 -5
  M ModSQL/Insert.java +3 -3
  M ModSQL/Literal.java +3 -3
  M ModSQL/LiteralRow.java +11 -11
  M ModSQL/LiteralTable.java +9 -9
  M ModSQL/Makefile +1 -1
  M ModSQL/MetaManager.java +2 -2
  M ModSQL/Operator.java +6 -6
  M ModSQL/Operator_Add.java +1 -1
  M ModSQL/Operator_Logical.java +1 -1
  M ModSQL/Operator_Multiply.java +2 -2
  M ModSQL/Operator_Negate.java +1 -1
  M ModSQL/Operator_Not.java +1 -1
  M ModSQL/RowConstructor.java +1 -1
  M ModSQL/RowList.java +1 -1
  M ModSQL/Select.java +26 -26
  M ModSQL/Table.java +2 -2
  M ModSQL/TableReader.java +4 -4
  M ModSQL/Update.java +4 -4
  M SampleDatabase/Manager.java +1 -1
  M TODO +8 -10
  M TemporaryDatabase/Manager.java +1 -1

2003-03-12 19:13:05 Chris Studholme <Chris.Studholme@utoronto.ca>
  * finished implementing query execution
  M ModSQL/GroupByList.java +1 -1
  M ModSQL/IndirectFunction.java +6 -2
  M ModSQL/Select.java +178 -75
  M ModSQL/TableReader.java +9 -7
  M TODO +0 -1

2003-03-12 00:46:51 Chris Studholme <Chris.Studholme@utoronto.ca>
  * removed a few more obsolete files
  D ModSQL/ExplicitRowList.java 
  D ModSQL/Util.java 
  M TODO +12 -0

2003-03-12 00:34:23 Chris Studholme <Chris.Studholme@utoronto.ca>
  * ORDER BY works with GROUP BY, but not with non-grouping query yet
  M ModSQL/Select.java +84 -466
  M ModSQL/TableReader.java +5 -7
  M TODO +12 -16

2003-03-11 23:03:04 Chris Studholme <Chris.Studholme@utoronto.ca>
  * work ensuring EndOfTable thrown at appropriate times and aggregate accuracy
  M ModSQL/Select.java +150 -112
  M ModSQL/TableReader.java +118 -23
  M TODO +4 -0

2003-03-11 17:23:17 Chris Studholme <Chris.Studholme@utoronto.ca>
  * implemented aggregate function COUNT
  M ModSQL/AbstractAggregate.java +48 -3
  A ModSQL/Aggregate_Count.java 
  M ModSQL/Expression.java +40 -3
  M ModSQL/IndirectFunction.java +6 -2
  M ModSQL/Makefile +2 -0
  M ModSQL/ModSQL.conf +2 -1

2003-03-11 07:50:42 Chris Studholme <Chris.Studholme@utoronto.ca>
  * most queries are working now but order by and distinct are not
  M ModSQL/AbstractFunction.java +11 -8
  M ModSQL/ColumnValue.java +11 -3
  M ModSQL/EndOfTable.java +15 -1
  M ModSQL/Makefile +12 -20
  M ModSQL/Select.java +222 -74
  M ModSQL/TableReader.java +34 -9

2003-03-11 05:21:07 Chris Studholme <Chris.Studholme@utoronto.ca>
  * more query preparation and optimization
  A ModSQL/GroupByList.java 
  M ModSQL/IndirectFunction.java +4 -1
  M ModSQL/Makefile +3 -2
  M ModSQL/PreparedStatement.java +38 -41
  M ModSQL/Select.java +82 -71
  M ModSQL/TableReader.java +3 -2

2003-03-11 02:05:16 Chris Studholme <Chris.Studholme@utoronto.ca>
  * ensure that all return values are the correct type
  M ModSQL/AbstractFunction.java +251 -20
  M ModSQL/Expression.java +0 -148
  M ModSQL/Literal.java +1 -1
  M ModSQL/LiteralTable.java +20 -8
  M ModSQL/Operator_Add.java +26 -52
  M ModSQL/Operator_Compare.java +1 -2
  M ModSQL/Operator_Divide.java +24 -58
  M ModSQL/Operator_Multiply.java +28 -54
  M ModSQL/Operator_Negate.java +0 -9

2003-03-10 23:27:49 Chris Studholme <Chris.Studholme@utoronto.ca>
  * finished eliminating old code from compile
  M ModSQL/ColumnValue.java +242 -83
  M ModSQL/Delete.java +2 -2
  M ModSQL/Expression.java +6 -6
  M ModSQL/Insert.java +12 -11
  M ModSQL/Literal.java +183 -47
  M ModSQL/Makefile +3 -3
  M ModSQL/PreparedStatement.java +3 -3
  M ModSQL/ResultSet.java +2 -2
  M ModSQL/ResultSetMetaData.java +2 -2
  D ModSQL/RowDefinition.java 
  M ModSQL/Select.java +605 -453
  D ModSQL/SelectValue.java 
  M ModSQL/TableReader.java +4 -4
  M ModSQL/Update.java +6 -6
  D ModSQL/Value.java 

2003-03-10 22:57:57 Chris Studholme <Chris.Studholme@utoronto.ca>
  * basic queries are now working with new code;
  * work on removing old code from tree
  D ModSQL/Function_Add.java 
  D ModSQL/Function_Comparison.java 
  D ModSQL/Function_Concat.java 
  D ModSQL/Function_Divide.java 
  D ModSQL/Function_Is.java 
  D ModSQL/Function_Logical.java 
  D ModSQL/Function_Multiply.java 
  D ModSQL/Function_Negate.java 
  D ModSQL/List.java 
  M ModSQL/LiteralRow.java +1 -1
  M ModSQL/Makefile +8 -14
  M ModSQL/PreparedStatement.java +2 -2
  M ModSQL/ResultSet.java +10 -4
  M ModSQL/ResultSetMetaData.java +14 -20
  M ModSQL/TableReader.java +13 -32

2003-03-10 20:46:25 Chris Studholme <Chris.Studholme@utoronto.ca>
  * added table interface and literal table implementation
  * added table comparison operators (ie. IN) and fixed parsing of them
  M ModSQL/Expression.java +119 -63
  A ModSQL/LiteralTable.java 
  M ModSQL/Makefile +13 -10
  M ModSQL/Operator_Compare.java +4 -10
  A ModSQL/Operator_In.java 
  M ModSQL/RowConstructor.java +1 -1
  A ModSQL/Table.java 
  M ModSQL/TableReader.java +0 -9

2003-03-10 07:16:55 Chris Studholme <Chris.Studholme@utoronto.ca>
  * more work towards getting TableReader working properly
  M ModSQL/Expression.java +1 -1
  A ModSQL/FunctionProvider.java 
  A ModSQL/IndirectFunction.java 
  D ModSQL/IndirectValue.java 
  M ModSQL/Makefile +2 -1
  M ModSQL/PreparedStatement.java +1 -1
  M ModSQL/Select.java +4 -5
  M ModSQL/TableReader.java +3 -3

2003-03-10 05:59:00 Chris Studholme <Chris.Studholme@utoronto.ca>
  * mostly work implementing TableReader as replacement for RowDescription
  M ModSQL/AbstractFunction.java +26 -15
  M ModSQL/DatabaseFunction.java +12 -0
  M ModSQL/Expression.java +2 -2
  M ModSQL/IndirectValue.java +21 -13
  M ModSQL/LiteralRow.java +21 -0
  M ModSQL/Makefile +5 -0
  M ModSQL/PreparedStatement.java +3 -2
  A ModSQL/TableReader.java 

2003-03-10 03:54:19 Chris Studholme <Chris.Studholme@utoronto.ca>
  * altered addParameter() to combine like operators and remove double not/negation
  M ModSQL/Operator.java +54 -33
  M ModSQL/Operator_Add.java +22 -7
  M ModSQL/Operator_Logical.java +23 -6
  M ModSQL/Operator_Multiply.java +24 -6

2003-03-09 19:32:13 Chris Studholme <Chris.Studholme@utoronto.ca>
  * implemented scalar comparison
  * added interface and abstract implementation for aggregate functions
  * added interface for database supplied functions
  M AsciiDatabase/Manager.java +4 -0
  A ModSQL/AbstractAggregate.java 
  M ModSQL/AbstractFunction.java +4 -16
  A ModSQL/Aggregate.java 
  M ModSQL/DatabaseManager.java +25 -11
  M ModSQL/Expression.java +46 -74
  M ModSQL/LiteralRow.java +10 -1
  M ModSQL/Makefile +1 -0
  M ModSQL/MetaManager.java +11 -0
  M ModSQL/Operator_Compare.java +197 -46
  M SampleDatabase/Manager.java +5 -0
  M TemporaryDatabase/Manager.java +3 -0

2003-03-09 05:31:54 Chris Studholme <Chris.Studholme@utoronto.ca>
  * interface for row-constructors and an implementation
  M ModSQL/DatabaseFunction.java +4 -11
  M ModSQL/Expression.java +42 -39
  A ModSQL/LiteralRow.java 
  M ModSQL/Makefile +2 -3
  A ModSQL/RowConstructor.java 

2003-03-09 04:23:38 Chris Studholme <Chris.Studholme@utoronto.ca>
  * work on parsing expressions
  A ModSQL/ExplicitRowList.java 
  A ModSQL/Expression.java 
  A ModSQL/IndirectValue.java 
  M ModSQL/Makefile +9 -3
  M ModSQL/Operator.java +2 -28
  M ModSQL/Operator_Add.java +0 -1
  A ModSQL/Operator_Compare.java 
  M ModSQL/Operator_Concat.java +0 -1
  M ModSQL/Operator_Divide.java +0 -1
  M ModSQL/Operator_Is.java +0 -1
  M ModSQL/Operator_Like.java +0 -1
  M ModSQL/Operator_Logical.java +22 -23
  M ModSQL/Operator_Multiply.java +0 -1
  M ModSQL/Operator_Negate.java +3 -1
  M ModSQL/Operator_Not.java +3 -1
  A ModSQL/RowList.java 

2003-03-07 02:54:39 Chris Studholme <Chris.Studholme@utoronto.ca>
  * added LIKE operator and fixed type in IS operator
  M ModSQL/Makefile +1 -1
  M ModSQL/Operator_Is.java +1 -1
  A ModSQL/Operator_Like.java 

2003-03-07 02:40:49 Chris Studholme <Chris.Studholme@utoronto.ca>
  * can't evaluate constant parameters if some are row-constructors
  M ModSQL/AbstractFunction.java +22 -16
  M ModSQL/Makefile +1 -0
  M ModSQL/Operator_Add.java +1 -0
  M ModSQL/Operator_Concat.java +1 -0
  M ModSQL/Operator_Divide.java +4 -3
  A ModSQL/Operator_Is.java 
  M ModSQL/Operator_Logical.java +1 -0
  M ModSQL/Operator_Multiply.java +1 -0
  M ModSQL/Operator_Negate.java +1 -0
  M ModSQL/Operator_Not.java +1 -0

2003-03-07 01:54:52 Chris Studholme <Chris.Studholme@utoronto.ca>
  * work on porting operators to new function hierarchy
  A ModSQL/AbstractFunction.java 
  M ModSQL/DatabaseFunction.java +28 -10
  M ModSQL/Makefile +7 -0
  A ModSQL/Operator.java 
  A ModSQL/Operator_Add.java 
  A ModSQL/Operator_Concat.java 
  A ModSQL/Operator_Divide.java 
  A ModSQL/Operator_Logical.java 
  A ModSQL/Operator_Multiply.java 
  A ModSQL/Operator_Negate.java 
  A ModSQL/Operator_Not.java 

2003-03-04 17:22:54 Chris Studholme <Chris.Studholme@utoronto.ca>
  * started interface for database specific functions
  A ModSQL/DatabaseFunction.java 
  M TODO +1 -0

2003-03-03 18:05:50 Chris Studholme <Chris.Studholme@utoronto.ca>
  * changed empty string escape to E
  M TODO +1 -0
  M modsql.java +4 -4

2003-03-02 21:34:17 Chris Studholme <Chris.Studholme@utoronto.ca>
  * COPY TO escapes all characters between 0 and 31
  M TODO +0 -2
  M modsql.java +11 -6

2003-03-02 20:56:19 Chris Studholme <Chris.Studholme@utoronto.ca>
  * updated
  M TODO +1 -2

2003-03-02 20:55:35 Chris Studholme <Chris.Studholme@utoronto.ca>
  * COPY FROM implemented now
  M modsql.java +216 -48

2003-03-02 19:43:45 Chris Studholme <Chris.Studholme@utoronto.ca>
  * minor fixes and missing components of COPY TO
  M modsql.java +14 -4

2003-03-02 19:34:12 Chris Studholme <Chris.Studholme@utoronto.ca>
  * COPY TO works now
  M modsql.java +92 -5

2003-03-02 18:59:16 Chris Studholme <Chris.Studholme@utoronto.ca>
  * small updates to help text
  M modsql.java +5 -5

2003-03-02 18:52:35 Chris Studholme <Chris.Studholme@utoronto.ca>
  * improved help output (including SQL summary)
  M TODO +2 -2
  M modsql.java +66 -21

2003-03-02 17:27:17 Chris Studholme <Chris.Studholme@utoronto.ca>
  * parse UPDATE command
  M ModSQL/Update.java +61 -44
  M TODO +5 -5

2003-03-02 17:11:35 Chris Studholme <Chris.Studholme@utoronto.ca>
  * added commitUpdates() to DatabaseTable interface for atomic insert/update
  M AsciiDatabase/AsciiTable.java +5 -73
  M ModSQL/DatabaseTableBase.java +10 -0
  M ModSQL/IndexTable_Hash.java +3 -27
  M ModSQL/IndexTable_Sort.java +4 -30
  M ModSQL/Insert.java +2 -0
  M ModSQL/SelectTable.java +2 -23
  M SampleDatabase/TableTemplate.java +1 -19
  M TemporaryDatabase/Table.java +3 -6

2003-03-02 16:30:07 Chris Studholme <Chris.Studholme@utoronto.ca>
  * parses DELETE command
  M ModSQL/Delete.java +21 -36

2003-03-02 07:10:22 Chris Studholme <Chris.Studholme@utoronto.ca>
  * code to parse COPY TO and COPY FROM commands
  M modsql.java +347 -39

2003-03-02 06:21:02 Chris Studholme <Chris.Studholme@utoronto.ca>
  * incorrect update count for CREATE and DROP
  M ModSQL/Create.java +2 -2
  M ModSQL/Drop.java +1 -1

2003-03-02 02:47:57 Chris Studholme <Chris.Studholme@utoronto.ca>
  * can now seperate parse and execute using PreparedStatement
  M ModSQL/Insert.java +2 -1
  M ModSQL/PreparedStatement.java +263 -248
  M ModSQL/Query.java +0 -6
  M ModSQL/Select.java +1 -3

2003-03-01 21:58:31 Chris Studholme <Chris.Studholme@utoronto.ca>
  * started implementation of PreparedStatement
  * Statement class replaced by PreparedStatement
  M ModSQL/Connection.java +4 -3
  M ModSQL/Makefile +1 -1
  A ModSQL/PreparedStatement.java 
  M ModSQL/ResultSet.java +5 -5
  D ModSQL/Statement.java 
  M TODO +4 -8

2003-03-01 21:15:21 Chris Studholme <Chris.Studholme@utoronto.ca>
  * return appropriate update count
  M ModSQL/Insert.java +5 -2

2003-02-28 22:25:36 Chris Studholme <Chris.Studholme@utoronto.ca>
  * INSERT INTO ... SELECT ... works now too
  M ModSQL/Insert.java +13 -2

2003-02-28 22:12:54 Chris Studholme <Chris.Studholme@utoronto.ca>
  * INSERT INTO ... VALUES ... seems to work fine now
  M AsciiDatabase/Manager.java +17 -17
  M ModSQL/Insert.java +199 -28
  M SampleDatabase/Manager.java +7 -7
  M TemporaryDatabase/Table.java +6 -1

2003-02-28 20:00:01 Chris Studholme <Chris.Studholme@utoronto.ca>
  * finished add/delete/update support
  M TemporaryDatabase/Table.java +10 -7
  M TemporaryDatabase/TableData.java +61 -186

2003-02-28 18:58:14 Chris Studholme <Chris.Studholme@utoronto.ca>
  * implemented DROP TABLE
  M AsciiDatabase/Manager.java +9 -3
  M ModSQL/DatabaseManager.java +7 -3
  M ModSQL/Drop.java +50 -6
  M ModSQL/MetaManager.java +13 -9
  M SampleDatabase/Manager.java +8 -2
  M TODO +1 -0
  M TemporaryDatabase/Manager.java +5 -1
  M TemporaryDatabase/Table.java +8 -0

2003-02-28 18:35:48 Chris Studholme <Chris.Studholme@utoronto.ca>
  * temporary table database seems to be working now
  M README +1 -0
  M TODO +1 -0
  A TemporaryDatabase/Column.java 
  M TemporaryDatabase/Makefile +2 -1
  M TemporaryDatabase/Manager.java +37 -30
  M TemporaryDatabase/Table.java +90 -93
  A TemporaryDatabase/TableData.java 

2003-02-28 06:53:52 Chris Studholme <Chris.Studholme@utoronto.ca>
  * added TemporaryDatabase package for database of temporary tables
  M Makefile +2 -1
  M ModSQL/ModSQL.conf +1 -1
  A TemporaryDatabase/Makefile 
  A TemporaryDatabase/Manager.java 
  A TemporaryDatabase/Table.java 

2003-02-28 06:43:26 Chris Studholme <Chris.Studholme@utoronto.ca>
  * finished support for CREATE TABLE
  * small changes to Database* interfaces
  M AsciiDatabase/AsciiTable.java +3 -2
  M AsciiDatabase/Manager.java +4 -28
  M ModSQL/Create.java +214 -41
  M ModSQL/DatabaseManager.java +11 -36
  M ModSQL/DatabaseTable.java +3 -2
  M ModSQL/IndexTable_Hash.java +0 -4
  M ModSQL/IndexTable_Sort.java +0 -4
  M ModSQL/MetaManager.java +12 -22
  M ModSQL/SelectTable.java +2 -1
  M SampleDatabase/Manager.java +62 -67
  M SampleDatabase/TableTemplate.java +2 -1
  M TODO +1 -0

2003-02-27 06:34:46 Chris Studholme <Chris.Studholme@utoronto.ca>
  * started work to support CREATE TABLE, DROP, UPDATE, INSERT and DELETE
  M ModSQL/Create.java +5 -4
  A ModSQL/Delete.java 
  A ModSQL/Drop.java 
  A ModSQL/Insert.java 
  M ModSQL/Makefile +4 -1
  A ModSQL/Query.java 
  M ModSQL/Select.java +10 -2
  M ModSQL/Statement.java +35 -32
  A ModSQL/Update.java 

2003-02-27 05:17:14 Chris Studholme <Chris.Studholme@utoronto.ca>
  * minor updates
  M README +1 -0
  M TODO +4 -4

2003-02-19 05:07:53 Chris Studholme <Chris.Studholme@utoronto.ca>
  * split DatabaseTable into seperate table and index interfaces
  M AsciiDatabase/AsciiTable.java +5 -0
  A ModSQL/DatabaseIndex.java 
  M ModSQL/DatabaseTable.java +7 -217
  A ModSQL/DatabaseTableBase.java 
  M ModSQL/IndexTable.java +1 -1
  M ModSQL/IndexTable_Hash.java +16 -0
  M ModSQL/IndexTable_Sort.java +16 -0
  M ModSQL/Makefile +2 -1
  M ModSQL/RowDefinition.java +18 -7
  M ModSQL/SelectTable.java +4 -0
  M SampleDatabase/TableTemplate.java +4 -0

2003-02-18 19:30:59 Chris Studholme <Chris.Studholme@utoronto.ca>
  * undid changes mistakenly checked in
  M ModSQL/ModSQL.conf +2 -3

2003-02-18 19:27:53 Chris Studholme <Chris.Studholme@utoronto.ca>
  * readded ChangeLog file (will update manually each release)
  M ChangeLog +240 -31
  M ModSQL/ModSQL.conf +3 -2
  M modsql.c +1 -1

2003-02-18 19:17:19 Chris Studholme <Chris.Studholme@utoronto.ca>
  * last version update for 0.30
  M modsql.java +1 -1

2003-02-14 16:50:00 Chris Studholme <Chris.Studholme@utoronto.ca>
  * additional todo
  M TODO +1 -0

2003-02-14 06:50:11 Chris Studholme <Chris.Studholme@utoronto.ca>
  * preparing for v0.30 release (updated documenation)
  M AsciiDatabase/Manager.java +2 -2
  D ChangeLog 
  A ChangeLog.old 
  M ModSQL/DriverConfig.java +2 -2
  M NEWS +26 -0
  M README +16 -5
  M SampleDatabase/Manager.java +2 -2
  M TODO +19 -16
  A UPGRADE 

2003-02-14 06:27:00 Chris Studholme <Chris.Studholme@utoronto.ca>
  * added help text for --null, --true, and --false
  M modsql.java +570 -567

2003-02-14 05:00:43 Chris Studholme <Chris.Studholme@utoronto.ca>
  * added some debug output;
  * everything tested ok
  M ModSQL/IndexTable_Hash.java +3 -0
  M ModSQL/IndexTable_Sort.java +3 -0

2003-02-14 04:43:12 Chris Studholme <Chris.Studholme@utoronto.ca>
  * efficient search in findNext()
  M ModSQL/IndexTableEntry.java +18 -4
  M ModSQL/IndexTable_Hash.java +17 -14
  M ModSQL/IndexTable_Sort.java +31 -11

2003-02-14 02:52:00 Chris Studholme <Chris.Studholme@utoronto.ca>
  * improved sorted index along lines of hash index
  M ModSQL/IndexTableEntry.java +5 -7
  M ModSQL/IndexTable_Hash.java +5 -4
  M ModSQL/IndexTable_Sort.java +212 -226

2003-02-14 02:51:37 Chris Studholme <Chris.Studholme@utoronto.ca>
  * print stack trace during exception from database table
  M ModSQL/RowDefinition.java +2 -0

2003-02-14 01:53:45 Chris Studholme <Chris.Studholme@utoronto.ca>
  * implemented hash table index;
  * ensured that both index types can be created and used
  M ModSQL/Create.java +28 -34
  M ModSQL/IndexTable.java +26 -528
  M ModSQL/IndexTable_Hash.java +163 -233
  A ModSQL/IndexTable_Sort.java 
  M ModSQL/Makefile +3 -1

2003-02-11 07:26:01 Chris Studholme <Chris.Studholme@utoronto.ca>
  * uncommented simple methods in hash index;
  * fixed bug in IndexTableEntry
  M ModSQL/IndexTableEntry.java +1 -1
  M ModSQL/IndexTable_Hash.java +6 -17
  M ModSQL/Makefile +3 -1

2003-02-11 07:17:04 Chris Studholme <Chris.Studholme@utoronto.ca>
  * started work on hash index
  A ModSQL/IndexTableEntry.java 
  A ModSQL/IndexTableRowset.java 
  A ModSQL/IndexTable_Hash.java 

2003-02-11 03:16:01 Chris Studholme <Chris.Studholme@utoronto.ca>
  * reorder equality test to make better use of matchvalue (if necessary)
  M ModSQL/Function_Comparison.java +16 -7

2003-02-10 07:53:55 Chris Studholme <Chris.Studholme@utoronto.ca>
  * RowId must be serializable
  M AsciiDatabase/AsciiTable.java +1 -1

2003-02-10 06:52:06 Chris Studholme <Chris.Studholme@utoronto.ca>
  * updated versions
  M AsciiDatabase/Manager.java +1 -1
  M ModSQL/DriverConfig.java +3 -3
  M SampleDatabase/Manager.java +1 -1
  M TODO +0 -1

2003-02-10 01:58:11 Chris Studholme <Chris.Studholme@utoronto.ca>
  * allow use of SELECT aliases in HAVING as well as ORDER BY
  M ModSQL/Select.java +4 -2

2003-02-10 01:32:27 Chris Studholme <Chris.Studholme@utoronto.ca>
  * new implementation of LIKE pattern comparison
  M ModSQL/Function_Comparison.java +122 -166
  M TODO +1 -1

2003-02-08 20:16:33 Chris Studholme <Chris.Studholme@utoronto.ca>
  * made IndexTable a little more modular
  M ModSQL/IndexTable.java +19 -0
  M ModSQL/RowDefinition.java +6 -25

2003-02-08 19:04:05 Chris Studholme <Chris.Studholme@utoronto.ca>
  * eliminated use of Vector when parsing FROM
  M ModSQL/RowDefinition.java +24 -30
  M ModSQL/Select.java +46 -53

2003-02-08 18:21:00 Chris Studholme <Chris.Studholme@utoronto.ca>
  * implemented basic JOIN..ON and JOIN..USING
  M ModSQL/Select.java +105 -30
  M TODO +10 -7

2003-02-07 23:58:23 Chris Studholme <Chris.Studholme@utoronto.ca>
  * minor but fatal bug in IndexTableRow.compareTo()
  M ModSQL/IndexTable.java +1 -1

2003-02-07 23:53:56 Chris Studholme <Chris.Studholme@utoronto.ca>
  * changed to arbitrary Object for row id
  M AsciiDatabase/AsciiTable.java +32 -9
  M ModSQL/Create.java +2 -108
  M ModSQL/DatabaseTable.java +4 -5
  M ModSQL/IndexTable.java +524 -403
  M ModSQL/SelectTable.java +15 -6
  M SampleDatabase/TableTemplate.java +7 -7

2003-02-07 22:42:02 Chris Studholme <Chris.Studholme@utoronto.ca>
  * implemented findNext() and ensured it's use
  M AsciiDatabase/AsciiTable.java +165 -156
  M ModSQL/RowDefinition.java +20 -1
  M SampleDatabase/TableTemplate.java +214 -205

2003-02-07 22:28:40 Chris Studholme <Chris.Studholme@utoronto.ca>
  * fixed bug in new evaluate algorithm
  M ModSQL/Select.java +67 -74

2003-02-07 22:01:52 Chris Studholme <Chris.Studholme@utoronto.ca>
  * additional keywords
  M ModSQL/Value.java +8 -0

2003-02-07 20:57:40 Chris Studholme <Chris.Studholme@utoronto.ca>
  * using EndOfTable now to indicate table is done (some bugs remain though)
  M ModSQL/RowDefinition.java +119 -113
  M ModSQL/Select.java +45 -42

2003-02-07 20:09:43 Chris Studholme <Chris.Studholme@utoronto.ca>
  * introduced EndOfTable throwable to use when the end of a table is reached
  M ModSQL/ColumnValue.java +3 -3
  A ModSQL/EndOfTable.java 
  M ModSQL/Function_Add.java +2 -2
  M ModSQL/Function_Aggregate.java +2 -2
  M ModSQL/Function_Comparison.java +2 -2
  M ModSQL/Function_Concat.java +2 -2
  M ModSQL/Function_Divide.java +2 -2
  M ModSQL/Function_Is.java +1 -1
  M ModSQL/Function_Logical.java +2 -2
  M ModSQL/Function_Math.java +2 -2
  M ModSQL/Function_Multiply.java +2 -2
  M ModSQL/Function_NVL.java +20 -20
  M ModSQL/Function_Negate.java +3 -3
  M ModSQL/Function_String.java +2 -2
  M ModSQL/Makefile +1 -1
  M ModSQL/RowDefinition.java +18 -15
  M ModSQL/Select.java +67 -37
  M ModSQL/Value.java +7 -4

2003-02-06 23:10:54 Chris Studholme <Chris.Studholme@utoronto.ca>
  * more accesses to static const int through instance reference
  M modsql.java +2 -2

2003-02-06 23:09:16 Chris Studholme <Chris.Studholme@utoronto.ca>
  * small typo
  M AsciiDatabase/AsciiTable.java +3 -3

2003-02-06 22:31:55 Chris Studholme <Chris.Studholme@utoronto.ca>
  * implemented matched evaluate() for ColumnValue
  M ModSQL/ColumnValue.java +30 -22
  M ModSQL/RowDefinition.java +13 -9

2003-02-06 19:50:53 Chris Studholme <Chris.Studholme@utoronto.ca>
  * implemented match evaluate() for EQU case
  M ModSQL/Function_Comparison.java +39 -2

2003-02-06 19:27:24 Chris Studholme <Chris.Studholme@utoronto.ca>
  * implemented findNext()
  M ModSQL/IndexTable.java +376 -354

2003-02-06 19:22:28 Chris Studholme <Chris.Studholme@utoronto.ca>
  * accessing static const int using instance name
  M ModSQL/Select.java +1 -1
  M ModSQL/Value.java +2 -2

2003-02-06 18:39:28 Chris Studholme <Chris.Studholme@utoronto.ca>
  * filter for Y2K fixes
  M AsciiDatabase/AsciiTable.java +43 -2

2002-10-19 01:58:00 Chris Studholme <Chris.Studholme@utoronto.ca>
  * new version to go along with changes in Function_Compare
  M ModSQL/DriverConfig.java +2 -2
  M TODO +3 -0

2002-10-19 01:38:56 Chris Studholme <Chris.Studholme@utoronto.ca>
  * improved performance of "field IN (long list of literals)" construct by 
    sorting list and doing binary searches for values
  M ModSQL/Function_Comparison.java +43 -4

2001-03-16 01:17:04 Chris Studholme <Chris.Studholme@utoronto.ca>
  * integrated changes from soar; see ChangeLog (below)
  M AsciiDatabase/AsciiReader.java +42 -40
  M AsciiDatabase/AsciiTable.java +161 -59
  M AsciiDatabase/Manager.java +1 -1
  M ChangeLog +18 -1
  M TODO +2 -1
  M modsql.java +529 -506

2001-03-16 00:59:57 Chris Studholme <Chris.Studholme@utoronto.ca>
  * minor cosmetic changes to SampleDatabase/Manager
  M ChangeLog +4 -0
  M RCFile/Makefile +1 -21
  M SampleDatabase/Makefile +1 -21
  M SampleDatabase/Manager.java +63 -61
  M TODO +2 -0

2000-09-19 Chris Studholme <Chris.Studholme@ualberta.ca>
  * improved seek efficency in AsciiDatabases.AsciiReader

2000-08-30 Chris Studholme <Chris.Studholme@ualberta.ca>
  * changed ascii database so field descriptions (ie. comments) can be added  
    to each line

2000-08-18 Chris Studholme <Chris.Studholme@ualberta.ca>
  * changed null value checking in AsciiTable to use float instead of double

2000-07-23 Chris Studholme <Chris.Studholme@ualberta.ca>
  * added --null, --true and --false options to modsql
  * added option of using delimited access to AsciiTable

2000-07-19 Chris Studholme <Chris.Studholme@ualberta.ca>
  * minor cosmetic changes to SampleDatabase/Manager

2000-01-24 Chris Studholme <Chris.Studholme@ualberta.ca>
  * added a bunch to README
  * made up new samples in samples directory
  * released version 0.20

2000-01-20 Chris Studholme <Chris.Studholme@ualberta.ca>
  * removed static code in DatabaseManager decendants that auto-registers
    manager with MetaManager
  * changed MetaManager to register DatabaseManagers listed in ModSQL.conf
  * AsciiManager renamed to Manager
  * AsciiDatabase config file location read from ModSQL.conf

2000-01-19 Chris Studholme <Chris.Studholme@ualberta.ca>
  * modified Function_Concat to provide appropriate constructor
  * modified Function documentation to make subclass constructor
    requirements clearer

2000-01-14 Chris Studholme <Chris.Studholme@ualberta.ca>
  * Value.evaluate(matchvalue,matchfunction) defined more precisely
  * Select.nextRow() modifed to use the improved evaluate
  * implemented Function_Logical.evaluate(matchvalue,matchfunction)
  * implemented Function_Negate.evaluate(matchvalue,matchfunction)
  * ChangeLog file started
