Yes, I am stupid... My example was as I thought it works. In fact there was one more step.
CREATE TABLE IF NOT EXISTS 'test' (`testcol2` INTEGER);
ALTER TABLE 'test' ADD COLUMN `testcol` float;
INSERT INTO 'test' (`testcol`) VALUES ('1111');
SELECT * from 'test';
Yes, I know that table was altered but I forgotten to check the type. C++
code is sometimes hard to maintain.
Thanks for forcing me to think more.
Regards
