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