Prev: Does ANYBODY think this video is a good example of Bibliomancy?
Next: OBOPO ORO OPOBO
From: marty.musatov on 29 Mar 2010 02:21
#This file is automaticly generated by crash-me 1.61

NEG=yes # update of column= -column
###< create table crash_q (a integer)
###> OK
###< insert into crash_q values(10)
###> OK
###< update crash_q set a=-a
###> OK
###< drop table crash_q
###> OK
###
###As far as all queries returned OK, result is YES
Need_cast_for_null=no # Need to cast NULL for arithmetic
### Check if numeric_null (NULL) is 'NULL'
alter_add_col=yes # Alter table add column
###< alter table crash_q add d integer
###> OK
###
###As far as all queries returned OK, result is YES
alter_add_constraint=yes # Alter table add constraint
###< alter table crash_q add constraint c2 check(a > b)
###> OK
###
###As far as all queries returned OK, result is YES
alter_add_foreign_key=no # Alter table add foreign key
###< alter table crash_q add constraint f1 foreign key(c1)
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
###< references crash_q1(c1)
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'references crash_q1(c1)' at line 1
###
###As far as some queries didnt return OK, result is NO
alter_add_multi_col=yes # Alter table add many columns
###< alter table crash_q add (f integer,g integer)
###> OK
alter_add_primary_key=with constraint # Alter table add primary key
###< alter table crash_q1 add constraint p1 primary key(c1)
###> OK
alter_add_unique=yes # Alter table add unique
###< alter table crash_q add constraint u1 unique(c1)
###> OK
###
###As far as all queries returned OK, result is YES
alter_alter_col=yes # Alter table alter column default
###< alter table crash_q alter b set default 10
###> OK
###
###As far as all queries returned OK, result is YES
alter_change_col=yes # Alter table change column
###< alter table crash_q change a e char(50)
###> OK
###
###As far as all queries returned OK, result is YES
alter_drop_col=yes # Alter table drop column
###< alter table crash_q drop column b
###> OK
alter_drop_constraint=no # Alter table drop constraint
###< alter table crash_q drop constraint c2
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'constraint c2' at line 1
###
###< alter table crash_q drop constraint c2 restrict
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'constraint c2 restrict' at line 1
alter_drop_foreign_key=with drop foreign key # Alter table drop foreign key
###< alter table crash_q drop constraint f1
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'constraint f1' at line 1
###
###< alter table crash_q drop constraint f1 restrict
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'constraint f1 restrict' at line 1
###
###< alter table crash_q drop foreign key f1
###> OK
alter_drop_primary_key=drop primary key # Alter table drop primary key
###< alter table crash_q1 drop constraint p1 restrict
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'constraint p1 restrict' at line 1
###
###< alter table crash_q1 drop primary key
###> OK
alter_drop_unique=with drop key # Alter table drop unique
###< alter table crash_q drop constraint u1
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'constraint u1' at line 1
###
###< alter table crash_q drop constraint u1 restrict
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'constraint u1 restrict' at line 1
###
###< alter table crash_q drop key u1
###> OK
alter_modify_col=yes # Alter table modify column
###< alter table crash_q modify c1 CHAR(20)
###> OK
alter_rename_table=yes # Alter table rename table
###< alter table crash_q rename to crash_q1
###> OK
###
###As far as all queries returned OK, result is YES
atomic_updates=no # atomic updates
###< create table crash_q (a integer not null,primary key (a))
###> OK
###< insert into crash_q values (2)
###> OK
###< insert into crash_q values (3)
###> OK
###< insert into crash_q values (1)
###> OK
###< update crash_q set a=a+1
###> execute error:Duplicate entry '3' for key 1
###< drop table crash_q
###> OK
###
###As far as some queries didnt return OK, result is NO
automatic_rowid=_rowid # Automatic row id
###< create table crash_q (a int not null, primary key(a))
###> OK
###< insert into crash_q values (1)
###> OK
###< select _rowid from crash_q
###> OK
###< drop table crash_q
###> OK
binary_numbers=no # binary numbers (0b1001)
###< select 0b1001
###> execute error:Unknown column '0b1001' in 'field list'
###
###As far as some queries didnt return OK, result is NO
binary_strings=no # binary strings (b'0110')
###< select b'0110'
###> execute error:Unknown column 'b' in 'field list'
###
###As far as some queries didnt return OK, result is NO
case_insensitive_strings=yes # Case insensitive compare
###
###<select b from crash_me where b = 'A'
###>a
char_is_space_filled=no # char are space filled
###
###<select concat(b,b) from crash_me where b = 'a '
###>aa
###We expected 'a a ' but got 'aa'
column_alias=yes # Column alias
###< select a as ab from crash_me
###> OK
###
###As far as all queries returned OK, result is YES
columns_in_group_by=+64 # number of columns in group by
###We are trying (example with N=5):
###create table crash_q (q1 integer,q2 integer,q3 integer,q4 integer,q5 integer)
###insert into crash_q values(1,1,1,1,1)
###insert into crash_q values(1,1,1,1,1)
###select q1,q2,q3,q4,q5 from crash_q group by q1,q2,q3,q4,q5
columns_in_order_by=+64 # number of columns in order by
###We are trying (example with N=5):
###create table crash_q (q1 integer,q2 integer,q3 integer,q4 integer,q5 integer)
###insert into crash_q values(1,1,1,1,1)
###insert into crash_q values(1,1,1,1,1)
###select * from crash_q order by q1,q2,q3,q4,q5
comment_#=yes # # as comment
###< select * from crash_me # Testing of comments
###> OK
###
###As far as all queries returned OK, result is YES
comment_--=yes # -- as comment (ANSI)
###< select * from crash_me -- Testing of comments
###> OK
###
###As far as all queries returned OK, result is YES
comment_/**/=yes # /* */ as comment
###< select * from crash_me /* Testing of comments */
###> OK
###
###As far as all queries returned OK, result is YES
comment_//=no # // as comment
###< select * from crash_me // Testing of comments
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '// Testing of comments' at line 1
###
###As far as some queries didnt return OK, result is NO
compute=no # Compute
###< select a from crash_me order by a compute sum(a) by a
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'compute sum(a) by a' at line 1
###
###As far as some queries didnt return OK, result is NO
connections=101 # Simultaneous connections (installation default)
constraint_check=syntax only # Column constraints
###< create table crash_q (a int check (a>0))
###> OK
###
###< insert into crash_q values(0)
###> OK
###
###< drop table crash_q
###> OK
constraint_check_named=syntax only # Named constraints
###< create table crash_q (a int ,b int, constraint abc check (a>b))
###> OK
###
###< insert into crash_q values(0,0)
###> OK
###
###< drop table crash_q
###> OK
constraint_check_table=syntax only # Table constraints
###< create table crash_q (a int ,b int, check (a>b))
###> OK
###
###< insert into crash_q values(0,0)
###> OK
###
###< drop table crash_q
###> OK
constraint_null=yes # NULL constraint (SyBase style)
###< create table crash_q (a int null)
###> OK
###< drop table crash_q
###> OK
###
###As far as all queries returned OK, result is YES
crash_me_safe=yes # crash me safe
crash_me_version=1.61 # crash me version
create_default=yes # default value for column
###< create table crash_q (q integer default 10 not null)
###> OK
###< drop table crash_q
###> OK
###
###As far as all queries returned OK, result is YES
create_default_func=no # default value function for column
###< create table crash_q (q integer not null,q1 integer default (1+1))
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(1+1))' at line 1
###< drop table crash_q
###> execute error:Unknown table 'crash_q'
###
###As far as some queries didnt return OK, result is NO
create_if_not_exists=yes # create table if not exists
###< create table crash_q (q integer)
###> OK
###< create table if not exists crash_q (q integer)
###> OK
###
###As far as all queries returned OK, result is YES
create_index=yes # create index
###< create index crash_q on crash_me (a)
###> OK
create_schema=no # Create SCHEMA
###< create schema crash_schema create table crash_q (a int) create table crash_q2(b int)
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'schema crash_schema create table crash_q (a int) create table c
###< drop schema crash_schema cascade
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'schema crash_schema cascade' at line 1
###
###As far as some queries didnt return OK, result is NO
create_table_select=yes # create table from select
###< create table crash_q SELECT * from crash_me
###> OK
cross_join=yes # cross join (same as from a,b)
###< select crash_me.a from crash_me cross join crash_me3
###> OK
###
###As far as all queries returned OK, result is YES
date_as_string=yes # String functions on date columns
###< create table crash_me2 (a date not null)
###> OK
###< insert into crash_me2 values ('1998-03-03')
###> OK
###
###<select left(a,4) from crash_me2
###>1998
###
###< drop table crash_me2
###> OK
date_format_EUR=error # Supports DD.MM.YYYY (EUR) format
###< insert into crash_me_d(a) values ('16.08.1963')
###> OK
###
###<select a from crash_me_d
###>0000-00-00
###We expected '1963-08-16' but got '0000-00-00'
###
###< delete from crash_me_d
###> OK
date_format_EUR_with_date=error # Supports DATE 'DD.MM.YYYY' (EUR) format
###< insert into crash_me_d(a) values (DATE '16.08.1963')
###> OK
###
###<select a from crash_me_d
###>0000-00-00
###We expected '1963-08-16' but got '0000-00-00'
###
###< delete from crash_me_d
###> OK
date_format_ISO=yes # Supports YYYY-MM-DD (ISO) format
###< insert into crash_me_d(a) values ('1963-08-16')
###> OK
###
###<select a from crash_me_d
###>1963-08-16
###
###< delete from crash_me_d
###> OK
date_format_ISO_with_date=yes # Supports DATE 'YYYY-MM-DD' (ISO) format
###< insert into crash_me_d(a) values (DATE '1963-08-16')
###> OK
###
###<select a from crash_me_d
###>1963-08-16
###
###< delete from crash_me_d
###> OK
date_format_USA=error # Supports MM/DD/YYYY format
###< insert into crash_me_d(a) values ('08/16/1963')
###> OK
###
###<select a from crash_me_d
###>0000-00-00
###We expected '1963-08-16' but got '0000-00-00'
###
###< delete from crash_me_d
###> OK
date_format_USA_with_date=error # Supports DATE 'MM/DD/YYYY' format
###< insert into crash_me_d(a) values (DATE '08/16/1963')
###> OK
###
###<select a from crash_me_d
###>0000-00-00
###We expected '1963-08-16' but got '0000-00-00'
###
###< delete from crash_me_d
###> OK
date_format_YYYYMMDD=yes # Supports YYYYMMDD format
###< insert into crash_me_d(a) values ('19630816')
###> OK
###
###<select a from crash_me_d
###>1963-08-16
###
###< delete from crash_me_d
###> OK
date_format_YYYYMMDD_with_date=yes # Supports DATE 'YYYYMMDD' format
###< insert into crash_me_d(a) values (DATE '19630816')
###> OK
###
###<select a from crash_me_d
###>1963-08-16
###
###< delete from crash_me_d
###> OK
date_format_inresult=iso # Date format in result
###< insert into crash_me_d values( sysdate() )
###> OK
###
###< select a from crash_me_d
###> 2004-04-06
###< delete from crash_me_d
###> OK
date_infinity=error # Supports 'infinity dates
###< create table crash_me2 (a date not null)
###> OK
###< insert into crash_me2 values ('infinity')
###> OK
###
###<select a from crash_me2
###>0000-00-00
###We expected 'infinity' but got '0000-00-00'
###
###< drop table crash_me2
###> OK
date_last=yes # Supports 9999-12-31 dates
###< create table crash_me2 (a date not null)
###> OK
###< insert into crash_me2 values ('9999-12-31')
###> OK
###
###<select a from crash_me2
###>9999-12-31
###
###< drop table crash_me2
###> OK
date_one=yes # Supports 0001-01-01 dates
###< create table crash_me2 (a date not null)
###> OK
###< insert into crash_me2 values ('0001-01-01')
###> OK
###
###<select a from crash_me2
###>0001-01-01
###
###< drop table crash_me2
###> OK
date_with_YY=yes # Supports YY-MM-DD 2000 compilant dates
###< create table crash_me2 (a date not null)
###> OK
###< insert into crash_me2 values ('98-03-03')
###> OK
###
###<select a from crash_me2
###>1998-03-03
###
###< drop table crash_me2
###> OK
###
###< create table crash_me2 (a date not null)
###> OK
###< insert into crash_me2 values ('10-03-03')
###> OK
###
###<select a from crash_me2
###>2010-03-03
###
###< drop table crash_me2
###> OK
date_zero=yes # Supports 0000-00-00 dates
###< create table crash_me2 (a date not null)
###> OK
###< insert into crash_me2 values ('0000-00-00')
###> OK
###
###<select a from crash_me2
###>0000-00-00
###
###< drop table crash_me2
###> OK
domains=no # Domains (ANSI SQL)
###< create domain crash_d as varchar(10) default 'Empty' check (value <> 'abcd')
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'domain crash_d as varchar(10) default 'Empty' check (value <> '
###< create table crash_q(a crash_d, b int)
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'crash_d, b int)' at line 1
###< insert into crash_q(a,b) values('xyz',10)
###> execute error:Table 'test.crash_q' doesn't exist
###< insert into crash_q(b) values(10)
###> execute error:Table 'test.crash_q' doesn't exist
###< drop table crash_q
###> execute error:Unknown table 'crash_q'
###< drop domain crash_d
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'domain crash_d' at line 1
###
###As far as some queries didnt return OK, result is NO
dont_require_cast_to_float=yes # No need to cast from integer to float
###< select exp(1)
###> OK
###
###As far as all queries returned OK, result is YES
double_quotes=yes # Double '' as ' in strings
###
###<select 'Walker''s'
###>Walker's
drop_if_exists=yes # drop table if exists
###< create table crash_q (q integer)
###> OK
###< drop table if exists crash_q
###> OK
###
###As far as all queries returned OK, result is YES
drop_index=with 'ON' # drop index
###< drop index crash_q
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
###
###< drop index crash_q from crash_me
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'from crash_me' at line 1
###
###< drop index crash_q on crash_me
###> OK
drop_requires_cascade=no # drop table require cascade/restrict
###< create table crash_me (a integer not null)
###> OK
###< drop table crash_me
###> OK
drop_restrict=yes # drop table with cascade/restrict
###< create table crash_q (a int)
###> OK
###< drop table crash_q restrict
###> OK
###
###As far as all queries returned OK, result is YES
end_colon=yes # allows end ';'
###< select * from crash_me;
###> OK
###
###As far as all queries returned OK, result is YES
except=no # except
###< select * from crash_me except select * from crash_me3
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select * from crash_me3' at line 1
###
###As far as some queries didnt return OK, result is NO
except_all=no # except all
###< select * from crash_me except all select * from crash_me3
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'all select * from crash_me3' at line 1
###
###As far as some queries didnt return OK, result is NO
except_all_incompat=no # except all (incompatible lists)
###< select * from crash_me except all select * from crash_me2
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'all select * from crash_me2' at line 1
###
###As far as some queries didnt return OK, result is NO
except_incompat=no # except (incompatible lists)
###< select * from crash_me except select * from crash_me2
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select * from crash_me2' at line 1
###
###As far as some queries didnt return OK, result is NO
field_name_case=yes # case independent field names
###< create table crash_q (q integer)
###> OK
###< insert into crash_q(Q) values (1)
###> OK
###< drop table crash_q
###> OK
###
###As far as all queries returned OK, result is YES
float_int_expr=yes # mixing of integer and float in expression
###< select 1+1.0
###> OK
###
###As far as all queries returned OK, result is YES
foreign_key=syntax only # foreign keys
###< create table crash_me_qf (a integer not null,primary key (a))
###> OK
###
###< create table crash_me_qf2 (a integer not null,foreign key (a) references crash_me_qf (a))
###> OK
###
###< insert into crash_me_qf values (1)
###> OK
###
###< insert into crash_me_qf2 values (2)
###> OK
###
###< drop table crash_me_qf2
###> OK
###
###< drop table crash_me_qf
###> OK
full_outer_join=no # full outer join
###< select crash_me.a from crash_me full join crash_me2 ON
### crash_me.a=crash_me2.a
###> execute error:Unknown table 'crash_me' in field list
###
###As far as some queries didnt return OK, result is NO
func_extra_!=yes # Function NOT as '!' in SELECT
###
###<select ! 1
###>0
func_extra_%=yes # Function MOD as %
###
###<select 10%7
###>3
func_extra_&=yes # Function & (bitwise and)
###
###<select 5 & 3
###>1
func_extra_&&=yes # Function AND as '&&'
###
###<select 1=1 && 2=2
###>1
func_extra_<>=yes # Function <> in SELECT
###
###<select 1<>1
###>0
func_extra_==yes # Function =
###
###<select (1=1)
###>1
func_extra_add_months=no # Function ADD_MONTHS
###
###<select add_months('1997-01-01',1) from crash_me_d
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('1997-01-01',1) from crash_me_d' at line 1
func_extra_adddate=yes # Function ADDDATE
###
###<select ADDDATE('2002-12-01',3) from crash_me_d
###>2002-12-04
func_extra_addtime=yes # Function ADDTIME
###
###<select ADDTIME('20:02:12','00:00:03')
###>20:02:15
func_extra_alpha=no # Function ALPHA
###
###<select alpha('Aâ',2)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('Aâ',2)' at line 1
func_extra_and_or=yes # Function AND and OR in SELECT
###
###<select 1=1 AND 2=2
###>1
func_extra_ascii_char=no # Function ASCII_CHAR
###
###<select ASCII_CHAR(65)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(65)' at line 1
func_extra_ascii_code=no # Function ASCII_CODE
###
###<select ASCII_CODE('A')
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('A')' at line 1
func_extra_ascii_string=error # Function ASCII in string cast
###
###<select ascii('a')
###>97
###We expected 'a' but got '97'
func_extra_atn2=no # Function ATN2
###
###<select atn2(1,0)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(1,0)' at line 1
func_extra_auto_num2string=yes # Function automatic num->string convert
###
###<select concat('a',2)
###>a2
func_extra_auto_string2num=yes # Function automatic string->num convert
###
###<select '1'+2
###>3
func_extra_between=yes # Function BETWEEN in SELECT
###
###<select 5 between 4 and 6
###>1
func_extra_binary_shifts=yes # Function << and >> (bitwise shifts)
###
###<select (1 << 4) >> 2
###>4
func_extra_bit_count=yes # Function BIT_COUNT
###
###<select bit_count(5)
###>2
func_extra_ceil=yes # Function CEIL
###
###<select ceil(-4.5)
###>-4
func_extra_char_date=no # Function CHAR (conversation date)
###
###<select CHAR(a,EUR) from crash_me_d
###> execute failed:Unknown column 'EUR' in 'field list'
func_extra_charindex=no # Function CHARINDEX
###
###<select charindex('a','crash')
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('a','crash')' at line 1
func_extra_chr=no # Function CHR
###
###<select CHR(65)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(65)' at line 1
func_extra_chr_str=no # Function CHR (any type to string)
###
###<select CHR(67)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(67)' at line 1
func_extra_concat_as_+=error # Function concatenation with +
###
###<select 'abc' + 'def'
###>0
###We expected 'abcdef' but got '0'
func_extra_concat_list=yes # Function CONCAT(list)
###
###<select concat('a','b','c','d')
###>abcd
func_extra_convert=no # Function CONVERT
###
###<select convert(CHAR,5)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '5)' at line 1
func_extra_cosh=no # Function COSH
###
###<select cosh(0)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(0)' at line 1
func_extra_date=yes # Function DATE
###
###<select date('1963-08-16') from crash_me_d
###>1963-08-16
func_extra_date_format=yes # Function DATE_FORMAT
###
###<select date_format('1997-01-02 03:04:05','M W D Y y m d h i s w') from crash_me_d
###>M W D Y y m d h i s w
func_extra_dateadd=no # Function DATEADD
###
###<select dateadd(day,3,'1997-11-30') from crash_me_d
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(day,3,'1997-11-30') from crash_me_d' at line 1
func_extra_datediff=no # Function DATEDIFF
###
###<select datediff(month,'Oct 21 1997','Nov 30 1997') from crash_me_d
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''Nov 30 1997') from crash_me_d' at line 1
func_extra_datediff2arg=yes # Function DATEDIFF (2 arg)
###
###<select DATEDIFF('2002-12-04','2002-12-01') from crash_me_d
###>3
func_extra_datename=no # Function DATENAME
###
###<select datename(month,'Nov 30 1997') from crash_me_d
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(month,'Nov 30 1997') from crash_me_d' at line 1
func_extra_datepart=no # Function DATEPART
###
###<select datepart(month,'July 20 1997') from crash_me_d
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(month,'July 20 1997') from crash_me_d' at line 1
func_extra_day=yes # Function DAY
###
###<select DAY('2002-12-01') from crash_me_d
###>1
func_extra_decode=no # Function DECODE
###
###<select DECODE('S-103','T72',1,'S-103',2,'Leopard',3)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '1,'S-103',2,'Leopard',3)' at line 1
func_extra_ebcdic_string=no # Function EBCDIC in string cast
###
###<select ebcdic('a')
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('a')' at line 1
func_extra_elt=yes # Function ELT
###
###<select elt(2,'ONE','TWO','THREE')
###>TWO
func_extra_encrypt=yes # Function ENCRYPT
###
###<select encrypt('hello')
###>VNeu3dE4DbVJY
func_extra_expand2arg=no # Function EXPAND
###
###<select expand('abcd',6)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('abcd',6)' at line 1
func_extra_field=yes # Function FIELD
###
###<select field('IBM','NCA','ICL','SUN','IBM','DIGITAL')
###>4
func_extra_fixed=no # Function FIXED
###
###<select fixed(222.6666,10,2)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(222.6666,10,2)' at line 1
func_extra_float=no # Function FLOAT
###
###<select float(6666.66,4)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'float(6666.66,4)' at line 1
func_extra_format=yes # Function FORMAT
###
###<select format(1234.5555,2)
###>1,234.56
func_extra_from_days=yes # Function FROM_DAYS
###
###<select from_days(729024) from crash_me_d
###>1996-01-01
func_extra_from_unixtime=yes # Function FROM_UNIXTIME
###
###<select from_unixtime(0) from crash_me_d
###>1970-01-01 02:00:00
func_extra_getdate=no # Function GETDATE
###
###<select getdate()
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '()' at line 1
func_extra_greatest=yes # Function GREATEST
###
###<select greatest('HARRY','HARRIOT','HAROLD')
###>HARRY
func_extra_hex=yes # Function HEX
###
###<select HEX('A')
###>41
func_extra_if=yes # Function IF
###
###<select if(5,6,7)
###>6
func_extra_in_num=yes # Function IN on numbers in SELECT
###
###<select 2 in (3,2,5,9,5,1)
###>1
func_extra_in_str=yes # Function IN on strings in SELECT
###
###<select 'monty' in ('david','monty','allan')
###>1
func_extra_index=no # Function INDEX
###
###<select index('abcdefg','cd',1,1)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'index('abcdefg','cd',1,1)' at line 1
func_extra_initcap=no # Function INITCAP
###
###<select initcap('the soap')
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('the soap')' at line 1
func_extra_instr=yes # Function LOCATE as INSTR
###
###<select instr('hello','ll')
###>3
func_extra_instr_oracle=no # Function INSTR (Oracle syntax)
###
###<select INSTR('CORPORATE FLOOR','OR',3,2)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '3,2)' at line 1
func_extra_instrb=no # Function INSTRB
###
###<select INSTRB('CORPORATE FLOOR','OR',5,2)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('CORPORATE FLOOR','OR',5,2)' at line 1
func_extra_interval=yes # Function INTERVAL
###
###<select interval(55,10,20,30,40,50,60,70,80,90,100)
###>5
func_extra_last_day=yes # Function LAST_DAY
###
###<select last_day('1997-04-01') from crash_me_d
###>1997-04-30
func_extra_last_insert_id=yes # Function LAST_INSERT_ID
###
###<select last_insert_id()
###>0
func_extra_least=yes # Function LEAST
###
###<select least('HARRY','HARRIOT','HAROLD')
###>HAROLD
func_extra_length=error # Function LENGTH
###
###<select length(1)
###>1
###We expected '2' but got '1'
func_extra_lengthb=no # Function LENGTHB
###
###<select lengthb('CANDIDE')
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('CANDIDE')' at line 1
func_extra_lfill3arg=no # Function LFILL (3 arg)
###
###<select lfill('abcd','.',6)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('abcd','.',6)' at line 1
func_extra_like=yes # Function LIKE in SELECT
###
###<select 'a' like 'a%'
###>1
func_extra_like_escape=yes # Function LIKE ESCAPE in SELECT
###
###<select '%' like 'a%' escape 'a'
###>1
func_extra_ln=yes # Function LN
###
###<select ln(95)
###>4.553877
func_extra_log(m_n)=yes # Function LOG(m,n)
###
###<select log(10,100)
###>2.000000
func_extra_logn=no # Function LOGN
###
###<select logn(2)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(2)' at line 1
func_extra_lpad=yes # Function LPAD
###
###<select lpad('hi',4,'??')
###>??hi
func_extra_ltrim2arg=no # Function LTRIM (2 arg)
###
###<select ltrim('..abcd..','.')
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''.')' at line 1
func_extra_makedate=yes # Function MAKEDATE
###
###<select MAKEDATE(1963,228) from crash_me_d
###>1963-08-16
func_extra_maketime=yes # Function MAKETIME
###
###<select MAKETIME(20,02,12)
###>20:02:12
func_extra_mapchar=no # Function MAPCHAR
###
###<select mapchar('Aâ')
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('Aâ')' at line 1
func_extra_mdy=no # Function MDY
###
###<select mdy(7,1,1998) from crash_me_d
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(7,1,1998) from crash_me_d' at line 1
func_extra_microsecond=yes # Function MICROSECOND
###
###<select MICROSECOND('19630816200212111111')
###>110000
func_extra_mid=yes # Function SUBSTRING as MID
###
###<select mid('hello',3,2)
###>ll
func_extra_months_between=no # Function MONTHS_BETWEEN
###
###<select months_between('1997-02-02','1997-01-01') from crash_me_d
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('1997-02-02','1997-01-01') from crash_me_d' at line 1
func_extra_noround=no # Function NOROUND
###< select noround(22.6)
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(22.6)' at line 1
func_extra_not=yes # Function NOT in SELECT
###
###<select not false
###>1
func_extra_not_between=yes # Function NOT BETWEEN in SELECT
###
###<select 5 not between 4 and 6
###>0
func_extra_not_like=yes # Function NOT LIKE in SELECT
###
###<select 'a' not like 'a%'
###>0
func_extra_num=no # Function NUM
###
###<select NUM('2123')
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('2123')' at line 1
func_extra_odbc_convert=no # Function ODBC CONVERT
###
###<select convert(5,SQL_CHAR)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQL_CHAR)' at line 1
func_extra_password=yes # Function PASSWORD
###
###<select password('hello')
###>*6B4F89A54E2D27ECD7E8DA05B4AB8FD9D1D8B119
func_extra_paste=no # Function PASTE
###
###<select paste('ABCDEFG',3,2,'1234')
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('ABCDEFG',3,2,'1234')' at line 1
func_extra_patindex=no # Function PATINDEX
###
###<select patindex('%a%','crash')
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('%a%','crash')' at line 1
func_extra_period_add=yes # Function PERIOD_ADD
###
###<select period_add(9602,-12) from crash_me_d
###>199502
func_extra_period_diff=yes # Function PERIOD_DIFF
###
###<select period_diff(199505,199404) from crash_me_d
###>13
func_extra_pow=yes # Function POW
###
###<select pow(3,2)
###>9.000000
func_extra_range=no # Function RANGE
###
###<select range(a)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(a)' at line 1
func_extra_regexp=yes # Function REGEXP in SELECT
###
###<select 'a' regexp '^(a|b)*$'
###>1
func_extra_replace2arg=no # Function REPLACE (2 arg)
###
###<select replace('AbCd','bC')
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
func_extra_replicate=no # Function REPLICATE
###
###<select replicate('a',5)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('a',5)' at line 1
func_extra_reverse=yes # Function REVERSE
###
###<select reverse('abcd')
###>dcba
func_extra_rfill3arg=no # Function RFILL (3 arg)
###
###<select rfill('abcd','.',6)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('abcd','.',6)' at line 1
func_extra_root=no # Function ROOT
###
###<select root(4)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(4)' at line 1
func_extra_round1=yes # Function ROUND(1 arg)
###
###<select round(5.63)
###>6
func_extra_rpad=yes # Function RPAD
###
###<select rpad('hi',4,'??')
###>hi??
func_extra_rpad4arg=no # Function RPAD (4 arg)
###
###<select rpad('abcd',2,'+-',8)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '8)' at line 1
func_extra_rtrim2arg=no # Function RTRIM (2 arg)
###
###<select rtrim('..abcd..','.')
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''.')' at line 1
func_extra_sec_to_time=yes # Function SEC_TO_TIME
###
###<select sec_to_time(5001)
###>01:23:21
func_extra_sinh=no # Function SINH
###
###<select sinh(1)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(1)' at line 1
func_extra_str=no # Function STR
###
###<select str(123.45,5,1)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(123.45,5,1)' at line 1
func_extra_strcmp=yes # Function STRCMP
###
###<select strcmp('abc','adc')
###>-1
func_extra_stuff=no # Function STUFF
###
###<select stuff('abc',2,3,'xyz')
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('abc',2,3,'xyz')' at line 1
func_extra_subdate=yes # Function SUBDATE
###
###<select SUBDATE('2002-12-04',3) from crash_me_d
###>2002-12-01
func_extra_substr2arg=yes # Function SUBSTR (2 arg)
###
###<select substr('abcd',2)
###>bcd
func_extra_substr3arg=yes # Function SUBSTR (3 arg)
###
###<select substr('abcd',2,2)
###>bc
func_extra_substrb=no # Function SUBSTRB
###
###<select SUBSTRB('ABCDEFG',5,4.2)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('ABCDEFG',5,4.2)' at line 1
func_extra_substring_index=yes # Function SUBSTRING_INDEX
###
###<select substring_index('www.tcx.se','.',-2)
###>tcx.se
func_extra_subtime=yes # Function SUBTIME
###
###<select SUBTIME('20:02:15','00:00:03')
###>20:02:12
func_extra_sysdate=yes # Function SYSDATE
###
###<select sysdate()
###>2004-04-06 13:49:05
func_extra_tail=no # Function TAIL
###
###<select tail('ABCDEFG',3)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('ABCDEFG',3)' at line 1
func_extra_tanh=no # Function TANH
###
###<select tanh(1)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(1)' at line 1
func_extra_time=yes # Function TIME
###
###<select time('20:02:12')
###>20:02:12
func_extra_time_to_sec=yes # Function TIME_TO_SEC
###
###<select time_to_sec('01:23:21')
###>5001
func_extra_timediff=yes # Function TIMEDIFF
###
###<select TIMEDIFF('20:02:15','20:02:12')
###>00:00:03
func_extra_timestamp=error # Function TIMESTAMP
###
###<select timestamp('19630816','00200212')
###>1963-08-16 20:02:12
###We expected '19630816200212000000' but got '1963-08-16 20:02:12'
func_extra_to_days=yes # Function TO_DAYS
###
###<select to_days('1996-01-01') from crash_me_d
###>729024
func_extra_translate=no # Function TRANSLATE
###
###<select translate('abc','bc','de')
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('abc','bc','de')' at line 1
func_extra_trim1arg=yes # Function TRIM (1 arg)
###
###<select trim(' abcd ')
###>abcd
func_extra_trim2arg=no # Function TRIM (2 arg)
###
###<select trim('..abcd..','.')
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''.')' at line 1
func_extra_trim_many_char=error # Function TRIM; Many char extension
###
###<select trim(':!' FROM ':abc!')
###>:abc!
###We expected 'abc' but got ':abc!'
func_extra_trim_substring=yes # Function TRIM; Substring extension
###
###<select trim('cb' FROM 'abccb')
###>abc
func_extra_trunc=no # Function TRUNC
###
###<select trunc(18.18,-1)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(18.18,-1)' at line 1
func_extra_trunc1arg=no # Function TRUNC (1 arg)
###
###<select trunc(222.6)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(222.6)' at line 1
func_extra_uid=no # Function UID
###
###<select uid
###> execute failed:Unknown column 'uid' in 'field list'
func_extra_unix_timestamp=yes # Function UNIX_TIMESTAMP
###
###<select unix_timestamp()
###>1081248545
func_extra_userenv=no # Function USERENV
###
###<select userenv
###> execute failed:Unknown column 'userenv' in 'field list'
func_extra_value=no # Function VALUE
###
###<select value(NULL,'WALRUS')
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(NULL,'WALRUS')' at line 1
func_extra_version=yes # Function VERSION
###
###<select version()
###>4.1.2-alpha
func_extra_weekday=yes # Function WEEKDAY
###
###<select weekday('1997-11-29') from crash_me_d
###>5
func_extra_weekofyear=yes # Function WEEKOFYEAR
###
###<select WEEKOFYEAR('1963-08-16') from crash_me_d
###>33
func_extra_|=yes # Function | (bitwise or)
###
###<select 1 | 2
###>3
func_extra_||=yes # Function OR as '||'
###
###<select 1=0 || 1=1
###>1
func_extra_~*=no # Function ~* (case insensitive compare)
###
###<select 'hi' ~* 'HI'
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '~* 'HI'' at line 1
func_odbc_abs=yes # Function ABS
###
###<select abs(-5)
###>5
func_odbc_acos=yes # Function ACOS
###
###<select acos(0)
###>1.570796
func_odbc_ascii=yes # Function ASCII
###
###<select ASCII('A')
###>65
func_odbc_asin=yes # Function ASIN
###
###<select asin(1)
###>1.570796
func_odbc_atan=yes # Function ATAN
###
###<select atan(1)
###>0.785398
func_odbc_atan2=yes # Function ATAN2
###
###<select atan2(1,0)
###>1.570796
func_odbc_ceiling=yes # Function CEILING
###
###<select ceiling(-4.5)
###>-4
func_odbc_char=yes # Function CHAR
###
###<select CHAR(65)
###>A
func_odbc_concat=yes # Function CONCAT(2 arg)
###
###<select concat('a','b')
###>ab
func_odbc_cos=yes # Function COS
###
###<select cos(0)
###>1.000000
func_odbc_cot=yes # Function COT
###
###<select cot(1)
###>0.64209262
func_odbc_curdate=yes # Function CURDATE
###
###<select curdate()
###>2004-04-06
func_odbc_curtime=yes # Function CURTIME
###
###<select curtime()
###>13:49:04
func_odbc_database=yes # Function DATABASE
###
###<select database()
###>test
func_odbc_dayname=yes # Function DAYNAME
###< insert into crash_me_d values('1997-02-01')
###
###<select dayname(a) from crash_me_d
###>Saturday
func_odbc_dayofmonth=yes # Function DAYOFMONTH
###< insert into crash_me_d values('1997-02-01')
###
###<select dayofmonth(a) from crash_me_d
###>1
func_odbc_dayofweek=yes # Function DAYOFWEEK
###< insert into crash_me_d values('1997-02-01')
###
###<select dayofweek(a) from crash_me_d
###>7
func_odbc_dayofyear=yes # Function DAYOFYEAR
###< insert into crash_me_d values('1997-02-01')
###
###<select dayofyear(a) from crash_me_d
###>32
func_odbc_degrees=yes # Function DEGREES
###
###<select degrees(6.283185)
###>359.99998239991
func_odbc_difference=no # Function DIFFERENCE()
###
###<select difference('abc','abe')
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('abc','abe')' at line 1
###
###<select {fn difference('abc','abe') }
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('abc','abe') }' at line 1
func_odbc_exp=yes # Function EXP
###
###<select exp(1.0)
###>2.718282
func_odbc_floor=yes # Function FLOOR
###
###<select floor(2.5)
###>2
func_odbc_fn_left=yes # Function ODBC syntax LEFT & RIGHT
###
###<select { fn LEFT( { fn RIGHT('abcd',2) },1) }
###>c
func_odbc_hour=yes # Function HOUR
###< insert into crash_me_t values(20:08:16)
###
###<select hour('12:13:14')
###>12
func_odbc_hour_time=yes # Function ANSI HOUR
###< insert into crash_me_t values(20:08:16)
###
###<select hour(TIME '12:13:14')
###>12
func_odbc_ifnull=yes # Function IFNULL
###
###<select ifnull(2,3)
###>2
func_odbc_insert=yes # Function INSERT
###
###<select insert('abcd',2,2,'ef')
###>aefd
func_odbc_lcase=yes # Function LCASE
###
###<select lcase('ABC')
###>abc
func_odbc_left=yes # Function LEFT
###
###<select left('abcd',2)
###>ab
func_odbc_length=yes # Function REAL LENGTH
###
###<select length('abcd ')
###>5
func_odbc_length_without_space=error # Function ODBC LENGTH
###
###<select length('abcd ')
###>5
###We expected '4' but got '5'
###
###<select {fn length('abcd ') }
###>5
###We expected '4' but got '5'
func_odbc_locate_2=yes # Function LOCATE(2 arg)
###
###<select locate('bcd','abcd')
###>2
func_odbc_locate_3=yes # Function LOCATE(3 arg)
###
###<select locate('bcd','abcd',3)
###>0
func_odbc_log=yes # Function LOG
###
###<select log(2)
###>0.693147
func_odbc_log10=yes # Function LOG10
###
###<select log10(10)
###>1.000000
func_odbc_ltrim=yes # Function LTRIM
###
###<select ltrim(' abcd')
###>abcd
func_odbc_minute=yes # Function MINUTE
###< insert into crash_me_t values(20:08:16)
###
###<select minute('12:13:14')
###>13
func_odbc_mod=yes # Function MOD
###
###<select mod(11,7)
###>4
func_odbc_month=yes # Function MONTH
###< insert into crash_me_d values('1997-02-01')
###
###<select month(a) from crash_me_d
###>2
func_odbc_monthname=yes # Function MONTHNAME
###< insert into crash_me_d values('1997-02-01')
###
###<select monthname(a) from crash_me_d
###>February
func_odbc_now=yes # Function NOW
###
###<select now()
###>2004-04-06 13:49:04
func_odbc_pi=yes # Function PI
###
###<select pi()
###>3.141593
func_odbc_power=yes # Function POWER
###
###<select power(2,4)
###>16.000000
func_odbc_quarter=yes # Function QUARTER
###< insert into crash_me_d values('1997-02-01')
###
###<select quarter(a) from crash_me_d
###>1
func_odbc_radians=yes # Function RADIANS
###
###<select radians(360)
###>6.2831853071796
func_odbc_rand=yes # Function RAND
###
###<select rand(1)
###>0.40540353712198
func_odbc_repeat=yes # Function REPEAT
###
###<select repeat('ab',3)
###>ababab
func_odbc_replace=yes # Function REPLACE
###
###<select replace('abbaab','ab','ba')
###>bababa
func_odbc_right=yes # Function RIGHT
###
###<select right('abcd',2)
###>cd
func_odbc_round=yes # Function ROUND(2 arg)
###
###<select round(5.63,2)
###>5.63
func_odbc_rtrim=yes # Function RTRIM
###
###<select rtrim(' abcd ')
###> abcd
func_odbc_second=yes # Function SECOND
###< insert into crash_me_t values(20:08:16)
###
###<select second('12:13:14')
###>14
func_odbc_sign=yes # Function SIGN
###
###<select sign(-5)
###>-1
func_odbc_sin=yes # Function SIN
###
###<select sin(1)
###>0.841471
func_odbc_soundex=yes # Function SOUNDEX
###
###<select soundex('hello')
###>H400
func_odbc_space=yes # Function SPACE
###
###<select space(5)
###>
func_odbc_sqrt=yes # Function SQRT
###
###<select sqrt(4)
###>2.000000
func_odbc_substring=yes # Function ODBC SUBSTRING
###
###<select substring('abcd',3,2)
###>cd
func_odbc_tan=yes # Function TAN
###
###<select tan(1)
###>1.557408
func_odbc_timestampadd=no # Function TIMESTAMPADD
###
###<select timestampadd(SQL_TSI_SECOND,1,'1997-01-01 00:00:00')
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(SQL_TSI_SECOND,1,'1997-01-01 00:00:00')' at line 1
###
###<select {fn timestampadd(SQL_TSI_SECOND,1,{ts '1997-01-01 00:00:00'}) }
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(SQL_TSI_SECOND,1,{ts '1997-01-01 00:00:00'}) }' at line 1
func_odbc_timestampdiff=no # Function TIMESTAMPDIFF
###
###<select timestampdiff(SQL_TSI_SECOND,'1997-01-01 00:00:02', '1997-01-01 00:00:01')
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(SQL_TSI_SECOND,'1997-01-01 00:00:02', '1997-01-01 00:00:01')'
###
###<select {fn timestampdiff(SQL_TSI_SECOND,{ts '1997-01-01 00:00:02'}, {ts '1997-01-01 00:00:01'}) }
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(SQL_TSI_SECOND,{ts '1997-01-01 00:00:02'}, {ts '1997-01-01 00:
func_odbc_truncate=yes # Function TRUNCATE
###
###<select truncate(18.18,-1)
###>10
func_odbc_ucase=yes # Function UCASE
###
###<select ucase('abc')
###>ABC
func_odbc_user()=yes # Function USER()
###
###<select user()
###>monty(a)localhost
func_odbc_week=USA # WEEK
###<select week('1997-02-01')
###>4
###We expected '5' but got '4'
func_odbc_year=yes # Function YEAR
###< insert into crash_me_d values('1997-02-01')
###
###<select year(a) from crash_me_d
###>1997
func_sql_+=yes # Function +, -, * and /
###
###<select 5*3-4/2+1
###>14.00
func_sql_bit_length=yes # Function BIT_LENGTH
###
###<select bit_length('abc')
###>24
func_sql_cast=yes # Function CAST
###
###<select CAST(1 as CHAR)
###>1
func_sql_char_length=error # Function CHAR_LENGTH
###
###<select char_length(b) from crash_me
###>1
###We expected '10' but got '1'
func_sql_char_length(constant)=yes # Function CHAR_LENGTH(constant)
###
###<select char_length('abcd')
###>4
func_sql_character_length=yes # Function CHARACTER_LENGTH
###
###<select character_length('abcd')
###>4
func_sql_coalesce=yes # Function COALESCE
###
###<select coalesce(NULL,'bcd','qwe')
###>bcd
func_sql_concat_as_||=error # Function concatenation with ||
###
###<select 'abc' || 'def'
###>0
###We expected 'abcdef' but got '0'
func_sql_current_date=yes # Function CURRENT_DATE
###
###<select current_date
###>2004-04-06
func_sql_current_time=yes # Function CURRENT_TIME
###
###<select current_time
###>13:49:04
func_sql_current_timestamp=yes # Function CURRENT_TIMESTAMP
###
###<select current_timestamp
###>2004-04-06 13:49:04
func_sql_current_user=yes # CURRENT_USER
###< select CURRENT_USER
###> OK
func_sql_extract_sql=yes # Function EXTRACT
###
###<select extract(minute from timestamp '2000-02-23 18:43:12.987')
###>43
func_sql_localtime=yes # Function LOCALTIME
###
###<select localtime
###>2004-04-06 13:49:04
func_sql_localtimestamp=yes # Function LOCALTIMESTAMP
###
###<select localtimestamp
###>2004-04-06 13:49:04
func_sql_lower=yes # Function LOWER
###
###<select LOWER('ABC')
###>abc
func_sql_nullif_num=yes # Function NULLIF with numbers
###
###<select NULLIF(NULLIF(1,2),1)
###>
func_sql_nullif_string=yes # Function NULLIF with strings
###
###<select NULLIF(NULLIF('first','second'),'first')
###>
func_sql_octet_length=yes # Function OCTET_LENGTH
###
###<select octet_length('abc')
###>3
func_sql_position=yes # Function POSITION
###
###<select position('ll' in 'hello')
###>3
func_sql_searched_case=yes # Function searched CASE
###
###<select case when 1 > 2 then 'false' when 2 > 1 then 'true' end
###>true
func_sql_session_user=with_parenthesis # SESSION_USER
###< select SESSION_USER
###> execute error:Unknown column 'SESSION_USER' in 'field list'
###
###< select SESSION_USER()
###> OK
func_sql_simple_case=yes # Function simple CASE
###
###<select case 2 when 1 then 'false' when 2 then 'true' end
###>true
func_sql_substring=yes # Function ANSI SQL SUBSTRING
###
###<select substring('abcd' from 2 for 2)
###>bc
func_sql_system_user=with_parenthesis # SYSTEM_USER
###< select SYSTEM_USER
###> execute error:Unknown column 'SYSTEM_USER' in 'field list'
###
###< select SYSTEM_USER()
###> OK
func_sql_trim=yes # Function TRIM
###
###<select trim(trailing from trim(LEADING FROM ' abc '))
###>abc
func_sql_upper=yes # Function UPPER
###
###<select UPPER('abc')
###>ABC
func_sql_user=with_parenthesis # USER
###< select USER
###> execute error:Unknown column 'USER' in 'field list'
###
###< select USER()
###> OK
func_where_between=yes # Function BETWEEN
###
###<select a from crash_me where 5 between 4 and 6
###>1
func_where_eq_all=yes # Function = ALL
###
###<select a from crash_me where b =all (select b from crash_me)
###>1
func_where_eq_any=yes # Function = ANY
###
###<select a from crash_me where b =any (select b from crash_me)
###>1
func_where_eq_some=yes # Function = SOME
###
###<select a from crash_me where b =some (select b from crash_me)
###>1
func_where_exists=yes # Function EXISTS
###
###<select a from crash_me where exists (select * from crash_me)
###>1
func_where_in_num=yes # Function IN on numbers
###
###<select a from crash_me where 2 in (3,2,5,9,5,1)
###>1
func_where_like=yes # Function LIKE
###
###<select a from crash_me where b like 'a%'
###>1
func_where_like_escape=yes # Function LIKE ESCAPE
###
###<select a from crash_me where b like '%' escape 'a'
###>1
func_where_match=no # Function MATCH
###
###<select a from crash_me where 1 match (select a from crash_me)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'match (select a from crash_me)' at line 1
func_where_match_unique=no # Function MATCH UNIQUE
###
###<select a from crash_me where 1 match unique (select a from crash_me)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'match unique (select a from crash_me)' at line 1
func_where_matches=no # Function MATCHES
###
###<select a from crash_me where b matcjhes 'a*'
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'matcjhes 'a*'' at line 1
func_where_not_between=yes # Function NOT BETWEEN
###
###<select a from crash_me where 7 not between 4 and 6
###>1
func_where_not_exists=yes # Function NOT EXISTS
###
###<select a from crash_me where not exists (select * from crash_me where a = 2)
###>1
func_where_not_like=yes # Function NOT LIKE
###
###<select a from crash_me where b not like 'b%'
###>1
func_where_not_unique=no # Function NOT UNIQUE
###
###<select a from crash_me where not unique (select * from crash_me where a = 2)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'unique (select * from crash_me where a = 2)' at line 1
func_where_unique=no # Function UNIQUE
###
###<select a from crash_me where unique (select * from crash_me)
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'unique (select * from crash_me)' at line 1
functions=yes # Functions
###< select 1+1
###> OK
###
###As far as all queries returned OK, result is YES
group_by=yes # Group by
###< select a from crash_me group by a
###> OK
###
###As far as all queries returned OK, result is YES
group_by_alias=yes # Group by alias
###< select a as ab from crash_me group by ab
###> OK
###
###As far as all queries returned OK, result is YES
group_by_null=yes # Group on column with null values
###< create table crash_q (s char(10))
###> OK
###< insert into crash_q values(null)
###> OK
###< insert into crash_q values(null)
###> OK
###
###<select count(*),s from crash_q group by s
###>2
###
###< drop table crash_q
###> OK
group_by_position=yes # Group by position
###< select a from crash_me group by 1
###> OK
###
###As far as all queries returned OK, result is YES
group_distinct_functions=yes # Group functions with distinct
###< select count(distinct a) from crash_me
###> OK
###
###As far as all queries returned OK, result is YES
group_func_extra_bit_and=yes # Group function BIT_AND
###
###<select bit_and(a),a from crash_me group by a
###>1
group_func_extra_bit_or=yes # Group function BIT_OR
###
###<select bit_or(a),a from crash_me group by a
###>1
group_func_extra_count_distinct_list=yes # Group function COUNT(DISTINCT expr,expr,...)
###
###<select count(distinct a,b),a from crash_me group by a
###>1
group_func_extra_std=yes # Group function STD
###
###<select std(a),a from crash_me group by a
###>0.0000
group_func_extra_stddev=yes # Group function STDDEV
###
###<select stddev(a),a from crash_me group by a
###>0.0000
group_func_extra_variance=yes # Group function VARIANCE
###
###<select variance(a),a from crash_me group by a
###>0.0000
group_func_sql_any=no # Group function ANY
###
###<select any(a),a from crash_me group by a
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(a),a from crash_me group by a' at line 1
group_func_sql_avg=yes # Group function AVG
###
###<select avg(a),a from crash_me group by a
###>1.0000
group_func_sql_count_*=yes # Group function COUNT (*)
###
###<select count(*),a from crash_me group by a
###>1
group_func_sql_count_column=yes # Group function COUNT column name
###
###<select count(a),a from crash_me group by a
###>1
group_func_sql_count_distinct=yes # Group function COUNT(DISTINCT expr)
###
###<select count(distinct a),a from crash_me group by a
###>1
group_func_sql_every=no # Group function EVERY
###
###<select every(a),a from crash_me group by a
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(a),a from crash_me group by a' at line 1
group_func_sql_max=yes # Group function MAX on numbers
###
###<select max(a),a from crash_me group by a
###>1
group_func_sql_max_str=yes # Group function MAX on strings
###
###<select max(b),a from crash_me group by a
###>a
group_func_sql_min=yes # Group function MIN on numbers
###
###<select min(a),a from crash_me group by a
###>1
group_func_sql_min_str=yes # Group function MIN on strings
###
###<select min(b),a from crash_me group by a
###>a
group_func_sql_some=no # Group function SOME
###
###<select some(a),a from crash_me group by a
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(a),a from crash_me group by a' at line 1
group_func_sql_sum=yes # Group function SUM
###
###<select sum(a
 | 
Pages: 1
Prev: Does ANYBODY think this video is a good example of Bibliomancy?
Next: OBOPO ORO OPOBO