[Firebird-devel] [FB-Tracker] Created: (CORE-6544) ambigious column name '...'
ambigious column name '...' --- Key: CORE-6544 URL: http://tracker.firebirdsql.org/browse/CORE-6544 Project: Firebird Core Issue Type: Improvement Environment: Win10, x64 Reporter: Alexander Muylaert Attachments: image_2021_04_21T05_29_28_939Z.png Hi We had an accidental performance degrade because of a calculated field that should wasn't intended to be used in production. The problem behind it was the SQL that was approved. It contained ambiguous column names between tables. It would be magnificent if you could fail on compile time, since this is a very dangerous situation. In my example, bit T_ADDRESS and T_PROJECT have a field F_PERS_ID and the code I'm showing is the computed by of a calculated field. The second (correct) implementation gives me a correct, fast result, while the first one, returns a full table scan. What it should do... But it would have saved us many stupid hours of debugging if the ambiguous warning would have been thrown. A bit like in MS-SQL. kind regards Alexander -- 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] travis-ci.org => travis-ci.com
20.04.2021 15:17, Vlad Khorsun wrote: 20.04.2021 15:06, Dimitry Sibiryakov wrote: 20.04.2021 13:58, Adriano dos Santos Fernandes wrote: Build of master (AMD64 on Xenial) is constantly failed (but doesn't report failure): /home/travis/build/FirebirdSQL/firebird/src/common/../common/../common/config/config.h:441:18: error: ‘is_member_function_pointer’ is not a member of ‘std’ static_assert(!std::is_member_function_pointer::value, "Must be a static function"); \ ^ Seems it uses too old compiler to build master: So we'd better disable it. Better would be to include required header into config.h. Done, lets see if it helps. It helps, thanks! Regards, Vlad Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] travis-ci.org => travis-ci.com
20.04.2021 15:06, Dimitry Sibiryakov wrote: 20.04.2021 13:58, Adriano dos Santos Fernandes wrote: Build of master (AMD64 on Xenial) is constantly failed (but doesn't report failure): /home/travis/build/FirebirdSQL/firebird/src/common/../common/../common/config/config.h:441:18: error: ‘is_member_function_pointer’ is not a member of ‘std’ static_assert(!std::is_member_function_pointer::value, "Must be a static function"); \ ^ Seems it uses too old compiler to build master: So we'd better disable it. Better would be to include required header into config.h. Done, lets see if it helps. Regards, Vlad Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] travis-ci.org => travis-ci.com
20.04.2021 13:58, Adriano dos Santos Fernandes wrote: Build of master (AMD64 on Xenial) is constantly failed (but doesn't report failure): /home/travis/build/FirebirdSQL/firebird/src/common/../common/../common/config/config.h:441:18: error: ‘is_member_function_pointer’ is not a member of ‘std’ static_assert(!std::is_member_function_pointer::value, "Must be a static function"); \ ^ Seems it uses too old compiler to build master: So we'd better disable it. Better would be to include required header into config.h. -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] travis-ci.org => travis-ci.com
On 20/04/2021 08:35, Vlad Khorsun wrote: > 19.04.2021 15:32, Adriano dos Santos Fernandes wrote: >> On 19/04/2021 08:19, Adriano dos Santos Fernandes wrote: >>> On 19/04/2021 03:53, Mark Rotteveel wrote: >>> I was able to get extra credits from Travis CI, but maybe we should do what Dimitry suggested, and migrate to GitHub Actions. >>> >>> We are already on GitHub Actions. >>> >>> We only lack Ubuntu build for v3 (but have Alpine build). >>> >>> When I tried Ubuntu for v3, it was segfaulting when utilities just build >>> were used - maybe related to destruction order of things. >>> >>> I'll try to enable it again. >>> >> >> Enabled now (three builds passed). > > Build of master (AMD64 on Xenial) is constantly failed (but doesn't > report failure): > > /home/travis/build/FirebirdSQL/firebird/src/common/../common/../common/config/config.h:441:18: > error: > ‘is_member_function_pointer’ is not a member of ‘std’ > > static_assert(!std::is_member_function_pointer::value, > "Must be a static function"); \ > ^ > > Seems it uses too old compiler to build master: > So we'd better disable it. Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] travis-ci.org => travis-ci.com
19.04.2021 15:32, Adriano dos Santos Fernandes wrote: On 19/04/2021 08:19, Adriano dos Santos Fernandes wrote: On 19/04/2021 03:53, Mark Rotteveel wrote: I was able to get extra credits from Travis CI, but maybe we should do what Dimitry suggested, and migrate to GitHub Actions. We are already on GitHub Actions. We only lack Ubuntu build for v3 (but have Alpine build). When I tried Ubuntu for v3, it was segfaulting when utilities just build were used - maybe related to destruction order of things. I'll try to enable it again. Enabled now (three builds passed). Build of master (AMD64 on Xenial) is constantly failed (but doesn't report failure): /home/travis/build/FirebirdSQL/firebird/src/common/../common/../common/config/config.h:441:18: error: ‘is_member_function_pointer’ is not a member of ‘std’ static_assert(!std::is_member_function_pointer::value, "Must be a static function"); \ ^ Seems it uses too old compiler to build master: $ g++ --version g++ (Ubuntu 5.4.0-6ubuntu1~16.04.12) 5.4.0 20160609 Copyright (C) 2015 Free Software Foundation, Inc. Regards, Vlad Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Charset of plugin configuration parameters
In Windows we already consider ANSI code page to be the "system charset". I think config files should be handled as ANSI encoded in Windows. About UTF-8 BOM, many tools also does not recognize it. Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Server 4.0 question: communication paths to exchange control information ?
20.04.2021 12:39, Pro Turm wrote: do you have any references (docs, example etc.) for the approaches you proposed? http://www.ibphoenix.com/files/60ApiGuide.zip -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Server 4.0 question: communication paths to exchange control information ?
Hello, sorry for the stupid question, but do you have any references (docs, example etc.) for the approaches you proposed? Am Di., 13. Apr. 2021 um 11:31 Uhr schrieb Dmitry Yemanov < firebi...@yandex.ru>: > 13.04.2021 12:22, Dimitry Sibiryakov wrote: > > > >> I'd like for example to set the database from read/write mode to read > >> modus and vs. > > > > You can get current database mode via API isc_database_info() call > > and set it using DPB tag on attach. > > Or, alternatively, via Services API. > > > Dmitry > > > > > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel > Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Charset of plugin configuration parameters
Den 2021-04-19 kl. 17:52, skrev Alex Peshkoff via Firebird-devel: On 4/19/21 6:43 PM, Dimitry Sibiryakov wrote: In my own recent config parsers I separate ANSI files from UTF-8 files by BOM and handle them accordingly but I use Unicode for internal processing which Firebird doesn't. Telling true I doubt that separating ANSI from UTF8 is actual - noone (well, almost noone) will use utf8 on windows or ANSI on linux. What may be interesting (and does cause troubles) is separating OEM vs. ANSI on windows. I, for one, use Notepad++ for all my text file editing, and have it set to UTF-8 with BOM as default enconding. I would not be surprised if there are many others with some kind of similar setup. That said, I tend to not change encoding of existing files, so if the Firebird installation ships with .conf files in a specific encoding, that encoding will probably remain at my site. Not sure I think core-5198 is a good idea though. You could write in the docs which rules and assumptions regarding encoding are used in Firebird, and leave it at that, assuming those rules and assumptions are reasonable. For example, on Windows, presence of a BOM should be respected of course. If not, try to auto detect, at least distinguish between UTF-8 and ANSI (assuming the codepage of the current locale, e.g. win-1252), and the Windows-native Unicode encoding UTF-16. Regards, Kjell <>Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel