Dimitry Sibiryakov

Results 114 comments of Dimitry Sibiryakov

Transform LEFT joins into INNER ones if the WHERE condition violates the outer join rules

Per-database options is a huge pain for support. In the major release it would be better to register cases of generated bad plans as bugs for separate optimizer improvements.

Transform LEFT joins into INNER ones if the WHERE condition violates the outer join rules

Another MSSQL-style option is the last thing Firebird needs IMHO.

Transform LEFT joins into INNER ones if the WHERE condition violates the outer join rules

If you want hints - implement hints. Or use already existing PLAN clause.

Regression: "Blob not found" exception after insert, select and delete in procedure

This behavior is "as designed" and fixing it would result in significant performance penalty. On 2.5 the error was raised as well if UPDATE is used instead of DELETE. Now...

Regression: "Blob not found" exception after insert, select and delete in procedure

Theoretically whole BLOB could be copied into the temporary tablespace unless it is already there but that's performance penalty I was talked about. Another solution could be reference-counted BLOB IDs.

Regression: "Blob not found" exception after insert, select and delete in procedure

Do "c = c||'';" and yuo'll get what you want.

Regression: "Blob not found" exception after insert, select and delete in procedure

> What about blobs greater than 64K? Concatenation works with them without problems and no restriction is going to be applied.

Declare procedure and function for a table

What's the difference from simple "MyProcedure"?

Feature Request: Perl Compatible Regular Expressions

What exactly in Perl is "more powerful"?

New connection to server causes CPU core to run at 100%

I see no firebird.exe anywhere in stack and by offsets I'm jugging that symbols in OdbcFb.dll were resolved wrongly. Besides the stack ends up in "Wait" functions that hardly can...