[Firebird-devel] [FB-Tracker] Created: (CORE-6332) Get rid of FileSystemCacheThreshold parameter

2020-06-14 Thread Carlos H. Cantu (JIRA)
Get rid of FileSystemCacheThreshold parameter
-

 Key: CORE-6332
 URL: http://tracker.firebirdsql.org/browse/CORE-6332
 Project: Firebird Core
  Issue Type: Task
  Components: Engine
Affects Versions: 4.0 Beta 2
Reporter: Carlos H. Cantu


Since FileSystemCacheThreshold looks like an attempt to allow a kind of "per 
database" configuration for filesystem cache usage when there was no 
databases.conf, I suggest to get rid of it and create a more obvious per 
database parameter, ie: AllowFilesystemCache (boolean), in Firebird 4.

-- 
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




Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] [FB-Tracker] Created: (CORE-6138) Inconsistent behavior regarding visibility of master record on detail inserts

2019-09-07 Thread Carlos H. Cantu (JIRA)
Inconsistent behavior regarding visibility of master record on detail inserts
-

 Key: CORE-6138
 URL: http://tracker.firebirdsql.org/browse/CORE-6138
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 2.5.9, 3.0.4, 3.0.3, 3.0.2, 3.0.1, 3.0.0
Reporter: Carlos H. Cantu


During a master-detail insert using two different transactions, where the 
detail transaction is snapshot, FB allows the detail insert even when the 
master record is not visible for the detail transaction. It can be easily 
reproduced with the following steps:

Open two isql sessions (isql1 and isql2) connected to the same database, and 
follow the sequence of commands in this order:

isql1:
CREATE TABLE A
 (
 ID BIGINT NOT null PRIMARY KEY);

 CREATE TABLE B
 (
 ID BIGINT NOT null PRIMARY KEY,
 ID_A BIGINT NOT NULL
 );

 ALTER TABLE B ADD constraint FK_B__A FOREIGN KEY(ID_A) REFERENCES A(ID) ON 
UPDATE CASCADE ON DELETE CASCADE;

 commit;
 INSERT INTO A (ID) VALUES (1);

isql2:
 commit; -- to be sure that if there is active transaction, it will be ended now
 select * from a; -- just to be sure that snapshot transaction is started now

isql1:
 commit;

isql2:
 INSERT INTO B (ID, ID_A) VALUES (1, 1); -- This SHOULD break, since master is 
not visible for this transaction, but FB will accept it
 -- Any trigger based action against the master record will have null effect, 
but the detail insert will not fail!
 commit;

PS: For people with business rules on triggers, this behavior may lead to wrong 
results.

-- 
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




Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] [FB-Tracker] Created: (CORE-6036) Adjust comment of DummyPacketInterval in fb.conf

2019-03-27 Thread Carlos H. Cantu (JIRA)
Adjust comment of DummyPacketInterval in fb.conf


 Key: CORE-6036
 URL: http://tracker.firebirdsql.org/browse/CORE-6036
 Project: Firebird Core
  Issue Type: Improvement
  Components: Engine
Affects Versions: 4.0 Beta 1, 3.0.4, 3.0.3
Reporter: Carlos H. Cantu


# NOTE. This option may hang or crash Windows NT4 or Windows 2000 pre SP3 
# on the client side as explained here: 
# http://support.microsoft.com/default.aspx?kbid=296265.
# or may not prevent eventual inactive client disconnection for other OS.

Firebird 3 can't run on Windows NT and Windows 2000 (MSVC 10 is not support in 
those Windows versions), so it doesn't make sense to have such comment in 
fb.conf. Please remove it for the next releases/subreleases.

-- 
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




Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] [FB-Tracker] Created: (CORE-5742) Incorrect error message in iSQL when trying to create database with wrong password

2018-02-08 Thread Carlos H. Cantu (JIRA)
Incorrect error message in iSQL when trying to create database with wrong 
password
--

 Key: CORE-5742
 URL: http://tracker.firebirdsql.org/browse/CORE-5742
 Project: Firebird Core
  Issue Type: Bug
Affects Versions: 3.0.3
Reporter: Carlos H. Cantu


Imagine a new user, just created as TESTE password 1234. 

isql -user teste -pas 123 [PASSWORD IS INTENCIONALLY WRONG]
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'localhost:d:\teste.fdb';
Statement failed, SQLSTATE = 42000
SQL error code = -104
-Token unknown
-teste

The error message "token unknown teste" has nothing to do with the real reason 
of the error, and makes no sense.

-- 
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



--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] [FB-Tracker] Created: (CORE-5603) Allow change of field type to similar domain, even when there are associated constraints

2017-09-04 Thread Carlos H. Cantu (JIRA)
Allow change of field type to similar domain, even when there are associated 
constraints


 Key: CORE-5603
 URL: http://tracker.firebirdsql.org/browse/CORE-5603
 Project: Firebird Core
  Issue Type: Improvement
Affects Versions: 3.0.2, 2.5.7, 3.0.1, 2.5.6, 3.0.0, 4.0 Initial, 2.5.5, 
2.5.4, 2.5.3 Update 1, 2.1.7, 2.5.3, 2.5.2 Update 1, 2.5.2, 2.5.1, 2.5.0
Reporter: Carlos H. Cantu


Firebird does not allow changing the field type when there are pks, fks, 
indexes, in that field. This is a known limitation and a real pain.
But I can't see why it doesn't allow changing to a domain with the same type, 
ie:
Field was created as integer not null, and you want to change it to an existing 
domain, which is also declared as integer not null.
In this case, there is no change to the underlying stored data, so why do not 
allow it?

-- 
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



--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] [FB-Tracker] Created: (CORE-5194) Invalid computed by definition generated by isql -x

2016-04-11 Thread Carlos H. Cantu (JIRA)
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=/ca-pub-7940484522588532
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] [FB-Tracker] Created: (CORE-5162) SEC$ tables and tag/attributes

2016-03-22 Thread Carlos H. Cantu (JIRA)
SEC$ tables and tag/attributes
--

 Key: CORE-5162
 URL: http://tracker.firebirdsql.org/browse/CORE-5162
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 3.0 RC2
Reporter: Carlos H. Cantu


FB 3 allows to have users with the same name, if they are created by different 
plugins. But if you set a tag/attribute to the user A with plugin SRP, this 
tag/attribute stay visible to  user A of LegacyAuth plugin, when you select 
from the sec$ virtual tables.
PS: Initial report by Ann Harrison.

-- 
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



--
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] [FB-Tracker] Created: (CORE-5129) FB 3 RC2 installer is displaying "empty texts" when Portuguese is selected

2016-03-04 Thread Carlos H. Cantu (JIRA)
FB 3 RC2 installer is displaying "empty texts" when Portuguese is selected
--

 Key: CORE-5129
 URL: http://tracker.firebirdsql.org/browse/CORE-5129
 Project: Firebird Core
  Issue Type: Bug
  Components: Installation
Affects Versions: 3.0 RC2
Reporter: Carlos H. Cantu


When Portuguese (Portugal) is choose during installation, installer is not 
displaying the text (docs) in two screens:
1) Screen right after the license (supposed to display installation_readme.txt)
2) Screen after the files are copied (content should be the readme.txt, = 
leia-me.txt)
In previous versions, the installer displayed the contents in English (since no 
portuguese translation was available). I suggest to do the same with FB 3 
installer.


-- 
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



--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] [FB-Tracker] Created: (CORE-5068) gbak with invalid parameter crashes FB

2016-01-05 Thread Carlos H. Cantu (JIRA)
gbak with invalid parameter crashes FB
--

 Key: CORE-5068
 URL: http://tracker.firebirdsql.org/browse/CORE-5068
 Project: Firebird Core
  Issue Type: Bug
Affects Versions: 2.5.5
Reporter: Carlos H. Cantu


Typo in gbak's command line parameter causes Firebird process to crash, ie:

gbak -c -v -se service_mgr -user_all_space d:\backup.gbk d:\bd.fdb
gbak:unknown switch "USER_ALL_SPACE"
gbak: ERROR:connection lost to database
gbak:Exiting before completion due to errors


-- 
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



--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] [FB-Tracker] Created: (CORE-5053) changeServerMode.sh can mess with configuration

2015-12-24 Thread Carlos H. Cantu (JIRA)
changeServerMode.sh can mess with configuration
---

 Key: CORE-5053
 URL: http://tracker.firebirdsql.org/browse/CORE-5053
 Project: Firebird Core
  Issue Type: Bug
  Components: Installation
Affects Versions: 3.0 RC2
 Environment: Linux Ubuntu 14.04 and 15.03
Reporter: Carlos H. Cantu
Priority: Critical


When trying to change a fresh installed Firebird 3.0 RC1 in a Gnome Linux 
Ubuntu (both 14.04 and 15.03) virtual machine (downloaded from osboxes.org), it 
fails or just behave incorrectly:

With GUbuntu 15.03 - script fails (error: 1560: [: classic: unexpected operator)
With GUbuntu 14.04 - script runs with no errors, but incorrectly sets the 
servermode parameter (ie: I asked for classic, but it set as super)... maybe it 
mess with other things too.


-- 
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



--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] [FB-Tracker] Created: (CORE-5021) Extend the "update conflict" message

2015-11-18 Thread Carlos H. Cantu (JIRA)
Extend the "update conflict" message


 Key: CORE-5021
 URL: http://tracker.firebirdsql.org/browse/CORE-5021
 Project: Firebird Core
  Issue Type: Improvement
  Components: Engine
Reporter: Carlos H. Cantu


Currently only the conflicting transaction number is reported. If would be nice 
if there was some way to know in what table the update conflict happened.

-- 
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



--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] [FB-Tracker] Created: (CORE-4608) Improve Windows installer web page loading in the end of installation

2014-11-13 Thread Carlos H. Cantu (JIRA)
Improve Windows installer web page loading in the end of installation
-

 Key: CORE-4608
 URL: http://tracker.firebirdsql.org/browse/CORE-4608
 Project: Firebird Core
  Issue Type: Improvement
  Components: Installation
Affects Versions: 2.5.3, 3.0 Alpha 2, 3.0 Beta 1
Reporter: Carlos H. Cantu


Enhance the Windows installer in a way that if it detects that Internet is 
available, it should automatically open the final web page with details about 
joining FF, registering to receive newsletter, etc. (the currently installer 
asks the user if he want to open the page). Maybe it would be also good to open 
the release notes automatically.

-- 
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



--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] [FB-Tracker] Created: (CORE-4544) Allow hiding source code of procedures and triggers in FB 3

2014-09-06 Thread Carlos H. Cantu (JIRA)
Allow hiding source code of procedures and triggers in FB 3
---

 Key: CORE-4544
 URL: http://tracker.firebirdsql.org/browse/CORE-4544
 Project: Firebird Core
  Issue Type: Improvement
Affects Versions: 3.0 Alpha 2, 3.0 Alpha 1, 3.0 Beta 1
Reporter: Carlos H. Cantu


As discussed in fb-devel, there should be a way to hide the source code of 
procedures and triggers in FB 3, either by allowing the long-time-used hack 
of nulling the source code in the system tables, or implementing an official 
way.

-- 
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



--
Slashdot TV.  
Video for Nerds.  Stuff that matters.
http://tv.slashdot.org/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] [FB-Tracker] Created: (CORE-4524) New gbak option to enable encryption during restore

2014-08-18 Thread Carlos H. Cantu (JIRA)
New gbak option to enable encryption during restore
---

 Key: CORE-4524
 URL: http://tracker.firebirdsql.org/browse/CORE-4524
 Project: Firebird Core
  Issue Type: Improvement
  Components: GBAK
Affects Versions: 3.0 Alpha 2, 3.0 Alpha 1
Reporter: Carlos H. Cantu


It would be nice to have a new gbak switch to enable encryption in a database 
when doing a restore.

-- 
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



--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] [FB-Tracker] Created: (CORE-4516) Crash running gstat or gbak after encryption is enabled

2014-08-11 Thread Carlos H. Cantu (JIRA)
Crash running gstat or gbak after encryption is enabled
---

 Key: CORE-4516
 URL: http://tracker.firebirdsql.org/browse/CORE-4516
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 3.0 Alpha 2
 Environment: Windows 7 Pro 64bits - FB 3.0 alpha 2
Reporter: Carlos H. Cantu


if you run a gstat -a or a gbak -b in the database, right after enabling 
database encryption, it crashes.

-- 
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



--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] [FB-Tracker] Created: (CORE-4409) Enhancement in precision of calculations with NUMERIC/DECIMAL

2014-04-28 Thread Carlos H. Cantu (JIRA)
Enhancement in precision of calculations with NUMERIC/DECIMAL
-

 Key: CORE-4409
 URL: http://tracker.firebirdsql.org/browse/CORE-4409
 Project: Firebird Core
  Issue Type: Improvement
  Components: Engine
Affects Versions: 3.0 Alpha 2, 3.0 Alpha 1, 2.5.2 Update 1, 2.1.5 Update 1, 
2.5.2, 2.1.5
 Environment: Dialetic 3 databases
Reporter: Carlos H. Cantu


The way Firebird deals with the precision of the results of calculations 
involving multiple arguments can easily cause overflows, specially in 
maths/divs, when the precision of the result is the sum of the precision of the 
arguments, what can easily extrapolate the actual limits of the currently 
numeric/decimal datatypes. Also, some care is needed in the intermediate 
calculations, to avoid loss of precision and overflows.

-- 
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



--
Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.  Get 
unparalleled scalability from the best Selenium testing platform available.
Simple to use. Nothing to install. Get started now for free.
http://p.sf.net/sfu/SauceLabs
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] [FB-Tracker] Created: (CORE-4323) FB 2.1.5 64bits Windows zip kit misses fbsvcmgr.exe

2014-01-23 Thread Carlos H. Cantu (JIRA)
FB 2.1.5 64bits Windows zip kit misses fbsvcmgr.exe
---

 Key: CORE-4323
 URL: http://tracker.firebirdsql.org/browse/CORE-4323
 Project: Firebird Core
  Issue Type: Bug
  Components: Installation
Affects Versions: 2.1.5 Update 1
Reporter: Carlos H. Cantu


The zip kit version of FB 2.1.5 64bits (Windows) available for download 
doesn't contains the file fbsvcmgr.exe

-- 
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



--
CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments  Everything In Between.
Get a Quote or Start a Free Trial Today. 
http://pubads.g.doubleclick.net/gampad/clk?id=119420431iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] [FB-Tracker] Created: (CORE-3926) Inconsistent behavior with COMPUTED BY fields and metadata extraction

2012-09-17 Thread Carlos H. Cantu (JIRA)
Inconsistent behavior with COMPUTED BY fields and metadata extraction
-

 Key: CORE-3926
 URL: http://tracker.firebirdsql.org/browse/CORE-3926
 Project: Firebird Core
  Issue Type: Improvement
  Components: Engine
Affects Versions: 2.1.5, 2.0.7, 2.5.1, 2.1.4, 2.5.0, 2.0.6, 3.0 Initial, 
2.1.3, 2.1.2, 2.0.5, 2.1.1, 2.1.0, 2.5.2, 2.5.3, 2.1.6, 3.0.0
Reporter: Carlos H. Cantu
Priority: Trivial


ALTER statement allows me to change a computed by field with a new formula 
referencing a field that is positioned higher than the computed by field, but 
when you extract the table metadata and try to run it, it crashes with Column 
unknown. error.

To reproduce:

Step 1)

create table a
( field2 numeric (9,2),
 field1 computed by (field2 * 0.5));

Step 2)

alter table a add field3 numeric (9,2);

Step 3)

alter table a alter field1 computed by (field3 * 0.5); -- This works fine!!!


Step 3 works fine, but when you extract the DDL of the table and try to run it, 
it will
crash, since it will be extracted like:

CREATE TABLE A (
FIELD2  NUMERIC(9,2),
FIELD1  COMPUTED BY (field3 * 0.5),
FIELD3  NUMERIC(9,2)
);

This means that you may have a good database, but when you extract its 
metadata into a script to create another empty database, it will crash :-(

IMHO, the behavior should be consistent in the two scenarios so, or the table 
creation should succeed, or the ALTER should had failed.


-- 
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



--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] [FB-Tracker] Created: (CORE-3889) Please add support for -? in firebird.exe

2012-07-13 Thread Carlos H. Cantu (JIRA)
Please add support for -? in firebird.exe
-

 Key: CORE-3889
 URL: http://tracker.firebirdsql.org/browse/CORE-3889
 Project: Firebird Core
  Issue Type: Improvement
Affects Versions: 3.0 Alpha 1
Reporter: Carlos H. Cantu
Priority: Minor


Please enhance firebird.exe to support the -? command line switch and return 
all the supported switches.


-- 
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



--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel