Re: [Firebird-net-provider] About GUIDs in Firebird

[Jiří Činčura]

After a lot of thinking and considering pros and cons, I decided to do
the change. It's going to be painful, especially for people already
using it, but the least surprise principle here is strong argument in my
head. Also because there are some big changes in Firebird 3 itself (like
this
https://www.tabsoverspaces.com/233552-gotcha-with-firebird-3-count-and-executescalar-common-casting-pattern/),
it's better to do it sooner than later.

Thus very likely next _major_ version will contain this change.

-- 
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] About GUIDs in Firebird

[Jiří Činčura]

> I may have missed the point or I'm not aware of all the details here but
> trying to use a GUID in its string representation is a failure by itself. 

Thank you!

> Is there a case where this is needed because doing it right (using a Guid
> as its type and not as string) and use parameters isn't possible? 

I'm not aware of any. Except when you want to show the Guid for some
logging/debugging purposes and you're looking for it in database. But
still...

-- 
Mgr. Jiří Činčura
Independent IT Specialist

--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] About GUIDs in Firebird

[Ralf Jansen]

I may have missed the point or I'm not aware of all the details here but trying 
to use a GUID in its string representation is a failure by itself. 
I see no benefit in making something work that isn't advisable in the first 
place. Like trying to move a datetime as string to the db and hoping it get 
interpreted correctly. 

Is there a case where this is needed because doing it right (using a Guid as 
its type and not as string) and use parameters isn't possible? 

-Ursprüngliche Nachricht-
Von: Jiří Činčura [mailto:j...@cincura.net] 
Gesendet: Dienstag, 10. Januar 2017 15:20
An: For users & developers of the Firebird .NET providers 
<firebird-net-provider@lists.sourceforge.net>
Betreff: [Firebird-net-provider] About GUIDs in Firebird

Hi *,

we have this ticket DNET-509 in tracker. Although I agree the change would be 
nice, it's also a breaking change as huge as it can get. What's your take on 
it? Or do you see clean way out?

--
Mgr. Jiří Činčura
Independent IT Specialist

--
Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi 
processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi 
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] About GUIDs in Firebird

[Геннадий Забула]

We had encountered this one in our migration to .net provider, it
caused us much pain, because divergence with other SQL providers.

I'd vote for changing this and declaring it as breaking change. With
supplied fixes for existing code, of course.

On 10 January 2017 at 16:20, Jiří Činčura  wrote:
> Hi *,
>
> we have this ticket DNET-509 in tracker. Although I agree the change
> would be nice, it's also a breaking change as huge as it can get. What's
> your take on it? Or do you see clean way out?
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> --
> Developer Access Program for Intel Xeon Phi Processors
> Access to Intel Xeon Phi processor-based developer platforms.
> With one year of Intel Parallel Studio XE.
> Training and support from Colfax.
> Order your platform today. http://sdm.link/xeonphi
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] About GUIDs in Firebird

[Jiří Činčura]

Hi *,

we have this ticket DNET-509 in tracker. Although I agree the change
would be nice, it's also a breaking change as huge as it can get. What's
your take on it? Or do you see clean way out?

-- 
Mgr. Jiří Činčura
Independent IT Specialist

--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider