ATION_CONSTRAINTS rc
on rc.RDB$INDEX_NAME = s.RDB$INDEX_NAME and rc.RDB$CONSTRAINT_TYPE =
'FOREIGN KEY')
on i.RDB$RELATION_NAME = rf.RDB$RELATION_NAME
where
rf.RDB$FIELD_SOURCE starting with 'D_FK_'
Did I miss something or does this turn out to be a bug?
Greetings, Tho
13
> Rise to greatness in Intel's independent game demo contest.
> Compete for recognition, cash, and the chance to get your game
> on Steam. $5K grand prize plus 10 genre and skill prizes.
> Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d
> Firebird-Devel mailin
k downtime and maximize team effectiveness.
> Reduce network management and security costs.Learn how to hire
> the most talented Cisco Certified professionals. Visit the
> Employer Resources Portal
> http://www.cisco.com/web/learning/employer_resources/index.html
>
>
>
Kjell pointed out.
What I think is, that trying approach 4 will be doomed to fail, and
approach 2 is - well I'd not say "useless", but probably not worth the
efford. Thus, we should try to find a way to make this extensible just
like collations.
--
Mit freundlichen Grüßen,
Thomas
list): Aren't we talking
about building something into the firebird engine?
A UDF can be written by whom-so-ever, the architecture is there and does
not need to be developed by the firebird developer team...
--
Mit freundlichen Grüßen,
Thomas Beckmann
Diplom-Informatiker
Wielandstraße 14c • 235
me and maximize team effectiveness.
> Reduce network management and security costs.Learn how to hire
> the most talented Cisco Certified professionals. Visit the
> Employer Resources Portal
> http://www.cisco.com/web/learning/employer_resources/index.html
> Firebird-Devel mailing l
st talented Cisco Certified professionals. Visit the
> Employer Resources Portal
> http://www.cisco.com/web/learning/employer_resources/index.html
>
>
>
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
--
Mi
Is there a way to execute a statement on FB3.0-server from 2.5 by
"execute statement on external"? At least, I did not manage to
successfully connect...
Thank you for any hints! Thomas
--
Mit freundlichen Grüßen,
Thomas Beckmann
Diplom-Informatiker
Wielandstraße 14c • 23558 Lübeck
T
o work with users list. Don't forget to restore
> default when you over with this task.
Thank you Alex, for your detailed information. Will there be a way to
connect without decrease of security level?
--
Mit freundlichen Grüßen,
Thomas Beckmann
Diplom-Informatiker
Wielandstraße 14c • 235
I switched
UserManager back to default and restarted server before trying to
connect - or does the UserManager has to remain "legacy" as long as I
want to do my experiments from FB2.5?
Thank you, Thomas
Am 08.05.2013 17:27, schrieb Alex Peshkoff:
> On 05/08/13 19:16, Thomas Beckman
Hi Alex,
sorry - I had no time to work on this problem again, before:
I got it to work.
Switching
AuthServer = Legacy_Auth
AuthClient = Legacy_Auth
UserManager = Legacy_UserManager
will show me a couple of older users in security database and I could
add my new user using gsec.
Switching on
> I had to grant access to PUBLIC for all the tables I'd like to access
> this way, or is there any other way?
I went for particular roles, which works fine.
--
ASSFINET Dienstleistungs-GmbH
Wielandstraße 14c * 23558 Lübeck
Tel +49 (04 51) 399 04 - 555 * Fax +49 (04 51) 399 04 -529
Mail thoma
> You may grant access to the particular user, which is used in execute
> statement.
Ok, this works, even though the user is not visible in FB3.0?
--
ASSFINET Dienstleistungs-GmbH
Wielandstraße 14c * 23558 Lübeck
Tel +49 (04 51) 399 04 - 555 * Fax +49 (04 51) 399 04 -529
Mail thomas.beckm...
Am Fri, 24 May 2013 16:06:39 +0400
schrieb Alex Peshkoff :
> On 05/24/13 15:51, Dimitry Sibiryakov wrote:
> > 24.05.2013 13:44, Alex Peshkoff wrote:
> >> It's possible to show all users. The problems are:
> >> 1. What to do when modify or delete someuser is issued, and someuser is
> >> present in
> This makes plugins better than Legacy almost useless. Legacy auth
> transfers passwords almost palin over the wire, making it too easy to be
> captured by 3d party. And knowing first 8 bytes of password makes
> finding the rest (provided password is longer than 8 bytes) much easier.
I agree,
Am 07.06.2013 17:55, schrieb Dimitry Sibiryakov:
> 07.06.2013 17:31, Leyne, Sean wrote:
>> If an operator is comparing OCTETS against a string value, OCTETS
>> value should be coerced into the charset of the other value.
>
>In which way? How code x'a0' should be "coerced" into UTF-8?
tigate about it? Do you have an idea what's going on here?
Thank you for hints! Thomas
--
Mit freundlichen Grüßen,
Thomas Beckmann
Diplom-Informatiker
Wielandstraße 14c • 23558 Lübeck
Tel +49 (04 51) 399 04 - 545 • Fax +49 (04 51) 399 04 - 604
Mail thomas.beckm...@assfinet.de
quite difficult to follow...
>> But: Did any one of you investigate about it?
> Yes, a bit
>
>> Do you have an idea what's going on here?
> So far i have no solution
Ok, have you been able to reproduce it, though?
Again: Thank you! Thomas
--
Mit fr
ome of this behavior might be a bug, but some might be intended...
Thank you for some hints on this! Thomas
--
Mit freundlichen Grüßen,
Thomas Beckmann
Diplom-Informatiker
Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <m
> This one has already been fixed.
Thank you, I'll update and check again!
--
Mit freundlichen Grüßen,
Thomas Beckmann
Diplom-Informatiker
Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:t
ine 1, column 129
Very interesting...
--
Mit freundlichen Grüßen,
Thomas Beckmann
Diplom-Informatiker
Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>
ASSFINET-Logo
*ASSFINET
e statement" to tell that "Legacy_Auth"
plugin is to be used?
Thank you! Thomas
--
Mit freundlichen Grüßen,
Thomas Beckmann
Diplom-Informatiker
Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thoma
-
> This SF.net email is sponsored by Windows:
>
> Build for Windows Store.
>
> http://p.sf.net/sfu/windows-dev2dev
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
--
Mit f
t execute statement assumes same port as original connection...
Ok, thank you for your hints!
Best regards and have a nice weekend, Thomas
--
Mit freundlichen Grüßen,
Thomas Beckmann
Diplom-Informatiker
Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22
y default
Hm, but if I omit it, it does not work, if I add it, it works...
>> Probably, it should be the first plugin in the list...
>
> Not necessary
Hm, I made a couple of tests and it seems to make a difference...
Regards, Thomas
--
Mit freundlichen Grüßen,
Thomas Beck
I'm still struggling with getting my user priviledges set up the proper
way in FB3.0, and stumbled across table SEC$USERS - can someone give me
a hint what this is for or where I can find some informations about it?
Thank you!
Regards, Thomas
--
Mit freundlichen Grüßen,
Thomas Beckmann
D
ble that shows users allowed to be managed
> (ALTER/DROP USER) by the current user. For SYSDBA, it returns the full
> list of known users.
Thank you, Dimitry!
--
Mit freundlichen Grüßen,
Thomas Beckmann
Diplom-Informatiker
Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +
ze in adding this procedure?
Best regards, Thomas
--
Mit freundlichen Grüßen,
Thomas Beckmann
Diplom-Informatiker
Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>
ASSFINET-Logo
Creating the procedure outside a package works fine.
>
> That's weird. A test case would be appreciated.
>
> Dmitry
--
Mit freundlichen Grüßen,
Thomas Beckmann
Diplom-Informatiker
Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail t
ck.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
--
Mit freundlichen Grüßen,
Thomas Beckmann
Diplom-Informatiker
Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax
y were
> generated names, yes, it will be useful.
I definitely agree: If it's not too much hazle to show them, I'd really
appreciate to see them. With the tools I use, I can see them and it
would lead me to the error much faster.
--
Mit freundlichen Grüßen,
Thomas Beckmann
Diplom-I
e - though I don't see the need to change current behavior: If you
want to, you can restrict working with system tables by database and
role design and if you mess up your system tables, it's up to you to get
out of it...
--
Mit freundlichen Grüßen,
Thomas Beckmann
Diplom-Informatiker
k.I) on i.I = j.I and j.I<10
But it does not: It behaves like
select i.I, j.I, k.I from CTE_CNT i
join CTE_CNT j on i.I = j.I and j.I<10
join CTE_CNT k on j.I = k.I
Can someone explain this to me? Is this as intended or is this a bug?
Thanks alot! Thomas
--
Mit freundlichen Grüßen,
Thoma
TE_CNT j on i.I = j.I and j.I<10
> left join CTE_CNT k on j.I = k.I
>
> to keep the LEFT behaviour for all the streams depending on J.
Thank you, Dimitry!
--
Mit freundlichen Grüßen,
Thomas Beckmann
Diplom-Informatiker
Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 -
rdnews.org and firebase
> about what users would expect in "native" FB replication.
--
Mit freundlichen Grüßen,
Thomas Beckmann
Diplom-Informatiker
Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mail
>> This "useless garbage" is required for self-documenting
>
>Self-documenting of what? Isn't list in header enough for this purpose?..
No: Not everybody using firebird reads C-code.
Thomas
--
Diplom-Informatiker
Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 2
2, 'toto'
> 4, 3, 'toto'
> .
> .
> .
> 1, , 'toto'
>
> When executing the request there is no problem, but when retrieving the
> results there is an error : Fetch "too many concurrent executions of the same
> request&
code.
Thomas
--
Mit freundlichen Grüßen,
Thomas Beckmann
Diplom-Informatiker
Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>
ASSFINET-Logo
*ASSFINET Dienstleistungs-GmbH*
Max
lly pointless without
> application that
> works with it.
That really depends: Most of the business logic in our accounting system
is covered by PSQL in triggers and procedures. The application(s) just
visualize the UI...
--
Mit freundlichen Grüßen,
Thomas Beckmann
Diplom-Informatiker
Wielandst
> And it might not be feasible to rewrite PSQL code to UDRs, given
> time and money constraints.
Hey, PSQL words fine in may ways, is natively integrated - why should we
even consider of moving the code to anything else?
Greetings, Thomas
--
Mit freundlichen Grüßen,
Thomas Beckmann
>> 02.09.2014 00:22, James Starkey wrote:
>>
>>> What possible user applications are going to be doing procedure and
>>> trigger definitions that require the source be omitted?
>>
>> Whatever user application that works with the database and executes
>> metadata upgrade scripts itself, without inv
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
--
Mit freundlichen Grüßen,
Thomas Beckmann
Diplom-Informatiker
Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm
e calls or mobile push notifications.
> Take corrective actions from your mobile device.
> http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
>
>
>
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listi
Dear Vicente,
I admit to not have checked all your DML provided in detail (but in
overview), but your description points to a non firebird problem: If
your problem would be related to the number of rows, the specification
of indices or any other database specific stuff, it would be probably
the sa
: Firebird Core
Issue Type: Bug
Affects Versions: 3.0 Alpha 1
Environment: Windows 7 64, Firebird "WI-T3.0.0.30281 Firebird 3.0
Unstable"
Reporter: Thomas Beckmann
Priority: Critical
The code in the examples file fbout-header.sql fails:
SQL&
Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 1
Environment: Windows 7 64, ISQL, Version: WI-T3.0.0.30287 Firebird 3.0
Unstable
Reporter: Thomas Beckmann
Priority: Critical
I guess, this should not be possible:
SQL> show version;
I
ebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 1
Environment: Win7 64, Firebird/Windows/Intel/i386 (access method),
version "WI-T3.0.0.30287 Firebird 3.0 Unstable"
on disk structure version 12.0
Reporter: Thomas Beckmann
Versions: 3.0 Alpha 1
Environment: Win7/64, WI-T3.0.0.30317 Firebird 3.0 Unstable
Reporter: Thomas Beckmann
Priority: Minor
Maybe, I just do not know how to write it, but I thought
"comment on function . is '';"
would add a comment to the functi
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 1
Environment: Win7/64, version "WI-T3.0.0.30317 Firebird 3.0 Unstable"
Reporter: Thomas Beckmann
Priority: Critical
Hard to des
Affects Versions: 3.0 Alpha 1
Environment: W7/63, WI-T3.0.0.30317 Firebird 3.0 Unstable
Reporter: Thomas Beckmann
Consider the following example:
create table TEST (BIT smallint);
create index IDX_TEST_BIT on TEST computed by (bin_shl(1, TEST.BIT-1));
insert into test values (0
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 1
Environment: W7/64, WI-T3.0.0.30317 Firebird 3.0 Unstable
Reporter: Thomas Beckmann
Consider the following test case:
create table TEST (UID varchar(64));
update or insert into TEST (U
, WI-T3.0.0.30338 Firebird 3.0 Unstable
Reporter: Thomas Beckmann
Priority: Minor
The following statement
execute block returns (U varchar(14)) as begin U = gen_uuid(); suspend; end;
results in the error message:
"Arithmetic overflow or division by zero has occ
Affects Versions: 3.0 Alpha 1
Environment: W7/64, WI-T3.0.0.30338 Firebird 3.0 Unstable
Reporter: Thomas Beckmann
Priority: Critical
The following statement works as expected in FB2.5 but fails in 3.0, returning
"SQL error code = -104. Invalid expression in the s
ons: 2.5.2
Environment: Win7/64
Reporter: Thomas Beckmann
As this example points out, x'##'-codes are not properly matched by similar to:
select
iif(' ' similar to '[[:WHITESPACE:]]', 'T', 'F'),
iif(x'20' similar
Components: ISQL
Affects Versions: 3.0 Initial
Environment: W7/64
ISQL Version: WI-T3.0.0.30435 Firebird 3.0 Unstable
Server version:
Firebird/Windows/Intel/i386 (access method), version "WI-T3.0.0.30435 Firebird
3.0 Unstable"
Reporter: Thoma
Issue Type: Bug
Components: ISQL
Affects Versions: 3.0 Initial
Environment: W7/64
ISQL Version: WI-T3.0.0.30435 Firebird 3.0 Unstable
Server version:
Firebird/Windows/Intel/i386 (access method), version "WI-T3.0.0.30435 Firebird
3.0 Unstable"
Reporter: Thomas Bec
Type: Bug
Components: GBAK
Affects Versions: 3.0 Initial
Environment: W7/64
ISQL Version: WI-T3.0.0.30435 Firebird 3.0 Unstable
Server version:
Firebird/Windows/Intel/i386 (access method), version "WI-T3.0.0.30435 Firebird
3.0 Unstable"
Reporter: Thoma
Environment: W7/64
ISQL Version: WI-T3.0.0.30435 Firebird 3.0 Unstable
Server version:
Firebird/Windows/Intel/i386 (access method), version "WI-T3.0.0.30435 Firebird
3.0 Unstable"
Reporter: Thomas Beckmann
Consider following small example:
create domain D_TES
Environment: Win7/64
gbak version WI-T3.0.0.30472 Firebird 3.0 Alpha 1
Reporter: Thomas Beckmann
Consider this testcase:
isql -user testuser -password testpwd
create database c:\temp\test.fdb
exit;
Now:
gbak -b c:\temp\test.fdb c:\temp\test.fbk
gbak -rep c:\temp\test.fbk c
59 matches
Mail list logo
