SmallSQL Database

This version include the follow bug fixes: - Add AUTO_INCREMENT as alias for IDENTITY.- Add the keyword LIMIT as alias for the TOP syntax of a SELECT- Improve the handling from IDENTITY values (bug 1954682).- Fix a bug with different writing of the ... [More] same database.- Fix a thread bug with concurrent reading of the same table.- Fix an ArrayIndexOutOfBoundsException with large values >32K (bug 2264600).- CREATE TABLE and CREATE VIEW are now in a transaction. This make a rollback possible. (bug 2256579). (0 comments) [Less]

This version include the follow bug fixes: - Add AUTO_INCREMENT as alias for IDENTITY.- Add the keyword LIMIT as alias for the TOP syntax of a SELECT- Improve the handling from IDENTITY values (bug 1954682).- Fix a bug with different writing of the ... [More] same database.- Fix a thread bug with concurrent reading of the same table.- Fix an ArrayIndexOutOfBoundsException with large values >32K (bug 2264600).- CREATE TABLE and CREATE VIEW are now in a transaction. This make a rollback possible. (bug 2256579). (0 comments) [Less]

This version include the follow bug fixes: - Add AUTO_INCREMENT as alias for IDENTITY. - Add the keyword LIMIT as alias for the TOP syntax of a SELECT - Improve the handling from IDENTITY values (bug 1954682). - Fix a bug with different writing of ... [More] the same database. - Fix a thread bug with concurrent reading of the same table. - Fix an ArrayIndexOutOfBoundsException with large values >32K (bug 2264600). - CREATE TABLE and CREATE VIEW are now in a transaction. This make a rollback possible. (bug 2256579). [Less]

This version include the follow bug fixes: - Add AUTO_INCREMENT as alias for IDENTITY. - Add the keyword LIMIT as alias for the TOP syntax of a SELECT - Improve the handling from IDENTITY values (bug 1954682). - Fix a bug with different writing of ... [More] the same database. - Fix a thread bug with concurrent reading of the same table. - Fix an ArrayIndexOutOfBoundsException with large values >32K (bug 2264600). - CREATE TABLE and CREATE VIEW are now in a transaction. This make a rollback possible. (bug 2256579). [Less]

This version include the follow bug fixes: - Add support for multi language error messages. Support for English, Italian and German was added.- Improve the performance of a simple JOIN.- Double columns in an INSERT throw an SQLException now (bug ... [More] 1735908).- Date range check improved (bug 1738435).- Check for ambiguous columns added.- SmallSQL verify now that a database is only open once.- Added SQL comments symbols, both single (" -- comment ") and multi-line (" /* comment */ ").- A NullPointerException with a comma at end of the SQL (bug 1745881).- Check the close state of a Statement in many methods (bug 1753529).- The keyword INNER in the JOIN syntax is optional now (feature 1753519).- Added SQL functions: BIT_LENGTH(string), CHAR_LENGTH(string), CHARACTER_LENGTH(string), OCTET_LENGTH(string) and CURRENT_DATE(). (0 comments) [Less]

This version include the follow bug fixes: - Add support for multi language error messages. Support for English, Italian and German was added. - Improve the performance of a simple JOIN. - Double columns in an INSERT throw an SQLException now (bug ... [More] 1735908). - Date range check improved (bug 1738435). - Check for ambiguous columns added. - SmallSQL verify now that a database is only open once. - Added SQL comments symbols, both single (" -- comment ") and multi-line (" /* comment */ "). - A NullPointerException with a comma at end of the SQL (bug 1745881). - Check the close state of a Statement in many methods (bug 1753529). - The keyword INNER in the JOIN syntax is optional now (feature 1753519). - Added SQL functions: BIT_LENGTH(string), CHAR_LENGTH(string), CHARACTER_LENGTH(string), OCTET_LENGTH(string) and CURRENT_DATE(). [Less]

This version include the follow bug fixes: - Add support for multi language error messages. Support for English, Italian and German was added.- Improve the performance of a simple JOIN.- Double columns in an INSERT throw an SQLException now (bug ... [More] 1735908).- Date range check improved (bug 1738435).- Check for ambiguous columns added.- SmallSQL verify now that a database is only open once.- Added SQL comments symbols, both single (" -- comment ") and multi-line (" /* comment */ ").- A NullPointerException with a comma at end of the SQL (bug 1745881).- Check the close state of a Statement in many methods (bug 1753529).- The keyword INNER in the JOIN syntax is optional now (feature 1753519).- Added SQL functions: BIT_LENGTH(string), CHAR_LENGTH(string), CHARACTER_LENGTH(string), OCTET_LENGTH(string) and CURRENT_DATE(). (0 comments) [Less]

This version include the follow bug fixes: - Add support for multi language error messages. Support for English, Italian and German was added. - Improve the performance of a simple JOIN. - Double columns in an INSERT throw an SQLException now (bug ... [More] 1735908). - Date range check improved (bug 1738435). - Check for ambiguous columns added. - SmallSQL verify now that a database is only open once. - Added SQL comments symbols, both single (" -- comment ") and multi-line (" /* comment */ "). - A NullPointerException with a comma at end of the SQL (bug 1745881). - Check the close state of a Statement in many methods (bug 1753529). - The keyword INNER in the JOIN syntax is optional now (feature 1753519). - Added SQL functions: BIT_LENGTH(string), CHAR_LENGTH(string), CHARACTER_LENGTH(string), OCTET_LENGTH(string) and CURRENT_DATE(). [Less]

This version include the follow bug fixes: - Fix bugs with the methods isBeforeFirst(), isFirst(), isLast() and isAfterLast(). The problems occur mostly with empty ResultSets and together with ORDER BY or GROUP BY. - Fix the scrolling of scrollable ... [More] , updatable ResultSets with inserted rows. - Signal inserted and rollbacked rows as deleted (method rowDeleted()). - A NullPointerException with flag create=true was fixed. - Check the range of the parsed date time parts now. - Double columns in a table are now prevented. It was possible with CREATE TABLE and ALTER TABLE to create doubled columns. - Unicode characters are possible in JDBC URL parameters now. - The method getPropertyInfo is implemented now. [Less]

This version include the follow bug fixes:- Fix bugs with the methods isBeforeFirst(), isFirst(), isLast() and isAfterLast(). The problems occur mostly with empty ResultSets and together with ORDER BY or GROUP BY.- Fix the scrolling of scrollable ... [More] , updatable ResultSets with inserted rows.- Signal inserted and rollbacked rows as deleted (method rowDeleted()).- A NullPointerException with flag create=true was fixed.- Check the range of the parsed date time parts now.- Double columns in a table are now prevented. It was possible with CREATE TABLE and ALTER TABLE to create doubled columns.- Unicode characters are possible in JDBC URL parameters now.- The method getPropertyInfo is implemented now. (0 comments) [Less]