[MCOL-642] Add BLOB/TEXT detection Created: 2017-03-27  Updated: 2017-05-02  Resolved: 2017-05-02

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.1.0
Fix Version/s: 1.1.0

Type: New Feature Priority: Major
Reporter: Andrew Hutchings (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MCOL-267 TEXT and BLOB data types are not supp... Closed
Sprint: 2017-6, 2017-7, 2017-8, 2017-9

 Description   

We need to detect the difference between BLOB and TEXT so that cpimport can use string data for text and hex data for blob.

This can be done by having two distinct types in our DDL instead of making it all BLOB.



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2017-03-27 ]
  • TEXT and BLOB now have separate identifiers internally
  • TEXT columns are identified as such in system catalog
  • cpimport only requires hex input for BLOB, not TEXT

For testing the existing BLOB test case covers this. You can see TEXT columns in editem and other places that probe the extent map.

Comment by Daniel Lee (Inactive) [ 2017-05-02 ]

Build verified:

[root@localhost mariadb-columnstore-server]# git show
commit 5a090c64bced6532578dd8910f15530fd37fce2c
Merge: 9efb0a7 b062156
Author: david hill <david.hill@mariadb.com>
Date: Thu Apr 27 16:13:15 2017 -0500

Merge pull request #45 from mariadb-corporation/FixPackageName

Change the package name to match engines format

[root@localhost mariadb-columnstore-engine]# git show
commit 715a514f155338c616d8408e5a7e7edc6cadba2f
Merge: 6320a59 f6caa88
Author: Andrew Hutchings <andrew@linuxjedi.co.uk>
Date: Thu Apr 27 17:38:57 2017 +0100

Merge branch 'MCOL-597' into develop

MariaDB [mytest]> create table t1 (c1 int, c2 text, b3 blob, c4 longtext, c5 longblob) engine=columnstore;
Query OK, 0 rows affected (0.19 sec)

MariaDB [calpontsys]> select columnname, datatype from syscolumn where tablename='t1';
--------------------+

columnname datatype

--------------------+

c1 6
c2 24
b3 15
c4 24
c5 15

--------------------+
5 rows in set (0.01 sec)

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