Re: [Firebird-devel] Case-sensitive plugin names

2014-12-30 Thread Adriano dos Santos Fernandes
On 30/12/2014 10:35, Alex Peshkoff wrote: Would it be feasible to insist that all plug-ins are installed with lower-case file/directory names on case-sensitive file systems? (And nothing else will be recognised.) Then the content of your config files can be completely case-insensitive and

Re: [Firebird-devel] Using of interfaces after last changes

2015-01-23 Thread Adriano dos Santos Fernandes
On 23/01/2015 14:26, Dimitry Sibiryakov wrote: 23.01.2015 17:23, Adriano dos Santos Fernandes wrote: The wrappers exists so you can use an master-getStatus() instance. I don't need to get status from master because I receive IStatus interface from inside of the engine as a function's

Re: [Firebird-devel] Using of interfaces after last changes

2015-01-23 Thread Adriano dos Santos Fernandes
On 23/01/2015 15:32, Dimitry Sibiryakov wrote: 23.01.2015 18:18, Dimitry Sibiryakov wrote: 23.01.2015 17:50, Alex wrote: Pay attention to the second parameter in *Impl template class PluginModule : public IPluginModuleImplPluginModule, CheckStatusWrapper Did you ever think that throwing

Re: [Firebird-devel] Using of interfaces after last changes

2015-01-30 Thread Adriano dos Santos Fernandes
On 30/01/2015 13:29, Alex Peshkoff wrote: Adriano, what am I missing in currently generated code? We just miss a statement of how IStatus should work. We already talked about inconsistencies. I don't known what are the intentions when a dirty status is passed to a function: - the function

Re: [Firebird-devel] Using of interfaces after last changes

2015-02-02 Thread Adriano dos Santos Fernandes
On 02/02/2015 08:53, Dimitry Sibiryakov wrote: 02.02.2015 11:48, Alex Peshkoff wrote: It can be split, but is speed of compilation really a problem? At my computer full build of solution takes about an hour and a half. Yes, this is a problem, especially because MSVC doesn't stop

Re: [Firebird-devel] Using of interfaces after last changes

2015-02-02 Thread Adriano dos Santos Fernandes
On 02/02/2015 09:28, Alex Peshkoff wrote: On 02/02/15 14:04, Dimitry Sibiryakov wrote: 02.02.2015 12:00, Adriano dos Santos Fernandes wrote: So split the files manually and report the time differences. I see two times speed up for a module that uses Interfaces.h. 14k lines is a big bunch

[Firebird-devel] Remote / embedded connection

2015-01-18 Thread Adriano dos Santos Fernandes
Hi! Scenario: - Linux without config changes - Server started just with firebird command - Database could not be used by different processes Work: - First attachment with: isql localhost:database - Second attachment with: isql database Don't work: - First attachment with: isql database - Second

Re: [Firebird-devel] Examples broken in Windows

2015-01-28 Thread Adriano dos Santos Fernandes
On 27/01/2015 16:05, Egor Pugin wrote: Are the examples broken in all Windows builds? No, CMake build works well. cd firebird_sources mkdir build cd build cmake .. or cmake -H. -Bwin gives: CMake Error: CMake can not determine linker language for target: engine12_common Adriano

Re: [Firebird-devel] Examples broken in Windows

2015-01-28 Thread Adriano dos Santos Fernandes
On 28/01/2015 12:55, Egor Pugin wrote: I've commited possible fix. Please, 1) update the sources; 2) remove previous build dir ('build' or 'win' or whatever you have); 3) re-run any cmake command you listed. I tried again and the same error happened: CMake Error at src/CMakeLists.txt:416

[Firebird-devel] Windows build

2015-01-29 Thread Adriano dos Santos Fernandes
Hi! That always worked as this, but now with much more DLLs and conf files, I should ask... Do you still need to do manual steps to have a working debug/build environment in Windows? I mean, make_boot/make_all copy files to output_arch but IDE run files from temp\arch\conf\firebird... Do any

Re: [Firebird-devel] Windows build

2015-01-29 Thread Adriano dos Santos Fernandes
On 29/01/2015 13:56, Egor Pugin wrote: What files do you mean? --- With cmake try to run building of Custom build steps/copy_files project in VS solution manually and see in 'build_dir/firebird/conf/ if this is what you need. Apparently it copies, but I don't run to test now. So, is it

Re: [Firebird-devel] Windows build

2015-01-29 Thread Adriano dos Santos Fernandes
On 29/01/2015 13:12, Paul Reeves wrote: On Thursday 29 January 2015 16:06:12 Adriano dos Santos Fernandes wrote: Hi! That always worked as this, but now with much more DLLs and conf files, I should ask... Do you still need to do manual steps to have a working debug/build environment

Re: [Firebird-devel] Using of interfaces after last changes

2015-01-30 Thread Adriano dos Santos Fernandes
On 30/01/2015 15:42, Alex Peshkoff wrote: On 01/30/15 20:38, Dimitry Sibiryakov wrote: CLOOP sources are not committed yet. Interfaces' declarations for languages and compilers different from C++ aren't as well. All this make me very skeptical about its future. I have no idea why

Re: [Firebird-devel] Using of interfaces after last changes

2015-01-30 Thread Adriano dos Santos Fernandes
I'll not fall on your nitpicking, I have much thing to do! You may filter all messages with my name and read answers to all your (probably false) doubts! Adriano On 30-01-2015 16:33, Dimitry Sibiryakov wrote: 30.01.2015 18:59, Adriano dos Santos Fernandes wrote: It's not complete

[Firebird-devel] Examples broken in Windows

2015-01-27 Thread Adriano dos Santos Fernandes
Hi! Are the examples broken in all Windows builds? I'm trying win32 msvc12 build and, for example, it don't locate fbclient.lib, so it's not a thing recently changed. Adriano -- Dive into the World of Parallel

Re: [Firebird-devel] Add some functions.

2015-03-16 Thread Adriano dos Santos Fernandes
On 13-03-2015 22:44, Hajime Nakagami wrote: Hi, I made patch to add some functions about standard division. https://github.com/FirebirdSQL/core/pull/2 Can someone merge this patch ? Commented in https://github.com/FirebirdSQL/core/pull/2 Adriano

Re: [Firebird-devel] Y-valve and DPBs

2015-03-22 Thread Adriano dos Santos Fernandes
, 2015, at 6:46 PM, Adriano dos Santos Fernandes adrian...@gmail.com wrote: DPB is wrong in all sense. It's very cheap to parse, but nobody needs to live with its all disadvantages in a much cost (attachment) process. It's binary, every connection layer must support it. We do not talk

Re: [Firebird-devel] Y-valve and DPBs

2015-03-22 Thread Adriano dos Santos Fernandes
. On Mar 21, 2015, at 6:46 PM, Adriano dos Santos Fernandes adrian...@gmail.com wrote: DPB is wrong in all sense. It's very cheap to parse, but nobody needs to live with its all disadvantages in a much cost (attachment) process. It's binary, every connection layer must support it. We do

Re: [Firebird-devel] Y-valve and DPBs

2015-03-22 Thread Adriano dos Santos Fernandes
On 22-03-2015 13:01, James Starkey wrote: So let me get this straight. Your everything wrong with DPBs boils down to the absence of a comment in a header? Oh, dear me, that is indeed a deep and grevious fault. This is one of the problems. As I point out, and not only me, since someone just

Re: [Firebird-devel] Firebird 3 snapshot not contain Employee.fdb and more..

2015-03-16 Thread Adriano dos Santos Fernandes
On 16-03-2015 04:58, liviuslivius wrote: Hi, snapshot of Firebird3 not conatain employee.fdb and also full script for it But if i restore it from FB2.5 then README.window_functions.txt Examples in this file are just abstract. Nothing to do with the employee.fdb database.

Re: [Firebird-devel] Firebird 3 API demo usage with Pascal

2015-03-16 Thread Adriano dos Santos Fernandes
On 16-03-2015 19:54, liviusliv...@poczta.onet.pl wrote: How you are declaring it in the record? You should use ISC_QUAD. Adriano I use Int64 it is equivalent to ISC_QUAD It's really Int64. ISC_QUAD is for blobs. but I see what hapened Whe should decide about buffer alignment I can

Re: [Firebird-devel] Firebird 3 API demo usage with Pascal

2015-03-16 Thread Adriano dos Santos Fernandes
On 16-03-2015 17:52, liviusliv...@poczta.onet.pl wrote: Hi Adriano, I'm using Firebird for a long time. I decided that I could do something more for the Firebird community. I started working on support for all types supported by the Firebird in your FB Api on Delphi. Good! And so I

Re: [Firebird-devel] Firebird 3 API demo usage with Pascal

2015-03-17 Thread Adriano dos Santos Fernandes
On 17-03-2015 13:11, liviusliv...@poczta.onet.pl wrote: I think it must be more or less like Win32 records declared in Pascal. They follow standard C alignment rules, so as Firebird. Adriano Hi, and how it look in C Win 64 - because i use Win64 compiler and 64bit fbclient.dll No

[Firebird-devel] Y-valve and DPBs

2015-03-20 Thread Adriano dos Santos Fernandes
Hi! We have in the set of DPB constants: - Completely FB-engine features - Features uses in y-valve All these constants are mixed in the same number space. So we say we support multiple providers, but at the same time we expect that all providers has identical FB-engine features? How do non-FB

Re: [Firebird-devel] Y-valve and DPBs

2015-03-21 Thread Adriano dos Santos Fernandes
On 21-03-2015 12:10, Dimitry Sibiryakov wrote: 21.03.2015 15:46, Adriano dos Santos Fernandes wrote: Say, I now create a private XPTO provider If you really do that, DPB constants will be your smallest problem, trust me. I may only trust you if you say what are these problems

Re: [Firebird-devel] Y-valve and DPBs

2015-03-21 Thread Adriano dos Santos Fernandes
On 21-03-2015 13:16, Dimitry Sibiryakov wrote: 21.03.2015 17:03, Adriano dos Santos Fernandes wrote: That's not architecture. Choose something and pray. You do not know how many DPBs a private provider needs nor how many will be added in Firebird in the future. Yes, but that's the way

Re: [Firebird-devel] Y-valve and DPBs

2015-03-21 Thread Adriano dos Santos Fernandes
On 21-03-2015 14:11, Dimitry Sibiryakov wrote: 21.03.2015 18:04, Adriano dos Santos Fernandes wrote: That is not a problem only if we fool people and ourself that we support plugins, but our plugins should all reside in the same source tree. But that's exactly what you do in version 3.0

Re: [Firebird-devel] Y-valve and DPBs

2015-03-21 Thread Adriano dos Santos Fernandes
On 21-03-2015 05:52, Dimitry Sibiryakov wrote: 21.03.2015 2:18, Adriano dos Santos Fernandes wrote: All these constants are mixed in the same number space. So we say we support multiple providers, but at the same time we expect that all providers has identical FB-engine features? How do non

Re: [Firebird-devel] Y-valve and DPBs

2015-03-21 Thread Adriano dos Santos Fernandes
On 21-03-2015 14:40, James Starkey wrote: The classical mechanism is to establish one range for systen define codes and another for private extensions. As has beeb pointed out, any engine or transport can safely ignore unrecognized codes. Part if the architecture long before Firebird and

Re: [Firebird-devel] Y-valve and DPBs

2015-03-21 Thread Adriano dos Santos Fernandes
On 21-03-2015 16:00, Jim Starkey wrote: On Mar 21, 2015, at 2:35 PM, Kovalenko Dmitry dmitry.lipe...@gmail.com wrote: Look to OLE DB properties. Each property has the unique ID: GUID.Number. Bad idea for many reasons: 1. Not upwards compatible from existing scheme 2.

Re: [Firebird-devel] Firebird 3 API demo usage with Pascal

2015-03-17 Thread Adriano dos Santos Fernandes
On 17-03-2015 06:40, Vlad Khorsun wrote: 17.03.2015 10:06, liviusliv...@poczta.onet.pl wrote: but I see what hapened Whe should decide about buffer alignment I can use packed record instead of record then data are as is But what is your buffer alignment when you fill data in that record?

Re: [Firebird-devel] Firebird 3 API demo usage with Pascal

2015-03-17 Thread Adriano dos Santos Fernandes
On 17-03-2015 05:06, liviusliv...@poczta.onet.pl wrote: but I see what hapened Whe should decide about buffer alignment I can use packed record instead of record then data are as is But what is your buffer alignment when you fill data in that record? Search for type_alignments:

Re: [Firebird-devel] Firebird 3 API demo usage with Pascal

2015-03-09 Thread Adriano dos Santos Fernandes
On 08-03-2015 12:05, liviusliv...@poczta.onet.pl wrote: With that changes all work Please try the current files without modifications. PS is it possible to specify user and pass without storing it in system vars - which is not secure? You could build DPB as before. This is a piece

Re: [Firebird-devel] Firebird 3 API demo usage with Pascal

2015-03-11 Thread Adriano dos Santos Fernandes
On 10/03/2015 06:19, liviuslivius wrote: one more change is needed OutMessage = record relationId: SmallInt; relationIdNull: SmallInt; relationName: Array[0..93] of AnsiChar; == here is the change relationNameNull: SmallInt;

Re: [Firebird-devel] Commits visible in our main page.

2015-03-10 Thread Adriano dos Santos Fernandes
On 10/03/2015 10:03, Dmitry Yemanov wrote: 10.03.2015 15:56, Omacht András wrote: why do you need several working directory? Using git is very cheap to switch between branches, it is not necessary to make local copies. I don't see much sense to create a branch every time I have an idea to

Re: [Firebird-devel] Firebird 3 API demo usage with Pascal

2015-03-06 Thread Adriano dos Santos Fernandes
On 06/03/2015 07:05, liviuslivius wrote: Hi Adriano, please add {$IFNDEF FPC} QWord = type UInt64; {$ENDIF} in FbApi.pas Done. Thanks. About your I/O error, seems as a Delphi problem when WriteLn is used with GUI application. Are you building the project as GUI instead of

Re: [Firebird-devel] Firebird 3 API demo usage with Pascal

2015-03-06 Thread Adriano dos Santos Fernandes
On 06/03/2015 09:46, liviuslivius wrote: but any try to attachment := dispatcher.createDatabase or attachment := dispatcher.attachDatabase return me I/O error 105. Returns how? Is this printed in the FbException handling, after calling fb_interpret? Adriano

Re: [Firebird-devel] Firebird 3 API demo usage with Pascal

2015-03-06 Thread Adriano dos Santos Fernandes
On 06/03/2015 08:35, liviuslivius wrote: Hi Adriano, i try to run your example - i change code to Delphi after master := fb_get_master_interface(); i got version=12 and VTable version=2 status show me vTable version 3 Version=10 so far so good but any try to attachment :=

Re: [Firebird-devel] Firebird 3 API demo usage with Pascal

2015-03-06 Thread Adriano dos Santos Fernandes
On 06/03/2015 15:45, liviusliv...@poczta.onet.pl wrote: Hi Adriano, thanks i found this i change also PChar = type System.Pointer; Why?? and now i got problematic message :))) Your user name and password are not defined. Ask your database administrator to set up a Firebird login. how

Re: [Firebird-devel] Firebird 3 API demo usage with Pascal

2015-03-07 Thread Adriano dos Santos Fernandes
On 06-03-2015 16:23, liviusliv...@poczta.onet.pl wrote: do you mean Windows system vars? I try this without effects Did you reopen Delphi after the change? You can also use embedded, passing only the database filename in the connection string. It should not need a password. Adriano

Re: [Firebird-devel] Add some functions.

2015-03-13 Thread Adriano dos Santos Fernandes
On 13-03-2015 22:44, Hajime Nakagami wrote: Hi, I made patch to add some functions about standard division. https://github.com/FirebirdSQL/core/pull/2 Can someone merge this patch ? I'll review it. Adriano

Re: [Firebird-devel] Firebird 3 API demo usage with Pascal

2015-03-14 Thread Adriano dos Santos Fernandes
On 14-03-2015 06:56, liviusliv...@poczta.onet.pl wrote: few problems didive library file into two files (initialization is not allowed in library file itself - only in unit) change PChar to PAnsiChar and change 2 declarations of functions and implementation function open(status: Status;

Re: [Firebird-devel] Firebird 3 API demo usage with Pascal

2015-03-11 Thread Adriano dos Santos Fernandes
On 10/03/2015 19:11, liviusliv...@poczta.onet.pl wrote: as you can see - for utf8 record must contain NAZWAlen and array size must be multipy by 4 (UTF8) If you do not declare the message descriptors yourself, like in the example, you should construct the buffer types exactly based in the

Re: [Firebird-devel] Time to update our headers.

2015-03-05 Thread Adriano dos Santos Fernandes
On 05/03/2015 11:57, Leyne, Sean wrote: 05.03.2015 15:19, Leyne, Sean wrote: The fact that Inprise/Borland/embarcadero have not maintained the URL location is not our problem. What's the problem with broken IBPhoenix URL then?.. There is none with changing that -- the IDPL is a 'product'

Re: [Firebird-devel] Firebird 3 API demo usage with Pascal

2015-03-05 Thread Adriano dos Santos Fernandes
On 05/03/2015 12:37, Alex Peshkoff wrote: On 03/05/15 18:23, Adriano dos Santos Fernandes wrote: On 05/03/2015 11:53, Adriano dos Santos Fernandes wrote: The others things seems ok and easy to use. We need some new functions in the new API, for example, to convert status vectors to strings

Re: [Firebird-devel] Firebird 3 API demo usage with Pascal

2015-03-05 Thread Adriano dos Santos Fernandes
On 05/03/2015 11:53, Adriano dos Santos Fernandes wrote: The others things seems ok and easy to use. We need some new functions in the new API, for example, to convert status vectors to strings, but this is not specific to pascal. Also, we have a half new API. To much constants come from

[Firebird-devel] Firebird 3 API demo usage with Pascal

2015-03-05 Thread Adriano dos Santos Fernandes
Hi! I just build an example of Firebird 3 API usage with FreePascal. https://github.com/asfernandes/fbstuff/blob/db56fa93850a70c473362296df12a95c7494a7dc/src/pascal/FbApiTest.dpr As said early, working with input/output buffers directly in non-C/C++ is difficult. This requires auxiliary

Re: [Firebird-devel] Provider objects has different semantics than y-valve objects

2015-02-23 Thread Adriano dos Santos Fernandes
On 23/02/2015 07:36, Vlad Khorsun wrote: 22.02.2015 20:11, Adriano dos Santos Fernandes wrote: A solution must be to pass a parameter to destroy methods specifying if they should release or not the object. Must be ? I don't think so. I'm not ready to point to correct solution right now

Re: [Firebird-devel] Record level compresion imroovement

2015-02-23 Thread Adriano dos Santos Fernandes
On 23/02/2015 16:36, James Starkey wrote: Encode null as a value type and skip the null flags altogether -- saves a couple of bytes for every record. I'd encode the format version as the first value. That will let you have 2^63 format versions, which should be enough. I'd getvthe

Re: [Firebird-devel] Provider objects has different semantics than y-valve objects

2015-02-22 Thread Adriano dos Santos Fernandes
On 22-02-2015 14:51, Dimitry Sibiryakov wrote: 22.02.2015 18:35, Adriano dos Santos Fernandes wrote: So you have: IBlob* blob = ...-openBlob(...); blob-cancel(); // no leak Using of smart pointers here makes life even funnier. IMHO, it is Y-valve bug. But in absence of API

[Firebird-devel] Provider objects has different semantics than y-valve objects

2015-02-22 Thread Adriano dos Santos Fernandes
Hi! Lets call YBlob::cancel, YTransaction::commit, YTransaction::rollback, YEvents::cancel and maybe others as destroy methods. Destroy methods when called in y-valve objects automatically does a release on them. So you have: IBlob* blob = ...-openBlob(...); blob-cancel(); // no leak On the

Re: [Firebird-devel] Proposal of new feature: Event triggers

2015-02-26 Thread Adriano dos Santos Fernandes
On 26/02/2015 11:18, Carlos H. Cantu wrote: I'll give you a real example that could justify this need: In my ERP, I store some global configuration data in a config table. In several triggers, I need to keep reading this config table to get some values and use in IF's, etc. For batch

Re: [Firebird-devel] Proposal of new feature: Event triggers

2015-02-26 Thread Adriano dos Santos Fernandes
On 26/02/2015 10:29, Carlos H. Cantu wrote: I would like to start a discussion to propose the implementation of Event triggers (for the lack of a better name for now). Those special triggers would be associated to an EVENT, not to a TABLE. When the associated event is fired in any of the

Re: [Firebird-devel] Add some functions.

2015-03-27 Thread Adriano dos Santos Fernandes
On 27-03-2015 17:44, Simonov Denis wrote: Adriano dos Santos Fernandes adrian...@gmail.com wrote Tue, 17 Mar 2015 06:02:42 +0300: Found several errors in README.regr_functions.txt. 1. a small slip of the pen REGR_INTERCEPT (Y, X) = REGR_AVGY (Y, X) - REGR_SLOPE (Y, X) * REGR_AVG_X

Re: [Firebird-devel] Using of interfaces after last changes

2015-01-23 Thread Adriano dos Santos Fernandes
On 23/01/2015 14:16, Dimitry Sibiryakov wrote: 23.01.2015 17:15, Adriano dos Santos Fernandes wrote: Like it's used in Firebird code. Use CheckStatusWrapper, ThrowStatusWrapper or create your own specialization of IStatus like these classes does. How to do that? Should I define

Re: [Firebird-devel] Semantics of field [NOT] NULL flag based on domains

2015-04-01 Thread Adriano dos Santos Fernandes
On 31-03-2015 07:41, Alex Peshkoff wrote: I.e. we can not override NOT NULL constraint set in the domain. Changed. Thanks. Adriano -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored

Re: [Firebird-devel] Semantics of field [NOT] NULL flag based on domains

2015-04-02 Thread Adriano dos Santos Fernandes
On 02-04-2015 22:13, Claudio Valderrama C. wrote: -Original Message- From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com] Sent: Miércoles, 01 de Abril de 2015 22:29 On 31-03-2015 07:41, Alex Peshkoff wrote: I.e. we can not override NOT NULL constraint set in the domain

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-4750) SIMILAR TO: matching engine can fail for records that come from UNION ALL datasource

2015-04-13 Thread Adriano dos Santos Fernandes
On 13-04-2015 19:04, Leyne, Sean wrote: What happened to this case/issue? It doesn't exist in the tracker. Pavel Zotov asked to delete it. Adriano -- BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT

Re: [Firebird-devel] db trigger not firing

2015-04-20 Thread Adriano dos Santos Fernandes
On 20/04/2015 11:31, Adriano dos Santos Fernandes wrote: I will run the exe in Windows, and it has hardcoded localhost:. AFAIK Firebird server cannot (anymore?) redirect to another server via alias. But I can edit the exe changing localhost and adjusting my hosts file. :) Adriano

Re: [Firebird-devel] db trigger not firing

2015-04-20 Thread Adriano dos Santos Fernandes
On 20/04/2015 10:52, Dimitry Sibiryakov wrote: 20.04.2015 15:36, Adriano dos Santos Fernandes wrote: I do not have Delphi to recompile it, and I want to test the server in Linux. That's what aliases are for. It's not. Adriano

Re: [Firebird-devel] Fwd: SF.net SVN: firebird:[61378] firebird/trunk/src/jrd/scl.epp

2015-04-20 Thread Adriano dos Santos Fernandes
On 20/04/2015 14:25, Alex Peshkoff wrote: I understand that is a very good idea for one to associate their metadata with real objects with a foreign key to a system table, specially if this foreign key has update/delete cascade, hence not interrupting the engine from doing anything. Why

[Firebird-devel] Fwd: SF.net SVN: firebird:[61378] firebird/trunk/src/jrd/scl.epp

2015-04-20 Thread Adriano dos Santos Fernandes
Forwarded Message Subject:[Firebird-checkins] SF.net SVN: firebird:[61378] firebird/trunk/src/jrd/scl.epp Date: Mon, 20 Apr 2015 17:04:42 + From: alexpeshk...@users.sourceforge.net To: firebird-check...@lists.sourceforge.net Revision: 61378

[Firebird-devel] Visual Studio Code for Linux, Mac OSX, and Windows

2015-04-30 Thread Adriano dos Santos Fernandes
Not tried yet... https://code.visualstudio.com/ -- One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and

Re: [Firebird-devel] Visual Studio Code for Linux, Mac OSX, and Windows

2015-04-30 Thread Adriano dos Santos Fernandes
Looks like something very simple and completely out of focus for Firebird. Sorry... :D On 30/04/2015 11:25, Adriano dos Santos Fernandes wrote: Not tried yet... https://code.visualstudio.com/ -- One dashboard

Re: [Firebird-devel] Resolved: (CORE-4760) Can not create user with non-ascii (multi-byte) characters in it's name

2015-05-04 Thread Adriano dos Santos Fernandes
On 04/05/2015 08:04, Alex Peshkoff wrote: On 04/30/15 18:18, Adriano dos Santos Fernandes wrote: I think this change (and maybe before it too) is wrong. If one creates a User1, you should not create USER1. Nor úser2 should be ÚSER2. But ASCII users used to be case-insensitive from

Re: [Firebird-devel] Resolved: (CORE-4760) Can not create user with non-ascii (multi-byte) characters in it's name

2015-05-04 Thread Adriano dos Santos Fernandes
On 04/05/2015 08:54, Dimitry Sibiryakov wrote: 04.05.2015 13:39, Alex Peshkoff wrote: And now imagine how many scripts will fail if we require SYSDBA not sysdba Almost all of them, I guess. As I said... Roles in DPB are checked for double quotes. I hate it, but seems how user names could

Re: [Firebird-devel] Resolved: (CORE-4760) Can not create user with non-ascii (multi-byte) characters in it's name

2015-05-04 Thread Adriano dos Santos Fernandes
On 04/05/2015 11:22, Dimitry Sibiryakov wrote: 04.05.2015 16:14, Alex Peshkoff wrote: On 05/04/15 16:39, Dimitry Sibiryakov wrote: By the standard there are following cases: 1. An identifier contain letters [A-Z0-9_$]. 2. An identifier contain letters [a-z0-9_$]. 3. An identifier is

Re: [Firebird-devel] Resolved: (CORE-4760) Can not create user with non-ascii (multi-byte) characters in it's name

2015-04-30 Thread Adriano dos Santos Fernandes
I think this change (and maybe before it too) is wrong. If one creates a User1, you should not create USER1. Nor úser2 should be ÚSER2. User names should respect quoted identifier rules, when quoted. So only unquoted ASCII characters should be uppercased. There may be an exception, in DPB tags.

Re: [Firebird-devel] Correct way to deallocate event blocks?

2015-05-05 Thread Adriano dos Santos Fernandes
On 05/05/2015 09:24, Mark Rotteveel wrote: What is the correct way to deallocate/free/delete the event blocks allocated with isc_event_block? As far as I can tell these are never deallocated and the API also doesn't provide a way to deallocate them. What is the proper way?

Re: [Firebird-devel] Firebird 3 - Understandig result of isc_info_req_select_count

2015-05-06 Thread Adriano dos Santos Fernandes
On 06/05/2015 06:57, Mark Rotteveel wrote: On Wed, 06 May 2015 11:36:26 +0200, Gabor Boros gaborbo...@yahoo.com wrote: 2015.05.06. 10:59 keltezéssel, Dimitry Sibiryakov írta: Do fetch all records and then show its count. Fetch all slow down the application and the server. There is no way

Re: [Firebird-devel] Firebird 3 - Understandig result of isc_info_req_select_count

2015-05-06 Thread Adriano dos Santos Fernandes
On 06/05/2015 08:01, Dimitry Sibiryakov wrote: 06.05.2015 12:58, Adriano dos Santos Fernandes wrote: there is a way, if one controls the SQL command: select count(*) over (), x.* from x; Will it be faster (produce less load on server) than full fetch? Obviously, the select must be fully

Re: [Firebird-devel] Resolved: (CORE-4760) Can not create user with non-ascii (multi-byte) characters in it's name

2015-05-06 Thread Adriano dos Santos Fernandes
On 06/05/2015 07:10, p519446 wrote: IMO, it will be entirely not comfortable for any user to be forced always remember that his login -- if it contains non-ascii letters -- is case Sensitive. Generally, this user can has NO any knowledge about SQL standard and it's rules about identifiers,

Re: [Firebird-devel] Initialization of metadata cache

2015-04-08 Thread Adriano dos Santos Fernandes
On 08-04-2015 12:20, Dimitry Sibiryakov wrote: 08.04.2015 17:16, Adriano dos Santos Fernandes wrote: How do system queries will work without system tables in cache? They are precompiled with GPRE, aren't they? Internal requests do uses MET, just not use METD. Adriano

Re: [Firebird-devel] Initialization of metadata cache

2015-04-08 Thread Adriano dos Santos Fernandes
On 08-04-2015 12:13, Dimitry Sibiryakov wrote: Hello, All. Is there any reason (except performance one) for INI_init() to fill relations' cache from internal structures instead of database? Chicken and egg problem. How do system queries will work without system tables in cache?

Re: [Firebird-devel] db trigger not firing

2015-04-02 Thread Adriano dos Santos Fernandes
On 02-04-2015 14:15, Lauri Zoova wrote: I've had more time now and created a small test project to reproduce the issue without fail. If anyone is interested to take a look then let me know where to send it. Can you put it somewhere we can download? Adriano

Re: [Firebird-devel] METD's isSystemRelation()

2015-04-10 Thread Adriano dos Santos Fernandes
On 10-04-2015 18:02, Dimitry Sibiryakov wrote: 10.04.2015 18:55, Adriano dos Santos Fernandes wrote: Well, Firebird metadata handling is in many places brainless. Ok. Related question: flag REL_force_scan is checked in exactly one place, but is nowhere set. Is it incomplete

Re: [Firebird-devel] employee db build broken

2015-06-25 Thread Adriano dos Santos Fernandes
On 25/06/2015 06:51, Paul Reeves wrote: On Thursday 25 June 2015 10:56:24 Paul Reeves wrote: I'll do a 32-bit build and compare. OK, it doesn't look as if gpre is the problem. The employee.c generated is identical on 32 and 64-bit. So it must be related to the database that was created.

Re: [Firebird-devel] employee db build broken

2015-06-25 Thread Adriano dos Santos Fernandes
On 25/06/2015 08:29, Alex Peshkoff wrote: On 06/24/2015 07:59 PM, Adriano dos Santos Fernandes wrote: Crashs with clang ang gcc. I.e. it's not compiler issue. That's good. A sleep before the system call does not help, but manually calling the command does not produce problem. Sooner

Re: [Firebird-devel] Differences between triggers

2015-06-25 Thread Adriano dos Santos Fernandes
On 25/06/2015 12:38, Jiří Činčura wrote: Hi *, If I create insert or delete and delete or insert trigger these are stored differently in a system table. Is there really a difference? Just a way to store the order you passed. DDL triggers are stored different, using a fixed bit per trigger

Re: [Firebird-devel] employee db build broken

2015-06-24 Thread Adriano dos Santos Fernandes
On 24/06/2015 10:06, Alex Peshkoff wrote: which are transformed to this in empbuild.c isc_vtov ((char*) job_code, (char*) isc_36.isc_39, 21); isc_vtov ((char*) job_country, (char*) isc_36.isc_40, 61); Confirmed on linux. After my changes in GPRE, it creates buffers of different

Re: [Firebird-devel] employee db build broken

2015-06-24 Thread Adriano dos Santos Fernandes
On 24/06/2015 10:06, Alex Peshkoff wrote: Confirmed on linux. I can't confirm in Linux 64-bit. What I see constantly is this segfault: Segmentation fault Couldn't turn forced writes off I disabled the gfix call and embuild runs without errors. Adriano

Re: [Firebird-devel] Differences between triggers

2015-06-27 Thread Adriano dos Santos Fernandes
On 27-06-2015 04:19, Jiří Činčura wrote: Just a way to store the order you passed. I know it doesn't matter now, but is there a reason to store the order? Extract the metadata in the same way it was created, I guess. Adriano

Re: [Firebird-devel] employee db build broken

2015-06-24 Thread Adriano dos Santos Fernandes
On 24/06/2015 13:42, Paul Reeves wrote: No such luck for me :-( I just did a fresh checkout and the Win64 build still fails with the same errors I reported earlier. Please try to remove -r from gpre calls in make_examples.bat. Adriano

Re: [Firebird-devel] employee db build broken

2015-06-24 Thread Adriano dos Santos Fernandes
On 24/06/2015 12:05, Alex Peshkoff wrote: On 06/24/2015 05:56 PM, Adriano dos Santos Fernandes wrote: On 24/06/2015 10:06, Alex Peshkoff wrote: Confirmed on linux. I can't confirm in Linux 64-bit. I did not want to say that there is segfault. What I confirm is incorrect code in .c file

Re: [Firebird-devel] Regular Expression Library

2015-06-11 Thread Adriano dos Santos Fernandes
On 11/06/2015 05:26, Mark Rotteveel wrote: That doesn't work: SQL regex is an SQL abomination that doesn't look like normal (perl or posix) regular expressions. Surely it has not normal perl/posix syntax. BTW, as far as I know the postgresql similar to is SQL standard compliant, but they

Re: [Firebird-devel] Regular Expression Library

2015-06-11 Thread Adriano dos Santos Fernandes
On 11/06/2015 07:58, Vlad Khorsun wrote: 11.06.2015 13:44, Adriano dos Santos Fernandes wrote: On 11/06/2015 06:08, Dmitry Yemanov wrote: 10.06.2015 21:03, Adriano dos Santos Fernandes wrote: At a first look, boost.regex is the library who can do it. It's templatized and works with iterators

[Firebird-devel] Regular Expression Library

2015-06-10 Thread Adriano dos Santos Fernandes
Hi! When I created SIMILAR TO predicate, I research for libraries to do the real work and found no good alternative. PgSQL were using (AFAIR) Henry Spencer library, but its (PgSQL) SIMILAR TO were definitively non SQL standard. We needed a library to work with 1, 2 or 4 byte-length characters,

Re: [Firebird-devel] Brainstorming Secure Unattended Start w/ Encrypted Files

2015-08-24 Thread Adriano dos Santos Fernandes
On 24/08/2015 09:16, James Starkey wrote: No problem other than this requires that database account credentials be on the client disk and therefor theoretically available to an attacker. There is no way to make any of this easy. I think it's clear that when you mix: - A possible attacker has

Re: [Firebird-devel] Brainstorming Secure Unattended Start w/ Encrypted Files

2015-08-24 Thread Adriano dos Santos Fernandes
On 24/08/2015 10:24, James Starkey wrote: On Monday, August 24, 2015, Adriano dos Santos Fernandes adrian...@gmail.com mailto:adrian...@gmail.com wrote: On 24/08/2015 09:16, James Starkey wrote: No problem other than this requires that database account credentials

Re: [Firebird-devel] Brainstorming Secure Unattended Start w/ Encrypted Files

2015-08-24 Thread Adriano dos Santos Fernandes
On 24/08/2015 10:06, Scott Morgan wrote: It's not simply an either/or situation, there is a place and use for encryption as a deterrent in these cases, however technically flawed it may be. You'll never stop a determined thief, true, but you can at least deter the far more numerous casual

[Firebird-devel] System tables changes in read only databases

2015-07-30 Thread Adriano dos Santos Fernandes
Hi! I purposely put a MODIFY of system tables in epp file without considering dbb-readOnly() flag. And it worked (changed the database) and committed the change. Shouldn't that be prevent in lower layers? Then I chmod -w the database. Then it fails at commit time with: Statement failed,

Re: [Firebird-devel] FB3 maximum password length

2015-07-24 Thread Adriano dos Santos Fernandes
There should be no different thing than what we already had with file names. Otherwise, something is completely wrong. Adriano On 24/07/2015 05:10, Alex Peshkoff wrote: On 07/23/2015 05:09 PM, Dimitry Sibiryakov wrote: 23.07.2015 15:44, Alex Peshkoff wrote: This can be solved provided

Re: [Firebird-devel] FB3 maximum password length

2015-07-24 Thread Adriano dos Santos Fernandes
On 24/07/2015 11:54, Alex Peshkoff wrote: On 07/24/2015 03:14 PM, Adriano dos Santos Fernandes wrote: On 24/07/2015 09:11, Dimitry Sibiryakov wrote: 24.07.2015 13:53, Adriano dos Santos Fernandes wrote: We could safely assume that a sequence of ascii characters means the same thing in every

Re: [Firebird-devel] FB3 maximum password length

2015-07-24 Thread Adriano dos Santos Fernandes
On 24/07/2015 12:17, Dimitry Sibiryakov wrote: 24.07.2015 16:54, Alex Peshkoff wrote: Adriano, initially it was said that in passwords (to be precise - not only passwords, but also logins and filenames) from CONNECT command in ISQL we currently can use international characters, provided they

Re: [Firebird-devel] FB3 maximum password length

2015-07-24 Thread Adriano dos Santos Fernandes
On 24/07/2015 08:44, Alex Peshkoff wrote: On 07/24/2015 02:04 PM, Dimitry Sibiryakov wrote: 24.07.2015 12:59, Adriano dos Santos Fernandes wrote: There should be no different thing than what we already had with file names. Otherwise, something is completely wrong. One different thing

Re: [Firebird-devel] FB3 maximum password length

2015-07-24 Thread Adriano dos Santos Fernandes
On 24/07/2015 09:11, Dimitry Sibiryakov wrote: 24.07.2015 13:53, Adriano dos Santos Fernandes wrote: We could safely assume that a sequence of ascii characters means the same thing in every charset, as we do not use wide character sets. ASCII characters are not problem. National characters

Re: [Firebird-devel] code quality and strange comments

2015-07-15 Thread Adriano dos Santos Fernandes
And? Any of these comments are not compiling? Adriano On 15/07/2015 09:17, swobje...@outlook.com wrote: Iam fairly new to the codebase but i found allready some strange stuff in some source files. Is some of this allready reviewed and/or allready fixed? firebird/trunk L1165 file:

[Firebird-devel] Maximum length of string literals

2015-07-15 Thread Adriano dos Santos Fernandes
Hi! Looking again, Ivan Přenosil may be right and string literals up to 64K byte-length *may* be safe, as descriptors uses USHORT and internal calculations ULONG. At the same time, columns, parameters and everything else should be constrained to 32K. Currently, intermediate strings (say, a

Re: [Firebird-devel] Firebird 3 problem with inserting string to blob

2015-07-15 Thread Adriano dos Santos Fernandes
On 15/07/2015 11:48, Adriano dos Santos Fernandes wrote: On 15/07/2015 10:34, Ivan Přenosil wrote: From: Dmitry Yemanov ... In FB2, FB2.5, FB3-Beta1, FB3-31661 it was possible to directly insert 50k long text into blob field: However, in FB3-Beta2 and latest snapshot FB3-31925 it raises

Re: [Firebird-devel] Firebird 3 problem with inserting string to blob

2015-07-15 Thread Adriano dos Santos Fernandes
On 15/07/2015 10:34, Ivan Přenosil wrote: From: Dmitry Yemanov ... In FB2, FB2.5, FB3-Beta1, FB3-31661 it was possible to directly insert 50k long text into blob field: However, in FB3-Beta2 and latest snapshot FB3-31925 it raises error ... I'm afraid it could be a bug in prior versions

<    1   2   3   4   5   6   7   8   9   10   >