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