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 unexpec
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
e 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
t; > 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's less spe
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 an al
cific 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+ ManageEngine ITSM Solution
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
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
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.sourcefor
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
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
.
Paul Vinkenoog
--
Get 100% visibility into Java/.NET code with AppDynamics Lite!
It's a free troubleshooting tool designed for production.
Get down to code-level detail for bottlenecks, with 2% overhead.
Download for free
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 the ways today's security
a waste of resources as well as a serious
limitation 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 Vinkenoog
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 cover all the ways today's security and
threat
' functions).
Cheers,
Paul Vinkenoog
(why do I always do these things at night?)
--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how
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
--
Live Security
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 and
threat landscape has changed
nothing of this makes sense.
Quite agreed.
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
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_CHAR may
still need the small change that UUID_TO_CHAR2 already underwent (output lower
case a..f instead of upper case).
Kind regards,
Paul Vinkenoog
, 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 Vinkenoog
--
Live Security Virtual Conference
Exclusive live
/XE2/en/DateUtils.StartOfTheWeek
http://docwiki.embarcadero.com/VCL/XE2/en/DateUtils.EndOfTheWeek
Guys, I think it's better to discuss tracker items in the tracker. I'll leave
my comment there ;-)
Paul Vinkenoog
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'm aware that in, say
: 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 SourceForge Community by Eric
Ries, the creator of the Lean
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 x, analogous to WHEN SQLCODE and
WHEN GDSCODE.
Possibly even in 2.5.1...?
--
This message is automatically
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
--
Simplify data backup and recovery for your virtual environment
27 matches
Mail list logo