Re: [Firebird-devel] CMake build system

2014-12-17 Thread Egor Pugin
In Visual Studio:
1. Select boot_* (boot step), epp_* (boot and master epp - cpp steps),
databases (security.fdb, messages.fdb, help.fdb generation), messages
(firebird.msg generation), other projects you need to turn off (examples,
etc). Right click - unload projects. They still will be unloaded after VS
restart.
2. Just uncheck projects in Solution Properties - Configuration Properties.


On 17 December 2014 at 03:46, Adriano dos Santos Fernandes 
adrian...@gmail.com wrote:

 On 16-12-2014 07:12, Egor Pugin wrote:
  Hi!
 
  ​I prepared building of Firebird using CMake.
  You can find more information on the link below. Also you can try it.
  https://bitbucket.org/egor_pugin/firebird_cmake
 
  CMake can simplify the build process, solve a lot of problems with
  integration icu, zlib and other libraries into the build (I saw
  discussions here about them during last 2-3 weeks).
 
  ​I hope you find this useful and consider including this into trunk.
  If you like it, we'll discuss details about patch later.
 

 After an initial full build, how do I build it avoiding the boot-build
 phase?


 Adriano


 --
 Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
 from Actuate! Instantly Supercharge Your Business Reports and Dashboards
 with Interactivity, Sharing, Native Excel Exports, App Integration  more
 Get technology previously reserved for billion-dollar corporations, FREE

 http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk
 Firebird-Devel mailing list, web interface at
 https://lists.sourceforge.net/lists/listinfo/firebird-devel



-- 
Egor Pugin
--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration  more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrkFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


Re: [Firebird-devel] CMake build system

2014-12-17 Thread Adriano dos Santos Fernandes
On 17/12/2014 08:03, Egor Pugin wrote:
 In Visual Studio:
 1. Select boot_* (boot step), epp_* (boot and master epp - cpp
 steps), databases (security.fdb, messages.fdb, help.fdb generation),
 messages (firebird.msg generation), other projects you need to turn
 off (examples, etc). Right click - unload projects. They still will be
 unloaded after VS restart.
 2. Just uncheck projects in Solution Properties - Configuration
 Properties.



I want to known with make in Linux, sorry, missed to say...


Adriano


--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration  more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


Re: [Firebird-devel] CMake build system

2014-12-17 Thread Egor Pugin
Yes, this is a problem.
I know possible solution and will try to fix it.

On 17 December 2014 at 13:16, Adriano dos Santos Fernandes 
adrian...@gmail.com wrote:

 On 17/12/2014 08:03, Egor Pugin wrote:
  In Visual Studio:
  1. Select boot_* (boot step), epp_* (boot and master epp - cpp
  steps), databases (security.fdb, messages.fdb, help.fdb generation),
  messages (firebird.msg generation), other projects you need to turn
  off (examples, etc). Right click - unload projects. They still will be
  unloaded after VS restart.
  2. Just uncheck projects in Solution Properties - Configuration
  Properties.
 
 

 I want to known with make in Linux, sorry, missed to say...


 Adriano



 --
 Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
 from Actuate! Instantly Supercharge Your Business Reports and Dashboards
 with Interactivity, Sharing, Native Excel Exports, App Integration  more
 Get technology previously reserved for billion-dollar corporations, FREE

 http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk
 Firebird-Devel mailing list, web interface at
 https://lists.sourceforge.net/lists/listinfo/firebird-devel



-- 
Egor Pugin
--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration  more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrkFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] [FB-Tracker] Created: (CORE-4640) subselect losing the index when where clause includes coalesce()

2014-12-17 Thread JIRA
subselect losing the index when where clause includes coalesce()


 Key: CORE-4640
 URL: http://tracker.firebirdsql.org/browse/CORE-4640
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 2.5.2 Update 1
 Environment: Win8.1, Firebird 2.5.2.26540 (x64)
Reporter: Omacht András
 Attachments: FB_TEST.ZIP

See the attached database.

When running 

select t3.id,
   (select first 1 v1.id
  from v1
  where v1.vc1 = 'A' and v1.i2 = 1000 and v1.i1 = coalesce(t3.i1_1, 
t3.i1_2))
  from t3

no indicies were found for view v1:

Plan
PLAN (V1 T1 NATURAL)
PLAN (V1 T2 NATURAL)
PLAN (T3 NATURAL)

The engine should use T1_UK and T2_UK:
Plan
PLAN (V1 T1 INDEX (T1_UK1))
PLAN (V1 T2 INDEX (T2_UK1))
PLAN (T3 NATURAL)


Without coalesce in then where clause it works fine:

select t3.id,
   (select first 1 v1.id
  from v1
  where v1.vc1 = 'A' and v1.i2 = 1000 and v1.i1 = t3.i1_1)
  from t3

Plan
PLAN (V1 T1 INDEX (T1_UK1))
PLAN (V1 T2 INDEX (T2_UK1))
PLAN (T3 NATURAL)

and

select t3.id,
   (select first 1 v1.id
  from v1
  where v1.vc1 = 'A' and v1.i2 = 1000 and v1.i1 = t3.i1_2)
  from t3

Plan
PLAN (V1 T1 INDEX (T1_UK1))
PLAN (V1 T2 INDEX (T2_UK1))
PLAN (T3 NATURAL)

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

   

--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration  more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


Re: [Firebird-devel] [PATCH] Cobol interface

2014-12-17 Thread Dmitry Yemanov
18.12.2014 10:47, Alexey Pavlov wrote:

 -*(ISC_ULONG *)arg_vector[-1].a_address = (ISC_ULONG)p;
 -
 +*(uintptr_t *)arg_vector[-1].a_address = (uintptr_t)p;

So far our practice is to favor FB-specific typedefs instead of system 
ones. U_IPTR should be used here instead of uintptr_t.


Dmitry


--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration  more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel