2017. 12. 12. 18:31 keltezéssel, Vlad Khorsun via Firebird-devel írta:
12.12.2017 17:38, Gabor Boros wrote:
If the problem can't be reproduces with a simple database and simple
application, it's probably another problem.
I have a simple application and three databases. Can I send to you
priv
On 12/12/2017 15:38, Gabor Boros wrote:
> 2017. 12. 12. 17:34 keltezéssel, Adriano dos Santos Fernandes írta:
>
>> Can you make this leaks using only ISQL?
>>
>> 1) Running the SELECT statement one after another
>
>
> If run the next SELECT 5 times I get the below stats.
>
> SQL> SELECT * FROM TABL
2017. 12. 12. 17:34 keltezéssel, Adriano dos Santos Fernandes írta:
Can you make this leaks using only ISQL?
1) Running the SELECT statement one after another
If run the next SELECT 5 times I get the below stats.
SQL> SELECT * FROM TABLE1 ORDER BY
(CAST(SUBSTRING(TABLE1.TEXT_BLOB_FIELD FRO
12.12.2017 17:38, Gabor Boros wrote:
If the problem can't be reproduces with a simple database and simple
application, it's probably another problem.
I have a simple application and three databases. Can I send to you privately? I attached earlier but got a message about the 40 KB
body limit.
2017. 12. 12. 17:29 keltezéssel, Dimitry Sibiryakov írta:
12.12.2017 17:12, Gabor Boros wrote:
I checked now, but only one statement exists.
Ok. Are you able to build server from sources?
No.
Gabor
--
Check out
On 12/12/2017 13:38, Gabor Boros wrote:
>> What is "change the ORDER BY ASC/DESC in a query and close/open it"?
>
>
> Meanwhile I realized the sort order is not count.
>
>
>> Is it same statement handle?
>
>
> I use FPC/Lazarus and IBX for connection.
> The test code is:
>
> procedure Proc_Query(in
12.12.2017 17:12, Gabor Boros wrote:
I checked now, but only one statement exists.
Ok. Are you able to build server from sources?
--
WBR, SD.
--
Check out the vibrant tech community on one of the world's most
eng
[
http://tracker.firebirdsql.org/browse/CORE-5652?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vlad Khorsun reopened CORE-5652:
I missed that script was executed with FlameRobin.
Now, with isql and AUTODDL OFF
SQL>
SQL> SET AUTODDL
2017. 12. 12. 16:45 keltezéssel, Dimitry Sibiryakov írta:
Look at MON$STATEMENTS during this test. Probably, this IBX fork
close but not free statements.
I checked now, but only one statement exists.
Gabor
--
Chec
On 12/12/2017 13:42, Lester Caine wrote:
> and it's the version data that is missing in the Oracle 'solution' ...
It's not that simple. Date/times are considered equal if their
conversion to UTC are equal, independent of region.
So, they are converted to UTC for storage. To convert to UTC, one nee
12.12.2017 16:38, Gabor Boros wrote:
I use FPC/Lazarus and IBX for connection.
The test code is:
Look at MON$STATEMENTS during this test. Probably, this IBX fork close but not free
statements.
--
WBR, SD.
--
Ch
On 12/12/17 15:20, Alex Peshkoff via Firebird-devel wrote:
>> Oracle also mentions inconsistency that may happen when the time zone
>> database is updated. If user had previously entered a time in a moment
>> that subsequently has updated by the time zone db, it may become
>> inconsistent. So it sh
On 12/12/2017 13:20, Alex Peshkoff via Firebird-devel wrote:
> On 12/12/17 17:57, Adriano dos Santos Fernandes wrote:
>> Oracle also mentions inconsistency that may happen when the time zone
>> database is updated. If user had previously entered a time in a moment
>> that subsequently has updated b
What is "change the ORDER BY ASC/DESC in a query and close/open it"?
Meanwhile I realized the sort order is not count.
Is it same statement handle?
I use FPC/Lazarus and IBX for connection.
The test code is:
procedure Proc_Query(in_Query:TIBQuery);
begin
in_Query.Close;
in_Query.SQL
On 12/12/17 17:57, Adriano dos Santos Fernandes wrote:
Oracle also mentions inconsistency that may happen when the time zone
database is updated. If user had previously entered a time in a moment
that subsequently has updated by the time zone db, it may become
inconsistent. So it should be update
On 21/11/2017 14:16, Lester Caine wrote:
> On 21/11/17 14:55, Adriano dos Santos Fernandes wrote:
>> Implementing TIME WITH TIME ZONE and TIMESTAMP WITH TIME ZONE datatypes
>> as specified in the SQL standard is not a big problem.
> The only question is just how is the timezone data managed. It is
16 matches
Mail list logo
