Dmitry Yemanov comments

Results 190 comments of


                                            Dmitry Yemanov

Query that uses index on numeric column may not found existing data if search criterion is a string that represents negative numbers

I fail to see a "numeric column" mentioned in the issue title. X is declared as CHAR(2).

Query that uses index on numeric column may not found existing data if search criterion is a string that represents negative numbers

``` SQL> select -(-('1')) from t2; Statement failed, SQLSTATE = 42000 Dynamic SQL Error -expression evaluation not supported -Strings cannot be negated (applied the minus operator) in dialect 3 ```...

Tablespaces [CORE688]

@drraptis This feature is purely optional and costs you nothing if not used.

Fix potential vulnerable cloned function

@AlexPeshkoff should it be merged or were there any reasons to postpone it?

Fix potential vulnerable cloned function

For v6, I suppose we may just update our libtom-imported sources. If this needs to be backported, the suggested patch is preferred -- although I doubt this is necessary given...

Very slow memory table scan firebird compared to other databases

Firebird compresses data on pages and this cannot be disabled. It saves disk space but spends CPU cycles on reading.

Very slow memory table scan firebird compared to other databases

Data page is always the same, be it either on disk or cached in memory.

Very slow memory table scan firebird compared to other databases

> Compression is on records. But in case of count it shouldn't matter. Did you miss the `WHERE DATA` condition?

Replication errors

How long ago (and on which FB version) the replica was re-initialized the last time?

Firebird 5 wrong plan

Please send the test database (or download link) to firebird2 at yandex dot ru.