View Issue Details

IDProjectCategoryView StatusLast Update
0037213PatchesPatchpublic2020-07-16 09:28
ReporterGabor Boros Assigned ToMartin Friebe  
PrioritynormalSeverityminorReproducibilityN/A
Status resolvedResolutionfixed 
Product Version2.1 (SVN) 
Fixed in Version2.2 
Summary0037213: SynEdit - Update Firebird 4.0 highlighter
DescriptionThe attached patch update Firebird 4.0 keyword list to Beta 2 state.
TagsNo tags attached.
Fixed in Revision63366
LazTarget2.2
Widgetset
Attached Files

Activities

Gabor Boros

2020-06-14 10:46

reporter  

synhighlightersql.pas.patch (8,403 bytes)   
Index: components/synedit/synhighlightersql.pas
===================================================================
--- components/synedit/synhighlightersql.pas	(revision 63352)
+++ components/synedit/synhighlightersql.pas	(working copy)
@@ -1131,57 +1131,60 @@
   Firebird40KW: string =
     'ABS,ABSOLUTE,ACCENT,ACOS,ACOSH,ACTION,ACTIVE,ADD,ADMIN,AFTER,ALL,ALTER,'+
     'ALWAYS,AND,ANY,AS,ASC,ASCENDING,ASCII_CHAR,ASCII_VAL,ASIN,ASINH,AT,ATAN,'+
-    'ATAN2,ATANH,AUTO,AUTONOMOUS,AVG,BACKUP,BASE64_DECODE,BASE64_ENCODE,BEFORE,'+
-    'BEGIN,BETWEEN,BIGINT,BIN_AND,BIN_NOT,BIN_OR,BIN_SHL,BIN_SHR,BIN_XOR,BINARY,'+
-    'BIND,BIT_LENGTH,BLOB,BLOCK,BODY,BOOLEAN,BOTH,BREAK,BY,CALLER,CASCADE,CASE,'+
-    'CAST,CEIL,CEILING,CHAR,CHAR_LENGTH,CHAR_TO_UUID,CHARACTER,CHARACTER_LENGTH,'+
-    'CHECK,CLEAR,CLOSE,COALESCE,COLLATE,COLLATION,COLUMN,COMMENT,COMMIT,'+
-    'COMMITTED,COMMON,COMPARE_DECFLOAT,COMPUTED,CONDITIONAL,CONNECT,CONNECTIONS,'+
-    'CONSISTENCY,CONSTRAINT,CONTAINING,CONTINUE,CORR,COS,COSH,COT,COUNT,COUNTER,'+
-    'COVAR_POP,COVAR_SAMP,CRC32,CREATE,CROSS,CSTRING,CTR_BIG_ENDIAN,CTR_LENGTH,'+
-    'CTR_LITTLE_ENDIAN,CUME_DIST,CURRENT,CURRENT_CONNECTION,CURRENT_DATE,'+
-    'CURRENT_ROLE,CURRENT_TIME,CURRENT_TIMESTAMP,CURRENT_TRANSACTION,'+
-    'CURRENT_USER,CURSOR,DATABASE,DATA,DATE,DATEADD,DATEDIFF,DAY,DDL,DEC,'+
-    'DECFLOAT,DECIMAL,DECLARE,DECODE,DECRYPT,DEFAULT,DEFINER,DELETE,DELETING,'+
-    'DENSE_RANK,DESC,DESCENDING,DESCRIPTOR,DETERMINISTIC,DIFFERENCE,DISCONNECT,'+
-    'DISTINCT,DO,DOMAIN,DOUBLE,DROP,ELSE,ENCRYPT,END,ENGINE,ENTRY_POINT,ESCAPE,'+
-    'EXCEPTION,EXCESS,EXCLUDE,EXECUTE,EXISTS,EXIT,EXP,EXTERNAL,EXTRACT,FALSE,'+
-    'FETCH,FILE,FILTER,FIRST,FIRST_DAY,FIRST_VALUE,FIRSTNAME,FLOAT,FLOOR,'+
-    'FOLLOWING,FOR,FOREIGN,FREE_IT,FROM,FULL,FUNCTION,GDSCODE,GENERATED,'+
-    'GENERATOR,GEN_ID,GEN_UUID,GLOBAL,GRANT,GRANTED,GROUP,HASH,HAVING,'+
-    'HEX_DECODE,HEX_ENCODE,HOUR,IDENTITY,IDLE,IF,IGNORE,IIF,IN,INACTIVE,'+
-    'INCREMENT,INDEX,INNER,INPUT_TYPE,INSENSITIVE,INSERT,INSERTING,INT,INT128,'+
-    'INTEGER,INTO,INVOKER,IS,ISOLATION,IV,JOIN,KEY,LAG,LAST,LAST_DAY,LAST_VALUE,'+
-    'LASTNAME,LEAD,LEADING,LEAVE,LEFT,LEGACY,LENGTH,LEVEL,LIFETIME,LIKE,LIMBO,'+
-    'LINGER,LIST,LN,LOCAL,LOCALTIME,LOCALTIMESTAMP,LOCK,LOG,LOG10,LONG,LOWER,'+
-    'LPAD,LPARAM,MANUAL,MAPPING,MATCHED,MATCHING,MAX,MAXVALUE,MERGE,MESSAGE,'+
-    'MILLISECOND,MIDDLENAME,MIN,MINUTE,MINVALUE,MOD,MODE,MODULE_NAME,MONTH,NAME,'+
-    'NAMES,NATIONAL,NATIVE,NATURAL,NCHAR,NEXT,NO,NORMALIZE_DECFLOAT,NOT,'+
-    'NTH_VALUE,NTILE,NULLIF,NULL,NULLS,NUMBER,NUMERIC,OCTET_LENGTH,OF,OFFSET,'+
-    'OLDEST,ON,ONLY,OPEN,OPTION,OR,ORDER,OS_NAME,OTHERS,OUTER,OUTPUT_TYPE,OVER,'+
-    'OVERFLOW,OVERLAY,OVERRIDING,PACKAGE,PAD,PAGE,PAGES,PAGE_SIZE,PARAMETER,'+
-    'PARTITION,PASSWORD,PERCENT_RANK,PI,PLACING,PLAN,PLUGIN,POOL,POSITION,'+
-    'POST_EVENT,POWER,PRECEDING,PRECISION,PRESERVE,PRIMARY,PRIOR,PRIVILEGE,'+
-    'PRIVILEGES,PROCEDURE,PROTECTED,QUANTIZE,RAND,RANGE,RANK,RDB$DB_KEY,'+
+    'ATAN2,ATANH,AUTO,AUTONOMOUS,AVG,BACKUP,BASE64_DECODE,BASE64_ENCODE,'+
+    'BEFORE,BEGIN,BETWEEN,BIGINT,BIN_AND,BIN_NOT,BIN_OR,BIN_SHL,BIN_SHR,'+
+    'BIN_XOR,BINARY,BIND,BIT_LENGTH,BLOB,BLOCK,BODY,BOOLEAN,BOTH,BREAK,BY,'+
+    'CALLER,CASCADE,CASE,CAST,CEIL,CEILING,CHAR,CHAR_LENGTH,CHAR_TO_UUID,'+
+    'CHARACTER,CHARACTER_LENGTH,CHECK,CLEAR,CLOSE,COALESCE,COLLATE,COLLATION,'+
+    'COLUMN,COMMENT,COMMIT,COMMITTED,COMMON,COMPARE_DECFLOAT,COMPUTED,'+
+    'CONDITIONAL,CONNECT,CONNECTIONS,CONSISTENCY,CONSTRAINT,CONTAINING,'+
+    'CONTINUE,CORR,COS,COSH,COT,COUNT,COUNTER,COVAR_POP,COVAR_SAMP,CRC32,'+
+    'CREATE,CROSS,CSTRING,CTR_BIG_ENDIAN,CTR_LENGTH,CTR_LITTLE_ENDIAN,'+
+    'CUME_DIST,CURRENT,CURRENT_CONNECTION,CURRENT_DATE,CURRENT_ROLE,'+
+    'CURRENT_TIME,CURRENT_TIMESTAMP,CURRENT_TRANSACTION,CURRENT_USER,CURSOR,'+
+    'DATABASE,DATA,DATE,DATEADD,DATEDIFF,DAY,DDL,DEC,DECFLOAT,DECIMAL,DECLARE,'+
+    'DECODE,DECRYPT,DEFAULT,DEFINER,DELETE,DELETING,DENSE_RANK,DESC,'+
+    'DESCENDING,DESCRIPTOR,DETERMINISTIC,DIFFERENCE,DISABLE,DISCONNECT,'+
+    'DISTINCT,DO,DOMAIN,DOUBLE,DROP,ELSE,ENABLE,ENCRYPT,END,ENGINE,'+
+    'ENTRY_POINT,ESCAPE,EXCEPTION,EXCESS,EXCLUDE,EXECUTE,EXISTS,EXIT,EXP,'+
+    'EXTENDED,EXTERNAL,EXTRACT,FALSE,FETCH,FILE,FILTER,FIRST,FIRST_DAY,'+
+    'FIRST_VALUE,FIRSTNAME,FLOAT,FLOOR,FOLLOWING,FOR,FOREIGN,FREE_IT,FROM,'+
+    'FULL,FUNCTION,GDSCODE,GENERATED,GENERATOR,GEN_ID,GEN_UUID,GLOBAL,GRANT,'+
+    'GRANTED,GROUP,HASH,HAVING,HEX_DECODE,HEX_ENCODE,HOUR,IDENTITY,IDLE,IF,'+
+    'IGNORE,IIF,IN,INACTIVE,INCREMENT,INDEX,INNER,INPUT_TYPE,INSENSITIVE,'+
+    'INSERT,INSERTING,INT,INTEGER,INTO,INVOKER,IS,ISOLATION,IV,JOIN,KEY,LAG,'+
+    'LAST,LAST_DAY,LAST_VALUE,LASTNAME,LEAD,LEADING,LEAVE,LEFT,LEGACY,LENGTH,'+
+    'LEVEL,LIFETIME,LIKE,LIMBO,LINGER,LIST,LN,LATERAL,LOCAL,LOCALTIME,'+
+    'LOCALTIMESTAMP,LOCK,LOG,LOG10,LONG,LOWER,LPAD,LPARAM,MAKE_DBKEY,MANUAL,'+
+    'MAPPING,MATCHED,MATCHING,MAX,MAXVALUE,MERGE,MESSAGE,MILLISECOND,'+
+    'MIDDLENAME,MIN,MINUTE,MINVALUE,MOD,MODE,MODULE_NAME,MONTH,NAME,NAMES,'+
+    'NATIONAL,NATIVE,NATURAL,NCHAR,NEXT,NO,NORMALIZE_DECFLOAT,NOT,NTH_VALUE,'+
+    'NTILE,NULLIF,NULL,NULLS,NUMBER,NUMERIC,OCTET_LENGTH,OF,OFFSET,OLDEST,ON,'+
+    'ONLY,OPEN,OPTION,OR,ORDER,OS_NAME,OTHERS,OUTER,OUTPUT_TYPE,OVER,OVERFLOW,'+
+    'OVERLAY,OVERRIDING,PACKAGE,PAD,PAGE,PAGES,PAGE_SIZE,PARAMETER,PARTITION,'+
+    'PASSWORD,PERCENT_RANK,PI,PLACING,PLAN,PLUGIN,POOL,POSITION,POST_EVENT,'+
+    'POWER,PRECEDING,PRECISION,PRESERVE,PRIMARY,PRIOR,PRIVILEGE,PRIVILEGES,'+
+    'PROCEDURE,PROTECTED,PUBLICATION,QUANTIZE,RAND,RANGE,RANK,RDB$DB_KEY,'+
     'RDB$ERROR,RDB$GET_CONTEXT,RDB$GET_TRANSACTION_CN,RDB$RECORD_VERSION,'+
     'RDB$ROLE_IN_USE,RDB$SET_CONTEXT,RDB$SYSTEM_PRIVILEGE,READ,REAL,'+
     'RECORD_VERSION,RECREATE,RECURSIVE,REFERENCES,REGR_AVGX,REGR_AVGY,'+
     'REGR_COUNT,REGR_INTERCEPT,REGR_R2,REGR_SLOPE,REGR_SXX,REGR_SXY,REGR_SYY,'+
-    'RELATIVE,RELEASE,REPLACE,REQUESTS,RESERV,RESERVING,RESET,RESTART,RESTRICT,'+
-    'RETAIN,RETURN,RETURNING,RETURNING_VALUES,RETURNS,REVERSE,REVOKE,RIGHT,ROLE,'+
-    'ROLLBACK,ROUND,ROW,ROW_COUNT,ROW_NUMBER,ROWS,RPAD,RSA_DECRYPT,RSA_ENCRYPT,'+
-    'RSA_PRIVATE,RSA_PUBLIC,RSA_SIGN,RSA_VERIFY,SALT_LENGTH,SAVEPOINT,'+
-    'SCALAR_ARRAY,SCHEMA,SCROLL,SECOND,SECURITY,SEGMENT,SELECT,SENSITIVE,'+
-    'SEQUENCE,SERVERWIDE,SESSION,SET,SHADOW,SHARED,SIGN,SIGNATURE,SIMILAR,SIN,'+
-    'SINGULAR,SINH,SIZE,SKIP,SMALLINT,SNAPSHOT,SOME,SORT,SOURCE,SPACE,SQL,'+
-    'SQLCODE,SQLSTATE,SQRT,STABILITY,START,STARTING,STARTS,STATEMENT,STATISTICS,'+
-    'STDDEV_POP,STDDEV_SAMP,SUBSTRING,SUB_TYPE,SUM,SUSPEND,SYSTEM,TABLE,TAGS,'+
-    'TAN,TANH,TEMPORARY,THEN,TIES,TIME,TIMESTAMP,TIMEOUT,TIMEZONE_HOUR,'+
-    'TIMEZONE_MINUTE,TO,TOTALORDER,TRAILING,TRANSACTION,TRAPS,TRIGGER,TRIM,TRUE,'+
-    'TRUNC,TRUSTED,TWO_PHASE,TYPE,UNBOUNDED,UNCOMMITTED,UNDO,UNION,UNIQUE,'+
-    'UNKNOWN,UPDATE,UPDATING,UPPER,USAGE,USER,USING,UUID_TO_CHAR,VALUE,VALUES,'+
-    'VAR_POP,VAR_SAMP,VARBINARY,VARCHAR,VARIABLE,VARYING,VIEW,WAIT,WEEK,WEEKDAY,'+
-    'WHEN,WHERE,WHILE,WINDOW,WITH,WITHOUT,WORK,WRITE,YEAR,YEARDAY,ZONE';
+    'RELATIVE,RELEASE,REPLACE,REQUESTS,RESERV,RESERVING,RESET,RESTART,'+
+    'RESTRICT,RETAIN,RETURN,RETURNING,RETURNING_VALUES,RETURNS,REVERSE,REVOKE,'+
+    'RIGHT,ROLE,ROLLBACK,ROUND,ROW,ROW_COUNT,ROW_NUMBER,ROWS,RPAD,RSA_DECRYPT,'+
+    'RSA_ENCRYPT,RSA_PRIVATE,RSA_PUBLIC,RSA_SIGN,RSA_VERIFY,SALT_LENGTH,'+
+    'SAVEPOINT,SCALAR_ARRAY,SCHEMA,SCROLL,SECOND,SECURITY,SEGMENT,SELECT,'+
+    'SENSITIVE,SEQUENCE,SERVERWIDE,SESSION,SET,SHADOW,SHARED,SIGN,SIGNATURE,'+
+    'SIMILAR,SIN,SINGULAR,SINH,SIZE,SKIP,SMALLINT,SNAPSHOT,SOME,SORT,SOURCE,'+
+    'SPACE,SQL,SQLCODE,SQLSTATE,SQRT,STABILITY,START,STARTING,STARTS,'+
+    'STATEMENT,STATISTICS,STDDEV_POP,STDDEV_SAMP,SUBSTRING,SUB_TYPE,SUM,'+
+    'SUSPEND,SYSTEM,TABLE,TAGS,TAN,TANH,TEMPORARY,THEN,TIES,TIME,TIMESTAMP,'+
+    'TIMEOUT,TIMEZONE_HOUR,TIMEZONE_MINUTE,TO,TOTALORDER,TRAILING,TRANSACTION,'+
+    'TRAPS,TRIGGER,TRIM,TRUE,TRUNC,TRUSTED,TWO_PHASE,TYPE,UNBOUNDED,'+
+    'UNCOMMITTED,UNDO,UNION,UNIQUE,UNKNOWN,UPDATE,UPDATING,UPPER,USAGE,USER,'+
+    'USING,UUID_TO_CHAR,VALUE,VALUES,VAR_POP,VAR_SAMP,VARBINARY,VARCHAR,'+
+    'VARIABLE,VARYING,VIEW,WAIT,WEEK,WEEKDAY,WHEN,WHERE,WHILE,WINDOW,WITH,'+
+    'WITHOUT,WORK,WRITE,YEAR,YEARDAY,ZONE';
 
 procedure MakeIdentTable;
 var
synhighlightersql.pas.patch (8,403 bytes)   

Martin Friebe

2020-06-17 01:42

manager   ~0123461

Thanks, applied.

I know many lines are over 80 chars. But reformating lines that have no other change makes it impossible to see the actual change. So I restored the long lines.

Gabor Boros

2020-07-16 09:28

reporter   ~0124077

My fault because not formatted the lines properly in the original patch which create the 2.5, 3.0 and 4.0 highlighters. What do you think about a just-reformat patch?

Issue History

Date Modified Username Field Change
2020-06-14 10:46 Gabor Boros New Issue
2020-06-14 10:46 Gabor Boros File Added: synhighlightersql.pas.patch
2020-06-14 11:41 Martin Friebe Assigned To => Martin Friebe
2020-06-14 11:41 Martin Friebe Status new => assigned
2020-06-17 01:42 Martin Friebe Status assigned => resolved
2020-06-17 01:42 Martin Friebe Resolution open => fixed
2020-06-17 01:42 Martin Friebe Fixed in Version => 2.2
2020-06-17 01:42 Martin Friebe Fixed in Revision => 63366
2020-06-17 01:42 Martin Friebe LazTarget => 2.2
2020-06-17 01:42 Martin Friebe Note Added: 0123461
2020-07-16 09:28 Gabor Boros Note Added: 0124077