Thread: SQL not work

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Location
    thailand
    Posts
    5
    Rep Power
    0

    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
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Location
    Bucharest
    Posts
    72
    Rep Power
    12
    yes, in fb 1.5 is not implemeted yet (is planed for fb 2.0)
    ... work fine in mysql, also
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,785
    Rep Power
    348
    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
  6. #4
  7. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Location
    Bucharest
    Posts
    72
    Rep Power
    12
    use a stored precedure insted (search this forum)
    select tr_acc,tr_desc,tr_amt from sp_stored_procedure(...)
  8. #5
  9. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Location
    thailand
    Posts
    5
    Rep Power
    0

    thank you


    thank you for all reply

    OK waiting for fb 2.0. How long?
  10. #6
  11. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    250
    Rep Power
    14
    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.
    Martijn Tonies
    Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle
    Upscene Productions
    http://www.upscene.com
  12. #7
  13. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Posts
    15
    Rep Power
    0
    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.
  14. #8
  15. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Location
    Bucharest
    Posts
    72
    Rep Power
    12

    Thumbs up yea, yea


    Originally posted by skidder
    BTW, since Firebird is the Open Source project feel free to use 2.0 version now and provide the feedback.
    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!

IMN logo majestic logo threadwatch logo seochat tools logo