Re: [Firebird-devel] Error compiling FB for android

2018-02-08 Thread Alex Peshkoff via Firebird-devel

On 01/21/18 14:18, Jorge Gonçalves wrote:

After some progress I'm blocked...



What is missing?




Did you choose master branch with knowledge that it is highly 
experimental or stable B3_0_Release (firebird-3) may be better for you?
Anyway - I've fixed android build in master, new features requiring new 
libraries were added to it, android build was missing them.




ps : I have found some other problems that I have "solved" changing 2 
source files:


1 :  HAVE_CTIME_R  is not defined



This is fixed on github now.



2: HAVE_SIGSET



Here I'm surprised - I do not believe that google added this deprecated 
function to android. Firebird successfully builds w/o this define.




--
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-5743) Query parsing failed

2018-02-08 Thread Pierre Yager (JIRA)
Query parsing failed


 Key: CORE-5743
 URL: http://tracker.firebirdsql.org/browse/CORE-5743
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 3.0.3
 Environment: Windows 7, Delphi using UIB and Firebird Client DLL 
(reproducible within IBExpert)
Reporter: Pierre Yager


This query was known to work in Firebird 3.0.2 :

select
  2 as TYPE_MVT,
  TYPE_REGLEMENT,
  DEVISE,
  null as BANQUE
  sum(QUANTITE) as NOMBRE,
  sum(VALEUR) as MONTANT
from JOURNAL_CAISSE
where (TYPE_MOUVEMENT in (2, 3)) and (ANNULE is false)
  and (periode = ?)
group by 1,2,3,4

Now,, in Firebird 3.0.3 I get :

Overflow occurred during data type conversion.
conversion error from string "2".

I have to cast "2" as Integer to make it work again.

select
  cast(2 as Integer) as TYPE_MVT,
  TYPE_REGLEMENT,
  DEVISE,
  null as BANQUE
  sum(QUANTITE) as NOMBRE,
  sum(VALEUR) as MONTANT
from JOURNAL_CAISSE
where (TYPE_MOUVEMENT in (2, 3)) and (ANNULE is false)
  and (periode = ?)
group by 1,2,3,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



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


Re: [Firebird-devel] [SPAM] Re: Crash Firebird 2.5.8 Embedded with Firebird Ado.net provider.

2018-02-08 Thread Mark Rotteveel

On 7-2-2018 23:38, Vlad Khorsun via Firebird-devel wrote:

   Yes, sure.

   BTW, in Firebird 3 role of fb_shutdown is even more important as it 
uses plugin

architecture and many code layers are at separate DLL's now.

I was just experimenting with Jaybird, and I noticed an odd 
inconsistency with fb_shutdown_callback on Windows. For other 
callbacks in fbclient (ie the event callback), I must define the 
callback using StdCall calling conventions. 


   Hmm...

If I don't, things break. For the shutdown callback, using the 
'normal' JNA calling convention (which I assume is cdecl) just works.


   In ibase.h all callback prototypes are declared not using ISC_EXPORT 
macro (this macro
expands into __stdcall). So, i see no inconsistency there: (almost) all 
ISC API
functions declared using ISC_EXPORT and all callbacks are without 
ISC_EXPORT.


However with fb_shutdown_callback, if I do apply the StdCall 
convention, then the callback is invoked, but the application ends 
with error 0xC409 ('unknown exception').


   As expected.

I haven't (yet) defined the method fb_shutdown_callback to explicitly 
accept the StdCall callback (contrary to isc_queue_events), but I'm 
surprised that it actually works without changing the calling 
convention. Is this something specific to the shutdown callback?


   So far i see no specific here.


I don't think I'll actually need the callback, but I'll make some 
further tests to see what happens if I have the definition the same to 
the event callback.


Mark
--
Mark Rotteveel

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