Running crash-me 1.61 on 'MySQL 4.1.11/'
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 should not crash MySQL if it was distributed together with the
running MySQL version.
If this is the case you can probably continue without having to worry about
destroying something.
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: yes
Double '' as ' in strings: yes
Multiple line strings: yes
" as identifier quote (ANSI SQL): error
` as identifier quote: yes
[] as identifier quote: no
Double "" in identifiers as ": no
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: yes
INSERT with set syntax: yes
INSERT with DEFAULT: yes
INSERT with empty value list: no
INSERT DEFAULT VALUES: no
allows end ';': yes
LIMIT number of rows: with LIMIT
SELECT with LIMIT #,#: yes
SELECT with LIMIT # OFFSET #: yes
Alter table add column: yes
Alter table add many columns: yes
Alter table change column: yes
Alter table modify column: yes
Alter table alter column default: yes
Alter table drop column: yes
Alter table rename table: yes
rename table: yes
truncate: yes
Alter table add constraint: yes
Alter table drop constraint: no
Alter table add unique: yes
Alter table drop unique: with drop key
Alter table add primary key: with constraint
Alter table add foreign key: yes
Alter table drop foreign key: with drop foreign key
Alter table drop primary key: drop primary key
Case insensitive compare: yes
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: yes
binary numbers (0b1001): no
hex numbers (0x41): yes
binary strings (b'0110'): no
hex strings (x'1ace'): yes
Value of logical operation (1=1): 1
Value of TRUE: 1
Value of FALSE: 0
Simultaneous connections (installation default): 99
query size: 1048574
Keyword ABSOLUTE: no
Keyword ACCESS: no
Keyword ACTION: no
Keyword ADD: yes
Keyword ADMIN: no
Keyword AFTER: no
Keyword AGGREGATE: no
Keyword ALIAS: no
Keyword ALL: yes
Keyword ALLOCATE: no
Keyword ALTER: yes
Keyword ANALYZE: yes
Keyword AND: yes
Keyword ANY: no
Keyword ARE: no
Keyword ARRAY: no
Keyword AS: yes
Keyword ASC: yes
Keyword ASSERTION: no
Keyword ASYNC: no
Keyword AT: no
Keyword AUDIT: no
Keyword AUTHORIZATION: no
Keyword AUTO_INCREMENT: no
Keyword AVG: no
Keyword BACKUP: no
Keyword BDB: no
Keyword BEFORE: yes
Keyword BEGIN: no
Keyword BERKELEYDB: no
Keyword BETWEEN: yes
Keyword BIGINT: yes
Keyword BINARY: yes
Keyword BIT: no
Keyword BIT_LENGTH: no
Keyword BLOB: yes
Keyword BOOLEAN: no
Keyword BOTH: yes
Keyword BREADTH: no
Keyword BREAK: no
Keyword BROWSE: no
Keyword BTREE: no
Keyword BULK: no
Keyword BY: yes
Keyword CALL: no
Keyword CASCADE: yes
Keyword CASCADED: no
Keyword CASE: yes
Keyword CAST: no
Keyword CATALOG: no
Keyword CHANGE: yes
Keyword CHAR: yes
Keyword CHARACTER: yes
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: yes
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: yes
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: yes
Keyword DATABASES: yes
Keyword DATALINK: no
Keyword DATE: no
Keyword DAY: no
Keyword DAY_HOUR: yes
Keyword DAY_MINUTE: yes
Keyword DAY_SECOND: yes
Keyword DBCC: no
Keyword DEALLOCATE: no
Keyword DEC: yes
Keyword DECIMAL: yes
Keyword DECLARE: no
Keyword DEFAULT: yes
Keyword DEFERRABLE: no
Keyword DEFERRED: no
Keyword DELAYED: yes
Keyword DELETE: yes
Keyword DENY: no
Keyword DEPTH: no
Keyword DEREF: no
Keyword DESC: yes
Keyword DESCRIBE: yes
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: yes
Keyword DISTRIBUTED: no
Keyword DO: no
Keyword DOMAIN: no
Keyword DOUBLE: yes
Keyword DROP: yes
Keyword DUMMY: no
Keyword DUMP: no
Keyword DYNAMIC: no
Keyword EACH: no
Keyword ELSE: yes
Keyword ELSEIF: no
Keyword ENCLOSED: yes
Keyword END: no
Keyword END-EXEC: yes
Keyword EQUALS: no
Keyword ERRLVL: no
Keyword ERRORS: no
Keyword ESCAPE: no
Keyword ESCAPED: yes
Keyword EVERY: no
Keyword EXCEPT: no
Keyword EXCEPTION: no
Keyword EXCLUSIVE: no
Keyword EXEC: no
Keyword EXECUTE: no
Keyword EXISTS: yes
Keyword EXIT: no
Keyword EXPAND: no
Keyword EXPANDING: no
Keyword EXPLAIN: yes
Keyword EXTERNAL: no
Keyword EXTRACT: no
Keyword FALSE: yes
Keyword FETCH: no
Keyword FIELDS: yes
Keyword FILE: no
Keyword FILLFACTOR: no
Keyword FIRST: no
Keyword FLOAT: yes
Keyword FOR: yes
Keyword FOREIGN: yes
Keyword FOUND: no
Keyword FREE: no
Keyword FREETEXT: no
Keyword FREETEXTTABLE: no
Keyword FROM: yes
Keyword FULL: no
Keyword FULLTEXT: yes
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: yes
Keyword HOLDLOCK: no
Keyword HOST: no
Keyword HOUR: no
Keyword HOUR_MINUTE: yes
Keyword HOUR_SECOND: yes
Keyword IDENTIFIED: no
Keyword IDENTITY: no
Keyword IDENTITYCOL: no
Keyword IDENTITY_INSERT: no
Keyword IF: yes
Keyword IGNORE: yes
Keyword IMMEDIATE: no
Keyword IN: yes
Keyword INCREMENT: no
Keyword INDEX: yes
Keyword INDICATOR: no
Keyword INFILE: yes
Keyword INITIAL: no
Keyword INITIALIZE: no
Keyword INITIALLY: no
Keyword INNER: yes
Keyword INNODB: no
Keyword INOUT: no
Keyword INPUT: no
Keyword INSENSITIVE: no
Keyword INSERT: yes
Keyword INT: yes
Keyword INTEGER: yes
Keyword INTERSECT: no
Keyword INTERVAL: yes
Keyword INTO: yes
Keyword IS: yes
Keyword ISOLATION: no
Keyword ITERATE: no
Keyword JOIN: yes
Keyword KEY: yes
Keyword KEYS: yes
Keyword KILL: yes
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: yes
Keyword LOAD: yes
Keyword LOCAL: no
Keyword LOCALTIME: yes
Keyword LOCALTIMESTAMP: yes
Keyword LOCATOR: no
Keyword LOCK: yes
Keyword LONG: yes
Keyword LONGBLOB: yes
Keyword LONGTEXT: yes
Keyword LOOP: no
Keyword LOWER: no
Keyword LOW_PRIORITY: yes
Keyword MASTER_SERVER_ID: no
Keyword MATCH: yes
Keyword MAX: no
Keyword MAXEXTENTS: no
Keyword MEDIUMBLOB: yes
Keyword MEDIUMINT: yes
Keyword MEDIUMTEXT: yes
Keyword MEETS: no
Keyword MIDDLEINT: yes
Keyword MIN: no
Keyword MINUS: no
Keyword MINUTE: no
Keyword MINUTE_SECOND: yes
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: no
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: yes
Keyword OBJECT: no
Keyword OCTET_LENGTH: no
Keyword OF: no
Keyword OFF: no
Keyword OFFLINE: no
Keyword OFFSETS: no
Keyword OID: no
Keyword OLD: no
Keyword ON: yes
Keyword ONLINE: no
Keyword ONLY: no
Keyword OPEN: no
Keyword OPENDATASOURCE: no
Keyword OPENQUERY: no
Keyword OPENROWSET: no
Keyword OPENXML: no
Keyword OPERATION: no
Keyword OPERATORS: no
Keyword OPTIMIZE: yes
Keyword OPTION: yes
Keyword OPTIONALLY: yes
Keyword OR: yes
Keyword ORDER: yes
Keyword ORDINALITY: no
Keyword OTHERS: no
Keyword OUT: no
Keyword OUTER: yes
Keyword OUTFILE: yes
Keyword OUTPUT: no
Keyword OVER: no
Keyword OVERLAPS: no
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: yes
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: yes
Keyword PROC: no
Keyword PROCEDURE: yes
Keyword PROTECTED: no
Keyword PUBLIC: no
Keyword PURGE: yes
Keyword RAISERROR: no
Keyword RAW: no
Keyword READ: yes
Keyword READS: no
Keyword READTEXT: no
Keyword REAL: yes
Keyword RECONFIGURE: no
Keyword RECURSIVE: no
Keyword REDO: no
Keyword REF: no
Keyword REFERENCES: yes
Keyword REFERENCING: no
Keyword REGEXP: yes
Keyword RELATIVE: no
Keyword RENAME: yes
Keyword REPEAT: no
Keyword REPLACE: yes
Keyword REPLICATION: no
Keyword REQUIRE: yes
Keyword RESIGNAL: no
Keyword RESOURCE: no
Keyword RESTORE: no
Keyword RESTRICT: yes
Keyword RESULT: no
Keyword RETURN: no
Keyword RETURNS: no
Keyword REVOKE: yes
Keyword RIGHT: yes
Keyword RLIKE: yes
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: no
Keyword SET: yes
Keyword SETS: no
Keyword SETUSER: no
Keyword SHARE: no
Keyword SHOW: yes
Keyword SHUTDOWN: no
Keyword SIGNAL: no
Keyword SIMILAR: no
Keyword SIZE: no
Keyword SMALLINT: yes
Keyword SOME: no
Keyword SONAME: yes
Keyword SPACE: no
Keyword SPATIAL: yes
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: yes
Keyword SQL_CALC_FOUND_ROWS: yes
Keyword SQL_SMALL_RESULT: yes
Keyword SSL: yes
Keyword START: no
Keyword STARTING: yes
Keyword STATE: no
Keyword STATIC: no
Keyword STATISTICS: no
Keyword STRAIGHT_JOIN: yes
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: yes
Keyword TEMPORARY: no
Keyword TERMINATE: no
Keyword TERMINATED: yes
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: yes
Keyword TINYINT: yes
Keyword TINYTEXT: yes
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: yes
Keyword UNSIGNED: yes
Keyword UNTIL: no
Keyword UPDATE: yes
Keyword UPDATETEXT: no
Keyword UPPER: no
Keyword USAGE: yes
Keyword USE: yes
Keyword USER: no
Keyword USER_RESOURCES: no
Keyword USING: yes
Keyword VALIDATE: no
Keyword VALUE: no
Keyword VALUES: yes
Keyword VARBINARY: yes
Keyword VARCHAR: yes
Keyword VARCHAR2: no
Keyword VARIABLE: no
Keyword VARYING: yes
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: yes
Keyword WITHOUT: no
Keyword WORK: no
Keyword WRITE: yes
Keyword WRITETEXT: no
Keyword XOR: yes
Keyword YEAR: no
Keyword YEAR_MONTH: yes
Keyword ZEROFILL: yes
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): no
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: no
Type interval year to month: no
Type interval month: no
Type interval day: no
Type interval day to hour: no
Type interval day to minute: no
Type interval day to second: no
Type interval hour: no
Type interval hour to minute: no
Type interval hour to second: no
Type interval minute: no
Type interval minute to second: no
Type interval second: no
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: no
Supported odbc types
Type binary(1 arg): yes
Type varbinary(1 arg): yes
Type tinyint: yes
Type bigint: yes
Type datetime: yes
Supported extra types
Type blob: yes
Type byte: no
Type long varbinary: yes
Type image: no
Type text: yes
Type text(1 arg): yes
Type mediumtext: yes
Type long varchar(1 arg): no
Type varchar2(1 arg): no
Type mediumint: yes
Type middleint: yes
Type int unsigned: yes
Type int1: yes
Type int2: yes
Type int3: yes
Type int4: yes
Type int8: yes
Type uint: no
Type money: no
Type smallmoney: no
Type float4: yes
Type float8: yes
Type smallfloat: no
Type float(2 arg): yes
Type double: yes
Type enum(1 arg): yes
Type set(1 arg): yes
Type int(1 arg) zerofill: yes
Type serial: yes
Type char(1 arg) binary: yes
Type int not null auto_increment: yes
Type abstime: no
Type year: yes
Type datetime: yes
Type smalldatetime: no
Type timespan: no
Type reltime: no
Type int not null identity: no
Type box: no
Type bool: yes
Type circle: no
Type polygon: yes
Type point: yes
Type line: no
Type lseg: no
Type path: no
Type interval: no
Type inet: no
Type cidr: no
Type macaddr: no
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: yes
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(): no
Storage of float values: round
Type for row id: auto_increment
Automatic row id: _rowid
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 ||: error
Supported odbc functions
Function ASCII: yes
Function CHAR: yes
Function CONCAT(2 arg): yes
Function DIFFERENCE(): no
Function DIFFERENCE(): no
Function INSERT: yes
Function LEFT: yes
Function LTRIM: yes
Function REAL LENGTH: yes
Function ODBC LENGTH: error
Function ODBC LENGTH: error
Function LOCATE(2 arg): yes
Function LOCATE(3 arg): yes
Function LCASE: yes
Function REPEAT: yes
Function REPLACE: yes
Function RIGHT: yes
Function RTRIM: yes
Function SPACE: yes
Function SOUNDEX: yes
Function ODBC SUBSTRING: yes
Function UCASE: yes
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: yes
Function LOG10: yes
Function MOD: yes
Function PI: yes
Function POWER: yes
Function RAND: yes
Function RADIANS: yes
Function ROUND(2 arg): yes
Function SIGN: yes
Function SIN: yes
Function SQRT: yes
Function TAN: yes
Function TRUNCATE: yes
Function NOW: yes
Function CURDATE: yes
Function CURTIME: yes
Function TIMESTAMPADD: no
Function TIMESTAMPADD: no
Function TIMESTAMPDIFF: no
Function TIMESTAMPDIFF: no
Function USER(): yes
Function DATABASE: yes
Function IFNULL: yes
Function ODBC syntax LEFT & RIGHT: yes
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): no
Function AND and OR in SELECT: yes
Function AND as '&&': yes
Function ASCII_CHAR: no
Function ASCII_CODE: no
Function ATN2: no
Function BETWEEN in SELECT: yes
Function BIT_COUNT: yes
Function CEIL: yes
Function CHARINDEX: no
Function CHR: no
Function CONCAT(list): yes
Function CONVERT: no
Function COSH: no
Function ELT: yes
Function ENCRYPT: yes
Function FIELD: yes
Function FORMAT: yes
Function GETDATE: no
Function GREATEST: yes
Function IF: yes
Function IN on numbers in SELECT: yes
Function IN on strings in SELECT: yes
Function INITCAP: no
Function INSTR (Oracle syntax): no
Function INSTRB: no
Function INTERVAL: yes
Function LAST_INSERT_ID: yes
Function LEAST: yes
Function LENGTHB: no
Function LIKE ESCAPE in SELECT: yes
Function LIKE in SELECT: yes
Function LN: yes
Function LOCATE as INSTR: yes
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: yes
Function NOT in SELECT: yes
Function ODBC CONVERT: no
Function OR as '||': yes
Function PASSWORD: yes
Function PASTE: no
Function PATINDEX: no
Function POW: yes
Function RANGE: no
Function REGEXP in SELECT: yes
Function REPLICATE: no
Function REVERSE: yes
Function ROOT: no
Function ROUND(1 arg): yes
Function RPAD: yes
Function SINH: no
Function STR: no
Function STRCMP: yes
Function STUFF: no
Function SUBSTRB: no
Function SUBSTRING as MID: yes
Function SUBSTRING_INDEX: yes
Function SYSDATE: yes
Function TAIL: no
Function TANH: no
Function TRANSLATE: no
Function TRIM; Many char extension: error
Function TRIM; Substring extension: yes
Function TRUNC: no
Function UID: no
Function UNIX_TIMESTAMP: yes
Function USERENV: no
Function VERSION: yes
Function automatic num->string convert: yes
Function automatic string->num convert: yes
Function concatenation with +: error
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): no
Function LTRIM (2 arg): no
Function RTRIM (2 arg): no
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): no
Function FIXED: no
Function FLOAT: no
Function LENGTH: error
Function INDEX: no
Function MICROSECOND: yes
Function TIMESTAMP: error
Function VALUE: no
Function DECODE: no
Function NUM: no
Function CHR (any type to string): no
Function HEX: yes
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,...): yes
Group function STD: yes
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 concat('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: error
Supports DATE 'DD.MM.YYYY' (EUR) format: error
Supports YYYYMMDD format: yes
Supports DATE 'YYYYMMDD' format: yes
Supports MM/DD/YYYY format: error
Supports DATE 'MM/DD/YYYY' format: error
Supports 0000-00-00 dates: yes
Supports 0001-01-01 dates: yes
Supports 9999-12-31 dates: yes
Supports 'infinity dates: error
Supports YY-MM-DD dates: yes
Supports YY-MM-DD 2000 compilant dates: yes
WEEK: USA
Function DAYNAME: yes
Function MONTH: yes
Function MONTHNAME: yes
Function DAYOFMONTH: yes
Function DAYOFWEEK: yes
Function DAYOFYEAR: yes
Function QUARTER: yes
Function YEAR: yes
Function DATEADD: no
Function MDY: no
Function DATEDIFF: no
Function DATENAME: no
Function DATEPART: no
Function DATE_FORMAT: yes
Function FROM_DAYS: yes
Function FROM_UNIXTIME: yes
Function MONTHS_BETWEEN: no
Function PERIOD_ADD: yes
Function PERIOD_DIFF: yes
Function WEEKDAY: yes
Function ADDDATE: yes
Function SUBDATE: yes
Function DATEDIFF (2 arg): yes
Function WEEKOFYEAR: yes
Function CHAR (conversation date): no
Function MAKEDATE: yes
Function TO_DAYS: yes
Function ADD_MONTHS: no
Function LAST_DAY: yes
Function DATE: yes
Function DAY: yes
Supports HH:MM:SS (ISO) time format: yes
Supports HH.MM.SS (EUR) time format: error
Supports HHHHmmSS time format: yes
Supports HHmmSS time format: yes
Supports HH:MM:SS (AM|PM) time format: error
Function HOUR: yes
Function ANSI HOUR: yes
Function MINUTE: yes
Function SECOND: yes
Function TIME_TO_SEC: yes
Function SEC_TO_TIME: yes
Function ADDTIME: yes
Function SUBTIME: yes
Function TIMEDIFF: yes
Function MAKETIME: yes
Function TIME: yes
NOT ID BETWEEN interprets as ID NOT BETWEEN:no
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: yes
DELETE FROM table1,table2...: yes
Update with sub select: yes
Calculate 1--1: yes
ANSI SQL simple joins: yes
max text or blob size: 1048543
constant string size in where: 1048539
constant string size in SELECT: 1048565
return string size from function: 1048576
simple expressions: 1658
big expressions: 10
stacked expressions: 1658
OR and AND in WHERE: 42830
tables in join: 61
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: no
temporary tables: yes
create table from select: yes
index in create table: yes
create index: yes
drop index: with 'ON'
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): yes
different namespace for index: yes
case independent table names: no
case independent field names: yes
drop table if exists: yes
create table if not exists: yes
inner join: yes
left outer join: yes
natural left outer join: yes
left outer join using: yes
left outer join odbc style: yes
right outer join: yes
full outer join: no
cross join (same as from a,b): yes
natural join: yes
union: yes
union all: yes
intersect: no
intersect all: no
except: no
except all: no
except: no
except all: no
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: no
atomic updates: no
views: no
foreign keys: syntax only
Create SCHEMA: no
CHARACTER_LENGTH(varchar_field) = actual length
Column constraints=syntax only
Table constraints=syntax only
Named constraints=syntax only
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): 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: yes
/* */ as comment: yes
insert empty string: yes
Having with alias: yes
table name length: 64
column name length: 64
select alias name length: +512
table alias name length: +512
index name length: 64
max char() size: 1048543
max varchar() size: 1048543
max text or blob size: 1048543 (cache)
Columns in table: 2599
unique indexes: +64
index parts: 16
max index part length: 255
index varchar part length: 255
indexes: +64
index length: 1000
max table row length (without blobs): 65534
table row length with nulls (without blobs): 65502
number of columns in order by: +64
number of columns in group by: +64
safe decimal arithmetic=no
Where is null values in sorted recordset=first
Where is null values in sorted recordset (DESC)=last
Group by always sorted=yes
crash-me safe: yes
reconnected 0 times
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
