gstat -h
вт, 23 авг. 2022 г. в 07:15, Tommi Prami :
>
> Hello,
>
>
>
> I was thinking that if there is some kind of header (simple enough) in
> Firebird Databases and/or backup files, maybe some one could point me into
> the right direction.
>
> I would preferably need (mainly for installer) sma
ср, 11 мая 2022 г. в 21:10, Adriano dos Santos Fernandes :
>
> On 11/05/2022 14:47, Roman Simakov wrote:
> >
> > I was thinking the profiler should not touch profiled attachments at
> > all. It might influence its logic.
> >
>
> The profiler should work on i
ср, 11 мая 2022 г. в 19:40, Adriano dos Santos Fernandes :
>
> On 11/05/2022 11:55, Roman Simakov wrote:
> > Can you make up or describe a potential case of the situation?
> > Undoubtedly the feature would be useful but we've lived without it for
> > all the time.
&g
Can you make up or describe a potential case of the situation?
Undoubtedly the feature would be useful but we've lived without it for
all the time. If a role is revoked from a user, it will affect the
next attachment only, won't it?
ср, 11 мая 2022 г. в 16:36, Adriano dos Santos Fernandes :
>
> Hi
It makes sense. Could you create a ticket?
вт, 10 мая 2022 г. в 04:31, Adriano dos Santos Fernandes :
>
> Hi!
>
> A role can be default granted to PUBLIC.
>
> create role r1;
> grant default r1 to public;
>
> In this case I think the role should be act as a defaulted role to every
> user.
>
> But
Don't general instructions work?
вт, 19 апр. 2022 г. в 20:07, Hugo Larson via Firebird-devel
:
>
> Hi,
>
> I want to build FB4 for Linux (Ubuntu) arm64 and wonder if there is
> documentation with instructions?
>
> Thanks,
> Hugo.
>
> - Forwarded Message -
> From: Mark Rotteveel
> To: "fi
Alex,
Is it documented somewhere?
пн, 11 апр. 2022 г. в 18:45, Alex Peshkoff via Firebird-devel
:
>
> On 4/11/22 17:56, Dimitry Sibiryakov wrote:
> > Vasiliy Yashkov wrote 11.04.2022 16:52:
> >> What is the right way to throw an exception?
> >
> > Plugins (as any other DLL) is not supposed to t
;t
> ever be set by user.
>
> --
> Mgr. Jiří Činčura
> https://www.tabsoverspaces.com/
>
> On Mon, Feb 14, 2022, at 15:22, Roman Simakov wrote:
> > It's the default for a database. It cannot be NULL. Initial NULL means
> > INVOKER.
> >
> > пн, 14 февр.
It's possible to alter a trigger partly, alter an option of a trigger.
SQL SECURITY is one of such options. For procedures you must specify
"complete definition" every time.
пн, 14 февр. 2022 г. в 12:35, Jiří Činčura :
>
> Hi *,
>
> I'm wondering why is there explicit "DROP SQL SECURITY" for trigg
It's the default for a database. It cannot be NULL. Initial NULL means INVOKER.
пн, 14 февр. 2022 г. в 16:43, Jiří Činčura :
>
> Hi *,
>
> How can I drop SQL SECURITY on database, aka setting the RDB$SQL_SECURITY
> column back to "null"?
>
> --
> Mgr. Jiří Činčura
> https://www.tabsoverspaces.com
I hope it can be handled while restoring. I have no good idea how to
deal with differences between 3 and 4. It's possible to make a gap in
5 and handle it while restoring as well.
ср, 26 янв. 2022 г. в 17:03, Jiří Činčura :
>
> > They are also reinserted without changes in backup/restore...
>
> Ev
It's the first constant for DDL privileges and other constants must be
before it. See obj.h. Adding objects for DML privileges moved it
further.
Perhaps we should have reserved several items but ...
Maybe to leave a comment in code for the next move to make a gap?
ср, 26 янв. 2022 г. в 16:01, Jiří
пн, 6 дек. 2021 г. в 23:07, Dimitry Sibiryakov :
>
> Roman Simakov wrote 06.12.2021 18:50:
> > It looks so and we've returned to my original question)
>
>Actually no. It is still unknown which version of Firebird 3.0 you watched
> and which hash was used.
Actually,
пн, 6 дек. 2021 г. в 15:26, Dimitry Sibiryakov :
>
> Roman Simakov wrote 06.12.2021 13:16:
> > Can you point me to the commit? I see no difference between 3 and 5
> > versions of InternalHash::hash implementation.
>
>It looks like using of CRC32C was backported i
Can you point me to the commit? I see no difference between 3 and 5
versions of InternalHash::hash implementation.
пн, 6 дек. 2021 г. в 14:35, Dimitry Sibiryakov :
>
> Dimitry Sibiryakov wrote 06.12.2021 12:26:
> > Hashing function has been changed to one with supposedly "more even"
> > distributi
пн, 6 дек. 2021 г. в 14:08, Dimitry Sibiryakov :
>
> Roman Simakov wrote 06.12.2021 10:24:
> > We can see:
> > Hash slots: 65521, Hash lengths (min/avg/max):0/ 13/ 30
> > Under heavy load.
>
>On which version do you see it?
3.0. Were there any changes i
пн, 6 дек. 2021 г. в 12:47, Alex Peshkoff via Firebird-devel
:
>
> On 12/6/21 12:24, Roman Simakov wrote:
> > Hello!
> >
> > Isn't it time to increase the maximum number of HashSlots and make it
> > ULONG instead of USHORT? We can see:
> > Hash slots: 655
Hello!
Isn't it time to increase the maximum number of HashSlots and make it
ULONG instead of USHORT? We can see:
Hash slots: 65521, Hash lengths (min/avg/max):0/ 13/ 30
Under heavy load.
--
Best,
Roman Simakov
Firebird-Devel mailing list, web interface at
https://lists.sourceforg
isql like
ATT_STAT ON/OFF.
Opinions?
--
Best,
Roman Simakov
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
ions per attachment should be allowed or if the remote
> session should count as active session for the initiator or the being
> profiled attachment.
I think it's not critical to have multiple active sessions. I hardly
can imagine multiple developers profiling the same session. So an
.
--
Best,
Roman Simakov
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
.
Location of BLOB fields is postponed.
Page size is identical for every tablespace and the primary database.
Tablespaces are excluded from replication because it's physical layout
of a database and a replica may have another one.
==END=========
--
Roman Si
ср, 13 окт. 2021 г. в 15:25, Dimitry Sibiryakov :
> Roman Simakov wrote 13.10.2021 14:20:
> > I suppose you mean async replication. I guess like other errors, no?
>
>No, I meant exactly synch replication. "Other errors" in such cases
> leads to
> transact
cation. I guess like other errors, no?
--
Roman Simakov
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
вт, 12 окт. 2021 г. в 18:27, Dimitry Sibiryakov :
>
> Roman Simakov wrote 12.10.2021 17:16:
> > I'm not sure that keeping page numbers in a transactional relation is
> > a really excellent idea.
>
>But you added it into RDB$RELATIONS table, no?..
It does not mak
вт, 12 окт. 2021 г. в 18:03, Dimitry Sibiryakov :
>
> Roman Simakov wrote 12.10.2021 16:55:
> >> If this field is needed at all. Still there is no answer why tablespace
> >> cannot be identified by name only except "it was done this way 40 years
> >> ag
вт, 12 окт. 2021 г. в 18:07, Vlad Khorsun :
>
> 12.10.2021 17:53, Roman Simakov wrote:
> > вт, 12 окт. 2021 г. в 13:11, Vlad Khorsun :
> >>
> >> 12.10.2021 9:09, Roman Simakov wrote:
> >>> пн, 11 окт. 2021 г. в 23:03, Vlad Khorsun >>> <mai
people prefer PRIMARY so I think we include it in the
next version of the proposal.
--
Roman Simakov
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
ed by name only except "it was done this way 40 years ago".
Why not to suggest PR for this refactoring?
--
Roman Simakov
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
вт, 12 окт. 2021 г. в 13:11, Vlad Khorsun :
>
> 12.10.2021 9:09, Roman Simakov wrote:
> > пн, 11 окт. 2021 г. в 23:03, Vlad Khorsun > <mailto:hv...@optima.com.ua>>:
> >
> > 11.10.2021 21:23, Roman Simakov wrote:
> > > I'd be happy to ag
вт, 12 окт. 2021 г. в 11:56, Mark Rotteveel :
>
> On 11-10-2021 14:17, Roman Simakov wrote:
> [..]
>
> > SYNTAX
> > ===
> [..]
> > 3. *DROP TABLESPACE [INCLUDING CONTENTS]*
> >
> > If the tablespace contains some database objects the behaviour de
пн, 11 окт. 2021 г. в 23:03, Vlad Khorsun :
> 11.10.2021 21:23, Roman Simakov wrote:
> > пн, 11 окт. 2021 г. в 18:42, Vlad Khorsun hv...@optima.com.ua>>:
> >
> > 11.10.2021 15:17, Roman Simakov wrote:
> > > SYNTAX
> > > ===
> >
.
>
> The first PR may come without it, but I'm against releasing it until
> nbackup is supported.
>
Good!
--
Roman Simakov
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
пн, 11 окт. 2021 г. в 18:42, Vlad Khorsun :
> 11.10.2021 15:17, Roman Simakov wrote:
> > SYNTAX
> > ===
> >
> > Note: *MAIN* - is a name of the basic database file.
>
>Please, use *DEFAULT* for default (main) tablespace at "main" database
> f
пн, 11 окт. 2021 г. в 16:14, Dimitry Sibiryakov :
>
> Roman Simakov wrote 11.10.2021 14:52:
> >>> Add page space id to page number in ods.h:index_root_page.
> >>> pag_root is located in the tablespace where a table is located
> >> Why is this difference?
пн, 11 окт. 2021 г. в 15:27, Dimitry Sibiryakov :
>
> Roman Simakov wrote 11.10.2021 14:17:
> > FIELD TYPE CONSTRAINT ... USING INDEX ... TABLESPACE { | MAIN} --
> > field constraint tablespace
>
>What's the point of using "MAIN" here? Whole TABLESPACE
ain database.
==END=====
--
Roman Simakov
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
чт, 7 окт. 2021 г. в 17:12, Mark Rotteveel :
>
> On 07-10-2021 15:54, Roman Simakov wrote:
> > чт, 7 окт. 2021 г. в 11:14, Mark Rotteveel :
> >> I think it will save a lot of headaches if ALTER DATABASE {BEGIN|END}
> >> BACKUP can do that for all tablespaces at once.
чт, 7 окт. 2021 г. в 11:47, Dimitry Sibiryakov :
>
> Roman Simakov wrote 06.10.2021 21:49:
> >> How are data moved?
> >>
> >> Under transaction control?
> >>
> >> In background (and interruptible) like db crypt?
> > it's a dfw operat
чт, 7 окт. 2021 г. в 11:45, Dimitry Sibiryakov :
>
> Roman Simakov wrote 07.10.2021 8:14:
> > ср, 6 окт. 2021 г. в 23:57, Dimitry Sibiryakov:
> >> Roman Simakov wrote 06.10.2021 22:44:
> >>> Sorry I was wrong. TABLESPACE_ID is used as pagespace ID internally
&g
чт, 7 окт. 2021 г. в 11:14, Mark Rotteveel :
>
> On 2021-10-06 21:37, Roman Simakov wrote:
> > ср, 6 окт. 2021 г. в 19:29, Adriano dos Santos Fernandes
> > :
>
> >> And what about nbackup? Will it create a .delta file per tablespace?
> >
> > Our imple
чт, 7 окт. 2021 г. в 11:11, Mark Rotteveel :
>
> On 2021-10-06 21:27, Roman Simakov wrote:
> > ср, 6 окт. 2021 г. в 19:13, Mark Rotteveel :
> >> On 06-10-2021 17:32, Roman Simakov wrote:
> >> > 9. ALTER INDEX DROP TABLESPACE
> >> >
> >>
and then share with Firebird as well.
--
Roman Simakov
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
ср, 6 окт. 2021 г. в 23:57, Dimitry Sibiryakov :
>
> Roman Simakov wrote 06.10.2021 22:44:
> > Sorry I was wrong. TABLESPACE_ID is used as pagespace ID internally
> > but this id presents at index root page for example.
>
>I don't see it in ods.h:index_root_page.
x27;m not sure
if it's easy to break the relationship between TABLESPACE_ID and
TABLESPACE_NAME. It's an effective way to refer to a tablespace.
--
Roman Simakov
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
ср, 6 окт. 2021 г. в 22:17, Dimitry Sibiryakov :
>
> Roman Simakov wrote 06.10.2021 20:43:
> > Let me not describe every field. I hope most of them are obvious.
>
>No, they aren't.
ok
A new table RDB$TABLESPACES # keeps metadata of tablespaces.
RDB$T
ср, 6 окт. 2021 г. в 22:48, Dimitry Sibiryakov :
>
> Roman Simakov wrote 06.10.2021 21:27:
> > So am I. Currently tablespace headers are just not used.
>
>In this case how do you determine page size inside of tablespace file?
> Having
> it different from main one is
ср, 6 окт. 2021 г. в 22:01, Adriano dos Santos Fernandes :
>
> On 06/10/2021 15:43, Roman Simakov wrote:
> >
> >>> RDB$POINTER_PAGE - INTEGER
> >>> RDB$ROOT_PAGE - INTEGER
> >>
> >>What these are for?
> >
> > These fields
ср, 6 окт. 2021 г. в 19:29, Alex Peshkoff via Firebird-devel
:
>
> On 10/6/21 6:32 PM, Roman Simakov wrote:
>
> > 4. CREATE TABLE …
> > TABLESPACE
>
> Given syntax does not let specify tablespace for constraints-related
> indexes and separate fields. That'
ve paths support, in relation to
> main database file.
>
> In this case, restore will also restore the relative paths to the new
> location.
Good point. We'll do it such way.
> And what about nbackup? Will it create a .delta file per tablespace?
Our implementation does not support nba
ср, 6 окт. 2021 г. в 19:13, Mark Rotteveel :
>
> On 06-10-2021 17:32, Roman Simakov wrote:
> > 3. DROP TABLESPACE [INCLUDING CONTENTS]
>
> I think using {CASCADE | RESTRICT} instead of [INCLUDING CONTENTS] would
> be better, as that fits with similar definitions in the SQL
ср, 6 окт. 2021 г. в 18:56, Dimitry Sibiryakov :
>
> Roman Simakov wrote 06.10.2021 17:32:
> > A new table RDB$TABLESPACES:
> >
> > RDB$TABLESPACE_ID - SMALLINT
> > RDB$TABLESPACE_NAME - CHAR (63)
> > RDB$SECURITY_CLASS - CHAR (63)
> > RDB$SY
es.
==END=
First of all, please let me know whether you agree or not with SYNTAX
and ODS parts. Other opinions and suggestions are welcome as well.
--
Roman Simakov
https://reddatabase.ru
Firebird-Devel mailing list, web interface at
https://lists.sourc
irebirdsql.org/en/firebird-technical-specifications/
>
> Mark
>
> --
> Mark Rotteveel
>
>
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
--
Roman Simakov
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Great) So we just need to adjust documentation?
вс, 9 мая 2021 г. в 20:05, Mark Rotteveel :
>
> On 09-05-2021 18:38, Roman Simakov wrote:
> > Create a ticket, please: drop clauses for procedures, functions and
> > packages and inheriting a clause for packages.
>
> Curren
Create a ticket, please: drop clauses for procedures, functions and
packages and inheriting a clause for packages.
вс, 9 мая 2021 г. в 19:35, Mark Rotteveel :
>
> On 09-05-2021 18:24, Roman Simakov wrote:
> > вс, 9 мая 2021 г. в 19:04, Mark Rotteveel :
> >> Does that mean th
вс, 9 мая 2021 г. в 19:04, Mark Rotteveel :
>
> On 09-05-2021 17:58, Roman Simakov wrote:
> > I guess this was the reason not to implement it. But objects inherit
> > SQL SECURITY from the database and it might be useful to drop sql
> > security in order to use database def
eful to drop sql
security in order to use database default.
--
Roman Simakov
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
.
>
> Would it be sufficient to say something like
>
> """
> The property cannot be dropped for procedures, functions and packages,
> but it can be changed from INVOKER to DEFINER and vice versa.
> """
>
> Mark
> --
> Mark Rotteveel
>
&
Bug
Affects Versions: 4.0 RC 1
Reporter: Roman Simakov
The engine executing GRANT from a stored procedure with SQL SECURITY DEFINER
runned from another user with EXECUTE privilege raises the error "User cannot
write to RDB$USER_PRIVILEGES"
--
This message is automatically ge
Reporter: Roman Simakov
roman@roman-home % ./isql firebird/gen/Debug/firebird/bin
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database '/tmp/buffb.fdb';
SQL> ^D% roman@roman-home % roman@roman-home % ./gfix -buffers 100
/tmp/buffb.fdb fi
pport
> breaking them ;-) The same for date with commas. The only "broken"
> format I agree to consider useful is '20 Oct 2020'. Given that
> space-parsing problems appear inside the time part, perhaps it could be
> re-allowed for dates (only).
Yes! I agree.
--
Roman Simakov
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
focused on other formats. Here
I'd focus on the broken backward compatibility. I see no problem to
keep it possible since we have had it already.
--
Roman Simakov
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
sons to break the backward compatibility?
--
Roman Simakov
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
PI is not easy to be
> directly used by application developers.
I agree
--
Roman Simakov
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
tional features Firebird almost fits the requirements.
Supporting of ARRAYs also required.
Maybe it's must be implemented in another way but before we understand
it we should not neither remove it nor depricate it. At least if there
are no strong reasons that block other good aims.
--
Hello!
I've made PR https://github.com/FirebirdSQL/firebird/pull/247
I left my comments there too.
Please, take a look.
--
Roman Simakov
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
:) Certainly they are. I just tested you)
ср, 27 нояб. 2019 г. в 21:50, Gabor Boros :
>
> 2019. 11. 27. 15:52 keltezéssel, Roman Simakov írta:
> >Backport of the fix from the master branch: Now CREATE
> > FUNCTION/PROCEDURE inside CREATE PACKAGE does not require CR
Exactly. First of all it's interesting to understand an effect of
implementation and then we can at least to keep it in mind.
вт, 17 сент. 2019 г. в 13:58, Alex Peshkoff via Firebird-devel
:
>
> On 16.09.2019 20:07, Leyne, Sean wrote:
> > Roman,
> >
> >> From:
Hi,
I guess it would be interesting alternative for spinlock
(https://kernelnewbies.org/Linux_5.3)
1.6. Power efficient userspace waiting with the umwait x86 instructions
More description is here:
https://lwn.net/Articles/790920/
--
Roman Simakov
Firebird-Devel mailing list, web interface at
net/lists/listinfo/firebird-devel
--
Roman Simakov
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
OK. Thanks. I forgot that we carry ICU with server on Windows. Sorry.
ср, 3 апр. 2019 г. в 18:27, Mark Rotteveel :
>
> On 3-4-2019 17:03, Roman Simakov wrote:
> > чт, 3 янв. 2019 г. в 14:15, Adriano dos Santos Fernandes
> > :
> >>
> >> On 30/12/2018 07:22, M
. Europe Standard
> > Time). Falling back to displacement.
> > """
> >
>
> That's because Windows build is still with old ICU without time zone data.
Is there any chance to fix it?
--
Roman Simakov
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
t this
> error? More
> than 15 second between running of isql and this failure on my notebook.
>
> --
>WBR, SD.
>
>
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
--
Roman Simakov
blems and allow to highlight other ones.
In other words RAM simulates the very good system IO like a PCIe-SSD.
> The comparision can show some problems but results must be analysed carefully.
The real tuning exactly must take into account all layers including disk IO.
--
Roman Simakov
F
ld >=2.31
Reporter: Roman Simakov
See
https://sourceware.org/git/gitweb.cgi?p=binutils-gdb.git;a=blob_plain;f=ld/NEWS;hb=refs/tags/binutils-2_31
for 2.31
*Add a configure option --enable-separate-code to decide whether
-z separate-code should be enabled in ELF linker by d
nge it only if you have a problem and consciously understand what
are you doing.
--
Roman Simakov
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Affects Versions: 2.5.8
Environment: Ubuntu 18.04, superclassic, classic
Reporter: Roman Simakov
To reproduce:
in terminal 1 run:
./isql -u sysdba -p masterkey
create database 'localhost:/tmp/test';
set term ^; execute block as begin execute statement 'exec
ср, 25 июл. 2018 г. в 13:08, liviuslivius :
>
>
> > Note: this SELECT may have greater CN then you have stored and it
> > means on the next step you may receive records already selected here.
> > You merge algorithm should take it into account.
> >
> > Roma
h previously cached
> dataset
> now we remember current CN as interesting
> interestingCN:=recentCN
> TR55 commit
--
Roman Simakov
--
Check out the vibrant tech community on one of the world's most
r
REQUEST_CN. You have to select RECUEST_CN in the same request as
select) Otherwise the next request will have its own new CN.
> It can provide simple way to retrive new records/changes in tables (new
> feature).
--
Roman Simakov
info/firebird-devel
> >
>
>
>
>
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> Firebird-Devel mailin
Reporter: Roman Simakov
New objects and some old object of database cannot be granted via role
privileges. Suggestion is the same as for check of existing objects: move
checks to code like it's already done for generators and exceptions.
To test a problem you can use the script
: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.3, 4.0 Alpha 1
Reporter: Roman Simakov
RDB$TRIGGER9 checks that object exists. After adding USAGE privilege on
generator and exception related checks were not added to RDB$TRIGGER9. As
result we
iguration.
I agree. "service_mgr" really seems very ugly and not so obvious why it needs.
--
Roman Simakov
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot
vel
> processing. We already did that for some.
I'm trying to do it for trigger1 right now because it do not cover
some new objects privileges and it's really hard to maintain.
--
Roman Simakov
--
Check out
platforms
Reporter: Roman Simakov
A logic of rvoking options, especially for field permissions is very
complicated and wrong. Several examples:
EXAMPLE 1
grant update(f1, f2) on table t to u with grant option;
commit;show grants;
/* Grant permissions
sions: 3.0.3, 4.0 Alpha 1, 3.0.2, 3.0.1, 3.0.0, 4.0 Initial
Reporter: Roman Simakov
isql -u sysdba -p masterkey
create database 'localhost:d:\db\test.fdb';
create user user1 password 'pass';
grant drop database to user1;
isql -u user1 -p pass
connect 'localhost:
Components: Engine
Affects Versions: 3.0.3, 4.0 Alpha 1
Reporter: Roman Simakov
That's because engine considers trigger as DDL.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
1
Reporter: Roman Simakov
We have no check of existance a subjects of privileges. I.e.
roman:bin$ ./isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'a';
SQL> create table t(i integer);
SQL> grant select on t to function wrong_func;
2018-02-20 15:43 GMT+03:00 Alex Peshkoff via Firebird-devel
:
> On 02/20/18 15:39, Roman Simakov wrote:
>> In this case it's a bug right?
>>
>
> yes
http://tracker.firebirdsql.org/browse/COR
ng_func;
There is no user-defined function WRONG_FUNC in this database
In this case it's a bug right?
--
Roman Simakov
--
Check out the vibrant tech community on one of the world's most
engaging tech sites,
this database
I tend to consider it as a bug to be fixed. Am I right?
--
Roman Simakov
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdo
Reporter: Roman Simakov
For example:
GRANT EXECUTE ON PROCEDURE TEST_PROCEDURE TO FUNCTION TEST_FUNCTION WITH GRANT
OPTION;
GRANT EXECUTE ON PROCEDURE TEST_PROCEDURE TO PACKAGE TEST_PACKAGE WITH GRANT
OPTION;
--
This message is automatically generated by JIRA.
-
If you think it was sent
Sounds resonable
2018-01-19 20:11 GMT+03:00 Alex Peshkoff via Firebird-devel
:
> On 01/19/18 14:03, Roman Simakov wrote:
>>
>> 2018-01-19 12:54 GMT+03:00 Vlad Khorsun via Firebird-devel
>> :
>>>
>>> 19.01.2018 11:41, Adriano dos Santos Fernandes wrote:
>&
2018-01-19 12:54 GMT+03:00 Vlad Khorsun via Firebird-devel
:
> 19.01.2018 11:41, Adriano dos Santos Fernandes wrote:
>>
>> On 19/01/2018 07:14, Roman Simakov wrote:
> it search for ICU library using versions numbers such as 5.19 ... 5.0, 4.19
> ... 4.0 etc.
>
> But, II
additional prefix like ".1" or "_1". I tries to make
symlink and server could find .so! However it could not find functions
because of the same problem. They also use such suffixes.
Anybody can fix a magic of library and functions looking up or at
least explain me an idea
Components: Engine
Affects Versions: 4.0 Alpha 1, 3.0.2, 2.5.7, 3.0.1, 2.5.6, 3.0.0, 4.0
Initial
Environment: Ubuntu x86_64
Reporter: Roman Simakov
In case of error after phase 3 of create_relation in dfw the engine have filled
RDB$PAGES in system transaction
You sould not strip out TOK_
https://github.com/FirebirdSQL/firebird/pull/133 fixed errors you see
2017-12-02 23:58 GMT+03:00 William L. Thomson Jr. :
> On Sat, 2 Dec 2017 23:45:09 +0300
> Roman Simakov wrote:
>>
>> Hmmm. I do not understand. Did ypu strip out TOK_ prefix
ared in this scope
> {NEQ, "!=", false},
> ^~~
>
> And it repeats for several lines, many things not declared.
>
> --
> William L. Thomson Jr.
>
> --
> Check out the vibrant tech community on one of the world's most
>
1 - 100 of 176 matches
Mail list logo
