[Firebird-devel] Fwd: CASE statement Error : Datatypes are not comparable in expression CASE

2020-05-21 Thread Jorge Gonçalves
-- Forwarded message - From: Mark Rotteveel Date: Thu, May 21, 2020 at 8:25 AM Subject: Re: [Firebird-devel] CASE statement Error : Datatypes are not comparable in expression CASE To: Jorge Gonçalves This looks like a bug to me, could you report it on http://tracker.firebirdsql.

Re: [Firebird-devel] Windows Package Manager Preview

2020-05-21 Thread Alex Peshkoff via Firebird-devel
On 2020-05-20 22:04, Adriano dos Santos Fernandes wrote: https://devblogs.microsoft.com/commandline/windows-package-manager-preview/ At the first glance appears very promising Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Windows Package Manager Preview

2020-05-21 Thread Dimitry Sibiryakov
21.05.2020 11:42, Alex Peshkoff via Firebird-devel wrote: On 2020-05-20 22:04, Adriano dos Santos Fernandes wrote: https://devblogs.microsoft.com/commandline/windows-package-manager-preview/ At the first glance appears very promising They could make CLI for Windows Store but they created c

Re: [Firebird-devel] Fwd: CASE statement Error : Datatypes are not comparable in expression CASE

2020-05-21 Thread Mark Rotteveel
On 21-05-2020 11:14, Jorge Gonçalves wrote: After a more detailed analysis I have found the problem. I have run the upgrade process of my application that creates a table with one field "DELETED" with type BOOLEAN. That BOOLEAN type is a domain of type smallint, but the create statement uses t

Re: [Firebird-devel] Fwd: CASE statement Error : Datatypes are not comparable in expression CASE

2020-05-21 Thread Leyne, Sean
> This looks like a bug to me, could you report it on > http://tracker.firebirdsql.org/browse/CORE ? Could not disagree more!!! > After a more detailed analysis I have found the problem. > > I have run the upgrade process of my application that creates a table with one > field "DELETED" with

[Firebird-devel] [FB-Tracker] Created: (CORE-6314) Assigning RDB$DB_KEY to MBCS CHAR/VARCHAR does not enforce the target limit nor does validate the well-formness of the data

2020-05-21 Thread Adriano dos Santos Fernandes (JIRA)
Assigning RDB$DB_KEY to MBCS CHAR/VARCHAR does not enforce the target limit nor does validate the well-formness of the data --- Key: CORE-6314

Re: [Firebird-devel] Fwd: CASE statement Error : Datatypes are not comparable in expression CASE

2020-05-21 Thread Mark Rotteveel
On 21-05-2020 16:43, Leyne, Sean wrote: This looks like a bug to me, could you report it on http://tracker.firebirdsql.org/browse/CORE ? Could not disagree more!!! To be clear, this was something that I emailed privately to Jorge. Because from the description of the initial email, it look

Re: [Firebird-devel] Fwd: CASE statement Error : Datatypes are not comparable in expression CASE

2020-05-21 Thread Jorge Gonçalves
> > > Actually, it looks like you: > > - didn't bother reading the v3.0+ release notes and read about the new > Boolean datatype. > who reads ( sarcasm ) > > - make appropriate changes to your schema. Namely, to change your domain > names/references to be unique (so then never collide with

Re: [Firebird-devel] Windows Package Manager Preview

2020-05-21 Thread Jiří Činčura
>They could make CLI for Windows Store but they created completely That would IMO mean polishing, or rather finishing, Windows Store. At the moment it's half baked (Windows Store). -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https:/

[Firebird-devel] Provider selection at database creation

2020-05-21 Thread Emil Totev
I am happily using Firebird 4 Beta2 to serve transparently both ODS12 and ODS13 databases, by adding Engine12 to the providers list. However, when creating a new database either by ISQL's CREATE DATABASE or gbak -c, the server always uses the first, default provider (if not overridden in database