[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.org/browse/CORE ?

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 the syntax  "... DELETED BOOLEAN ...".
Since we use FB2.5 that's ok, the engine will create a smallint field,  but
in FB4 this will create a BOOLEAN field.

So is not a engine bug ... is a application upgrade bug.

Regards
jGoncalves









Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
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 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 completely separated software 
distribution system instead.
  They could be compatible with apt/yum/etc but they just made another 
"different-from-anyone" thing.

  Pathetic.

--
  WBR, SD.


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

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 the syntax  "... DELETED BOOLEAN ...".
Since we use FB2.5 that's ok, the engine will create a smallint field,  
but in FB4 this will create a BOOLEAN field.


So is not a engine bug ... is a application upgrade bug.


Good to hear you managed to find the problem!

Mark
--
Mark Rotteveel


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

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 type BOOLEAN.
> That BOOLEAN type is a domain of type smallint, but the create statement uses
> the syntax  "... DELETED BOOLEAN ...".
> Since we use FB2.5 that's ok, the engine will create a smallint field,  but 
> in FB4
> this will create a BOOLEAN field.
> 
> So is not a engine bug ... is a application upgrade bug.

Actually, it looks like you:

- didn't bother reading the v3.0+ release notes and read about the new Boolean 
datatype.

-  make appropriate changes to your schema.  Namely, to change your domain 
names/references to be unique (so then never collide with future FB changes).  
For example, we have always used a "D_" prefix for all our domain names (i.e 
"D_Boolean") to protect against the issue your just encountered.


Sean


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[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
 URL: http://tracker.firebirdsql.org/browse/CORE-6314
 Project: Firebird Core
  Issue Type: Bug
Affects Versions: 4.0 Beta 2, 3.0.5
Reporter: Adriano dos Santos Fernandes


-- Does not fail
select cast(rdb$db_key as char(2) character set utf8) from rdb$database;

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




Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

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 looked like a 
conversion issue between smallint and other integer datatypes.


Mark
--
Mark Rotteveel


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

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 future FB
> changes).  For example, we have always used a "D_" prefix for all our
> domain names (i.e "D_Boolean") to protect against the issue your just
> encountered.
>
> Unfortunately we are stuck in FB2.5 for now and we don't have plans to
upgrade in the near future. The last time that I tested the
application, unofficially, with FB 3  everything work fine, with upgrade
with FB 2.5, backup and restore with FB 3.
Now I let the upgrade runs with FB4, so this problem arises, and I only
checked the code today...
And yes I now that when we decide to upgrade to FBx this is only one of my
problems. ..

jGoncalves


Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
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 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://lists.sourceforge.net/lists/listinfo/firebird-devel

[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 databases.conf, of course). Wouldn't it make sense to have a
way to specify explicitly the wanted provider/ODS? If I understood
correctly there is already an  isc_dpb_config  parameter to tell this to
the engine, so why not surface it as a command-line option for gbak and an
addition to CREATE DATABASE?

This would apply for both 3 and 4, and for future versions.

Thanks
Emil
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel