About GUIDs in Firebird

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

About GUIDs in Firebird

Jiří Činčura-2
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: 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:[hidden email]]
Gesendet: Dienstag, 10. Januar 2017 15:20
An: For users & developers of the Firebird .NET providers <[hidden email]>
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
[hidden email]
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
zab
Reply | Threaded
Open this post in threaded view
|

Re: About GUIDs in Firebird

zab
In reply to this post by Jiří Činčura-2
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 <[hidden email]> 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
> [hidden email]
> 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: About GUIDs in Firebird

Jiří Činčura-2
In reply to this post by 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.

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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: About GUIDs in Firebird

Jiří Činčura-2
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider