[MCOL-163] DOUBLE PRECISION synonym for DOUBLE datatype not supported Created: 2016-06-22  Updated: 2017-01-18  Resolved: 2017-01-17

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

Type: Bug Priority: Major
Reporter: Justin Swanhart (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2017-01, 2017-2

 Description   

create table fact (
i1 tinyint,
i2 smallint,
– i3 mediumint,
i4 int,
i8 bigint,
i1u tinyint unsigned,
i2u smallint unsigned,
– i3u mediumint unsigned,
i4u int unsigned,
i8u bigint unsigned,
d1 decimal(65),
d2 decimal(65,1),
d3 decimal(65,30),
d5 decimal(5,5),
f1 float,
f2 float(2,1),
f23 float(23,4),
f24 float(24,10),
f53 float(53,20),
r1 real,
r23 real(23,4),
r24 real(24,10),
r53 real(53,20),
dp1 double precision,
– b0 bit(0),
– b1 bit(1),
– b64 bit(64),
d date,
dt datetime,
– ts timestamp,
– t time,
– y2 year(2),
– y4 year(4),
c0 char(0),
c1 char(1),
c2 char(255),
vc0 varchar(0),
vc1 varchar(1),
vc2 varchar(255)
– vb0 varbinary(0),
– vb1 varbinary(1),
– vb2 varbinary(255),
– bi0 binary(0),
– bi1 binary(1),
– bi2 binary(255)
– bl0 blob(0),
– bl1 blob(1),
– bl2 blob(255),
– tx0 text(0),
– tx1 text(1),
– tx2 text(255),
– e1 enum('a'),
– e2 enum(' ', 'a'),
– e3 enum(' ', 'a', 'abc'),
– s1 set('a'),
– s2 set(' ', 'a'),
– s3 set(' ', 'a', 'abc')
) ENGINE=COLUMNSTORE

1178 - The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore. Please check the Columnstore syntax guide for supported syntax or data types.

 Comments   
Comment by David Hall (Inactive) [ 2017-01-06 ]

We need a regression test for this

Comment by Andrew Hutchings (Inactive) [ 2017-01-06 ]

Yep. Pull request added for test

Comment by David Hall (Inactive) [ 2017-01-06 ]

Daniel, just check to be sure you can create a table with "double" and with "double precision". Both should work. A regression test has been added.

Comment by Daniel Lee (Inactive) [ 2017-01-17 ]

Build verified: Github source build.

[root@builder mariadb-columnstore-server]# git show
commit 83b0e5c54a644bc31461752cf73f0e1140586d39
Merge: b975814 93c1c7e
Author: david hill <david.hill@mariadb.com>
Date: Thu Jan 12 09:27:28 2017 -0600

Merge pull request #26 from mariadb-corporation/MCOL-500

Update README.md

MariaDB [mytest]> create table t1 (dp1 double, dp2 double precision) engine=columnstore;
Query OK, 0 rows affected (1.15 sec)

MariaDB [mytest]> desc t1;
--------------------------------+

Field Type Null Key Default Extra

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

dp1 double YES   NULL  
dp2 double YES   NULL  

--------------------------------+
2 rows in set (0.00 sec)

Comment by Daniel Lee (Inactive) [ 2017-01-18 ]

Retested in the correct branch

Build verified: Github source build.

[root@localhost mariadb-columnstore-server]# git show
commit 9c73cdaa843fe475c0362fb478dae9fff2d0d355
Merge: 9ddd6d0 4c07522
Author: David Hill <david.hill@mariadb.com>
Date: Tue Dec 13 12:02:46 2016 -0600

merge develop branch

Comment by Daniel Lee (Inactive) [ 2017-01-18 ]

Retested:

Build verified: Github source build

[root@localhost mariadb-columnstore-server]# git show
commit 83b0e5c54a644bc31461752cf73f0e1140586d39
Merge: b975814 93c1c7e
Author: david hill <david.hill@mariadb.com>
Date: Thu Jan 12 09:27:28 2017 -0600

Merge pull request #26 from mariadb-corporation/MCOL-500

Update README.md

[root@localhost mariadb-columnstore-engine]# git show
commit c6799df6408c0e86ccba9ee63929a6b9ad4294bf
Merge: fa0fde9 2f3937a
Author: Andrew Hutchings <andrew@linuxjedi.co.uk>
Date: Fri Jan 13 21:03:35 2017 -0600

Merge pull request #96 from mariadb-corporation/MCOL-505

MCOL-505 Performance improvements to ExeMgr

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