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