_docs_en.properties

非常棒的java数据库

changelog_1062_li=Variables\: large objects (CLOB and BLOB) that don't fit in memory did not work correctly when used as variables.
changelog_1063_li=Fulltext search is now supported in named in-memory databases.
changelog_1064_li=H2 Console\: multiple consecutive spaces in the setting name did not work. Fixed.
changelog_1065_h2=Version 1.0.65 (2008-01-18)
changelog_1066_li=The build (ant) now automatically switches the source code to the correct version (JDK 1.4/1.5 or 1.6).
changelog_1067_li=A recovery bug has been fixed. With older versions, it was necessary to add ;RECOVER\=1 to the database URL in cases where it should not have been required.
changelog_1068_li=The performance for DROP and DROP ALL OBJECTS has been improved.
changelog_1069_li=The ChangePassword API has been improved.
changelog_1070_li=User defined variables are now supported. Examples\: SET @VAR\=10;CALL @VAR. This can be used for running totals as in\: select x, set(@t, ifnull(@t, 0) + x) from system_range(1, 10)
changelog_1071_li=The Ukrainian translation has been improved.
changelog_1072_li=CALL statements can now be used in batch updates and called using Statement.executeUpdate.
changelog_1073_li=New read-only setting CREATE_BUILD (the build number of the database engine that created the database).
changelog_1074_li=The optimizer did not use multi column indexes for range queries in some cases. Fixed.
changelog_1075_li=The H2 Console now calls DataSource.getConnection() instead of DataSource.getConnection(user, password) when user name and password are not specified.
changelog_1076_li=The bind IP address can now be set when using multi-homed host (if multiple network adapters are available) using the system property h2.bindAddress.
changelog_1077_li=Batch update\: Calling BatchUpdateException.printStackTrace() could result in out of memory. Fixed.
changelog_1078_li=Indexes of unique or foreign constraints where not dropped when the constraint was dropped after altering the table (for example dropping a column). Fixed.
changelog_1079_li=The performance for large result sets in the server mode has been improved.
changelog_1080_li=The setting h2.serverSmallResultSetSize has been renamed to h2.serverResultSetFetchSize.
changelog_1081_li=The SCRIPT command now uses multi-row insert statements to save space except if the option SIMPLE is used.
changelog_1082_li=The SCRIPT command did not split up CLOB data correctly. Fixed.
changelog_1083_li=Optimization for single column distinct queries with an index\: select distinct name from test. Can be disabled by setting the system property h2.optimizeDistinct to false.
changelog_1084_li=DROP ALL OBJECTS did not drop user defined aggregate functions and domains.
changelog_1085_li=PostgreSQL compatibility\: COUNT(T.*) is now supported.
changelog_1086_li=LIKE comparisons are now faster.
changelog_1087_li=Encrypted databases are now faster.
changelog_1088_h2=Version 1.0.64 (2007-12-27)
changelog_1089_li=3-way union queries with prepared statement or views could return the wrong results. Fixed.
changelog_1090_li=The PostgreSQL ODBC driver did not work in the last release due to a parser regression. Fixed.
changelog_1091_li=CSV tool\: some escape/separator character combinations did not work. Fixed.
changelog_1092_li=CSV tool\: the character \# could not be used as a separator when reading.
changelog_1093_li=Recovery\: when the index file is corrupt, now the database deletes it and re-creates it automatically.
changelog_1094_li=The MVCC mode did not work well with in-memory databases. Fixed.
changelog_1095_li=The FTP server now supports a event listener. Thanks Fulvio Biondi for the help\!
changelog_1096_li=New system function CANCEL_SESSION to cancel the currently executing statement of another session.
changelog_1097_li=The database now supports an exclusive mode. In exclusive mode, new connections are rejected.
changelog_1098_li=H2 Console\: when editing result sets, columns can now be set to null. The text 'null' must be escaped using '\=null'.
changelog_1099_li=New built-in functions RPAD and LPAD.
changelog_1100_li=New meta data table INFORMATION_SCHEMA.SESSIONS and LOCKS to get information about active connections and locks. Admins will see all connections, non-admins only their own session.
changelog_1101_li=The Ukrainian translation was not working in the last release. Fixed.
changelog_1102_li=Creating many tables (many hundreds) was slow. Fixed.
changelog_1103_li=Opening a database with many indexes (thousands) was slow. Fixed.
changelog_1104_li=H2 Console / autocomplete\: Ctrl+Space now shows the list in all modes.
changelog_1105_li=The method Trigger.init has been changed\: the parameters 'before' and 'type', have been added to the init method.
changelog_1106_li=The performance has been improved for ResultSet methods with column name.
changelog_1107_li=A stack trace was thrown if the system did not provide a quick secure random source and if there is no network or the network settings are not configured. Fixed.
changelog_1108_li=The H2 Console has been translated to Turkish. Thanks a lot to Ridvan Agar\!
changelog_1109_li=Improved debugging support\: toString methods of most object now return a meaningful text.
changelog_1110_li=The classes DbStarter and WebServlet have been moved to src/main.
changelog_1111_li=The column INFORMATION_SCHEMA.TRIGGERS.SQL now contains the CREATE TRIGGER statement.
changelog_1112_li=Loading classes and calling methods can be restricted using the new system property h2.allowedClasses.
changelog_1113_li=The database could not be used in Java applets due to security exceptions. Fixed.
changelog_1114_h2=Version 1.0.63 (2007-12-02)
changelog_1115_li=The SecurePassword example has been improved.
changelog_1116_li=In timezones where the summer time saving limit is at midnight, some dates do not work in some virtual machines, for example 2007-10-14 in Chile, using the Sun JVM 1.6.0_03-b05. Fixed.
changelog_1117_li=The native fulltext search was not working properly after re-connecting.
changelog_1118_li=Improved FTP server\: now the PORT command is supported.
changelog_1119_li=Temporary views (FROM(...)) with UNION didn't work if nested. Fixed.
changelog_1120_li=Performance optimization for IN(...) and IN(SELECT...), currently disabled by default. To enable, use java -Dh2.optimizeInJoin\=true
changelog_1121_li=The H2 Console has been translated to Ukrainian by Igor Dobrovolskyi. Thanks a lot\!
changelog_1122_li=New function TABLE_DISTINCT.
changelog_1123_li=Using LIMIT with values close to Integer.MAX_VALUE didn't work correctly.
changelog_1124_li=Certain setting in the Server didn't work (http\://code.google.com/p/h2database/issues/detail?id\=7).
changelog_1125_h2=Version 1.0.62 (2007-11-25)
changelog_1126_li=Large updates and deletes are now supported by buffering data to disk if required. The threshold is currently set to 100'000 bytes and can be changed using SET MAX_OPERATION_MEMORY or using by appending ;MAX_OPERATION_MEMORY\=.. to the database URL. See also the docs.
changelog_1127_li=MVCC\: now an exception is thrown when an application tries to change the MVCC setting while the database is already open.
changelog_1128_li=Referential integrity checks didn't lock the referenced table, and thus could read uncommitted rows of other connections. In that way the referential constraints could get violated (except when using MVCC).
changelog_1129_li=Renaming or dropping a user with a schema, or removing the admin property of that user made the schema inaccessible after re-opening the database. Fixed.
changelog_1130_li=The H2 Console now also support the command line option -ifExists when started from the Server tool, but only when connecting to H2 databases.
changelog_1131_li=Duplicate column names were not detected when renaming columns. Fixed.
changelog_1132_li=The console did not display multiple embedded spaces in text correctly. Fixed.
changelog_1133_li=Google Android support\: use 'ant codeswitchAndroid' to switch the source code to Android.
changelog_1134_li=Values of type ARRAY are now sorted as in PostgreSQL.
changelog_1135_li=In the cluster mode, could not connect if only one server was running (last release only). Fixed.
changelog_1136_li=The performance of large CSV operations has been improved.
changelog_1137_li=Now using custom toString() for most JDBC objects and commands.
changelog_1138_li=Nested temporary views (SELECT * FROM (SELECT ...)) with parameters didn't work in some cases. Fixed.
changelog_1139_li=CSV\: Using an empty field delimiter didn't work (a workaround was using char(0)). Fixed.
changelog_1140_li=A patch for Apache DDL Utils is available at https\://issues.apache.org/jira/browse/DDLUTILS-185
changelog_1141_li=The default value for h2.emergencySpaceInitial is now 256 KB (to speed up creating encrypted databases)
changelog_1142_li=Eduardo Velasques has translated the H2 Console and the error messages to Brazilian Portuguese. Thanks a lot\!
changelog_1143_li=Creating a table from GROUP_CONCAT didn't work if the data was longer than 255 characters
changelog_1144_h2=Version 1.0.61 (2007-11-10)
changelog_1145_li=The Lucene Fulltext implementation is now compiled and included in the h2.jar. Requires Lucene 2.2.
changelog_1146_li=Added more tests. The code coverage is now at 83%.
changelog_1147_li=ResultSetMetaData.getColumnDisplaySize was calculated as the longest display size for the given result set, but should be the maximum size that fits in the column. Fixed.
changelog_1148_li=The MODE used to be a global setting, now it is a database level setting.
changelog_1149_li=The database does now always round to the nearest number when converting a floating point to a integer\: CAST(1.5 AS INT) will now result in 2, like in PostgreSQL and MySQL.
changelog_1150_li=Math operations using unknown data types (for example -? and ?+?) are now interpreted as decimal.
changelog_1151_li=INSTR, LOCATE\: backward searching is not supported by using a negative start position.
changelog_1152_li=Can now open a database stored in a jar or zip file (for example, jdbc\:h2\:zip\:c\:/temp/h2.zip\!/test).
changelog_1153_li=Files access now uses an API (FileSystem, FileObject), this will simplify adding other file systems and features (for example replication).
changelog_1154_li=Vlad Alexahin has translated H2 Console to Russian. Thanks a lot\!