Stack Exchange sites like Super User are not actually forums, it is
purely Question & Answer. It is not a place for discussion, which makes
it a lot less suitable for troubleshooting.
Also, Super User is the wrong place, you should have asked on
https://dba.stackexchange.com/ or maybe https://stackoverflow.com/
Mark
--
Mark Rotteveel
www.firebirdfaq.org/faq167/
If it still doesn't work, we need more information, like the full DDL,
the query and the execution plan in both situations.
Mark
--
Mark Rotteveel
to parse it, or how to get it?
Mark
--
Mark Rotteveel
elase of Firebird?
AFAIK, this can happen if you changed the definition of a column to be
wider, but did not recompile the triggers or stored procedures. Those
are still using the older, smaller size and then break when confronted
with a value that is wider.
Mark
--
Mark Rotteveel
o such support.
Mark
--
Mark Rotteveel
On 2018-02-14 18:59, Omacht András aoma...@mve.hu [firebird-support]
wrote:
> Hi!
>
> Select gen_id(generator_name, 1)) as new_id from rdb$database
You should not do this with the generator of an identity column. The
system sequence to back the identity column is an implementation detail,
and
On 2018-02-14 18:32, Elton Fadel galdari...@yahoo.com.br
[firebird-support] wrote:
> I don't know why identity is better then the old method, but if we
> can't have access to the next number, this can be useless in some
> cases.
> How to get it like we did on FB 2.5 with a procedure to get the nex
Your problem has nothing to do with CTEs, you are combining implicit
(SQL-89) joins and explicit (SQL-92) joins, and referencing the
implicitly joined table from the explicitly joined tables. The rules for
these have changed in Firebird 3 to be compliant with the SQL
specification and to avoid
te a ticket on tracker.firebirdsql.org.
Make sure you aren't running in limitations of IBExpert itself, say for
example maybe it only shows the first 32K of a field, and your first
blob is 32K. Make sure to verify in a different tool (eg isql, FlameRobin).
Mark
--
Mark Rotteveel
re, that is simply not possible. UDFs (and the new
Firebird 3 PSQL functions) must explicitly declare their type, while
built-ins have access to additional type information at execution time.
Mark
--
Mark Rotteveel
the same folder as fbclient.dll, and even with connection parameters.
In other words: AuthServer configures which authentication options the
local server accepts, and AuthClient configures which authentication
option the local client tries.
I can't help you with your other questions.
Mark
--
Mark Rotteveel
ng up.
I'd so much prefer if Firebird simply does away with this monstrosity
and use TLS instead...
Mark
--
Mark Rotteveel
On 2018-01-26 19:51, Helen Borrie hele...@iinet.net.au
[firebird-support] wrote:
>> I am not familiar with the details of the SQL standard, is this the
>> proper was to round and calculate numeric values in SQL?
>
> You really do need to familiarise yourself with the way SQL handles
> numbers,
On 2018-01-26 16:17, Salim Naufal s.nau...@softnet.me [firebird-support]
wrote:
> I have noticed the following inconsistencies in Firebird 3.02:
>
> Try performing the following calculations:
>
> SELECT (1 - (1/1.11)) FROM RDB$DATABASEresult is rounded and
> yields 0.10 (rounded result)
Whi
On 2018-01-18 19:25, tiberiu_horv...@yahoo.com [firebird-support] wrote:
> Firebird 3, Delphi IBX.
>
> Somehow one of my customers inserted a product code so that at the end
> of the string he added chr(9) and stored this string in the database.
A ASCII_CHAR(9) is a perfectly valid character (hor
On 2018-01-16 09:52, Rustam rusta...@ukr.net [firebird-support] wrote:
> I think better way is to control input on client.
> If this is impossible you can try "spike": write selectable stored
> procedure with exception handler "when any do ..."
Or use a Firebird 3 Function.
Mark
ode and the exception stacktraces).
Mark
PS I hope you are aware that Firebird 2.0 is no longer supported, and
that 2.0.3 is not the latest version of Firebird 2.0 (that is 2.0.7).
--
Mark Rotteveel
o - for example - just setup.exe.
However, Firebird 1.5.6 was released 9 years ago and is no longer
supported, it has known security vulnerabilities and bugs. It is high
time that you upgrade.
Mark
--
Mark Rotteveel
On 11-1-2018 14:24, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
> On 11-1-2018 13:21, jonatan.laurit...@yahoo.dk [firebird-support] wrote:
>> I checked the system again - we use 3.0.2 indeed.
>>
>> There is no particular reason why we use -mend. We use it
t;
This causes the corruptions in data records to be ignored. While this
sounds like a good thing, it is not. Subsequent database actions (such
as taking a backup) will not include the corrupted records, **leading to
data loss**.
"""
Mark
--
Mark Rotteveel
suggestion would be to update to 3.0.2, which was released in
March last year. It fixes a security vulnerability, several hangs,
server crashes and some performance issues.
But you really should describe why you have used gfix -mend.
Mark
--
Mark Rotteveel
in Firebird there should be something equivalent.
Not yet.
--
Mark Rotteveel
UTE SATEMENT.
Please don't take advice for a specific situation as a blanket advice
that applies everywhere. My advice for your previous question was for
that specific code as shown in that question: you were dynamically
constructing a query in a way that was unnecessary for that specific
query as the query wasn't actually dynamic.
Mark
--
Mark Rotteveel
On 6-1-2018 14:30, m_brahi...@yahoo.fr [firebird-support] wrote:
> Selecting fields of stored procedure build with FOR SELECT from a
> delphi app with where clause is not bad a a method ? Thanks
I think you need to illustrate this with a small example.
Mark
--
Mark Rotteveel
It works, but you should not be using execute statemen. Using for select
should work just fine.
In your case, execute statement only adds overhead and removes compile
time syntax checking and makes it easier to make mistakes and harder to
spot them.
Changing this to use for select would simplify your code, as you would
not be dealing with string concatenation, and you get a compile time
syntax check in return.
Mark
--
Mark Rotteveel
sn't work, because that is just an empty string. You'd need ||'''';,
as '' is how you escape a single quote in a string literal.
But as I answered elsewhere, this isn't the right solution for your problem.
Mark
--
Mark Rotteveel
On 5-1-2018 13:37, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
> Your immediate problems is caused by missing quotes around the date
> values though.
Specifically, it would need to be:
V1=:V1 || ' WHERE CF.DATE_COMMANDE'||' BETWEEN '''
is caused by missing quotes around the date
values though.
Mark
--
Mark Rotteveel
> SUM(DC.CARICO - DC.SCARICO) as ESISTENZA,
> SUM(DC.IMPEGNATI) as Impegnati,
> SUM(DC.ORDINATI) as Ordinati
> FROM
> DOC_CORPO DC, DOC_TESTA DT
> WHERE
> DC.DOC_TESTA_ID = DT.ID
> AND DC.ARTICOLO_ID = :ID
> AND DT.DATA >= :DaData
> AND DT.DATA <= :AData
> GROUP BY
> DT.DEPOSITO_ID
> )
>
> How I can modify it?
>
> Thanks.
>
--
Mark Rotteveel
swers will be helpful to fill the void of
documentation/examples.
Mark
--
Mark Rotteveel
exist. Coalesce is for replacing null
values with an alternative value.
Mark
--
Mark Rotteveel
ic, SuperServer, or SuperClassic?
What client do you use (name + full version)?
--
Mark Rotteveel
expected to be released
soon). As far as I can tell, your is not a known (or fixed) bug, but you
might want to try it anyway.
You might also want to check your database with gfix, see
https://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gfix-dbverify.html
Mark
--
Mark Rotteveel
On 22-12-2017 13:10, Nico Speleers nico.spele...@carfac.com
[firebird-support] wrote:
> We are using Firebird 3.0.
What is the full version (eg 3.0.2.32703)?
--
Mark Rotteveel
arize your
question or problem, it will help getting better attention to your
questions.
Mark
--
Mark Rotteveel
ul execution caused by a system error that
> precludes successful execution of subsequent statements.
Which version of Firebird are you using (specify the full version, please).
Mark
--
Mark Rotteveel
peg into a round hole here?
Install Firebird 2.5.7, which will install just fine on Windows 2012R2
(I even spun up a VM to test it).
Mark
--
Mark Rotteveel
On 21-12-2017 08:49, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
> On 21-12-2017 03:06, FSPAPA INCA Team i...@foodstuffs-si.co.nz
> [firebird-support] wrote:
>> I reckon this change to src/remote/server/server.cpp in commit
>> 2fdb281759299f24d47349246f3c800ec
2012. Is there a solution?
What is the exact error message, and which Firebird 2.5 version are you
trying to install?
Mark
--
Mark Rotteveel
com]
> *Sent:* Wednesday, 20 December 2017 10:40 PM
> *To:* firebird-support@yahoogroups.com
> *Subject:* Re: [firebird-support] Firebird 3.0.3 no longer compatible
> with InterBase 7.5.1 clients
>
> On 19-12-2017 21:06, Dimitry Sibiryakov s...@ibphoenix.com
> [firebird-suppor
On 2017-12-20 19:38, 'Zoran' zoran...@gmail.com [firebird-support]
wrote:
> Hello Helen
>
> I understand that we shouldn't mess up with IDENTITY column, as you
> said. I have the same problem as original poster and I'm using this
> code
>
> SELECT G.RDB$GENERATOR_NAME
>
> FROM RDB$RELATION_FIEL
lient is not recognising it and waits forever
>
> So, you, actually, should ask Embarcadero why their client cannot work
> with Firebird
> anymore.
Not necessarily, it could also mean that 3.0.3 has a change that breaks
protocol version 10.
--
Mark Rotteveel
pdating a server to
> Firebird 3.0.3, InterBase 7.5.1 clients (including isql) hang when
> executing a simple SELECT query.
Firebird 3.0.3 has not been released yet. Which build are you having
problems with, and did you try a newer build?
Mark
--
Mark Rotteveel
On 2017-12-19 16:34, Nico Speleers nico.spele...@carfac.com
[firebird-support] wrote:
> Hi,
>
> Ex.
> CREATE TABLE ADDRESSES (
> IDINTEGER GENERATED BY DEFAULT AS IDENTITY
> NOT NULL,
[..]
> /* Keys */
> CONSTRAINT PK_ADDRESSES
> PRIMARY KEY (ID),
> /* Foreign
On 2017-12-08 12:01, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 08.12.2017 11:56, Mark Rotteveel m...@lawinegevaar.nl
> [firebird-support] wrote:
>> I don't agree with this. The string literal is in the connection
>> character set, but the value sho
On 2017-12-07 19:06, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 07.12.2017 18:46, Gabor Boros mlngl...@bgss.hu [firebird-support]
> wrote:
>> Why does the connection charset count?
>
>Because you are sending queries in connection charset. And string
> literals in them
On 2017-12-06 13:14, OB1 oldbasf...@googlemail.com [firebird-support]
wrote:
> We're making the jump from v1.56 to v3.0.2 (gulp!) and to make the
> transition easier for our clients we wondered if v3 client libs
> (fbclient.dll) can access 1.56 servers. We've tested this and it
> appears to work,
On 2017-11-28 00:06, Justis Root justis.r...@gmail.com
[firebird-support] wrote:
> Thank you for your responses,
>
> I’m running firebird 3.0; I’m not sure what version of firebird
> the database files were generated with.
> I’m using the JDBC driver to connect from InfoCaptor.
>
> When using th
github.com/FirebirdSQL/firebird
If you need more information about the sources, then please direct your
question to the Firebird development mailing list (firebird-devel).
Mark
--
Mark Rotteveel
On 2017-11-16 12:01, antoedinchar...@gmail.com [firebird-support] wrote:
> have you tried altering rdb$indices ?
That is something that will no longer work with Firebird 3.
Mark
On 14-11-2017 10:31, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
> On 14-11-2017 00:00, palevi pablo.l...@horus.es [firebird-support] wrote:
>> In firebird 2.x you can specify some parameters when creating a
>> database, i.e.:
>>
>> create
30-compat-sql.html#rnfb30-compat-username-namelength
)
Mark
PS The above create database statement would fail under Firebird 2.5 and
earlier with a "Token unknown SYSDBA" as it would need to be enclosed in
single (or double) quotes just like the database name and password.
--
Mark Rotteveel
ed or
> what I am misunderstanding.
It works exactly the same under Firebird 2.5. Maybe you are thinking of
a case where the view is created by a user without rights on tab_a?
Mark
--
Mark Rotteveel
gnoring some
implementation details), while your proposed primary key is 7 times
bigger, thus it has more overhead, and thus lower performance.
Reindexing manually (whatever that means) won't help you, because that
factor 7 difference in size remains.
Mark
--
Mark Rotteveel
of 7 * 4 bytes = 28 bytes (+ maybe some bytes overhead, I
keep forgetting implementation details like that). The decrease in
performance is probably not excessive, but if the decrease in
performance is acceptable or not is up to you.
Mark
--
Mark Rotteveel
l happening in 2.5.6 for me.
Version 2.5.7 also fixed a number of server hangs / slow downs.
Mark
--
Mark Rotteveel
eased
since 2.5.2 (which was released 4.5 years (!) ago in 2013).
As far as I know, Firebird 2.5.7 works fine on Windows Server 2016.
Mark
--
Mark Rotteveel
received updates (including security fixes) since December 2014. Using
that version for a program you are developing now is doing yourself and
your users a disservice IMHO.
You should be targeting Firebird 3 (maybe 2.5).
Mark
--
Mark Rotteveel
On 2017-10-19 09:54, Helen Borrie hele...@iinet.net.au
[firebird-support] wrote:
>> But I still can't connect. I also tested with DBerver but have the
>> same problem. I downloaded and installed the java driver to version
>> 3.0.2. But still no success at all. I have no idea what t o do.
>> A
On 2017-09-28 16:40, 'Daniel Miller' dmil...@amfes.com
[firebird-support] wrote:
> But that doesn't make sense. Right from the docs you quoted - "If
> ordering is important,
It is no guarantee as documented: "The ordering of the list values is
**undefined**—the order in which the strings are con
On 2017-09-28 10:49, 'Daniel Miller' dmil...@amfes.com
[firebird-support] wrote:
> It's certainly possible my database is corrupted - I don't think it
> is. But I'm willing to test if someone tells me how. However...
>
> At the moment, after several painful hours, I think I've determined
> the
ot found
>
> Engine Code : 335544351
> Engine Message :
> unsuccessful metadata update
> CREATE SEQUENCE RDB$GEN_REPLICADOR failed
> unknown ISC error 336068862
>
> How I can create that generator?
You might want to copy firebird.msg into c:\Windows\system32. The error
is "Sequence already exists"
--
Mark Rotteveel
On 2017-09-12 10:15, Magnus Johansson mag...@nimajo.se
[firebird-support] wrote:
> Hi All,
>
> Perhaps my previous post about collation problem was too long so that
> nobody cared to read it through, so let me start with a simpler
> question.
>
> I need unicode collation for Swedish and therefor
uld read 16 and 34 digits precision. I had called this out in my
initial review, but not clear enough.
Mark
--
Mark Rotteveel
cause the
network doesn't route it, or because a firewall 'blackholes' the port.
Mark
--
Mark Rotteveel
raro es que
> el cliente no se las haya regresado por ese motivo.
This is an English support list, please post in English.
Mark
--
Mark Rotteveel
oping in Firebird.
Mark
--
Mark Rotteveel
ompatibility with Interbase).
In any case this means you are probably using Firebird 3.0.2.32703
Mark
--
Mark Rotteveel
On 2017-08-17 22:29, Rudi Feijó rudi.fe...@multidadosti.com.br
[firebird-support] wrote:
> I’ve been having quite a few crashes on a new server with not much
> databases
> or requests. terminated abnormally (4294967295)
>
> It seems to be very random, there are not many different operations
> g
On 2017-08-17 13:40, Svein Erling Tysvær setys...@gmail.com
[firebird-support] wrote:
> Since the query contains 'from RDB$RELATION_FIELDS R, RDB$FIELDS F
> where ... R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME' (SQL-89 type of JOIN)
> and not 'from RDB$RELATION_FIELDS R JOIN RDB$FIELDS F ON
> R.RDB$FI
uates to true and is executed.
Maybe you meant AND instead of OR?
--
Mark Rotteveel
to design a transformation or
job, and Pan (transformations) or Kitchen (jobs) to execute them from
the command line.
However I haven't used them extensively, so I'm not sure if they are
suitable for what you want.
Mark
--
Mark Rotteveel
would be
20170812012345 and
20170812000234
If for some reason you are still stuck on ancient versions like Firebird
1.5, then I don't think there is an easy way to do this, if at all (I
don't recall if Firebird 1.5 supported sub-queries in IN or EXISTS, if
it does, you might be able to use that).
Mark
--
Mark Rotteveel
On 12-8-2017 13:03, venussof...@gmail.com [firebird-support] wrote:
> But still how can I get the rate attached to the top most dDt for each
> iItemID.
>
> Please advise
I'm not sure what you mean.
--
Mark Rotteveel
sorting with numbers of more than 10 digits.
We then use the max value with the iItemID group, and substring then
removes the date again to get the right cId back (zero-padded, but that
isn't a problem in this case, otherwise, you'll need to trim leading zeros).
Mark
--
Mark Rotteveel
On 2017-07-27 00:58, 'Leyne, Sean' s...@broadviewsoftware.com
[firebird-support] wrote:
> My question (and I'm sorry if I'm asking this before doing any
> research on my own) is simply, how compatible is the 2.5 version with
> databases created with 1.5.3?
Firebird 2.5 can read databases from Int
On 2017-07-26 17:52, scott...@comcast.net [firebird-support] wrote:
> Hello!
>
> I know it's been a while since I've posted on this Group, but current
> circumstances have brought me back.
>
> Today, I discovered that Microsoft forcibly removed fbserver & fbguard
> for version 1.5.3.4870. This ve
able. Your only option
is to try to detach, which might fail as well, but should deallocate any
clientside resources.
Mark
--
Mark Rotteveel
On 2017-07-20 16:53, fredf...@hotmail.com [firebird-support] wrote:
> I used Delphi's FireDAC components and FireDAC Monitor program which
> tracing issues with Firebird. I posted extracted data from tracing
> file after user hit save button to save changes in address1 line -
> it's very simple tr
On 2017-07-20 23:33, setysvar setys...@gmail.com [firebird-support]
wrote:
> Den 20.07.2017 16:53, skrev fredf...@hotmail.com [firebird-support]:
>
>> I used Delphi's FireDAC components and FireDAC Monitor program
>> which tracing issues with Firebird. I posted extracted data from
>> tracing fil
On 2017-07-20 00:18, fredf...@hotmail.com [firebird-support] wrote:
> The error states: Exception class EFDDBEngineException with message
> [FireDAC][Phys][FB_30]-312 Exact update affected [0] rows, while [1]
> was requested.
> If I hit "Continue" button then another exception raises:
> The error s
u. Not to mention that you do this just an
hour after posting your original question.
Mark
--
Mark Rotteveel
hat attempts to connect to the database. If
> it could not establish a connection, it restarts Firebird service. This
> script is run periodically by cron service.
That would suggest the listener crashed. Which version are you using?
Mark
--
Mark Rotteveel
On 16-7-2017 12:19, Andrea Raimondi andrea.raimo...@gmail.com
[firebird-support] wrote:
> Just wondering if Firebird supports either :)
>
> Anybody knows?
No, Firebird does not have data-types or indexes for - I assume - GIS
purposes.
Mark
--
Mark Rotteveel
rebird-on-j
Also make sure you are using the Firebird 3 fbclient.dll on your client
machine, or make sure that the legacy authentication is allowed and wire
encryption is downgraded from Required to Enabled.
Mark
--
Mark Rotteveel
> is also old method without direct hacking of system tables...
>
There currently is no `alter table ... rename to ...` in Firebird.
--
Mark Rotteveel
r process ended, just
that it stopped accepting connections. In any case, good luck.
Mark
--
Mark Rotteveel
On 2017-06-23 01:52, Aldo Caruso aldo.car...@argencasas.com
[firebird-support] wrote:
> Hi,
>
> I have Firebird 2.5 running since many years under the following
> environment
>
> OS: Ubuntu 14.04 Server
>
> Firebird Superserver 2.5.2.26540
>
> Web server: apache2 2.4.7
>
> Today co
firebirdsql.org/file/documentation/release_notes/html/en/2_5/notes-253.html
Mark
--
Mark Rotteveel
es to send data. Or if one side closed the connection in an
abortive manner (no linger).
It usually doesn't indicate a problem, just maybe a slightly unclean
connection handling.
Mark
--
Mark Rotteveel
is easy: just check if isc_info_sql_field is "DB_KEY", but this
doesn't work for parameters, because those don't include name information.
Mark
--
Mark Rotteveel
On 2017-05-03 19:07, Rudi Feijó rudi.fe...@multidadosti.com.br
[firebird-support] wrote:
> As of late, we have been experiencing with persistent connections on
> our
> backend. This is justifiable, we have a very high number of connection
> requests (lots of requests from lots of users).
>
> We
d = a.ar_id and b.ref_a_id is null
when matched then
update set b.ref_a_id = a.ref_a_id
See
https://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-dml-merge.html
How well that really performs depends on the presence of a suitable
index in table_b.
--
Mark Rotteveel
On 25-4-2017 18:21, Lester Caine les...@lsces.co.uk [firebird-support]
wrote:
> On 25/04/17 16:50, Mark Rotteveel m...@lawinegevaar.nl
> [firebird-support] wrote:
>> The SQL standard is quite clear at what needs to happen: adding a new
>> column with a default should behave as
or dropping the default), should not lead to changes to the value
of those rows that existed before the column was added with; the columns
need to retain the original default.
Mark
--
Mark Rotteveel
tep 4, the SURNAME field value is setting to empty string ('')
>
> Is that the correct behavior ?
Yes and no. Yes this is how Firebird works, and no it doesn't conform to
the behavior expected by the SQL standard. Firebird 3 does it better,
but some people consider that to be a bug (see CORE-5507 and the
accompanying discussion on firebird-devel).
Mark
--
Mark Rotteveel
execute block?
>
> I am required to write multiple commands in one block, so, I can not
> separate statements.
Why? Just like with stored procedures, you shouldn't be doing DDL from
execute block.
Mark
--
Mark Rotteveel
On 2017-03-14 18:32, Clyde Eisenbeis cte...@gmail.com [firebird-support]
wrote:
> I've recently written code using SQLite (C# .NET, using
> System.Data.SQLite) ... decided to try Firebird.
>
>
> To install Firebird: Visual Studio 2013 -> File -> New -> Project,
> etc. -- then Tools -> Li
On 2017-03-10 14:56, Martin Schreiber mse00...@gmail.com
[firebird-support] wrote:
> On 10.03.2017 15:35, hv...@users.sourceforge.net [firebird-support]
> wrote:
> >
> >
> > ---In firebird-support@yahoogroups.com, wrote :
> >
> >
> >> Are ther other possibilities to set the Firebird path t
On 2017-03-09 05:28, kyilintu...@yahoo.com [firebird-support] wrote:
> Can i connect Firebird with Jhipster
> because jhipster didn't show i can use firebird db
This question would be more on topic on the Firebird-java mailinglist.
However,I would guess that you are better off asking this on a
j
401 - 500 of 1341 matches
Mail list logo