Running crash-me 1.61 on 'PostgreSQL 8.0'
I hope you didn't have anything important running on this server....
NOTE: You should be familiar with 'crash-me --help' before continuing!
This test will crash postgreSQL when calculating the number of joinable tables!
You should be sure that no one is doing anything important with postgreSQL
and that you have privileges to restart it!
Some of the tests you are about to execute may require a lot of
memory. Your tests WILL adversely affect system performance. It's
not uncommon that either this crash-me test program, or the actual
database back-end, will DIE with an out-of-memory error. So might
any other program on your system if it requests more memory at the
wrong time.
Note also that while crash-me tries to find limits for the database server
it will make a lot of queries that can't be categorized as 'normal'. It's
not unlikely that crash-me finds some limit bug in your server so if you
run this test you have to be prepared that your server may die during it!
We, the creators of this utility, are not responsible in any way if your
database server unexpectedly crashes while this program tries to find the
limitations of your server. By accepting the following question with 'yes',
you agree to the above!
You have been warned!
Start test (yes/no) ?
Tables without primary key: yes
SELECT without FROM: yes
Select constants: yes
Select table_name.*: yes
Allows ' and " as string markers: no
Double '' as ' in strings: yes
Multiple line strings: yes
" as identifier quote (ANSI SQL): no
` as identifier quote: no
[] as identifier quote: no
Double "" in identifiers as ": yes
Column alias: yes
Table alias: yes
Functions: yes
Group functions: yes
Group functions with distinct: yes
Group functions with several distinct: yes
Group by: yes
Group by position: yes
Group by alias: yes
Group on unused column: yes
Order by: yes
Order by position: yes
Order by function: yes
Order by on unused column: yes
Compute: no
INSERT with Value lists: no
INSERT with set syntax: no
INSERT with DEFAULT: yes
INSERT with empty value list: no
INSERT DEFAULT VALUES: yes
allows end ';': yes
LIMIT number of rows: with LIMIT
SELECT with LIMIT #,#: no
SELECT with LIMIT # OFFSET #: yes
Alter table add column: yes
Alter table add many columns: with add
Alter table change column: no
Alter table modify column: no
Alter table alter column default: yes
Alter table drop column: yes
Alter table rename table: yes
rename table: no
truncate: yes
Alter table add constraint: yes
Alter table drop constraint: yes
Alter table add unique: yes
Alter table drop unique: with constraint
Alter table add primary key: with constraint
Alter table add foreign key: yes
Alter table drop foreign key: with drop constraint
Alter table drop primary key: drop constraint
Case insensitive compare: no
Ignore end space in compare: yes
Group on column with null values: yes
Having: yes
Having with group function: yes
Order by alias: yes
Having on alias: no
binary numbers (0b1001): no
hex numbers (0x41): no
binary strings (b'0110'): yes
hex strings (x'1ace'): yes
Value of logical operation (1=1): 1
Value of TRUE: 1
Value of FALSE: 0
Simultaneous connections (installation default): 100
query size: 16777216
Keyword ABSOLUTE: no
Keyword ACCESS: no
Keyword ACTION: no
Keyword ADD: no
Keyword ADMIN: no
Keyword AFTER: no
Keyword AGGREGATE: no
Keyword ALIAS: no
Keyword ALL: yes
Keyword ALLOCATE: no
Keyword ALTER: no
Keyword ANALYZE: yes
Keyword AND: yes
Keyword ANY: yes
Keyword ARE: no
Keyword ARRAY: yes
Keyword AS: yes
Keyword ASC: yes
Keyword ASSERTION: no
Keyword ASYNC: no
Keyword AT: no
Keyword AUDIT: no
Keyword AUTHORIZATION: yes
Keyword AUTO_INCREMENT: no
Keyword AVG: no
Keyword BACKUP: no
Keyword BDB: no
Keyword BEFORE: no
Keyword BEGIN: no
Keyword BERKELEYDB: no
Keyword BETWEEN: yes
Keyword BIGINT: no
Keyword BINARY: yes
Keyword BIT: no
Keyword BIT_LENGTH: no
Keyword BLOB: no
Keyword BOOLEAN: no
Keyword BOTH: yes
Keyword BREADTH: no
Keyword BREAK: no
Keyword BROWSE: no
Keyword BTREE: no
Keyword BULK: no
Keyword BY: no
Keyword CALL: no
Keyword CASCADE: no
Keyword CASCADED: no
Keyword CASE: yes
Keyword CAST: yes
Keyword CATALOG: no
Keyword CHANGE: no
Keyword CHAR: no
Keyword CHARACTER: no
Keyword CHARACTER_LENGTH: no
Keyword CHAR_LENGTH: no
Keyword CHECK: yes
Keyword CHECKPOINT: no
Keyword CLASS: no
Keyword CLOB: no
Keyword CLOSE: no
Keyword CLUSTER: no
Keyword CLUSTERED: no
Keyword COALESCE: no
Keyword COLLATE: yes
Keyword COLLATION: no
Keyword COLUMN: yes
Keyword COLUMNS: no
Keyword COMMENT: no
Keyword COMMIT: no
Keyword COMPLETION: no
Keyword COMPRESS: no
Keyword COMPUTE: no
Keyword CONDITION: no
Keyword CONNECT: no
Keyword CONNECTION: no
Keyword CONSTRAINT: yes
Keyword CONSTRAINTS: no
Keyword CONSTRUCTOR: no
Keyword CONTAINS: no
Keyword CONTAINSTABLE: no
Keyword CONTINUE: no
Keyword CONVERT: no
Keyword CORRESPONDING: no
Keyword COUNT: no
Keyword CREATE: yes
Keyword CROSS: yes
Keyword CUBE: no
Keyword CURRENT: no
Keyword CURRENT_DATE: yes
Keyword CURRENT_PATH: no
Keyword CURRENT_ROLE: no
Keyword CURRENT_TIME: yes
Keyword CURRENT_TIMESTAMP: yes
Keyword CURRENT_USER: yes
Keyword CURSOR: no
Keyword CYCLE: no
Keyword DATA: no
Keyword DATABASE: no
Keyword DATABASES: no
Keyword DATALINK: no
Keyword DATE: no
Keyword DAY: no
Keyword DAY_HOUR: no
Keyword DAY_MINUTE: no
Keyword DAY_SECOND: no
Keyword DBCC: no
Keyword DEALLOCATE: no
Keyword DEC: no
Keyword DECIMAL: no
Keyword DECLARE: no
Keyword DEFAULT: yes
Keyword DEFERRABLE: yes
Keyword DEFERRED: no
Keyword DELAYED: no
Keyword DELETE: no
Keyword DENY: no
Keyword DEPTH: no
Keyword DEREF: no
Keyword DESC: yes
Keyword DESCRIBE: no
Keyword DESCRIPTOR: no
Keyword DESTROY: no
Keyword DESTRUCTOR: no
Keyword DETERMINISTIC: no
Keyword DIAGNOSTICS: no
Keyword DICTIONARY: no
Keyword DISCONNECT: no
Keyword DISK: no
Keyword DISTINCT: yes
Keyword DISTINCTROW: no
Keyword DISTRIBUTED: no
Keyword DO: yes
Keyword DOMAIN: no
Keyword DOUBLE: no
Keyword DROP: no
Keyword DUMMY: no
Keyword DUMP: no
Keyword DYNAMIC: no
Keyword EACH: no
Keyword ELSE: yes
Keyword ELSEIF: no
Keyword ENCLOSED: no
Keyword END: yes
Keyword END-EXEC: yes
Keyword EQUALS: no
Keyword ERRLVL: no
Keyword ERRORS: no
Keyword ESCAPE: no
Keyword ESCAPED: no
Keyword EVERY: no
Keyword EXCEPT: yes
Keyword EXCEPTION: no
Keyword EXCLUSIVE: no
Keyword EXEC: no
Keyword EXECUTE: no
Keyword EXISTS: no
Keyword EXIT: no
Keyword EXPAND: no
Keyword EXPANDING: no
Keyword EXPLAIN: no
Keyword EXTERNAL: no
Keyword EXTRACT: no
Keyword FALSE: yes
Keyword FETCH: no
Keyword FIELDS: no
Keyword FILE: no
Keyword FILLFACTOR: no
Keyword FIRST: no
Keyword FLOAT: no
Keyword FOR: yes
Keyword FOREIGN: yes
Keyword FOUND: no
Keyword FREE: no
Keyword FREETEXT: no
Keyword FREETEXTTABLE: no
Keyword FROM: yes
Keyword FULL: yes
Keyword FULLTEXT: no
Keyword FUNCTION: no
Keyword GENERAL: no
Keyword GEOMETRY: no
Keyword GET: no
Keyword GLOBAL: no
Keyword GO: no
Keyword GOTO: no
Keyword GRANT: yes
Keyword GROUP: yes
Keyword GROUPING: no
Keyword HANDLER: no
Keyword HASH: no
Keyword HAST: no
Keyword HAVING: yes
Keyword HIGH_PRIORITY: no
Keyword HOLDLOCK: no
Keyword HOST: no
Keyword HOUR: no
Keyword HOUR_MINUTE: no
Keyword HOUR_SECOND: no
Keyword IDENTIFIED: no
Keyword IDENTITY: no
Keyword IDENTITYCOL: no
Keyword IDENTITY_INSERT: no
Keyword IF: no
Keyword IGNORE: no
Keyword IMMEDIATE: no
Keyword IN: yes
Keyword INCREMENT: no
Keyword INDEX: no
Keyword INDICATOR: no
Keyword INFILE: no
Keyword INITIAL: no
Keyword INITIALIZE: no
Keyword INITIALLY: yes
Keyword INNER: yes
Keyword INNODB: no
Keyword INOUT: no
Keyword INPUT: no
Keyword INSENSITIVE: no
Keyword INSERT: no
Keyword INT: no
Keyword INTEGER: no
Keyword INTERSECT: yes
Keyword INTERVAL: no
Keyword INTO: yes
Keyword IS: yes
Keyword ISOLATION: no
Keyword ITERATE: no
Keyword JOIN: yes
Keyword KEY: no
Keyword KEYS: no
Keyword KILL: no
Keyword LANGUAGE: no
Keyword LARGE: no
Keyword LAST: no
Keyword LATERAL: no
Keyword LEADING: yes
Keyword LEAVE: no
Keyword LEFT: yes
Keyword LESS: no
Keyword LEVEL: no
Keyword LIKE: yes
Keyword LIMIT: yes
Keyword LINENO: no
Keyword LINES: no
Keyword LOAD: no
Keyword LOCAL: no
Keyword LOCALTIME: yes
Keyword LOCALTIMESTAMP: yes
Keyword LOCATOR: no
Keyword LOCK: no
Keyword LONG: no
Keyword LONGBLOB: no
Keyword LONGTEXT: no
Keyword LOOP: no
Keyword LOWER: no
Keyword LOW_PRIORITY: no
Keyword MASTER_SERVER_ID: no
Keyword MATCH: no
Keyword MAX: no
Keyword MAXEXTENTS: no
Keyword MEDIUMBLOB: no
Keyword MEDIUMINT: no
Keyword MEDIUMTEXT: no
Keyword MEETS: no
Keyword MIDDLEINT: no
Keyword MIN: no
Keyword MINUS: no
Keyword MINUTE: no
Keyword MINUTE_SECOND: no
Keyword MLSLABEL: no
Keyword MODE: no
Keyword MODIFIES: no
Keyword MODIFY: no
Keyword MODULE: no
Keyword MONTH: no
Keyword MRG_MYISAM: no
Keyword NAMES: no
Keyword NATIONAL: no
Keyword NATURAL: yes
Keyword NCHAR: no
Keyword NCLOB: no
Keyword NEW: yes
Keyword NEXT: no
Keyword NO: no
Keyword NOAUDIT: no
Keyword NOCHECK: no
Keyword NOCOMPRESS: no
Keyword NONCLUSTERED: no
Keyword NONE: no
Keyword NORMALIZE: no
Keyword NOT: yes
Keyword NOWAIT: no
Keyword NULL: yes
Keyword NULLIF: no
Keyword NUMBER: no
Keyword NUMERIC: no
Keyword OBJECT: no
Keyword OCTET_LENGTH: no
Keyword OF: no
Keyword OFF: yes
Keyword OFFLINE: no
Keyword OFFSETS: no
Keyword OID: yes
Keyword OLD: yes
Keyword ON: yes
Keyword ONLINE: no
Keyword ONLY: yes
Keyword OPEN: no
Keyword OPENDATASOURCE: no
Keyword OPENQUERY: no
Keyword OPENROWSET: no
Keyword OPENXML: no
Keyword OPERATION: no
Keyword OPERATORS: no
Keyword OPTIMIZE: no
Keyword OPTION: no
Keyword OPTIONALLY: no
Keyword OR: yes
Keyword ORDER: yes
Keyword ORDINALITY: no
Keyword OTHERS: no
Keyword OUT: no
Keyword OUTER: yes
Keyword OUTFILE: no
Keyword OUTPUT: no
Keyword OVER: no
Keyword OVERLAPS: yes
Keyword PAD: no
Keyword PARAMETER: no
Keyword PARAMETERS: no
Keyword PARTIAL: no
Keyword PATH: no
Keyword PCTFREE: no
Keyword PENDANT: no
Keyword PERCENT: no
Keyword PERIOD: no
Keyword PLAN: no
Keyword POSITION: no
Keyword POSTFIX: no
Keyword PRECEDES: no
Keyword PRECISION: no
Keyword PREFIX: no
Keyword PREORDER: no
Keyword PREPARE: no
Keyword PRESERVE: no
Keyword PRIMARY: yes
Keyword PRINT: no
Keyword PRIOR: no
Keyword PRIVATE: no
Keyword PRIVILEGES: no
Keyword PROC: no
Keyword PROCEDURE: no
Keyword PROTECTED: no
Keyword PUBLIC: no
Keyword PURGE: no
Keyword RAISERROR: no
Keyword RAW: no
Keyword READ: no
Keyword READS: no
Keyword READTEXT: no
Keyword REAL: no
Keyword RECONFIGURE: no
Keyword RECURSIVE: no
Keyword REDO: no
Keyword REF: no
Keyword REFERENCES: yes
Keyword REFERENCING: no
Keyword REGEXP: no
Keyword RELATIVE: no
Keyword RENAME: no
Keyword REPEAT: no
Keyword REPLACE: no
Keyword REPLICATION: no
Keyword REQUIRE: no
Keyword RESIGNAL: no
Keyword RESOURCE: no
Keyword RESTORE: no
Keyword RESTRICT: no
Keyword RESULT: no
Keyword RETURN: no
Keyword RETURNS: no
Keyword REVOKE: no
Keyword RIGHT: yes
Keyword RLIKE: no
Keyword ROLE: no
Keyword ROLLBACK: no
Keyword ROLLUP: no
Keyword ROUTINE: no
Keyword ROW: no
Keyword ROWCOUNT: no
Keyword ROWGUIDCOL: no
Keyword ROWID: no
Keyword ROWNUM: no
Keyword ROWS: no
Keyword RTREE: no
Keyword RULE: no
Keyword SAVE: no
Keyword SAVEPOINT: no
Keyword SCHEMA: no
Keyword SCROLL: no
Keyword SEARCH: no
Keyword SECOND: no
Keyword SECTION: no
Keyword SELECT: yes
Keyword SENSITIVE: no
Keyword SEQUENCE: no
Keyword SESSION: no
Keyword SESSION_USER: yes
Keyword SET: no
Keyword SETS: no
Keyword SETUSER: no
Keyword SHARE: no
Keyword SHOW: no
Keyword SHUTDOWN: no
Keyword SIGNAL: no
Keyword SIMILAR: yes
Keyword SIZE: no
Keyword SMALLINT: no
Keyword SOME: yes
Keyword SONAME: no
Keyword SPACE: no
Keyword SPATIAL: no
Keyword SPECIFIC: no
Keyword SPECIFICTYPE: no
Keyword SQL: no
Keyword SQLCODE: no
Keyword SQLERROR: no
Keyword SQLEXCEPTION: no
Keyword SQLSTATE: no
Keyword SQLWARNING: no
Keyword SQL_BIG_RESULT: no
Keyword SQL_CALC_FOUND_ROWS: no
Keyword SQL_SMALL_RESULT: no
Keyword SSL: no
Keyword START: no
Keyword STARTING: no
Keyword STATE: no
Keyword STATIC: no
Keyword STATISTICS: no
Keyword STRAIGHT_JOIN: no
Keyword STRIPED: no
Keyword STRUCTURE: no
Keyword SUBSTRING: no
Keyword SUCCEEDS: no
Keyword SUCCESSFUL: no
Keyword SUM: no
Keyword SYNONYM: no
Keyword SYSDATE: no
Keyword SYSTEM_USER: no
Keyword TABLE: yes
Keyword TABLES: no
Keyword TEMPORARY: no
Keyword TERMINATE: no
Keyword TERMINATED: no
Keyword TEST: no
Keyword TEXTSIZE: no
Keyword THAN: no
Keyword THEN: yes
Keyword THERE: no
Keyword TIME: no
Keyword TIMESTAMP: no
Keyword TIMEZONE_HOUR: no
Keyword TIMEZONE_MINUTE: no
Keyword TINYBLOB: no
Keyword TINYINT: no
Keyword TINYTEXT: no
Keyword TO: yes
Keyword TOP: no
Keyword TRAILING: yes
Keyword TRAN: no
Keyword TRANSACTION: no
Keyword TRANSLATE: no
Keyword TRANSLATION: no
Keyword TREAT: no
Keyword TRIGGER: no
Keyword TRIM: no
Keyword TRUE: yes
Keyword TRUNCATE: no
Keyword TSEQUAL: no
Keyword TYPE: no
Keyword TYPES: no
Keyword UID: no
Keyword UNDER: no
Keyword UNDO: no
Keyword UNION: yes
Keyword UNIQUE: yes
Keyword UNKNOWN: no
Keyword UNLOCK: no
Keyword UNSIGNED: no
Keyword UNTIL: no
Keyword UPDATE: no
Keyword UPDATETEXT: no
Keyword UPPER: no
Keyword USAGE: no
Keyword USE: no
Keyword USER: yes
Keyword USER_RESOURCES: no
Keyword USING: yes
Keyword VALIDATE: no
Keyword VALUE: no
Keyword VALUES: no
Keyword VARBINARY: no
Keyword VARCHAR: no
Keyword VARCHAR2: no
Keyword VARIABLE: no
Keyword VARYING: no
Keyword VIEW: no
Keyword VIRTUAL: no
Keyword VISIBLE: no
Keyword WAIT: no
Keyword WAITFOR: no
Keyword WARNINGS: no
Keyword WHEN: yes
Keyword WHENEVER: no
Keyword WHERE: yes
Keyword WHILE: no
Keyword WITH: no
Keyword WITHOUT: no
Keyword WORK: no
Keyword WRITE: no
Keyword WRITETEXT: no
Keyword XOR: no
Keyword YEAR: no
Keyword YEAR_MONTH: no
Keyword ZEROFILL: no
Keyword ZONE: no
Supported sql types
Type character(1 arg): yes
Type char(1 arg): yes
Type char varying(1 arg): yes
Type character varying(1 arg): yes
Type boolean: yes
Type varchar(1 arg): yes
Type integer: yes
Type int: yes
Type smallint: yes
Type numeric(2 arg): yes
Type decimal(2 arg): yes
Type dec(2 arg): yes
Type bit: yes
Type bit(1 arg): yes
Type bit varying(1 arg): yes
Type float: yes
Type float(1 arg): yes
Type real: yes
Type double precision: yes
Type date: yes
Type time: yes
Type timestamp: yes
Type interval year: yes
Type interval year to month: yes
Type interval month: yes
Type interval day: yes
Type interval day to hour: yes
Type interval day to minute: yes
Type interval day to second: yes
Type interval hour: yes
Type interval hour to minute: yes
Type interval hour to second: yes
Type interval minute: yes
Type interval minute to second: yes
Type interval second: yes
Type national character varying(1 arg): yes
Type national character(1 arg): yes
Type nchar(1 arg): yes
Type national char varying(1 arg): yes
Type nchar varying(1 arg): yes
Type national character varying(1 arg): yes
Type timestamp with time zone: yes
Supported odbc types
Type binary(1 arg): no
Type varbinary(1 arg): no
Type tinyint: no
Type bigint: yes
Type datetime: no
Supported extra types
Type blob: no
Type byte: no
Type long varbinary: no
Type image: no
Type text: yes
Type text(1 arg): no
Type mediumtext: no
Type long varchar(1 arg): no
Type varchar2(1 arg): no
Type mediumint: no
Type middleint: no
Type int unsigned: no
Type int1: no
Type int2: yes
Type int3: no
Type int4: yes
Type int8: yes
Type uint: no
Type money: yes
Type smallmoney: no
Type float4: yes
Type float8: yes
Type smallfloat: no
Type float(2 arg): no
Type double: no
Type enum(1 arg): no
Type set(1 arg): no
Type int(1 arg) zerofill: no
Type serial: yes
Type char(1 arg) binary: no
Type int not null auto_increment: no
Type abstime: yes
Type year: no
Type datetime: no
Type smalldatetime: no
Type timespan: no
Type reltime: yes
Type int not null identity: no
Type box: yes
Type bool: yes
Type circle: yes
Type polygon: yes
Type point: yes
Type line: yes
Type lseg: yes
Type path: yes
Type interval: yes
Type inet: yes
Type cidr: yes
Type macaddr: yes
Type varchar2(1 arg): no
Type nvarchar2(1 arg): no
Type number(2 arg): no
Type number(1 arg): no
Type number: no
Type long: no
Type raw(1 arg): no
Type long raw: no
Type rowid: no
Type mlslabel: no
Type clob: no
Type nclob: no
Type bfile: no
Remembers end space in char(): no
Remembers end space in varchar(): yes
Storage of float values: round
Type for row id: oid
Automatic row id: no
Supported sql functions
Function +, -, * and /: yes
Function ANSI SQL SUBSTRING: yes
Function BIT_LENGTH: yes
Function searched CASE: yes
Function simple CASE: yes
Function CAST: yes
Function CHARACTER_LENGTH: yes
Function CHAR_LENGTH: error
Function CHAR_LENGTH(constant): yes
Function COALESCE: yes
Function CURRENT_DATE: yes
Function CURRENT_TIME: yes
Function CURRENT_TIMESTAMP: yes
Function EXTRACT: yes
Function LOCALTIME: yes
Function LOCALTIMESTAMP: yes
Function LOWER: yes
Function NULLIF with strings: yes
Function NULLIF with numbers: yes
Function OCTET_LENGTH: yes
Function POSITION: yes
Function TRIM: yes
Function UPPER: yes
Function concatenation with ||: yes
Supported odbc functions
Function ASCII: yes
Function CHAR: no
Function CHAR: no
Function CONCAT(2 arg): no
Function CONCAT(2 arg): no
Function DIFFERENCE(): no
Function DIFFERENCE(): no
Function INSERT: no
Function INSERT: no
Function LEFT: no
Function LEFT: no
Function LTRIM: yes
Function REAL LENGTH: yes
Function ODBC LENGTH: error
Function ODBC LENGTH: no
Function LOCATE(2 arg): no
Function LOCATE(2 arg): no
Function LOCATE(3 arg): no
Function LOCATE(3 arg): no
Function LCASE: no
Function LCASE: no
Function REPEAT: yes
Function REPLACE: yes
Function RIGHT: no
Function RIGHT: no
Function RTRIM: yes
Function SPACE: no
Function SPACE: no
Function SOUNDEX: no
Function SOUNDEX: no
Function ODBC SUBSTRING: yes
Function UCASE: no
Function UCASE: no
Function ABS: yes
Function ACOS: yes
Function ASIN: yes
Function ATAN: yes
Function ATAN2: yes
Function CEILING: yes
Function COS: yes
Function COT: yes
Function DEGREES: yes
Function EXP: yes
Function FLOOR: yes
Function LOG: error
Function LOG: no
Function LOG10: no
Function LOG10: no
Function MOD: yes
Function PI: yes
Function POWER: yes
Function RAND: no
Function RAND: no
Function RADIANS: yes
Function ROUND(2 arg): yes
Function SIGN: yes
Function SIN: yes
Function SQRT: yes
Function TAN: yes
Function TRUNCATE: no
Function TRUNCATE: no
Function NOW: yes
Function CURDATE: no
Function CURDATE: no
Function CURTIME: no
Function CURTIME: no
Function TIMESTAMPADD: no
Function TIMESTAMPADD: no
Function TIMESTAMPDIFF: no
Function TIMESTAMPDIFF: no
Function USER(): no
Function USER(): no
Function DATABASE: no
Function DATABASE: no
Function IFNULL: no
Function IFNULL: no
Function ODBC syntax LEFT & RIGHT: no
Function ODBC syntax LEFT & RIGHT: no
Supported extra functions
Function & (bitwise and): yes
Function | (bitwise or): yes
Function << and >> (bitwise shifts): yes
Function <> in SELECT: yes
Function =: yes
Function ~* (case insensitive compare): yes
Function AND and OR in SELECT: yes
Function AND as '&&': no
Function ASCII_CHAR: no
Function ASCII_CODE: no
Function ATN2: no
Function BETWEEN in SELECT: yes
Function BIT_COUNT: no
Function CEIL: yes
Function CHARINDEX: no
Function CHR: yes
Function CONCAT(list): no
Function CONVERT: no
Function COSH: no
Function ELT: no
Function ENCRYPT: no
Function FIELD: no
Function FORMAT: no
Function GETDATE: no
Function GREATEST: no
Function IF: no
Function IN on numbers in SELECT: yes
Function IN on strings in SELECT: yes
Function INITCAP: yes
Function INSTR (Oracle syntax): no
Function INSTRB: no
Function INTERVAL: no
Function LAST_INSERT_ID: no
Function LEAST: no
Function LENGTHB: no
Function LIKE ESCAPE in SELECT: yes
Function LIKE in SELECT: yes
Function LN: yes
Function LOCATE as INSTR: no
Function LOG(m,n): yes
Function LOGN: no
Function LPAD: yes
Function MOD as %: yes
Function NOT BETWEEN in SELECT: yes
Function NOT LIKE in SELECT: yes
Function NOT as '!' in SELECT: no
Function NOT in SELECT: yes
Function ODBC CONVERT: no
Function OR as '||': no
Function PASSWORD: no
Function PASTE: no
Function PATINDEX: no
Function POW: yes
Function RANGE: no
Function REGEXP in SELECT: no
Function REPLICATE: no
Function REVERSE: no
Function ROOT: no
Function ROUND(1 arg): yes
Function RPAD: yes
Function SINH: no
Function STR: no
Function STRCMP: no
Function STUFF: no
Function SUBSTRB: no
Function SUBSTRING as MID: no
Function SUBSTRING_INDEX: no
Function SYSDATE: no
Function TAIL: no
Function TANH: no
Function TRANSLATE: yes
Function TRIM; Many char extension: yes
Function TRIM; Substring extension: error
Function TRUNC: yes
Function UID: no
Function UNIX_TIMESTAMP: no
Function USERENV: no
Function VERSION: yes
Function automatic num->string convert: no
Function automatic string->num convert: yes
Function concatenation with +: no
Function SUBSTR (2 arg): yes
Function SUBSTR (3 arg): yes
Function LFILL (3 arg): no
Function RFILL (3 arg): no
Function RPAD (4 arg): no
Function TRIM (1 arg): yes
Function TRIM (2 arg): yes
Function LTRIM (2 arg): yes
Function RTRIM (2 arg): yes
Function EXPAND: no
Function REPLACE (2 arg) : no
Function MAPCHAR: no
Function ALPHA: no
Function ASCII in string cast: error
Function EBCDIC in string cast: no
Function TRUNC (1 arg): yes
Function FIXED: no
Function FLOAT: no
Function LENGTH: error
Function INDEX: no
Function MICROSECOND: no
Function TIMESTAMP: no
Function VALUE: no
Function DECODE: no
Function NUM: no
Function CHR (any type to string): error
Function HEX: no
Supported where functions
Function = ALL: yes
Function = ANY: yes
Function = SOME: yes
Function BETWEEN: yes
Function EXISTS: yes
Function IN on numbers: yes
Function LIKE ESCAPE: yes
Function LIKE: yes
Function MATCH UNIQUE: no
Function MATCH: no
Function MATCHES: no
Function NOT BETWEEN: yes
Function NOT EXISTS: yes
Function NOT LIKE: yes
Function NOT UNIQUE: no
Function UNIQUE: no
Supported sql group functions
Group function AVG: yes
Group function COUNT (*): yes
Group function COUNT column name: yes
Group function COUNT(DISTINCT expr): yes
Group function MAX on numbers: yes
Group function MAX on strings: yes
Group function MIN on numbers: yes
Group function MIN on strings: yes
Group function SUM: yes
Group function ANY: no
Group function EVERY: no
Group function SOME: no
Supported extra group functions
Group function BIT_AND: yes
Group function BIT_OR: yes
Group function COUNT(DISTINCT expr,expr,...): no
Group function STD: no
Group function STDDEV: yes
Group function VARIANCE: yes
mixing of integer and float in expression: yes
No need to cast from integer to float: yes
Is 1+NULL = NULL: yes
Is 'a' || NULL = NULL: yes
NOROUND: no
Supports YYYY-MM-DD (ISO) format: yes
Supports DATE 'YYYY-MM-DD' (ISO) format: yes
Supports DD.MM.YYYY (EUR) format: no
Supports DATE 'DD.MM.YYYY' (EUR) format: no
Supports YYYYMMDD format: yes
Supports DATE 'YYYYMMDD' format: yes
Supports MM/DD/YYYY format: yes
Supports DATE 'MM/DD/YYYY' format: yes
Supports 0000-00-00 dates: no
Supports 0001-01-01 dates: yes
Supports 9999-12-31 dates: yes
Supports 'infinity dates: no
Supports YY-MM-DD dates: no
WEEK: no
Function DAYNAME: no
Function MONTH: no
Function MONTHNAME: no
Function DAYOFMONTH: no
Function DAYOFWEEK: no
Function DAYOFYEAR: no
Function QUARTER: no
Function YEAR: no
Function DATEADD: no
Function MDY: no
Function DATEDIFF: no
Function DATENAME: no
Function DATEPART: no
Function DATE_FORMAT: no
Function FROM_DAYS: no
Function FROM_UNIXTIME: no
Function MONTHS_BETWEEN: no
Function PERIOD_ADD: no
Function PERIOD_DIFF: no
Function WEEKDAY: no
Function ADDDATE: no
Function SUBDATE: no
Function DATEDIFF (2 arg): no
Function WEEKOFYEAR: no
Function CHAR (conversation date): no
Function MAKEDATE: no
Function TO_DAYS: no
Function ADD_MONTHS: no
Function LAST_DAY: no
Function DATE: yes
Function DAY: no
Supports HH:MM:SS (ISO) time format: yes
Supports HH.MM.SS (EUR) time format: no
Supports HHHHmmSS time format: no
Supports HHmmSS time format: no
Supports HH:MM:SS (AM|PM) time format: yes
Function HOUR: no
Function ANSI HOUR: no
Function MINUTE: no
Function SECOND: no
Function TIME_TO_SEC: no
Function SEC_TO_TIME: no
Function ADDTIME: no
Function SUBTIME: no
Function TIMEDIFF: no
Function MAKETIME: no
Function TIME: no
NOT ID BETWEEN interprets as ID NOT BETWEEN:yes
LIKE on numbers: yes
column LIKE column: yes
update of column= -column: yes
String functions on date columns: yes
char are space filled: no
Update with many tables: no
DELETE FROM table1,table2...: no
Update with sub select: yes
Calculate 1--1: no
ANSI SQL simple joins: yes
max text or blob size: +8000000
constant string size in where: 16777181
constant string size in SELECT: 16777207
return string size from function: +8000000
simple expressions: +10000
big expressions: +100
stacked expressions: +2000
OR and AND in WHERE: 11907
tables in join: +64
primary key in create table: yes
unique in create table: yes
unique null in create: yes
default value for column: yes
default value function for column: yes
temporary tables: yes
create table from select: with AS
index in create table: no
create index: yes
drop index: yes
null in index: yes
null in unique index: yes
null combination in unique index: yes
null in unique index: yes
index on column part (extension): no
different namespace for index: no
case independent table names: yes
case independent field names: yes
drop table if exists: no
create table if not exists: no
inner join: yes
left outer join: yes
natural left outer join: yes
left outer join using: yes
left outer join odbc style: no
right outer join: yes
full outer join: yes
cross join (same as from a,b): yes
natural join: yes
union: yes
union all: yes
intersect: yes
intersect all: yes
except: yes
except all: yes
except: yes
except all: yes
minus: no
natural join (incompatible lists): yes
union (incompatible lists): yes
union all (incompatible lists): yes
intersect (incompatible lists): no
intersect all (incompatible lists): no
except (incompatible lists): no
except all (incompatible lists): no
except (incompatible lists): no
except all (incompatible lists): no
minus (incompatible lists): no
subqueries: yes
recursive subqueries: +64
insert INTO ... SELECT ...: yes
transactions: yes
rollback_metadata: yes
atomic updates: no
views: yes
foreign keys: yes
allows to update of foreign key values: no
Create SCHEMA: yes
Circular foreign keys: no
CHARACTER_LENGTH(varchar_field) = actual length
Column constraints=yes
Table constraints=yes
Named constraints=yes
NULL constraint (SyBase style): yes
Triggers (ANSI SQL): no
PSM procedures (ANSI SQL): no
PSM modules (ANSI SQL): no
PSM functions (ANSI SQL): no
Domains (ANSI SQL): yes
lock table: no
lock table: yes
many tables to drop table: yes
drop table with cascade/restrict: yes
-- as comment (ANSI): yes
// as comment: no
# as comment: no
/* */ as comment: yes
insert empty string: yes
Having with alias: no
table name length: +512
column name length: +512
select alias name length: +512
table alias name length: +512
index name length: +512
max char() size: +8000000
max varchar() size: +8000000
max text or blob size: +8000000 (cache)
Columns in table: 1600
unique indexes: +64
index parts: 32
max index part length: 235328
index varchar part length: 235328
indexes: +64
index length: +8192
max table row length (without blobs): 103275
table row length with nulls (without blobs): 103275
number of columns in order by: +64
number of columns in group by: +64
safe decimal arithmetic=yes
Where is null values in sorted recordset=last
Where is null values in sorted recordset (DESC)=first
Group by always sorted=no
crash-me safe: yes
reconnected 0 times
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
