Dear Sirs,
Until recently I was using version 2.0 and now I use 2.5. I encountered a
problem that bothers me, is about the message when they enrolled in the
database when the condition is not met foreign key. In version 2.0 messages
contained the names of tables and foreign key, now in version
Hello,
Can we get an idea of the amount of memory being consumed by category,
for instance, the amount used to store the results of the sub-query,
the amount consumed by intermediate joint results, the amount used by
the sort, the amount used by the grouping and aggregation. The more
Until recently I was using version 2.0 and now I use 2.5. I encountered a
problem that bothers me, is about the message when they enrolled in the
database when the condition is not met foreign key. In version 2.0 messages
contained the names of tables and foreign key, now in version 2.5 I get
more info, the last few lines of -v output from gbak are:
gbak:activating and creating deferred index FK_APABSE_LASTMODBYID
gbak:activating and creating deferred index FK_APBASE_CREATORID
gbak:activating and creating deferred index FK_TBLACTIVEPOWER_TBLELEMENT
gbak:activating and
Thanks for the information . Seems when running select query [with variations
] for terabyte of data , somehow system memory consumption jumps to 8GB ..
Is it possible to suggest some equation like this ; For eg
select a,b,c from table ;
Row_memory_usage = Total_rows_in_the_table * row page
the commandline used is
gbak -V -CREATE 110831130601.fbk -user sysdba -pass genesis
/opt/unb/archive/tmp/110831130601.fdb
On 31 August 2011 11:45, Nick Upson n...@telensa.com wrote:
more info, the last few lines of -v output from gbak are:
gbak:activating and creating deferred index
Hi,
Is it possible to merge results of a recursive CTE with the results of a
non-recursive CTE?
I seems one can not have one executable block of SQL containing both.
Typically I use a non-recursive CTE to filter data for the main table,
referencing many lookup tables. However, two of the
--- In firebird-support@yahoogroups.com, Nols Smit wrote:
Hi,
Is it possible to merge results of a recursive CTE with the results of a
non-recursive CTE?
I seems one can not have one executable block of SQL containing both.
Typically I use a non-recursive CTE to filter data for the
I know the SQL below is somewhat silly, but ignoring that, why did it
give me this error:
Error executing query: Dynamic SQL Error
SQL error code = -204
Implementation limit exceeded
block size exceeds implementation restriction
The SQL is only about 7 kbyte and the or-list contains far fewer
Hi,
Not sure i understand you correctly, but... did you tried to create query
with more that one CTE ? :)
My Recursive CTE:
=
With Recursive lc as
(
Select ID from BD_Locality where ID = :ID_Root
Union all
Select ID from BD_Locality, lc where Parent_ID = lc.id
)
select
What is the maximum number of query parameters for Firebird? Has it
changed between 2.1 and 2.5 and will it change in 3.0?
Didn't find the answer using Google. Where is it documented?
Kjell
--
--
Kjell Rilbe
DataDIA AB
E-post: kj...@datadia.se
Telefon:
On Wed, Aug 31, 2011 at 9:19 AM, Kjell Rilbe kjell.ri...@datadia.se wrote:
I know the SQL below is somewhat silly, but ignoring that, why did it
give me this error:
Error executing query: Dynamic SQL Error
SQL error code = -204
Implementation limit exceeded
block size exceeds
Den 2011-08-31 15:49 skrev Kjell Rilbe såhär:
What is the maximum number of query parameters for Firebird? Has it
changed between 2.1 and 2.5 and will it change in 3.0?
A bit of testing: with a query testing for equality with a varchar
column it accepted up to 162 parameters.
But on the same
Den 2011-08-31 16:36 skrev Ann Harrison såhär:
On Wed, Aug 31, 2011 at 9:19 AM, Kjell Rilbe kjell.ri...@datadia.se
mailto:kjell.rilbe%40datadia.se wrote:
I know the SQL below is somewhat silly, but ignoring that, why did it
give me this error:
Error executing query: Dynamic SQL
--- In firebird-support@yahoogroups.com, Nols Smit wrote:
Now I wondered if it's possible to have one block of executable SQL?
It depends on what do you call as one block of executable SQL.
Regards,
Vlad
Hello Marius,
Can anyone advise what I should be trying, or why this is happening?
backup file is physically corrupted.
Is there any way that I could instruct GBAK to ignore the table it is
having
issues with?
Backup has linear format, so gbak cannot help here.
You need to create
Nick Upson wrote:
the commandline used is
gbak -V -CREATE 110831130601.fbk -user sysdba -pass genesis
/opt/unb/archive/tmp/110831130601.fdb
User/pass have no effect unless you give localhost: in front of
connection string. Try:
gbak -V -CREATE 110831130601.fbk -user sysdba -pass genesis
Thank you Alexey,
I will instruct my Client to execute another backup. Im making the
assumption then that this is not a Firebird issue but rather just the luck
of the draw when backing up the database?
Regards
Marius
Hello Marius,
Can anyone advise what I should be trying, or why this is
It depends on what do you call as one block of executable SQL.
For example, If I use IBExpert (I'm actually developing a Web application using
Delphi7 Intraweb from AtoZed Software) it will suits me if the SQL Editor
will be able to execute the block of SQL (containing a mixture of
Marius,
Such backup error can be indication of HDD or RAM problems.
Check RAM http://www.ib-aid.com/articles/item93
and run checkdsk/another utility to check HDDs.
Regards,
Alexey Kovyazin
IBSurgeon (www.ib-aid.com)
Thank you Alexey,
I will instruct my Client to execute another backup. I'm
20 matches
Mail list logo