December 29th, 2003, 08:51 PM
SQL not work
I am practrice for Firebird.
Why not this SQL not work
select tr_acc,tr_desc,tr_amt from (select * from dtransaction) as a
but PostgreSQL work
December 30th, 2003, 03:16 AM
yes, in fb 1.5 is not implemeted yet (is planed for fb 2.0)
... work fine in mysql, also
December 30th, 2003, 03:18 AM
Firebird does not support derived tables (it will with version 2.0).
Is this a simplified example? Because if it's not, and you would like to use the statement as it is, you can rewrite it to:
select tr_acc,tr_desc,tr_amt from dtransaction
December 30th, 2003, 03:19 AM
use a stored precedure insted (search this forum)
select tr_acc,tr_desc,tr_amt from sp_stored_procedure(...)
December 30th, 2003, 09:05 AM
thank you for all reply
OK waiting for fb 2.0. How long?
December 30th, 2003, 04:07 PM
Firebird 2.0? Very long. Don't expect it in 2004, I think, but don't pin me down on it. Perhaps it will be in Q4 in 2004... I really have no idea (and I do follow the development process quite closely).
1.5 final isn't released yet.
Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle
January 4th, 2004, 01:20 PM
It took 15 months for Firebird 1.5 to pass cycle from Alpha 1 to RC8. I really think that RC8 is going to be the last RC because RC7 and RC8 mainly differ in minor installer tweaking.
Length of development cycle of Firebird 2.0 mainly depends on timings of couple large merges (Yaffil and Vulcan forks).
I'll probably release intermediate builds in a month or two without functionality from those forks. Architecturally, the system will be still like 1.5, but with new functionality currently present in the 2.0 codebase and new ODS. I.e.:
1. hot incremental physical backups
2. derived tables
3. use explicit named cursors in PSQL and other PSQL enchancements
4. new fast indices (with 255 index key length limit removed)
5. searchable BLOBs
6. Some bugfixes that required big changes (such as proper invariant subquery tracking in stored procedures and triggers or standard-compilant placement of NULLs in ordered queries)
BTW, since Firebird is the Open Source project feel free to use 2.0 version now and provide the feedback.
January 4th, 2004, 01:34 PM
you forget that not all of us have the programer skills to use souce code from cvs so, a compiled version of fb2 it will be useful
Romania it's a beautiful country ... too bad that it's populated with ... peoples!