[MCOL-3594] Failed tests in the 001 suite in 1.4 - Jira

XML

Word

Printable

There are a number of different issues in test001 that must be addressed before we release.

includes

MCOL-3747 Regression in 1.4 working_ssb_compareLogOnly/sub/order_limit_sub

MCOL-3749 Truncate may cause mysqld to assert during update

MCOL-3760 rand() returns different results in 1.4 vs 1.2

MCOL-3867 from_unixtime() not giving expected output for a given time zone

MCOL-3868 unix_timestamp() output incorrect when time_zone is not 0:00

MCOL-3869 Use the server time_zone system variable for functions that it affects in ColumnStore.

relates to

MCOL-4102 Get all regression tests green in 1.5

(1 includes, 1 relates to)

1.	format(c1,0) returns only sign w/o a digit on a decimal (1) field	Closed	Gagan Goel (Inactive)
2.	TIMEDIFF() returns NULL instead of expected value	Closed	Daniel Lee (Inactive)
3.	ORDER BY over negative SEC_TO_TIME() results produce an incorrect order	Closed	Daniel Lee (Inactive)
4.	UDaFs moda() and regr_ are not created in 1.4	Closed	Daniel Lee (Inactive)
5.	Create bit_count(), charset(), unhex() and minute() functions that doesn't exists in CS in 1.4	Closed	David Hall (Inactive)
6.	regr_ tests returns doubles with higher precision in 1.4 then in 1.2	Closed	Daniel Lee (Inactive)
7.	windowFunctions failures	Closed	Daniel Lee (Inactive)
8.	Implement ISTRUE() function	Closed	Daniel Lee (Inactive)
9.	CS does not support LIMIT in correlated subqueries, but gives erroneous results	Closed	Daniel Lee (Inactive)
10.	CLONE - TIMEDIFF() returns NULL instead of expected value	Closed	Daniel Lee (Inactive)
11.	CLONE - windowFunctions failures	Closed	Daniel Lee (Inactive)
12.	CLONE - windowFunctions failures	Closed	Daniel Lee (Inactive)

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.