Failed tests in the 001 suite in 1.4 (MCOL-3594)

[MCOL-3756] Implement ISTRUE() function Created: 2020-02-04  Updated: 2020-11-12  Resolved: 2020-05-06

Status: Closed
Project: MariaDB ColumnStore
Component/s: PrimProc
Affects Version/s: None
Fix Version/s: 1.4.4, 1.5.1

Type: Sub-Task Priority: Major
Reporter: Roman Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2020-1, 2020-2, 2020-3, 2020-4, 2020-5, 2020-6, 2020-7
Epic/Theme: 1.4_regressions

 Description   

The test working_tpch1_compareLogOnly/view/mts_view.60.sql fails with

MariaDB [test]> insert into table_24532 values (0, 0, 0, 0);
 
Query OK, 1 row affected (0.540 sec)
 
 
 
MariaDB [test]> select * from view_24532_a;
 
 ERROR 1178 (42000): The storage engine for the table doesn't support IDB-1001: Function 'istrue' can only be used in the outermost select or order by clause and cannot be used in conjunction with an aggregate function.



 Comments   
Comment by Roman [ 2020-04-07 ]

4QA. There was a relevant test added: working_tpch1/qa_fe_cnxFunctions/truth_functions.sql

Comment by Daniel Lee (Inactive) [ 2020-05-06 ]

Build verified: 1.4.4-1, 1.5.0-1 source

1.4.4-1

/root/ColumnStore/buildColumnstoreFromGithubSource/server
commit d8ff39957275afc7a870487631cd3b3be5eb8818
Author: Rasmus Johansson <razze@iki.fi>
Date: Mon May 4 10:10:07 2020 +0000

MDEV-22273 jUnit patch: xml test result differs from MTR output in case if retry

/root/ColumnStore/buildColumnstoreFromGithubSource/server/engine
commit 4c275557633edb60905faa500990d55a6834951d
Merge: aa054a9 47f2933
Author: David.Hall <david.hall@mariadb.com>
Date: Tue May 5 12:34:03 2020 -0500

Merge pull request #1179 from pleblanc1976/update-libs3-ref

Updated the s3 lib.

1.5.0-1

/root/ColumnStore/buildColumnstoreFromGithubSource/server
commit 43b7e5d29a5480214cee8317a4625b749ccffbaf
Author: Rasmus Johansson <razze@iki.fi>
Date: Mon May 4 10:10:07 2020 +0000

MDEV-22273 jUnit patch: xml test result differs from MTR output in case if retry

/root/ColumnStore/buildColumnstoreFromGithubSource/server/engine
commit 368c4fac059d5cf4f1596e56ea7b1e729e29ec49
Merge: 15a9efa 4bc408c
Author: David.Hall <david.hall@mariadb.com>

Date: Tue May 5 12:35:14 2020 -0500

Merge pull request #1178 from pleblanc1976/update-libs3-ref-1.5

Updated s3 lib ref

Verified scripts against innodb tables.

Generated at Thu Feb 08 02:45:12 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.