[Firebird-devel] [FB-Tracker] Created: (CORE-4172) Creating external function (udf) to not existing dll - and then procedure with it - crash server

2013-08-06 Thread Karol Bieniaszewski (JIRA)
Creating external function (udf) to not existing dll - and then procedure with it - crash server Key: CORE-4172 URL: http://tracker.firebirdsql.org/browse/CORE-4172

[Firebird-devel] [FB-Tracker] Created: (CORE-4171) Provide new command in ISQL that show ALL the list of command that were previously entered

2013-08-06 Thread Pavel Zotov (JIRA)
Provide new command in ISQL that show ALL the list of command that were previously entered -- Key: CORE-4171 URL: http://tracker.firebirdsql.org/browse/CORE-4171

[Firebird-devel] [FB-Tracker] Created: (CORE-4170) Allow (add) ability to specify database cache in kb/mb/gb

2013-08-06 Thread kdv (JIRA)
Allow (add) ability to specify database cache in kb/mb/gb - Key: CORE-4170 URL: http://tracker.firebirdsql.org/browse/CORE-4170 Project: Firebird Core Issue Type: New Feature

[Firebird-devel] [FB-Tracker] Created: (CORE-4169) A.

2013-08-06 Thread kdv (JIRA)
A. -- Key: CORE-4169 URL: http://tracker.firebirdsql.org/browse/CORE-4169 Project: Firebird Core Issue Type: New Feature Reporter: kdv -- This message is automatically generated by JIRA. - If you think it was sent incorrectl

[Firebird-devel] [FB-Tracker] Created: (CORE-4168) Backup containing procedures or triggers that select from external tables cannot be restored with ExternalFileAccess=None

2013-08-06 Thread Dmitry Yemanov (JIRA)
Backup containing procedures or triggers that select from external tables cannot be restored with ExternalFileAccess=None - Key: CORE-4168 URL:

Re: [Firebird-devel] FB3.0 Restore process should not check external tables settings

2013-08-06 Thread Dmitry Yemanov
05.08.2013 17:57, liviuslivius wrote: > > Firebird 3.0 > i have database backup file (from "import" server) and now i need to > restore it on "production" server > On import server external tables access is set "Full" > on Production Server it is Set to "None" > then when i try to restore database

Re: [Firebird-devel] FB 3.0 Alpha 1 - Initialize security database - Reference to quick start guide

2013-08-06 Thread Thomas Steinmaurer
> On 08/05/13 22:13, Thomas Steinmaurer wrote: >> Hello, >> >> upon first usage/connect, the user is prompted with an "-Install >> incomplete, please read chapter "Initializing security database" in >> Quick Start Guide" message. >> >> Obviously there is no QSG (or I haven't found it), so that's a

Re: [Firebird-devel] Type BOOLEAN in FB3

2013-08-06 Thread Adriano dos Santos Fernandes
On 05/08/2013 05:17, Dmitry Yemanov wrote: > 04.08.2013 16:47, Simonov Denis wrote: >> select 1 >> from rdb$database >> where true is true >> >> >> Work is correct >> >> select 1 >> from rdb$database >> where (1=1) and true >> >> >> Work is correct >> >> select 1 >> from rdb$database >> where

[Firebird-devel] [FB-Tracker] Created: (CORE-4167) Allow an alternate symbol redirects the flow to create a remote backup

2013-08-06 Thread Simonov Denis (JIRA)
Allow an alternate symbol redirects the flow to create a remote backup -- Key: CORE-4167 URL: http://tracker.firebirdsql.org/browse/CORE-4167 Project: Firebird Core Issue Ty

Re: [Firebird-devel] MON$ATTACHMENTS - MON$ATTACHMENT_NAME VARCHAR(85) FB3.0 vs VARCHAR(255) FB2.5?

2013-08-06 Thread liviuslivius
Hi,   this is problem with flamerobin - it show wrong info for Firebird3.0   MON$ATTACHMENT_NAME is as RDB$FILE_NAME2 which is declared as VARCHAR(255) UNICODE_FSS as in previous FB2.5     regards, Karol Bieniaszewski   W dniu 2013-08-06 14:06:40 użytkownik liviuslivius napisał: Hi,   i see that

[Firebird-devel] MON$ATTACHMENTS - MON$ATTACHMENT_NAME VARCHAR(85) FB3.0 vs VARCHAR(255) FB2.5?

2013-08-06 Thread liviuslivius
Hi,   i see that MON$ATTACHMENT_NAME size was changed from VARCHAR(255) FB2.5 to VARCHAR(85) FB3.0? I have localization of db with longer path but this work when i do select from   C:\DOCUMENTS AND SETTINGS\XPMUSER\PULPIT\KBSQLSTAT\FIREBIRD\NOWY FOLDER\NOWY FOLDER\NOWY FOLDER\RIDO.FDB <- 105 char

Re: [Firebird-devel] FB 3.0 Alpha 1 - Initialize security database - Reference to quick start guide

2013-08-06 Thread liviuslivius
W dniu 2013-08-06 08:47:03 użytkownik Alex Peshkoff napisał: > On 08/05/13 22:13, Thomas Steinmaurer wrote: > > Hello, > > > > upon first usage/connect, the user is prompted with an "-Install > > incomplete, please read chapter "Initializing security database" in > > Quick Start Guide" message.

Re: [Firebird-devel] FB3.0 Restore process should not check external tables settings

2013-08-06 Thread Alex Peshkoff
On 08/05/13 17:57, liviuslivius wrote: > Hi, > > Firebird 3.0 > i have database backup file (from "import" server) and now i need to restore > it on "production" server > On import server external tables access is set "Full" > on Production Server it is Set to "None" > > then when i try to r

Re: [Firebird-devel] Speed comparision on some query FB2.5 vs FB3.0 - totally different plans

2013-08-06 Thread Dmitry Yemanov
06.08.2013 11:04, liviuslivius wrote: > > if you need more info, please ask me Can you provide the sample database? Dmitry -- Get your SQL database under version control now! Version control is standard for applicatio

Re: [Firebird-devel] Firebird 3.0 driver development

2013-08-06 Thread Reinier Olislagers
On 06/08/2013 09:13, Alex Peshkoff wrote: > On 08/06/13 10:08, Reinier Olislagers wrote: >> 1. Does it make sense to start rewriting drivers against the new (C) API >> or are there still major changes possible/likely before release > > Major hopefully not, some - definitely. > Sooner of all fbclie

Re: [Firebird-devel] Firebird 3.0 driver development

2013-08-06 Thread Alex Peshkoff
On 08/06/13 10:08, Reinier Olislagers wrote: > Hi *, > > I help maintain the database subsystem for the FPC FreePascal compiler. > > With the release of 3.0 alpha, I was wondering: > 0. Firebird 3 has a 2.x compatibility mode - but you won't use the new > network protocol if you use that, and the c

[Firebird-devel] Speed comparision on some query FB2.5 vs FB3.0 - totally different plans

2013-08-06 Thread liviuslivius
Hi,   i have some automatic test which i run on FB3.0 and not pass test boundaries i test here if new version of FB eliminates unnescessary call to unrelated subqueries  query is like this    SELECT * FROM PLAYERS P INNER JOIN P_NAMES PN ON PN.ID=P.ID     LEFT JOIN PLAYERS P_OLD ON P_OLD.ID=P.ID A