[Firebird-devel] [FB-Tracker] Created: (CORE-5915) New transaction-related items in 'SYSTEM' namespace for Firbird version 2.5(.9)
New transaction-related items in 'SYSTEM' namespace for Firbird version 2.5(.9) --- Key: CORE-5915 URL: http://tracker.firebirdsql.org/browse/CORE-5915 Project: Firebird Core Issue Type: Improvement Components: Engine Affects Versions: 2.5.8 Reporter: Omacht András Priority: Minor Referring to the correspondence on the support list with Vlad, I request the following: please add the following transaction-realted items in SYSTEM namespace: - TRANSACTION_ID - ISOLATION_LEVEL - LOCK_TIMEOUT - READ_ONLY Thanks! -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5916) Pading strings with spaces to longest string in queries with union
Pading strings with spaces to longest string in queries with union -- Key: CORE-5916 URL: http://tracker.firebirdsql.org/browse/CORE-5916 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0.3 Environment: WIndows 7 Reporter: Wojtek Priority: Minor I have query using union all to add many records to database at one time. But in each varchar field spaces are added at the end. There is a sample demonstrating problem: SELECT COL, REPLACE(COL, ' ', '.'), CHAR_LENGTH(COL), CHAR_LENGTH(TRIM(COL)) FROM ( SELECT 'a' AS COL FROM RDB$DATABASE UNION ALL SELECT 'bbb' FROM RDB$DATABASE UNION ALL SELECT 'cc' FROM RDB$DATABASE ) And result: COL REPLACE CHAR_LENGTH CHAR_LENGTH1 a a.. 7 1 bbb bbb 7 7 cc cc. 7 2 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5917) ENDING WITH
ENDING WITH --- Key: CORE-5917 URL: http://tracker.firebirdsql.org/browse/CORE-5917 Project: Firebird Core Issue Type: New Feature Components: Engine Reporter: Kovalenko Dmitry Firebird and InterBase support the "STARTING WITH" operator in SQL. But not support "ENDING WITH". I know, that I may use LIKE, or "RIGHT(value,CHAR_LENGTH(pattern))=pattern", but (in general case) "ENDING WITH" looks better :) --- Where it need - in translator of LINQ-queries into Firebird SQL. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] FB4 vs CORE-5222
2018. 09. 03. 10:53 keltezéssel, Vlad Khorsun írta: Issue (a) is fixed now (see above) but issue (b) is hard to fix and i need some time to find if it can be fixed and how to do it. Probably, it should not be fixed at all (hi, Adriano ;)). I going to try this test with execute statement, just to see what happens. Please fix it. If not, the WAIT feature is useless. Or not? PS In ReadConsistency = 0 mode test case produced a lot of backversions of single record that was updated many times. It happens because "main" transaction blocks garbage collection. In ReadConsistency = 1 (after i added retry on update conflict handling at P-SQL level) it produces just 2 backversions - thanks to the intermediate garbage collection. "2" backversions better than "lot of". But only if the WAIT feature working. Default value of ReadConsistency is illogical for me. The documentation say "To help test existing applications...". If I want to test a new feature I turn it on. Currently turn off to eliminate "update conflicts...". (My own test application execute 1 statement/second which is not a high load and got "update conflicts..." instantly if execute two instances in parallel from it. A defaulted non properly working new feature is not a good message (for me). Develop it, test it and if everything works with it as before, set as default. But I am just a user. :D Gabor Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] FB4 vs CORE-5222
ср, 19 сент. 2018 г. в 19:57, Gabor Boros : > Default value of ReadConsistency is illogical for me. The > documentation say "To help test existing applications...". If I want to > test a new feature I turn it on. Currently turn off to eliminate "update > conflicts...". (My own test application execute 1 statement/second which > is not a high load and got "update conflicts..." instantly if execute > two instances in parallel from it. > > A defaulted non properly working new feature is not a good message (for > me). Develop it, test it and if everything works with it as before, set > as default. But I am just a user. :D This value is default because of this behavior is consistent and correct. Previous one could lead to logical errors in the results of queries. I'm totally support this value as default and the need to change it only if you have a problem and consciously understand what are you doing. -- Roman Simakov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
