Re: [Firebird-devel] CHAR fields in system tables

2018-04-28 Thread Omacht András
community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel __ Information from ESET Mail Security, version of virus signature database 172

Re: [Firebird-devel] CHAR fields in system tables

2018-04-28 Thread Dimitry Sibiryakov
28.04.2018 13:44, Mark Rotteveel wrote: Sure, but is there any reason why this couldn't be changed with a new ODS? GPRE started to support VARCHAR in v4 only (and even there the support is limited) and a lot of code will have to be rewritten for such change. Core team have no time for clean

Re: [Firebird-devel] CHAR fields in system tables

2018-04-28 Thread Dimitry Sibiryakov
28.04.2018 13:38, fbbt wrote: select RDB$RELATION_NAME F from RDB$RELATIONS where RDB$RELATION_NAME like 'RDB$RELATIONS' Use '=' instead of 'LIKE', Luke! -- WBR, SD. -- Check out the vibrant tech community on on

Re: [Firebird-devel] CHAR fields in system tables

2018-04-28 Thread Mark Rotteveel
On 28-4-2018 13:10, Alex Peshkoff via Firebird-devel wrote: On 04/28/18 12:22, fbbt wrote: For example: CREATE TABLE SEC$USERS ( SEC$USER_NAME    CHAR(63), SEC$FIRST_NAME   SEC$NAME_PART /* SEC$NAME_PART = VARCHAR(32) NOT NULL */, SEC$MIDDLE_NAME  SEC$NAME_PART /* SEC$NAME_PART

Re: [Firebird-devel] CHAR fields in system tables

2018-04-28 Thread fbbt
select RDB$RELATION_NAME F from RDB$RELATIONS where RDB$RELATION_NAME = 'RDB$RELATIONS' --- 1 record, F = 'RDB$RELATIONS '; select RDB$RELATION_NAME F from RDB$RELATIONS where RDB$RELATION_NAME like 'RDB$RELATIONS%' --- 1 record select RDB$RELAT

Re: [Firebird-devel] CHAR fields in system tables

2018-04-28 Thread liviuslivius
Hi, i agree with you totally. Because of something like this i have made wrong assumption when i have created http://tracker.firebirdsql.org/browse/CORE-5807. I never create char fields for variable length data. But FB developers can show some light on this i suppose Regards,Karol Bieniaszewski

Re: [Firebird-devel] CHAR fields in system tables

2018-04-28 Thread Alex Peshkoff via Firebird-devel
On 04/28/18 12:22, fbbt wrote: For example: CREATE TABLE SEC$USERS ( SEC$USER_NAMECHAR(63), SEC$FIRST_NAME SEC$NAME_PART /* SEC$NAME_PART = VARCHAR(32) NOT NULL */, SEC$MIDDLE_NAME SEC$NAME_PART /* SEC$NAME_PART = VARCHAR(32) NOT NULL */, SEC$LAST_NAMESEC$NAME_PART

[Firebird-devel] CHAR fields in system tables

2018-04-28 Thread fbbt
For example: CREATE TABLE SEC$USERS ( SEC$USER_NAMECHAR(63), SEC$FIRST_NAME SEC$NAME_PART /* SEC$NAME_PART = VARCHAR(32) NOT NULL */, SEC$MIDDLE_NAME SEC$NAME_PART /* SEC$NAME_PART = VARCHAR(32) NOT NULL */, SEC$LAST_NAMESEC$NAME_PART /* SEC$NAME_PART = VARCHAR(32) NOT N