You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-11-02 06:13:16 +03:00
17 lines
399 B
Plaintext
17 lines
399 B
Plaintext
DROP DATABASE IF EXISTS mcol5778;
|
|
CREATE DATABASE mcol5778;
|
|
USE mcol5778;
|
|
create table test ( a double, b double ) engine=columnstore;
|
|
insert into test values (100,100);
|
|
select sum(a)/NULLIF(sum(b),0) from test;
|
|
sum(a)/NULLIF(sum(b),0)
|
|
1
|
|
select sum(a)/NULLIF(b,0) from test;
|
|
sum(a)/NULLIF(b,0)
|
|
1
|
|
select sum(a)/NULLIF(100,0) from test;
|
|
sum(a)/NULLIF(100,0)
|
|
1
|
|
drop table test;
|
|
DROP DATABASE mcol5778;
|