Re: [Firebird-devel] READ BLOB / INSERT BLOB SQL commands

2012-02-01 Thread Roman Simakov
but current stable kinterbasdb does not > build with current stable firebird (2.5.1). We should better avoid such > things. More careful is to declare them deprecated and implement them returning errors. Cleanup will be possible in the next release after this.

Re: [Firebird-devel] Firebird 3, time to rename conflict names ?

2012-11-16 Thread Roman Simakov
, cloud infrastructure, etc. Download 30-day Free Trial. > Pricing starts from $795 for 25 servers or applications! > http://p.sf.net/sfu/zoho_dev2dev_nov > Firebird-Devel mailing list, web interface at > https://lists.sourc

Re: [Firebird-devel] RFC: non-expandable fields

2013-04-04 Thread Roman Simakov
t; text explicitly > and "hidden" otherwise. I have no good vision of how it could be elegantly implemented but sometimes I really need ability to hide some set of fields. So I agree on feasibility of

Re: [Firebird-devel] RFC: non-expandable fields

2013-04-04 Thread Roman Simakov
ccess. IMO produce an error is incorrect in this case. User just want to see all available fields. Also IMO it can be a solution of original problem. Just revoke select permission of service "hidden" fields. Only granted replication procedures will have an acc

Re: [Firebird-devel] RFC: non-expandable fields

2013-04-05 Thread Roman Simakov
return fail. It means that "select *" is valid operation only for user who has select permission for every field of table. -- Roman Simakov -- Minimize network downtime and maximize team effectiveness. Reduce

[Firebird-devel] Fwd: Error in save_xunit

2013-10-21 Thread Roman Simakov
Hello! Since I did not get an answer in firebird-test list I repost it here. -- Forwarded message -- From: Roman Simakov Date: 2013/10/10 Subject: Error in save_xunit To: firebird-t...@lists.sourceforge.net Hello! I got an error with following backtrace

Re: [Firebird-devel] Error in save_xunit

2013-10-31 Thread Roman Simakov
your result file with this one https://www.dropbox.com/s/bglu3bmrlaf73v3/results.trf and then run fbt_view -x Thanks. 2013/10/21 Roman Simakov : > Hello! > > Since I did not get an answer in firebird-test list I repost it here. > > -- Forwarded message -- > From

Re: [Firebird-devel] Update ICU in Windows

2014-02-17 Thread Roman Simakov
ot a question of src size (at least Internet becomes faster and > faster), but an approach in general - where possible we should use > standard 3d-party software. +1 and let them support their products. -- Roman Simakov ---

Re: [Firebird-devel] [Firebird-checkins] SF.net SVN: firebird:[59230] firebird/trunk/builds/install/arch-specific/ linux/linuxLibrary.sh.in

2014-03-06 Thread Roman Simakov
2014-03-06 13:59 GMT+04:00 Alex Peshkoff : > BTW, did they really make a solution? I remember there was very active > discussion re switch to systemd. AFAIK They decided to use systemd especially for Linux based systems. -- Roman S

Re: [Firebird-devel] Confusing BLR constants.

2014-04-07 Thread Roman Simakov
write, the names avoid the current confusion. Extending an idea it would be good to rename all such constants in the same manner. No? -- Roman Simakov -- Put Bad Developers to Shame Dominate Development with Jenkins Continuou

Re: [Firebird-devel] GIS (Planning the post v3 development)

2014-04-30 Thread Roman Simakov
um testing platform available. > Simple to use. Nothing to install. Get started now for free." > http://p.sf.net/sfu/SauceLabs > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Roman Simakov --

Re: [Firebird-devel] Cursor stability in READ COMMITTED transactions

2014-06-24 Thread Roman Simakov
CITLY specify TPB option isc_tpb_insensitive_cursor. I assume current applications relies on logically correct result so backward compatibility will not be broken. -- Roman Simakov -- Open source business process manag

Re: [Firebird-devel] Cursor stability in READ COMMITTED transactions

2014-06-25 Thread Roman Simakov
ing RC transaction he must be ready to get not > consistent data in it. IMO logical correctness is the first then GC. AFAIU we not prevent GC in transaction. We prevent GC in requests. -- Roman Simakov -- Open source

Re: [Firebird-devel] Cursor stability in READ COMMITTED transactions

2014-06-25 Thread Roman Simakov
2014-06-25 12:09 GMT+04:00 Dimitry Sibiryakov : > In this case why to use READ COMMITED transaction at all?.. Because opening cursor is not opening transaction. You can have long transaction but not opened cursors. Do not open if you are not going to fetch. -- Roman Sima

Re: [Firebird-devel] Cursor stability in READ COMMITTED transactions

2014-06-25 Thread Roman Simakov
n re-read fresh data in the same transaction, for instance refresh number of books. >May be it would be better if (s)he use brain and start transaction when it > is really > needed?.. +1. But read commited transaction can see new data. But to see new data during query execution is reall

Re: [Firebird-devel] Cursor stability in READ COMMITTED transactions

2014-06-25 Thread Roman Simakov
2014-06-25 14:49 GMT+04:00 Dimitry Sibiryakov : > 25.06.2014 12:41, Roman Simakov wrote: >> The same prepared query can re-read fresh data in the same >> transaction, for instance refresh number of books. > >You'll be wondered, perhaps, but a prepared query can re

Re: [Firebird-devel] DDL permissions

2014-07-07 Thread Roman Simakov
1, '42', '702', 0, 773, 'dup_attribute', NULL, NULL); +(-901, '42', '000', 0, 774, 'dyn_no_priv', NULL, NULL) +(-901, '42', '000', 0, 775, 'dsql_cant_grant_option', NULL, NULL); -- GFIX (-901, '00'

Re: [Firebird-devel] DDL permissions

2014-07-14 Thread Roman Simakov
2014-07-14 10:18 GMT+04:00 Simonov Denis : > I think it is more correct to describe it as Agreed. -- Roman Simakov -- Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 li

Re: [Firebird-devel] DDL permissions

2014-07-14 Thread Roman Simakov
permissions. I do not think that separate operators for these are good. It can lead to inconsistence like "user has permissions on object but cannot see it". -- Roman Simakov -- Want fast and easy access to all

Re: [Firebird-devel] Firebird 3 build broken with gcc under Linux

2014-07-19 Thread Roman Simakov
- > Want fast and easy access to all the code in your enterprise? Index and > search up to 200,000 lines of code with a free copy of Black Duck > Code Sight - the same software that powers the world's largest code > search on Ohloh, the Black Duck Open Hub! Try it

Re: [Firebird-devel] Firebird 3 build broken with gcc under Linux

2014-07-19 Thread Roman Simakov
f1e94000 (gdb) print sizeof(U_IPTR) $11 = 8 -- Roman Simakov -- Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the s

Re: [Firebird-devel] Firebird 3 build broken with gcc under Linux

2014-07-19 Thread Roman Simakov
linux is unsigned int and 4 bytes. IMO FB must use system size_t. -- Roman Simakov -- Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Co

Re: [Firebird-devel] Firebird 3 build broken with gcc under Linux

2014-07-21 Thread Roman Simakov
t; 19.07.2014 14:14, Roman Simakov wrote: > >> IMO FB must use system size_t. > > We were using system size_t until Nickolay had committed FB_SIZE_T a few > days ago in attempt to avoid warnings. The bad thing is that it wa

Re: [Firebird-devel] DDL permissions

2014-08-01 Thread Roman Simakov
DL commands but in the same time will provide a way to revert behavior for legacy tools. Other ideas? -- Roman Simakov -- Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lin

Re: [Firebird-devel] Hiding source code of procedures and triggers will not work in FB 3

2014-08-29 Thread Roman Simakov
to an idea of either encryption of SOURCE field by developer's key or do not store SOURCE code at all depending on special option of CREATE or ALTER procedure. -- Roman Simakov -- Slashdot TV. Video for Nerds.

Re: [Firebird-devel] Coding style: one-line blocks

2014-09-02 Thread Roman Simakov
2014-09-02 21:31 GMT+04:00 Dmitry Yemanov : > Let me disagree. +1 -- Roman Simakov -- Slashdot TV. Video for Nerds. Stuff that matters. http://tv.slashdot.org/ Firebird-Devel mailing list, web interface at ht

Re: [Firebird-devel] error on restore

2014-10-02 Thread Roman Simakov
2014-10-02 20:18 GMT+04:00 Frank Schlottmann-Gödde : > version LI-T3.0.0.31199 > with > version LI-T3.0.0.31348 Sorry for some kind of offtopic. What does it mean the last number in version? Is it synthetic build number? How can I understand what revision number was used to build it?

Re: [Firebird-devel] error on restore

2014-10-02 Thread Roman Simakov
o restore a backup created by > version LI-T3.0.0.31199 > with > version LI-T3.0.0.31348 > > any ideas? Between this versions was my commit #59840 for DDL permissions which changed ODS a little bit. I'm afraid you could not restore such backup. Before beta version it does not

[Firebird-devel] Interesting assert

2014-10-03 Thread Roman Simakov
Hello Claudio and all! I found very interesting assert in backup.epp (put_data function) fb_assert(field_count > 0 && field_count * 9 > 0 && field_count * 9 + 200 > 0) could you explain it? -- Roman Simakov --

[Firebird-devel] Building Firebird 3 on Mac

2014-10-28 Thread Roman Simakov
*** [master_process] Error 2 make[1]: *** [firebird] Error 2 make: *** [firebird] Error 2 ===== Any ideas? -- Roman Simakov -- Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] [PATCH] Mingw compilers don't support Win98

2014-12-18 Thread Roman Simakov
s, App Integration & more > Get technology previously reserved for billion-dollar corporations, FREE > http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebir

Re: [Firebird-devel] READ UNCOMMITTED implementation

2015-03-04 Thread Roman Simakov
2015-03-04 11:08 GMT+03:00 Dmitry Yemanov : > Over my dead body +1 I guess application must emulate this behaviour on application layer. -- Roman Simakov -- Dive into the World of Parallel Programming The Go Paral

Re: [Firebird-devel] Odp: READ UNCOMMITTED implementation

2015-03-05 Thread Roman Simakov
> 5 марта 2015 г., в 20:26, Jim Starkey написал(а): > > "read imaginary» Is it not the same as "read uncommited"? :) -- Roman Simakov -- Dive into the World of Parallel Programming

[Firebird-devel] ANN: BenchmarkSQL

2015-03-12 Thread Roman Simakov
share you investigations. -- Roman Simakov -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things paralle

Re: [Firebird-devel] ANN: BenchmarkSQL

2015-03-12 Thread Roman Simakov
aul Reeves : > > On Thursday 12 March 2015 10:25:49 Roman Simakov wrote: >> Hello! >> >> I've ported BenchmarkSQL for Firebird. It's TPC-C test working via >> JDBC and support PostgreSQL, Oracle, DB2 and now Firebird. >> >> https://github.com/romansimako

Re: [Firebird-devel] ANN: BenchmarkSQL

2015-03-12 Thread Roman Simakov
rogram via the same JDBC interface. From this POV it's useful benchmarking application. -- Roman Simakov -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partner

Re: [Firebird-devel] Lucene: The Good Parts via hackernews

2015-06-08 Thread Roman Simakov
to any contribution for this work. -- Roman Simakov skype: simakov_roman www.red-soft.biz -- Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] revoke all on all

2015-09-29 Thread Roman Simakov
; there, it's a massive security risk, but if you deleted him as per your > rules, you'd end up with permissions of "everybody:none". Maybe explicitly require it in SQL command? Like cascades? -- Roman Simakov -

Re: [Firebird-devel] Security problem with encrypted databases

2015-11-09 Thread Roman Simakov
you to easily query your data on Hadoop in a > more interactive manner. Teradata is also now providing full enterprise > support for Presto. Download a free open source copy now. > http://pubads.g.doubleclick.net/gampad/clk?id=250295911&iu=/4140 > Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Security problem with encrypted databases

2015-11-09 Thread Roman Simakov
2015-11-09 21:08 GMT+03:00 Dimitry Sibiryakov : > In Firebird, crypto-plugin has no access to header page and engine at all. Key correctness can check engine via crypto-plugin after attachment. -- Roman Sima

Re: [Firebird-devel] Security problem with encrypted databases

2015-11-09 Thread Roman Simakov
Key correctness can be checked by engine via crypto-plugin... 2015-11-09 21:21 GMT+03:00 Roman Simakov : > 2015-11-09 21:08 GMT+03:00 Dimitry Sibiryakov : >> In Firebird, crypto-plugin has no access to header page and engine at all. > > Key correctness can check engine via cryp

Re: [Firebird-devel] GitHub

2016-03-13 Thread Roman Simakov
+1 13 марта 2016 г. 7:15 PM пользователь "Mark Rotteveel" написал: > On 13-3-2016 17:10, Egor Pugin wrote: > > Jaybird repos will be prefixed as you wrote. > > https://github.com/firebirdsql/jaybird > > https://github.com/firebirdsql/jaybird-manual > > > > It's an option to move Jaybird to its ow

Re: [Firebird-devel] src_bundle.sh

2016-03-27 Thread Roman Simakov
http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140 > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel > -- Roman Simakov -- Trans

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5252) Crash on bugs.core_3029 in dev build

2016-05-25 Thread Roman Simakov
I guess it's a bug like http://tracker.firebirdsql.org/browse/CORE-5171 Am I the only who run tests in developer build sometimes? Is it possible to add one more configureation to CI of ci.ibphoenix.com? 2016-05-25 18:16 GMT+03:00 Roman Simakov (JIRA) : > Crash on bugs.core_3029 in d

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5252) Crash on bugs.core_3029 in dev build

2016-05-25 Thread Roman Simakov
Seems like the rest tests are good. 2016-05-25 18:21 GMT+03:00 Roman Simakov : > I guess it's a bug like http://tracker.firebirdsql.org/browse/CORE-5171 > > Am I the only who run tests in developer build sometimes? > > Is it possible to add one more configureation to CI

Re: [Firebird-devel] ODS 13

2016-06-01 Thread Roman Simakov
2016-06-01 10:53 GMT+03:00 Dmitry Yemanov : > I've bumped the ODS version for v4. It cannot work with ODS12 databases > anymore, backup/restore is needed. Does it make sence to install several previous engines with current one to make it possible to perform B/R after server upgrade?

[Firebird-devel] Crash on developer build

2016-07-07 Thread Roman Simakov
l. The root of call is here #ifdef DEBUG_GDS_ALLOC Firebird::AutoPtr file; { Firebird::PathName name = fb_utils::getPrefix( Firebird::IConfigManager::DIR_LOG, "memdebug.log"); #ifdef HAVE_DLADDR Release build is OK. -- Roman Simakov --

Re: [Firebird-devel] Crash on developer build

2016-07-07 Thread Roman Simakov
Yes. Developer build is OK now. 2016-07-07 15:39 GMT+03:00 Alex Peshkoff : > On 07/07/2016 01:53 PM, Roman Simakov wrote: > >> The reason is an attempt to get config manager of DummyMasterImpl. The >> root of call is here >> > > Fixed it - at least for linux. &g

[Firebird-devel] Source of objects

2016-07-22 Thread Roman Simakov
trigger_type trigger_position AS local_declaration_list full_proc_block { $$ = newNode(*$1); $$->active = $2; $$->type = $3; $$->position = $4; $$->source = makeParseStr(YYPOSNARG(5), YYPOSNARG(7)); $$->localDeclList = $6; $$->body = $7; } It's not uniform, con

Re: [Firebird-devel] Source of objects

2016-07-22 Thread Roman Simakov
2016-07-22 15:17 GMT+03:00 Adriano dos Santos Fernandes : > Is there any problem with isql extraction? > > Does it also manually adds AS for one and not for the other? No problem but two the same places with different processing. IMO it's strange. -- С уважением Роман Симаков Директор департаме

Re: [Firebird-devel] Source of objects

2016-07-22 Thread Roman Simakov
ain it. Maybe it requires double check. I'm not sure I understand how procedures are parsed in 2.5. For triggers it looks the same. Functions are new in 3.0. -- Roman Simakov skype: simakov_roman www.red-soft.ru -

Re: [Firebird-devel] C++11 features

2016-09-01 Thread Roman Simakov
I guess atomic also must be very helpful. 2016-09-01 20:37 GMT+03:00 Adriano dos Santos Fernandes : > On 01/09/2016 13:41, Dmitry Yemanov wrote: >> + nullptr and static_assert, maybe also initializer lists and non-static >> member initializers. >> > And override too, which can be easily defined fo

[Firebird-devel] SQL SECURITY

2016-10-19 Thread Roman Simakov
thout SQL SECURITY clause or SQL routins with them but using only SQL Standard features. 3) Use database But in the same time we can override permissions for tables, triggers, etc. It extentds standard in more usual use case for Firebird. -- Roman Simakov ---

Re: [Firebird-devel] Coroutines

2016-10-26 Thread Roman Simakov
w operators in one peace of well readable code but keep a pipeline processing of data. -- Roman Simakov -- The Command Line: Reinvented for Modern Developers Did the resurgence of CLI tooling catch you by surprise? Reco

Re: [Firebird-devel] Coroutines

2016-10-26 Thread Roman Simakov
With callbacks you will smear code over two methods: caller, callback. Also you will need to keep some state! AFAIU coroutins solve this problem in more elegant manner using saving running context. Operator A push a portion of data to pipe and *goto* operator B which pull the portion process it and

Re: [Firebird-devel] Profiling Windows native process?

2016-11-13 Thread Roman Simakov
#x27;s free and you can try. http://developer.amd.com/tools-and-sdks/opencl-zone/codexl/ -- Roman Simakov skype: simakov_roman www.red-soft.ru -- Developer Access Program for Intel Xeon Phi Processors Access to Int

Re: [Firebird-devel] Profiling Windows native process?

2016-11-14 Thread Roman Simakov
2016-11-14 10:55 GMT+03:00 Roman Simakov : > http://developer.amd.com/tools-and-sdks/opencl-zone/codexl/ Now it's here I guess: http://gpuopen.com/compute-product/codexl/ -- С уважением Роман Симаков Директор департамента развития системных продуктов ООО "Ред Софт" sk

Re: [Firebird-devel] arithmetic exception, numeric overflow, or string truncation after change column datatype and select from older format view

2016-11-23 Thread Roman Simakov
d as > soon as possible, to force the object definition to be reloaded. Why not to use the same sync objects? :) Locks, ASTs, flags of invalidated cache? The table t does know about new record format. The view v also must know it. I suppose it's not so easy but I agre

Re: [Firebird-devel] SQL:2016 was released a month ago

2017-01-12 Thread Roman Simakov
Anybody have a recent draft? :) 2017-01-12 14:54 GMT+03:00 marius adrian popa : > SQL:2016 was released a month ago: > http://www.iso.org/iso/home/store/catalogue_tc/catalogue_detail.htm?csnumber=63556 > New: - Row pattern matching - JSON - polymorphic table functions - > CAST(FORMAT) > >

Re: [Firebird-devel] Virtual metadata

2017-01-17 Thread Roman Simakov
does not match. May I ask an example? Will it work? start transaction; alter table T add column N INTEGER; insert into T (..., N) values (..., 10); commit; -- Roman Simakov -- Check out the vibrant tech community on on

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 Re

Re: [Firebird-devel] Firebird 3.x on MacOS

2017-03-01 Thread Roman Simakov
At least a description of the complicated settings build would be very useful. I several times started to build FB3 and master on my mac and cried :) 2017-03-01 12:11 GMT+03:00 Paul Beach : > A question by Vlad has prompted me to write this brief message... > > Some of you may have noticed that we

[Firebird-devel] INDEX ON SYSTEM RELATIONS

2017-03-29 Thread Roman Simakov
RDB$USER_PRIVILEGES I guess we can allow this. If there are no objections I'll fix it. -- Roman Simakov -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.

[Firebird-devel] Default port on client side

2017-09-27 Thread Roman Simakov
isten. ON SERVER: if RemoteServicePort is not specified - use 3050 ON CLIENT: expected: if port is not specified (like localhost:alias) use 3050 real: if port is not specified (like localhost:alias) use config or 3050 -- Rom

Re: [Firebird-devel] Default port on client side

2017-09-28 Thread Roman Simakov
OK. Thanks to all :) 2017-09-29 7:44 GMT+03:00 Dmitry Yemanov : > 27.09.2017 16:05, Roman Simakov wrote: >> >> >> I noticed that client uses RemoteServicePort parameter from >> firebird.conf if it's not specified in connection string. Is it by >> design?

Re: [Firebird-devel] cmake build error

2017-12-02 Thread Roman Simakov
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 >

Re: [Firebird-devel] cmake build error

2017-12-02 Thread Roman Simakov
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

[Firebird-devel] Firebird 3 and ICU

2018-01-19 Thread Roman Simakov
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

Re: [Firebird-devel] Firebird 3 and ICU

2018-01-19 Thread Roman Simakov
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

Re: [Firebird-devel] Firebird 3 and ICU

2018-01-19 Thread Roman Simakov
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: >&

[Firebird-devel] Existing a subject of privileges and refactoring

2018-02-20 Thread Roman Simakov
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

Re: [Firebird-devel] Existing a subject of privileges and refactoring

2018-02-20 Thread Roman Simakov
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,

Re: [Firebird-devel] Existing a subject of privileges and refactoring

2018-02-20 Thread Roman Simakov
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

Re: [Firebird-devel] System procedures

2018-05-27 Thread Roman Simakov
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

Re: [Firebird-devel] Services version 1 cleanup

2018-06-19 Thread Roman Simakov
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

Re: [Firebird-devel] Read consistency patch

2018-07-24 Thread 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

Re: [Firebird-devel] Read consistency patch

2018-07-24 Thread Roman Simakov
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

Re: [Firebird-devel] Read consistency patch

2018-07-25 Thread Roman Simakov
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

Re: [Firebird-devel] Read consistency patch

2018-07-25 Thread Roman Simakov
ср, 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

Re: [Firebird-devel] FB4 vs CORE-5222

2018-09-19 Thread Roman Simakov
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

Re: [Firebird-devel] Performance - 2.5 vs 3.0 vs 4.0

2019-01-23 Thread 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

Re: [Firebird-devel] ICU in HEAD

2019-02-07 Thread Roman Simakov
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

Re: [Firebird-devel] Difference in performance between current_timestamp and localtimestamp

2019-04-03 Thread Roman Simakov
. 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

Re: [Firebird-devel] Difference in performance between current_timestamp and localtimestamp

2019-04-03 Thread Roman Simakov
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

Re: [Firebird-devel] IDE or code editor on Linux

2019-09-14 Thread Roman Simakov
net/lists/listinfo/firebird-devel -- Roman Simakov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Power efficient userspace waiting with the umwait x86 instructions

2019-09-16 Thread Roman Simakov
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

Re: [Firebird-devel] Power efficient userspace waiting with the umwait x86 instructions

2019-09-17 Thread Roman Simakov
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:

Re: [Firebird-devel] [Firebird-checkins] [FirebirdSQL/firebird] 74f481: Backport of the fix from the master branch: Now CR...

2019-11-27 Thread Roman Simakov
:) 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

[Firebird-devel] TDBB_trusted_ddl flag

2020-01-10 Thread Roman Simakov
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

Re: [Firebird-devel] FB 3 & 4, new API and the ARRAY type

2020-04-26 Thread Roman Simakov
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. --

Re: [Firebird-devel] OO API examples for Object Pascal

2020-08-18 Thread Roman Simakov
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

Re: [Firebird-devel] Conversion error from string to date in Firebird 4

2020-10-20 Thread Roman Simakov
sons to break the backward compatibility? -- Roman Simakov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Conversion error from string to date in Firebird 4

2020-10-20 Thread Roman Simakov
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

Re: [Firebird-devel] Conversion error from string to date in Firebird 4

2020-10-20 Thread Roman Simakov
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

Re: [Firebird-devel] Contradiction in SQL SECURITY documentation in Firebird 4 release notes

2021-05-09 Thread Roman Simakov
. > > 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 > &

Re: [Firebird-devel] Contradiction in SQL SECURITY documentation in Firebird 4 release notes

2021-05-09 Thread Roman Simakov
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

Re: [Firebird-devel] Contradiction in SQL SECURITY documentation in Firebird 4 release notes

2021-05-09 Thread Roman Simakov
вс, 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

Re: [Firebird-devel] Contradiction in SQL SECURITY documentation in Firebird 4 release notes

2021-05-09 Thread Roman Simakov
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

Re: [Firebird-devel] Contradiction in SQL SECURITY documentation in Firebird 4 release notes

2021-05-09 Thread Roman Simakov
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

Re: [Firebird-devel] File and table sizes in Firebird 4.0

2021-08-14 Thread Roman Simakov
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

  1   2   >