See <http://jenkins.drizzle.org/job/drizzle-staging-dbqp-crashme-32/149/>
------------------------------------------
[...truncated 4816 lines...]
20120404-032614 Group function ANY:
20120404-032614 Got error from query: 'select any(a),a from crash_me group by
a'
20120404-032614 You have an error in your SQL syntax; check the manual that
corresponds to your Drizzle server version for the right syntax to use near
'(a),a from crash_me group by a' at line 1
20120404-032614 no
20120404-032614 Group function EVERY:
20120404-032614 Got error from query: 'select every(a),a from crash_me group
by a'
20120404-032614 FUNCTION every does not exist
20120404-032614 no
20120404-032614 Group function SOME:
20120404-032614 Got error from query: 'select some(a),a from crash_me group by
a'
20120404-032614 You have an error in your SQL syntax; check the manual that
corresponds to your Drizzle server version for the right syntax to use near
'(a),a from crash_me group by a' at line 1
20120404-032614 no
20120404-032614
20120404-032614 Supported extra group functions
20120404-032614 Group function BIT_AND:
20120404-032614 Got error from query: 'select bit_and(a),a from crash_me group
by a'
20120404-032614 FUNCTION bit_and does not exist
20120404-032614 no
20120404-032614 Group function BIT_OR:
20120404-032614 Got error from query: 'select bit_or(a),a from crash_me group
by a'
20120404-032614 FUNCTION bit_or does not exist
20120404-032614 no
20120404-032614 Group function COUNT(DISTINCT expr,expr,...): yes
20120404-032614 Group function STD: yes
20120404-032614 Group function STDDEV: yes
20120404-032614 Group function VARIANCE: yes
20120404-032614
20120404-032614 mixing of integer and float in expression: REPORT mixing of
integer and float in expression yes
20120404-032614 No need to cast from integer to float: REPORT No need to cast
from integer to float yes
20120404-032614 Is 1+NULL = NULL: yes
20120404-032614 Is 'a' || NULL = NULL: yes
20120404-032614 NOROUND:
20120404-032614 Got error from query: 'select noround(22.6) '
20120404-032614 FUNCTION noround does not exist
20120404-032614 no
20120404-032614
20120404-032614 Got error from query: 'select SESSION_USER '
20120404-032614 Unknown column 'SESSION_USER' in 'field list'
20120404-032614
20120404-032614 Got error from query: 'select SYSTEM_USER '
20120404-032614 Unknown column 'SYSTEM_USER' in 'field list'
20120404-032614
20120404-032614 Got error from query: 'select USER '
20120404-032614 Unknown column 'USER' in 'field list'
20120404-032614
20120404-032614 Got error from query: 'drop table crash_me_d '
20120404-032614 Unknown table 'crash_me_d'
20120404-032614 Supports YYYY-MM-DD (ISO) format: yes
20120404-032614 Supports DATE 'YYYY-MM-DD' (ISO) format: yes
20120404-032614 Supports DD.MM.YYYY (EUR) format:
20120404-032614 Got error from query: 'insert into crash_me_d(a) values
('16.08.1963')'
20120404-032614 Received an invalid DATE value '16.08.1963'.
20120404-032614 no
20120404-032614 Supports DATE 'DD.MM.YYYY' (EUR) format:
20120404-032614 Got error from query: 'insert into crash_me_d(a) values (DATE
'16.08.1963')'
20120404-032614 Received an invalid DATE value '16.08.1963'.
20120404-032614 no
20120404-032614 Supports YYYYMMDD format: yes
20120404-032614 Supports DATE 'YYYYMMDD' format: yes
20120404-032614 Supports MM/DD/YYYY format: yes
20120404-032614 Supports DATE 'MM/DD/YYYY' format: yes
20120404-032614 Supports 0000-00-00 dates:
20120404-032614 Got error from query: 'insert into crash_me2 values
('0000-00-00')'
20120404-032614 Received an invalid DATE value '0000-00-00'.
20120404-032614 no
20120404-032614 Supports 0001-01-01 dates: yes
20120404-032614 Supports 9999-12-31 dates: yes
20120404-032614 Supports 'infinity dates:
20120404-032614 Got error from query: 'insert into crash_me2 values
('infinity')'
20120404-032614 Received an invalid DATE value 'infinity'.
20120404-032614 no
20120404-032614 Supports YY-MM-DD dates: yes
20120404-032614 Supports YY-MM-DD 2000 compilant dates: yes
20120404-032614 WEEK:
20120404-032614 Got error from query: 'select week('1997-02-01') '
20120404-032614 You have an error in your SQL syntax; check the manual that
corresponds to your Drizzle server version for the right syntax to use near
'('1997-02-01')' at line 1
20120404-032614 no
20120404-032614 Function DAYNAME: yes
20120404-032614 Function MONTH: yes
20120404-032614 Function MONTHNAME: yes
20120404-032614 Function DAYOFMONTH: yes
20120404-032614 Function DAYOFWEEK: yes
20120404-032614 Function DAYOFYEAR: yes
20120404-032614 Function QUARTER: yes
20120404-032614 Function YEAR: yes
20120404-032614 Function DATEADD:
20120404-032614 Got error from query: 'select dateadd(day,3,'1997-11-30') from
crash_me_d'
20120404-032614 FUNCTION dateadd does not exist
20120404-032614 no
20120404-032614 Function MDY:
20120404-032614 Got error from query: 'select mdy(7,1,1998) from crash_me_d'
20120404-032614 FUNCTION mdy does not exist
20120404-032614 no
20120404-032614 Function DATEDIFF:
20120404-032614 Got error from query: 'select datediff(month,'Oct 21
1997','Nov 30 1997') from crash_me_d'
20120404-032614 Incorrect parameter count in the call to native function
'datediff'
20120404-032614 no
20120404-032614 Function DATENAME:
20120404-032614 Got error from query: 'select datename(month,'Nov 30 1997')
from crash_me_d'
20120404-032614 FUNCTION datename does not exist
20120404-032614 no
20120404-032614 Function DATEPART:
20120404-032614 Got error from query: 'select datepart(month,'July 20 1997')
from crash_me_d'
20120404-032614 FUNCTION datepart does not exist
20120404-032614 no
20120404-032614 Function DATE_FORMAT: yes
20120404-032614 Function FROM_DAYS:
20120404-032614 query: select from_days(729024) from crash_me_d didn't return
any result
20120404-032614 no
20120404-032614 Function FROM_UNIXTIME: yes
20120404-032614 Function MONTHS_BETWEEN:
20120404-032614 Got error from query: 'select
months_between('1997-02-02','1997-01-01') from crash_me_d'
20120404-032614 FUNCTION months_between does not exist
20120404-032614 no
20120404-032614 Function PERIOD_ADD: yes
20120404-032614 Function PERIOD_DIFF: yes
20120404-032614 Function WEEKDAY: yes
20120404-032614 Function ADDDATE: yes
20120404-032614 Function SUBDATE: yes
20120404-032614 Function DATEDIFF (2 arg): yes
20120404-032614 Function WEEKOFYEAR:
20120404-032614 Got error from query: 'select WEEKOFYEAR('1963-08-16') from
crash_me_d'
20120404-032614 FUNCTION WEEKOFYEAR does not exist
20120404-032614 no
20120404-032614 Function CHAR (conversation date):
20120404-032614 Got error from query: 'select CHAR(a,EUR) from crash_me_d'
20120404-032614 Unknown column 'EUR' in 'field list'
20120404-032614 no
20120404-032614 Function MAKEDATE: yes
20120404-032614 Function TO_DAYS: yes
20120404-032614 Function ADD_MONTHS:
20120404-032614 Got error from query: 'select add_months('1997-01-01',1) from
crash_me_d'
20120404-032614 FUNCTION add_months does not exist
20120404-032614 no
20120404-032614 Function LAST_DAY: yes
20120404-032614 Function DATE: yes
20120404-032614 Function DAY: yes
20120404-032614
20120404-032614 Got error from query: 'drop table crash_me_t '
20120404-032614 Unknown table 'crash_me_t'
20120404-032614 Supports HH:MM:SS (ISO) time format: yes
20120404-032614 Supports HH.MM.SS (EUR) time format:
20120404-032614 Got error from query: 'insert into crash_me_t(a) values
('20.08.16')'
20120404-032614 Received an invalid TIME value '20.08.16'.
20120404-032614 no
20120404-032614 Supports HHHHmmSS time format:
20120404-032614 Got error from query: 'insert into crash_me_t(a) values
('00200816')'
20120404-032614 Received an invalid TIME value '00200816'.
20120404-032614 no
20120404-032614 Supports HHmmSS time format: no
20120404-032614 Supports HH:MM:SS (AM|PM) time format:
20120404-032614 Got error from query: 'insert into crash_me_t(a) values
('08:08:16 PM')'
20120404-032614 Received an invalid TIME value '08:08:16 PM'.
20120404-032614 no
20120404-032614
20120404-032614 Got error from query: 'insert into crash_me_t values(20:08:16)'
20120404-032614 You have an error in your SQL syntax; check the manual that
corresponds to your Drizzle server version for the right syntax to use near
':08:16)' at line 1
20120404-032614 Function HOUR: yes
20120404-032614 Function ANSI HOUR:
20120404-032614 Got error from query: 'select hour(TIME '12:13:14') '
20120404-032614 You have an error in your SQL syntax; check the manual that
corresponds to your Drizzle server version for the right syntax to use near
''12:13:14')' at line 1
20120404-032614 no
20120404-032614 Function MINUTE: yes
20120404-032614 Function SECOND: yes
20120404-032614 Function TIME_TO_SEC:
20120404-032614 Got error from query: 'select time_to_sec('01:23:21') '
20120404-032614 FUNCTION time_to_sec does not exist
20120404-032614 no
20120404-032614 Function SEC_TO_TIME:
20120404-032614 Got error from query: 'select sec_to_time(5001) '
20120404-032614 FUNCTION sec_to_time does not exist
20120404-032614 no
20120404-032614 Function ADDTIME:
20120404-032614 Got error from query: 'select ADDTIME('20:02:12','00:00:03') '
20120404-032614 FUNCTION ADDTIME does not exist
20120404-032614 no
20120404-032614 Function SUBTIME:
20120404-032614 Got error from query: 'select SUBTIME('20:02:15','00:00:03') '
20120404-032614 FUNCTION SUBTIME does not exist
20120404-032614 no
20120404-032614 Function TIMEDIFF:
20120404-032614 Got error from query: 'select TIMEDIFF('20:02:15','20:02:12') '
20120404-032614 FUNCTION TIMEDIFF does not exist
20120404-032614 no
20120404-032614 Function MAKETIME:
20120404-032614 Got error from query: 'select MAKETIME(20,02,12) '
20120404-032614 FUNCTION MAKETIME does not exist
20120404-032614 no
20120404-032614 Function TIME:
20120404-032614 Got error from query: 'select time('20:02:12') '
20120404-032614 You have an error in your SQL syntax; check the manual that
corresponds to your Drizzle server version for the right syntax to use near
'('20:02:12')' at line 1
20120404-032614 no
20120404-032614 NOT ID BETWEEN interprets as ID NOT BETWEEN:yes
20120404-032614 LIKE on numbers: REPORT LIKE on numbers yes
20120404-032614 column LIKE column: REPORT column LIKE column yes
20120404-032614 update of column= -column: REPORT update of column= -column yes
20120404-032614 String functions on date columns: yes
20120404-032614 char are space filled:
20120404-032614 query: 'select b || b from crash_me where b = 'a ''
returned 'aa' instead of 'a a '
20120404-032614 no
20120404-032614 Update with many tables:
20120404-032614 Got error from query: 'update crash_q left join crash_me on
crash_q.a=crash_me.a set crash_q.b=crash_me.b'
20120404-032614 You have an error in your SQL syntax; check the manual that
corresponds to your Drizzle server version for the right syntax to use near
'left join crash_me on crash_q.a=crash_me.a set crash_q.b=crash_me.b' at line 1
20120404-032614
20120404-032614 Got error from query: 'update crash_q,crash_me set
crash_q.b=crash_me.b where crash_q.a=crash_me.a'
20120404-032614 You have an error in your SQL syntax; check the manual that
corresponds to your Drizzle server version for the right syntax to use near
'crash_me set crash_q.b=crash_me.b where crash_q.a=crash_me.a' at line 1
20120404-032614 no
20120404-032614 DELETE FROM table1,table2...:
20120404-032614 Got error from query: 'delete crash_q.* from crash_q,crash_me
where crash_q.a=crash_me.a'
20120404-032614 You have an error in your SQL syntax; check the manual that
corresponds to your Drizzle server version for the right syntax to use near
'crash_q.* from crash_q,crash_me where crash_q.a=crash_me.a' at line 1
20120404-032614 REPORT DELETE FROM table1,table2... no
20120404-032614 Update with sub select: yes
20120404-032614 Calculate 1--1: yes
20120404-032614 ANSI SQL simple joins:
20120404-032614 Got error from query: 'select crash_me.a from crash_me,
crash_me t0'
20120404-032614 Implicit cartesian join attempted.
20120404-032614 REPORT ANSI SQL simple joins no
20120404-032614 max text or blob size: 1048576 (cache)
20120404-032614 constant string size in where: 1048576 (cache)
20120404-032614 constant string size in SELECT: 1048576 (cache)
20120404-032614 return string size from function: DBD::drizzle::st execute
warning: at
<http://jenkins.drizzle.org/job/drizzle-staging-dbqp-crashme-32/ws/tests/sql-bench/crash-me>
line 3835, <CONFIG_FILE> line 4.
20120404-032614 .DBD::drizzle::st execute warning: at
<http://jenkins.drizzle.org/job/drizzle-staging-dbqp-crashme-32/ws/tests/sql-bench/crash-me>
line 3835, <CONFIG_FILE> line 4.
20120404-032614 .DBD::drizzle::st execute warning: at
<http://jenkins.drizzle.org/job/drizzle-staging-dbqp-crashme-32/ws/tests/sql-bench/crash-me>
line 3835, <CONFIG_FILE> line 4.
20120404-032614 .DBD::drizzle::st execute warning: at
<http://jenkins.drizzle.org/job/drizzle-staging-dbqp-crashme-32/ws/tests/sql-bench/crash-me>
line 3835, <CONFIG_FILE> line 4.
20120404-032614 ..DBD::drizzle::st execute warning: at
<http://jenkins.drizzle.org/job/drizzle-staging-dbqp-crashme-32/ws/tests/sql-bench/crash-me>
line 3835, <CONFIG_FILE> line 4.
20120404-032614 .DBD::drizzle::st execute warning: at
<http://jenkins.drizzle.org/job/drizzle-staging-dbqp-crashme-32/ws/tests/sql-bench/crash-me>
line 3835, <CONFIG_FILE> line 4.
20120404-032614 .DBD::drizzle::st execute warning: at
<http://jenkins.drizzle.org/job/drizzle-staging-dbqp-crashme-32/ws/tests/sql-bench/crash-me>
line 3835, <CONFIG_FILE> line 4.
20120404-032614 ..DBD::drizzle::st execute warning: at
<http://jenkins.drizzle.org/job/drizzle-staging-dbqp-crashme-32/ws/tests/sql-bench/crash-me>
line 3835, <CONFIG_FILE> line 4.
20120404-032614 .DBD::drizzle::st execute warning: at
<http://jenkins.drizzle.org/job/drizzle-staging-dbqp-crashme-32/ws/tests/sql-bench/crash-me>
line 3835, <CONFIG_FILE> line 4.
20120404-032614 .....DBD::drizzle::st execute warning: at
<http://jenkins.drizzle.org/job/drizzle-staging-dbqp-crashme-32/ws/tests/sql-bench/crash-me>
line 3835, <CONFIG_FILE> line 4.
20120404-032614 ....DBD::drizzle::st execute warning: at
<http://jenkins.drizzle.org/job/drizzle-staging-dbqp-crashme-32/ws/tests/sql-bench/crash-me>
line 3835, <CONFIG_FILE> line 4.
20120404-032614 32704
20120404-032614 simple expressions: +10000
20120404-032614 big expressions: DBD::drizzle::st execute warning: at
<http://jenkins.drizzle.org/job/drizzle-staging-dbqp-crashme-32/ws/tests/sql-bench/crash-me>
line 3570, <CONFIG_FILE> line 4.
20120404-032614 +100
20120404-032614 stacked expressions: +2000
20120404-032614 OR and AND in WHERE: ...Killed
20120404-032614
20120404-032614 ERROR Failed test. Use --force to execute beyond the first
test failure
20120404-032614 ===============================================================
20120404-032614 INFO Test execution complete in 1671 seconds
20120404-032614 INFO Summary report:
20120404-032614 INFO Executed 1/1 test cases, 100.00 percent
20120404-032614 INFO STATUS: FAIL, 1/1 test cases, 100.00 percent executed
20120404-032614 INFO FAIL tests: main.crashme
20120404-032614 INFO Spent 1664 / 1671 seconds on: TEST(s)
20120404-032614 INFO Test execution complete
20120404-032614 INFO Stopping all running servers...
Build step 'Execute shell' marked build as failure
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-builds
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-builds
More help : https://help.launchpad.net/ListHelp
