SELECT 

  R.splitlot_id,

  R.run_id, 

  I.ptest_info_id,

  COLUMN_GET(R.dynamic_flags,I.ptest_info_id as CHAR(1)),

  COLUMN_GET(R.dynamic_value,I.ptest_info_id as DECIMAL ) 

FROM  

  wt_ptest_results_rows R INNER JOIN

  wt_ptest_info I on R.splitlot_id=I.splitlot_id

where 

  COLUMN_GET(R.dynamic_value,I.ptest_info_id as DECIMAL) IS NOT NULL;

CREATE VIEW `wt_ptest_results_view`

(splitlot_id,run_id,ptest_info_id,flags,value) AS 

SELECT 

  R.splitlot_id,

  R.run_id, 

  I.ptest_info_id,

  COLUMN_GET(R.dynamic_flags,I.ptest_info_id as CHAR(1)),

  COLUMN_GET(R.dynamic_value,I.ptest_info_id as DECIMAL ) 

FROM  

  wt_ptest_results_rows R INNER JOIN

  wt_ptest_info I on R.splitlot_id=I.splitlot_id

where 

  COLUMN_GET(R.dynamic_value,I.ptest_info_id as DECIMAL) IS NOT NULL;

select * from wt_ptest_results_view limit 1;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that

corresponds to your MariaDB server version for the right syntax to use near ') a

s char(1) charset utf8) AS `flags`,cast(column_get(`r`.`dynamic_value`,`i`.`p' a

t line 1

show create view wt_ptest_results_view;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that

corresponds to your MariaDB server version for the right syntax to use near ') a

s char(1) charset utf8) AS `flags`,cast(column_get(`r`.`dynamic_value`,`i`.`p' a

t line 1

CREATE TABLE `wt_ptest_info` (

  `splitlot_id` int(10) unsigned NOT NULL DEFAULT '0',

  `ptest_info_id` smallint(5) unsigned NOT NULL DEFAULT '0',

  KEY `wtptestinfo_splitlot_ptest` (`splitlot_id`,`ptest_info_id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 PACK_KEYS=1

CREATE TABLE `wt_ptest_results_rows` (

  `splitlot_id` int(10) unsigned NOT NULL DEFAULT '0',

  `run_id` mediumint(7) unsigned NOT NULL DEFAULT '0',

  `dynamic_flags` blob,

  `dynamic_value` blob,

  PRIMARY KEY (`splitlot_id`,`run_id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1