Stupid oversight on my side: it probably depends on sql-mode. I will check
on Monday.
But if this is desired behavior (what I don't think) then at least the
error message is wrong and confusing in strict mode.
-- Peter
On Fri, Nov 6, 2015 at 10:53 AM, Peter Laursen
wrote:
> There are updates i
Hi,
> On 6 Nov 2015, at 07:40, Peter Laursen wrote:
>
> yup .. this is good!
>
> SELECT VERSION(); -- 10.1.8-MariaDB
>
> CREATE DATABASE vctest;
> USE vctest;
>
> CREATE TABLE `t1`(
> `id` INT NOT NULL,
> `id3` INT AS ( id*3 ) VIRTUAL
> );
>
> INSERT INTO `t1` VALUES (1,3);
> -- retru
There are updates in the bug report (http://bugs.mysql.com/bug.php?id=79148).
Those who are interested in the subject should read it.
Unfortunately Oracle chose a client-side and not server-side solution to
this problem. As a consequence 'mysqldumps' from Oracle/MySQL will restore
in MariaDB, but
Further research:
It *does not work* with the .msi package for Windows:
select version();
-- 10.1.8-MariaDB
CREATE TABLE `t1_virtual_uk` (
`f1` int(11) DEFAULT NULL,
`gc` int(11) AS (f1 + 1) VIRTUAL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
insert into `t1_virtual_uk` values (1,2);
-- Error
4 matches
Mail list logo
