Added Derby dialect. Finished HSQL dialect. Documentation.

* Improved DEFAULT value specifications.
* Fixed bug in buildObjects where the ResultSet could be closed by the
automatic create table attempt.
* DbInspector now uses the dialect's reported DATETIME class preference.
* Improved IciqlException SQLState code checks.
* Integrated LIMIT and OFFSET expression appending in dialects.
* Updated to H2 1.3.159
* Allow reopening of a memory database in the test suite.

1 files changed, 6 insertions, 5 deletions

diff --git a/src/com/iciql/SQLDialectMySQL.java b/src/com/iciql/SQLDialectMySQL.java
index 2593e0a..a6c1218 100644
--- a/src/com/iciql/SQLDialectMySQL.java
+++ b/src/com/iciql/SQLDialectMySQL.java
@@ -31,7 +31,7 @@ public class SQLDialectMySQL extends SQLDialectDefault {
 		}

 		return sqlType;

 	}

-	

+

 	@Override

 	public boolean supportsMemoryTables() {

 		return false;

@@ -41,15 +41,16 @@ public class SQLDialectMySQL extends SQLDialectDefault {
 	public String prepareColumnName(String name) {

 		return "`" + name + "`";

 	}

-	

+

 	@Override

-	protected boolean prepareColumnDefinition(StatementBuilder buff, boolean isAutoIncrement, boolean isPrimaryKey) {

+	protected boolean prepareColumnDefinition(StatementBuilder buff, boolean isAutoIncrement,

+			boolean isPrimaryKey) {

 		if (isAutoIncrement) {

 			buff.append(" AUTO_INCREMENT");

 		}

 		return false;

 	}

-	

+

 	@Override

 	public void prepareCreateIndex(SQLStatement stat, String schema, String table, IndexDefinition index) {

 		StatementBuilder buff = new StatementBuilder();

@@ -74,7 +75,7 @@ public class SQLDialectMySQL extends SQLDialectDefault {
 			buff.append(prepareColumnName(col));

 		}

 		buff.append(") ");

-		

+

 		// USING

 		switch (index.type) {

 		case HASH: