Re: [Firebird-devel] Database UUID

2015-11-19 Thread Dimitry Sibiryakov
18.11.2015 22:32, Dmitry Yemanov wrote:
>> >as long as UUID and Crypt Database ID are understood to be separate values
> Here I completely agree.

   Ok, I, actually, don't care which one my plugin will get. All I need is 
something for 
key holder to make decision which key it must return. Including cases when 
different 
databases on one server are encrypted with the same plugin but different keys 
and vice versa.

-- 
   WBR, SD.

--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] [FB-Tracker] Created: (CORE-5024) Provide better information for "Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause)"

2015-11-19 Thread Karol Bieniaszewski (JIRA)
Provide better information for "Invalid expression in the select list (not 
contained in either an aggregate function or the GROUP BY clause)"
-

 Key: CORE-5024
 URL: http://tracker.firebirdsql.org/browse/CORE-5024
 Project: Firebird Core
  Issue Type: Improvement
  Components: Engine
Reporter: Karol Bieniaszewski
Priority: Minor


Invalid expression in the select list (not contained in either an aggregate 
function or the GROUP BY clause)

Will be good to see what expression cause this error
Now we must analyze query and look what is wrong - what is used but not 
contained in group by





-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] [FB-Tracker] Created: (CORE-5023) Provide better message for - Adding Not null field without default - error "This operation is not defined for system tables"

2015-11-19 Thread Karol Bieniaszewski (JIRA)
Provide better message for - Adding Not null field without default - error 
"This operation is not defined for system tables"


 Key: CORE-5023
 URL: http://tracker.firebirdsql.org/browse/CORE-5023
 Project: Firebird Core
  Issue Type: Improvement
Reporter: Karol Bieniaszewski


Now when we try to add new NOT NULL field to table 
and when we do not specify default we got error 
Please add more informative error message

*** IBPP::SQLException ***
Context: Transaction::Commit

SQL Message : -607
This operation is not defined for system tables.

Engine Code: 335544351
Engine Message :
unsuccessful metadata update
unknown ISC error 335544989



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


Re: [Firebird-devel] Several connections to encrypted database in SS mode

2015-11-19 Thread Dimitry Sibiryakov
18.11.2015 19:31, Alex Peshkoff wrote:
>> >I think we need to step back and decide what the real problem is trying to 
>> >be solved!!!
> Yes.

   In this case the "real problem" is a ticket in tracker with feature request.

-- 
   WBR, SD.

--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] Database encryption

2015-11-19 Thread Dimitry Sibiryakov
   Hello, All.

   I've finished some modifications in database encryption system:

   Crypt plugin interface was made simpler.
   Database id generated at creation time is provided to it.
   Key holder interface was made simpler.
   Management of key holders was moved to Y-valve that enabled using of 
client-side key 
holders.
   Default key holder allows to use application-defined key callback out-of-box.

   You can get binaries for Windows 32 for testing and patch from
http://www.ibphoenix.com/ibpr_devel/
   Example of crypt plugin and key holder are included. For test purposes isql 
also sets 
up key callback and show you when the key is requested.

   Most likely I forgot something, comments are invited.

-- 
   WBR, SD.

PS: No, I don't want to force you to apply these changes to Firebird and I 
won't commit 
them without request.

--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel