<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - FIREBIRD: Migration: Migration routine does not import HSQL TEXT TABLES." href="https://bugs.documentfoundation.org/show_bug.cgi?id=117253#c1">Comment # 1</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - FIREBIRD: Migration: Migration routine does not import HSQL TEXT TABLES." href="https://bugs.documentfoundation.org/show_bug.cgi?id=117253">bug 117253</a> from <a class="email" href="mailto:drewjensen.inbox@gmail.com" title="Drew Jensen <drewjensen.inbox@gmail.com>"> Drew Jensen</a> <pre>Sorry, I hit save to quickly. Firebird does have support for external files also but the implementation is somewhat different from HSQLdb. HSQLdb embedded in ODB files uses a restricted naming scheme for the external files and requires that the files be stored in either the same directory as the ODB file or a directory below that. Firebird 3.0 also offers this restricted mode for their 'external file' support. Which would, it seems, allow the same restrictions as now. The fb engine must be configured for this support using the configuration item: ExternalFileAccess = (None, Full, Restricted) For restricted mode a list of directories are supplied and relative naming is allowed. ExternalFileAccess = Restrict /some/directory Two pieces of functionality available in HSQL are not available in fb. 1: The ability to create a text table from a SELECT INTO statement, in HSQL if you supply a file name and it does not exist the file is created with a structure to match the result set and the data copied into it. Under fb you can only do SELECT INTO a text table that has already been defined and that already exists on disk. 2: In HSQL you can change which file file a TEXT TABLE definition points to with a SET command. In FB the table definition must be dropped and recreated to do that. I don't know what the current configuration setting is. Executing a CREATE TABLE command in the SQL window will run to completion and the table defintion is displayed, but no column information is saved, it is a table with zero columns. (I know, needs a different issue)</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>