Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5460) Insert NULL into identity column with auth generated value

2017-01-19 Thread Mark Rotteveel
On 2017-01-18 23:38, Adriano dos Santos Fernandes wrote: > Ann, I assigned it to me based on Dimitry S. comment. > > After your comment, I edited the case to reflect the standard. Does the standard actually allow having an insert with null (or any other value for that matter) for a GENERATED

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5460) Insert NULL into identity column with auth generated value

2017-01-19 Thread Adriano dos Santos Fernandes
On 19/01/2017 07:07, Mark Rotteveel wrote: > On 2017-01-18 23:38, Adriano dos Santos Fernandes wrote: >> Ann, I assigned it to me based on Dimitry S. comment. >> >> After your comment, I edited the case to reflect the standard. > Does the standard actually allow having an insert with null (or any

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5460) Insert NULL into identity column with auth generated value

2017-01-19 Thread Dimitry Sibiryakov
19.01.2017 11:03, Adriano dos Santos Fernandes wrote: > c) If for some n, some underlying column of the column referenced by the > CN contained > in the n-th ordinal position in is an identity > column whose descriptor includes an > indication that values are generated by default, then if

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5460) Insert NULL into identity column with auth generated value

2017-01-19 Thread Adriano dos Santos Fernandes
On 19/01/2017 08:22, Dimitry Sibiryakov wrote: > 19.01.2017 11:03, Adriano dos Santos Fernandes wrote: > >> c) If for some n, some underlying column of the column referenced by the >> CN contained >> in the n-th ordinal position in is an identity >> column whose descriptor includes an >>

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5460) Insert NULL into identity column with auth generated value

2017-01-19 Thread Ann Harrison
> On Jan 19, 2017, at 1:46 AM, Dmitry Yemanov wrote: > > 19.01.2017 00:51, Ann Harrison wrote: >> >> In what universe does that make sense? The field is NOT NULL. You're >> storing NULL in it. That's an error. > > I'd say it depends. What about a BEFORE trigger

[Firebird-devel] -std=c++11 added to CXXFLAGS in 3.0 on linux

2017-01-19 Thread Michal Kubecek
Hello, commit 52d9a05a0f3d ("Backport from master: Optimized hash function for lock manager and hash join") in B3_0_Release branch adds "-std=c++11" to CXXFLAGS on Linux. Is this change intentional? Is it something we want? It doesn't seem to be necessary, as far as I can say, the build succeeds

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5460) Insert NULL into identity column with auth generated value

2017-01-19 Thread Mark Rotteveel
On 2017-01-19 13:14, Ann Harrison wrote: >> On Jan 19, 2017, at 1:46 AM, Dmitry Yemanov >> wrote: >> >> 19.01.2017 00:51, Ann Harrison wrote: >>> >>> In what universe does that make sense? The field is NOT NULL. >>> You're storing NULL in it. That's an error. >> >>

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5460) Insert NULL into identity column with auth generated value

2017-01-19 Thread Mark Rotteveel
On 2017-01-19 11:35, Adriano dos Santos Fernandes wrote: > On 19/01/2017 08:22, Dimitry Sibiryakov wrote: >> 19.01.2017 11:03, Adriano dos Santos Fernandes wrote: >> >>> c) If for some n, some underlying column of the column referenced by >>> the >>> CN contained >>> in the n-th ordinal

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5460) Insert NULL into identity column with auth generated value

2017-01-19 Thread Mark Rotteveel
On 2017-01-19 11:03, Adriano dos Santos Fernandes wrote: > On 19/01/2017 07:07, Mark Rotteveel wrote: >> Does the standard actually allow having an insert with null (or any >> other value for that matter) for a GENERATED ALWAYS AS IDENTITY (I >> don't >> have a copy of the SQL standard at hand

[Firebird-devel] [FB-Tracker] Created: (CORE-5463) Support GENERATED ALWAYS identity columns

2017-01-19 Thread Adriano dos Santos Fernandes (JIRA)
Support GENERATED ALWAYS identity columns - Key: CORE-5463 URL: http://tracker.firebirdsql.org/browse/CORE-5463 Project: Firebird Core Issue Type: New Feature Components: Engine

[Firebird-devel] [FB-Tracker] Created: (CORE-5464) AV in fbclient when reading blob stored in incompatible encoding

2017-01-19 Thread Vlad Khorsun (JIRA)
AV in fbclient when reading blob stored in incompatible encoding Key: CORE-5464 URL: http://tracker.firebirdsql.org/browse/CORE-5464 Project: Firebird Core Issue Type: Bug

[Firebird-devel] CORE-782, CORE-742, Partial CORE-679

2017-01-19 Thread Si Carter
Hi All, Hopefully I have the right audience, apologies if not, Some years ago I submitted the above suggestions. I now have compiled and tested a solution to most (excluding windows event log) which would still satisfy my need in ISP for Firebird. What is the best way to attempt to get these

Re: [Firebird-devel] CORE-782, CORE-742, Partial CORE-679

2017-01-19 Thread Roman Simakov
2017-01-20 2:12 GMT+03:00 Si Carter : > What is the best way to attempt to get these submitted into the current > build? I guess the best option to share your work is to make a fork of Fb git repo and prepare pull request (one per feature). -- Roman Simakov Red Soft