Re: [Firebird-devel] Odp: SQL Hint

2013-01-23 Thread Gopala Krishna Gundeboyina
Hi Karol, Thanks for the reply. My application is not a relational database but a library and hence I cannot use execute statement. This application stores data in binary format on disk with a complex business logic applied and has c++ apis to access data. I embedded the Firebird Server (v2.5) w

[Firebird-devel] Odp: SQL Hint

2013-01-23 Thread [email protected]
HI, first of all wrong group this is not support list. But you doing somethink what is supported by execute statement, and you do mot need to modify external table intf. Execute statement in Fb2.5 can run query against external database Regards, Karol Bieniaszewski - Reply message - Od

Re: [Firebird-devel] Optmizer vs IN (sub-select)

2013-01-23 Thread Dmitry Yemanov
23.01.2013 22:18, Alexandre Benson Smith wrote: > > There is any plan to add this kind of otimization in FB 3 ? Yes, it's in the plans. Dmitry -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC

[Firebird-devel] Optmizer vs IN (sub-select)

2013-01-23 Thread Alexandre Benson Smith
Hi ! It's known that Firebird transforms this kind of query: select TableA.Foo from TableA where TableA.Bar in (select TableB.Bar where X=Y) into: select TableA.Foo from TableA where exists (select * from TableB where where X=Y and TableB.Bar = TableA.Bar) This implies

[Firebird-devel] SQL Hint

2013-01-23 Thread Gopala Krishna Gundeboyina
Hi All, I have modified Firebird External Table interface to retrieve data from a proprietary database basically to take advantage of the SQL interface. I have been using it for some time and most of the standard SQL statements work great. But there are some additional attributes (call them as HI

[Firebird-devel] [FB-Tracker] Created: (CORE-4041) Get host name or IP via RDB$GET_CONTEXT()

2013-01-23 Thread Dmitry Beloshistov (JIRA)
Get host name or IP via RDB$GET_CONTEXT() - Key: CORE-4041 URL: http://tracker.firebirdsql.org/browse/CORE-4041 Project: Firebird Core Issue Type: Improvement Affects Versions: 2.5.3 Envir