Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.1.0
-
None
-
2017-10
Description
Build tested: Github source
[root@localhost mariadb-columnstore-server]# git show
commit 349cae544b6bc71910267a3b3b0fa3fb57b0a587
Merge: bd13090 2ecb85c
Author: benthompson15 <ben.thompson@mariadb.com>
Date: Thu May 4 16:06:16 2017 -0500
Merge pull request #50 from mariadb-corporation/10.2-fixes
10.2 fixes
[root@localhost mariadb-columnstore-server]# cd mariadb-columnstore-engine/
[root@localhost mariadb-columnstore-engine]# git show
commit 03c62656b3750fd5f9759897f048bda8423c4aae
Author: david hill <david.hill@mariadb.com>
Date: Wed May 10 10:35:56 2017 -0500
update post-install
removed test lines of echo adn early exit
diff --git a/oam/install_scripts/post-install b/oam/install_scripts/post-install
index c09e7d5..69dfb58 100755
— a/oam/install_scripts/post-install
+++ b/oam/install_scripts/post-install
@@ -36,10 +36,6 @@ for arg in "$@"; do
echo "post-install: ignoring unknown argument: $arg" 1>&2
fi
done
-
-echo $installdir
-echo $prefix
-exit 0
if [ $user != "root" ]; then
export COLUMNSTORE_INSTALL_DIR=$installdir
MariaDB [mytest]> select cidx, CTEXT from datatypetestm;
-----------------+
| cidx | CTEXT |
-----------------+
| 1 | aaaaaaaaaaa |
-----------------+
1 row in set (0.02 sec)
COUNT()
MariaDB [mytest]> select cidx, CTEXT, COUNT(CTEXT) from datatypetestm group by cidx, CTEXT;
-----------------------
| cidx | CTEXT | COUNT(CTEXT) |
-----------------------
| 1 | NULL | 1 |
-----------------------
1 row in set (0.02 sec)
MariaDB [mytest]> select cidx, CTEXT, COUNT(CLONGTEXT) from datatypetestm group by cidx, CTEXT;
---------------------------
| cidx | CTEXT | COUNT(CLONGTEXT) |
---------------------------
| 1 | NULL | 1 |
---------------------------
1 row in set (0.01 sec)
MIN()
MariaDB [mytest]> select MIN(CTEXT) from datatypetestm;
------------
| MIN(CTEXT) |
------------
| NULL |
------------
1 row in set (0.01 sec)
MariaDB [mytest]> select MIN(CLONGTEXT) from datatypetestm;
----------------
| MIN(CLONGTEXT) |
----------------
| NULL |
----------------
1 row in set (0.01 sec)
MAX()
MariaDB [mytest]> select MAX(CTEXT) from datatypetestm;
------------
| MAX(CTEXT) |
------------
| NULL |
------------
1 row in set (0.01 sec)
MariaDB [mytest]> select MAX(CLONGTEXT) from datatypetestm;
----------------
| MAX(CLONGTEXT) |
----------------
| NULL |
----------------
1 row in set (0.01 sec)
Same behavior when there are more than one row
Same behavior when there is only three columns in the table (int, TEXT, LONGTEXT).