Invalid computed by definition generated by isql -x
---------------------------------------------------
Key: CORE-5194
URL: http://tracker.firebirdsql.org/browse/CORE-5194
Project: Firebird Core
Issue Type: Bug
Components: ISQL
Affects Versions: 3.0 RC2
Reporter: Carlos H. Cantu
Priority: Critical
This came from Alexandre B. Smith... isql -x from FB 3 RC2 is generated invalid
sql script when computed by fields exists. The test works fine in FB 2.5:
create database "c:\sp\test.fdb";
CREATE TABLE T (A TIMESTAMP,
B COMPUTED BY (current_timestamp - a));
commit;
exit;
isql -user sysdba -password masterkey test.fdb -x > test.sql
The result is:
---------------------
SET SQL DIALECT 3;
CREATE DATABASE 'test.fdb' PAGE_SIZE 8192 DEFAULT CHARACTER SET NONE;
COMMIT WORK;
/* Table: T, Owner: SYSDBA */
CREATE TABLE T (A TIMESTAMP,
B NUMERIC(0, 9) COMPUTED BY (NULL));
/* Computed fields */
ALTER TABLE T
ALTER B TYPE NUMERIC(0, 9) COMPUTED BY (current_timestamp - a);
---------------------
Note the type of Column B defined as *NUMERIC(0,9)*
if you run it on isql you will get:
---------------------
Use CONNECT or CREATE DATABASE to specify a database
SQL> CREATE DATABASE 'test2.fdb' PAGE_SIZE 8192 DEFAULT CHARACTER SET NONE;
SQL>
SQL>
SQL> COMMIT WORK;
SQL>
SQL> /* Table: T, Owner: SYSDBA */
SQL> CREATE TABLE T (A TIMESTAMP,
CON> B NUMERIC(0, 9) COMPUTED BY (NULL));
Statement failed, SQLSTATE = HY104
Dynamic SQL Error
-SQL error code = -842
-Precision must be from 1 to 18
SQL>
SQL> /* Computed fields */
SQL>
SQL> ALTER TABLE T
CON> ALTER B TYPE NUMERIC(0, 9) COMPUTED BY (current_timestamp - a);
Statement failed, SQLSTATE = HY104
Dynamic SQL Error
-SQL error code = -842
-Precision must be from 1 to 18
SQL>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial! http://pubads.g.doubleclick.net/
gampad/clk?id=1444514301&iu=/ca-pub-7940484522588532
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
