Hello,
Your query uses index, which is correct (it contains unique values).
Try to run this query on partially restored database.
Regards,
Alexey Kovyazin
IBSurgeon (www.ib-aid.com)
Hi,
We use Firebird 2.5.1 on Linux 64 bit
Firebird fails to restore because of a unique constraint( see
Your query needs an aggregate field. Count.
Alan
On Oct 24, 2012 1:49 PM, sir_wally_lewis rgilland1...@gmail.com wrote:
Hi,
We use Firebird 2.5.1 on Linux 64 bit
Firebird fails to restore because of a unique constraint( see below ).
However when interrogating the data, no duplicate is
Hi!
Cannot connect to server under heavy load.
I get connection rejected by remote interface (335544421).
Is this a bug, ot there is an option in firebird.conft to avoid this?
Firebird.log (FB20 Classic Server)
L3S-4 Wed Oct 24 14:04:28 2012
I/O error for file C:\PROGRAM
On Wed, 24 Oct 2012 12:18:01 -, ma_golyo ma_go...@yahoo.com wrote:
Hi!
Cannot connect to server under heavy load.
I get connection rejected by remote interface (335544421).
Is this a bug, ot there is an option in firebird.conft to avoid this?
Firebird.log (FB20 Classic Server)
Hi!
2.0.7.13318
--- In firebird-support@yahoogroups.com, Mark Rotteveel mark@... wrote:
On Wed, 24 Oct 2012 12:18:01 -, ma_golyo ma_golyo@... wrote:
Hi!
Cannot connect to server under heavy load.
I get connection rejected by remote interface (335544421).
Is this a bug, ot
Sometimes I get Unable to complete network request to host l3s-4
(335544721) error not 335544421. In this case nothing apperars in firebird.log.
--- In firebird-support@yahoogroups.com, ma_golyo ma_golyo@... wrote:
Hi!
Cannot connect to server under heavy load.
I get connection rejected
Now I get cannot attach to password database (335544653) error.
Same log as first time.
--- In firebird-support@yahoogroups.com, ma_golyo ma_golyo@... wrote:
Hi!
Cannot connect to server under heavy load.
I get connection rejected by remote interface (335544421).
Is this a bug, ot there
I'm modifying a foreign key from one column to two.
I dropped the original foreign key from the child table, populated the
new columns, and then created the new key.
I forgot to populate the new column in the child table, so all the
relationships looked like this:
ChildParent
-
Another strange fact :
Running 1 application with 250 thread where each thread connects to 2 database
and runs 2 select works perfectly, BUT
Running 50 application with 5 thread where each thread connects to 2 database
and runs 2 select throw errors mentioned eralier.
--- In
Cannot connect to server under heavy load.
I get connection rejected by remote interface (335544421).
Is this a bug, ot there is an option in firebird.conft to avoid this?
Firebird.log (FB20 Classic Server)
L3S-4 Wed Oct 24 14:04:28 2012
I/O error for file C:\PROGRAM
The following simple query produces the results below:
SELECT SCHEDULE.DATE_TIME, TEAMS.TEAM FROM SCHEDULE
LEFT JOIN TEAMS ON SCHEDULE.HOME_TEAMID=TEAMS.PRIMARYKEY
***QUERY RESULTS (Showing 'Home Team' Column)***
12/01/2012 TeamA
12/21/2012 TeamB
12/25/2012 TeamC
How do I include the
The following simple query produces the results below:
SELECT SCHEDULE.DATE_TIME, TEAMS.TEAM FROM SCHEDULE LEFT JOIN
TEAMS ON SCHEDULE.HOME_TEAMID=TEAMS.PRIMARYKEY
***QUERY RESULTS (Showing 'Home Team' Column)***
12/01/2012 TeamA
12/21/2012 TeamB
12/25/2012 TeamC
How do I include
Try using aliases:
SELECT
SCHEDULE.DATE_TIME,
HOME_TEAM.TEAM as HomeTeamName,
AWAY_TEAM.TEAM as AwayTeamName
FROM
SCHEDULE
LEFT JOIN TEAMS HOME_TEAM ON SCHEDULE.HOME_TEAMID=HOME_TEAM.PRIMARYKEY
LEFT JOIN TEAMS AWAY_TEAM ON SCHEDULE.AWAY_TEAMID=AWAY_TEAM.PRIMARYKEY
On Wed, Oct 24,
--- In firebird-support@yahoogroups.com, Leyne, Sean Sean@... wrote:
Use tables aliases to include multiple references to a single table.
SELECT
SCHEDULE.DATE_TIME, HomeTeam.TEAM, AwayTeam.Team
FROM SCHEDULE
LEFT JOIN TEAMS HomeTeam ON HomeTeam.PRIMARYKEY = SCHEDULE.HOME_TEAMID
Hi All
I have query which extract the sales per day from a table
Select EXTRACT(YEAR from DT) as YEARNO, EXTRACT(YEARDAY from DT) AS DAYNO,
SUM(DUE) from CLIENT_INVOICES group by YEARNO, WEEKNO.
It works 100%, but only returns the dates with sales, I need it to also include
the dates with
I have query which extract the sales per day from a table
Select EXTRACT(YEAR from DT) as YEARNO, EXTRACT(YEARDAY from DT) AS
DAYNO, SUM(DUE) from CLIENT_INVOICES group by YEARNO, WEEKNO.
It works 100%, but only returns the dates with sales, I need it to also
include
the dates with
try something like this:
with recursive
Datas (Data) as
(select
Cast('2009-01-01' as Date)
From
rdb$database
union all
Select
Data + 1
From
Datas
Where
Data + 1 = Cast('2009-01-31' as Date))
select
But this won't return rows for dates where there is no record in the source
table.
On Wed, Oct 24, 2012 at 6:02 PM, Leyne, Sean s...@broadviewsoftware.comwrote:
**
I have query which extract the sales per day from a table
Select EXTRACT(YEAR from DT) as YEARNO, EXTRACT(YEARDAY from DT)
On 10/24/12 5:54 PM, cornievs wrote:
I have query which extract the sales per day from a table
Select EXTRACT(YEAR from DT) as YEARNO, EXTRACT(YEARDAY from DT) AS DAYNO,
SUM(DUE) from CLIENT_INVOICES group by YEARNO, WEEKNO.
It works 100%, but only returns the dates with sales, I need it to
Em 24/10/2012 20:21, Doug Chamberlin escreveu:
On 10/24/12 5:54 PM, cornievs wrote:
I have query which extract the sales per day from a table
Select EXTRACT(YEAR from DT) as YEARNO, EXTRACT(YEARDAY from DT) AS DAYNO,
SUM(DUE) from CLIENT_INVOICES group by YEARNO, WEEKNO.
It works 100%, but
On Wed, Oct 24, 2012 at 4:34 PM, Jeff jeff_j_dun...@yahoo.com wrote:
Use tables aliases to include multiple references to a single table.
SELECT
SCHEDULE.DATE_TIME, HomeTeam.TEAM, AwayTeam.Team
FROM SCHEDULE
LEFT JOIN TEAMS HomeTeam ON HomeTeam.PRIMARYKEY = SCHEDULE.HOME_TEAMID
On 10/24/12 6:25 PM, Alexandre Benson Smith wrote:
Em 24/10/2012 20:21, Doug Chamberlin escreveu:
On 10/24/12 5:54 PM, cornievs wrote:
I have query which extract the sales per day from a table
Select EXTRACT(YEAR from DT) as YEARNO, EXTRACT(YEARDAY from DT) AS DAYNO,
SUM(DUE) from
Em 24/10/2012 20:37, Doug Chamberlin escreveu:
On 10/24/12 6:25 PM, Alexandre Benson Smith wrote:
Em 24/10/2012 20:21, Doug Chamberlin escreveu:
On 10/24/12 5:54 PM, cornievs wrote:
I have query which extract the sales per day from a table
Select EXTRACT(YEAR from DT) as YEARNO,
I have query which extract the sales per day from a table
Select EXTRACT(YEAR from DT) as YEARNO, EXTRACT(YEARDAY from DT)
AS DAYNO, SUM(DUE) from CLIENT_INVOICES group by YEARNO, WEEKNO.
It works 100%, but only returns the dates with sales, I need it to
also include the dates with
24 matches
Mail list logo