would
have been a godsend - but of course I couldn't.
IMO, arrays are a very useful - if not often needed - addition to the
rigid-and-stiff SQL language.
Cheers,
Paul Vinkenoog
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
nts: Engine
Affects Versions: 3.0.0, 2.5.5
Environment: Win7, CentOS 7
Reporter: Paul Vinkenoog
Priority: Minor
If the second argument to BIT_SHL/BIT_SHR is 64 or greater, it is taken modulo
64 before the shift operation is performed. This leads to unexpected
on Windows and
save that in a file, like we do on Posix? It won't hurt anybody, even if
they expect the old 'masterke', as long as the installer informs them.
Paul Vinkenoog
--
Firebird-Devel mailing list
Hi Alex,
>> But I would drop the database name from the first message and only mention
>> the directory path, a) because that's the location, and b) for consistency
>> between DatabaseAccess and ExternalFileAccess.
> Sorry, in external file access it's also filename here, I've just typed
> it w
in the error message;
this could speed up debugging.
But I would drop the database name from the first message and only mention the
directory path, a) because that's the location, and b) for consistency between
DatabaseAccess and ExternalFileAccess.
Paul Vinkenoog
--
> > an allowed directory tree" when it is Restrict.
>
> May it be single text "Use of external table file at specified location
> is not allowed by server configuration" ?
Sure, it'
ne.
Ideally (if it's not too much work), the message should be something like "The
use of external tables is not allowed in the current configuration" when EFA is
None, and "The specified external table path does not belong to
Alex wrote:
> > I think the "Access to external file X is denied by server administrator"
> > message could be improved, as it suggests a specific ban on this particular
> > file. And of course the instructions in firebird.conf itself.
>
> Paul, taking into an account that it was written by non-
ests a specific ban on this particular
file. And of course the instructions in firebird.conf itself.
Paul Vinkenoog
--
Full-scale, agent-less Infrastructure Monitoring from a single dashboard
Integrate with 40+ ManageEngin
Alex Peshkoff wrote:
> On 09/29/2015 03:23 PM, Dimitry Sibiryakov wrote:
> > 29.09.2015 13:21, Paul Vinkenoog wrote:
> >> So a CASCADE option would be a welcome addition for such cases.
> > Another question: how many levels should this cascade go?
> >
> Unlim
Dimitry Sibiryakov wrote:
> 29.09.2015 13:21, Paul Vinkenoog wrote:
> > So a CASCADE option would be a welcome addition for such cases.
>
>Another question: how many levels should this cascade go?
If applied, it should be complete, otherwise it wouldn't be much use. Aft
Alex Peshkoff wrote:
> create table t (f int);
> grant select on t to public granted by abc;
> revoke all on all from abc;
>
> Currently privileges, granted by user ABC, remain as is after executing
> mentioned revoke operator. This looks like a bug for me, but befor
jects that were granted TO user ABC. IMO this should not imply that
any privileges granted to other users/roles BY user ABC are also withdrawn.
Paul Vinkenoog
--
Firebird-Devel mailing list, web interface at
https://lists
ereas UTF-8 needs at least 3.
I can imagine that Japanese Firebird users would appreciate UTF-16
support.
Paul Vinkenoog
--
Get 100% visibility into Java/.NET code with AppDynamics Lite!
It's a free troubleshooting tool desig
xpected it
> to take about 10.
Congratulations, Mark. It's always a relief when these precarious operations
turn out right.
Paul Vinkenoog
--
Live Security Virtual Conference
Exclusive live event will cover all th
ation of its usability with non-deterministic functions.
The same goes for CTE's.
So... have we implemented the DT and CTE features correctly? And if so, can
somebody point me to some authoritative sources?
Kind regards,
Paul
back again.
> >
>
> Sure, this is what I did now.
Yes, I read the mail where you mentioned this just after I had sent mine :-)
Paul Vinkenoog
--
Live Security Virtual Conference
Exclusive live event will cov
we have any idea how many people are running Firebird 2.5.x successfully on
big-endian platforms?
Paul Vinkenoog
--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security
since the 16-char string and the 36-char
string (should) have the same order, these two functions could be made dead
simple by eliminating the unnecessary steps that convert it to an FB_GUID
struct and back again.
Paul Vinkenoog
---
s).
BTW, I didn't look at evlCharToUuid, but I guess similar things are happening
there, because on little-endians CHAR_TO_UUID works fine despite the flaws in
StringToGuid, and CHAR_TO_UUID2 doesn't.
So, all in all, our five UUID functions are all flawed on at least one type of
pla
would be nice?
> Also I guess there is still time to commit it for 2.5.2, as otherwise
> nothing of this makes sense.
Quite agreed.
Paul Vinkenoog
--
Live Security Virtual Conference
Exclusive live event wi
es).
And possibly other functions?
Paul Vinkenoog
--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discu
the existing conversion functions copy the bytes one by one without any
reordering, so if the input is in network byte order, then so is the output.
If you want any more examples (including the conversion functions maybe),
please let me know. But now I need some sleep ;-)
Cheers,
Paul Vinkeno
e, I strongly suggest:
- Fix GEN_UUID by making GenerateGuid() return the time-high-and-version word
in network order. That's all it takes!
- Drop CHAR_TO_UUID2 and UUID_TO_CHAR2 before the final release of Firebird
2.5.2.
- Keep CHAR_TO_UUID and UUID_TO_CHAR as they are, except that UUID_TO_
eek() functions in Delphi DateUtils are
> ISO 8601 compliant.
>
> http://docwiki.embarcadero.com/VCL/XE2/en/DateUtils.StartOfTheWeek
> http://docwiki.embarcadero.com/VCL/XE2/en/DateUtils.EndOfTheWeek
Guys, I think it's better to
e a..f;
- drop uuid_to_char2() and char_to_uuid2() before they see the light of day.
BTW, I would have posted much earlier but I usually don't have time to follow
firebid-devel. I got alerted to this issue because of a DOC tracker item
assigned to me.
Cheers,
Paul Vinkenoog
PS:
Of course I'
ogous to selecting unqualified column names from a JOIN: you can do
it, but if the column exists in more then one participant, an error is thrown.
My 2 cts.
Paul Vinkenoog
--
AppSumo Presents a FREE Video for the SourceFo
Reporter: Paul Vinkenoog
Priority: Minor
Now that the SQLSTATE context variable has been implemented for 2.5.1, it seems
logical to also support WHEN SQLSTATE , analogous to WHEN SQLCODE and
WHEN GDSCODE.
Possibly even in 2.5.1...?
--
This message is automatically
Affects Versions: 2.5.0
Reporter: Paul Vinkenoog
According to the standard, the range - includes all the characters
greater than or equal to and smaller than or equal to
Consequently, a descending range such as [p-k] is empty.
Firebird however matches ANY character against a descending
Components: Engine
Affects Versions: 2.5.0
Reporter: Paul Vinkenoog
Priority: Minor
The standard, as copied in the 2.5 Release Notes, allows the following regular
factors:
%?
%*
%+
%{...}
Firebird accepts '%?', but deems the othe
a value of 772 and 516.
>
> Why would I get such a strange value for SQLSubType when normally I get
> the character set id.
For (VAR)CHARS, the high byte of the subtype contains the collation ID.
Cheers,
Paul Vinkenoog
--
31 matches
Mail list logo