Correction .. there is no error (except for my copy-paste error). This is
perfect and exactly as I think it should be.
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,
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);
-- retruns: Error Code: 1906 - The value specified for computed column
'id3' in table 't1' ignor
The insert statement returns a warning:
INSERT INTO `test`.`t1` VALUES (1,3);
Query OK, 1 row affected, 1 warning (0.07 sec)
Warning (Code 1906): The value specified for computed column 'id3' in
table 't1' ignored
On 06/11/2015 08:09, Peter Laursen wrote:
OK, I should have upgraded. But I am
OK, I should have upgraded. But I am currently travelling an with a small
laptop only and an Internet connectivity not fit for downloads (call it a
bad excuse if you want! :-) )
So it actually INSERTS. That is nice. But does it return an error or
warning or nothing? It should not be an error IMO a
06/11/2015 07:51, Peter Laursen wrote:
I reported this bug report to Oracle:
http://bugs.mysql.com/bug.php?id=79148
It is almost the same in MariaDB - but the error message is different, see
SELECT VERSION(); -- 10.1.2-MariaDB-log
CREATE TABLE `vc_test`.`t1`(
`id` INT NOT NULL,
`id3` INT
I reported this bug report to Oracle: http://bugs.mysql.com/bug.php?id=79148
It is almost the same in MariaDB - but the error message is different, see
SELECT VERSION(); -- 10.1.2-MariaDB-log
CREATE TABLE `vc_test`.`t1`(
`id` INT NOT NULL,
`id3` INT AS ( id*3 ) VIRTUAL
);
INSERT INTO `vc_te
Hi, Wlad!
Mostly ok, please see below
On Nov 03, w...@mariadb.com wrote:
> revision-id: 7931ca4f89ad5cd38ea3dc54f1363b7de2fd3414
> (mariadb-10.0.22-5-g7931ca4)
> parent(s): fa1438cbf4307731a54ea4137d5f7d4b744cdfbc
> committer: Vladislav Vaintroub
> timestamp: 2015-11-03 11:32:00 +0100
> message:
Hi Sergei,
On Thu, Nov 05, 2015 at 03:49:08PM +0100, Sergei Golubchik wrote:
> > > On Nov 03, Sergey Vojtovich wrote:
> > > > revision-id: 01bd373f8f0cf2e1737d01a48033a7615b2a
> > > > (mariadb-10.1.8-23-g01bd373)
> > > > parent(s): dc40d737d4af3cb0e272c58507ad54e4eb24be28
> > > > committer:
Hi, Sergey!
On Nov 05, Sergey Vojtovich wrote:
> revision-id: 178cddd664cb4ce2c6ccbe76c33e4fd2c1fc1b3d
> (mariadb-10.1.8-25-g178cddd)
> parent(s): 2ef562d2c74297b0b92c4322697dad98767cc873
> committer: Sergey Vojtovich
> timestamp: 2015-11-05 13:57:24 +0400
> message:
>
> MDEV-9082 - Debian: mysq
Hi, Sergey!
On Nov 05, Sergey Vojtovich wrote:
> Hi Sergei,
>
> On Thu, Nov 05, 2015 at 03:30:53PM +0100, Sergei Golubchik wrote:
> > Hi, Sergey!
> >
> > On Nov 03, Sergey Vojtovich wrote:
> > > revision-id: 01bd373f8f0cf2e1737d01a48033a7615b2a
> > > (mariadb-10.1.8-23-g01bd373)
> > > paren
Hi Sergei,
On Thu, Nov 05, 2015 at 03:30:53PM +0100, Sergei Golubchik wrote:
> Hi, Sergey!
>
> On Nov 03, Sergey Vojtovich wrote:
> > revision-id: 01bd373f8f0cf2e1737d01a48033a7615b2a
> > (mariadb-10.1.8-23-g01bd373)
> > parent(s): dc40d737d4af3cb0e272c58507ad54e4eb24be28
> > committer: Serg
Hi, Sergey!
ok to push
On Nov 04, Sergey Vojtovich wrote:
> revision-id: 2ef562d2c74297b0b92c4322697dad98767cc873
> (mariadb-10.1.8-24-g2ef562d)
> parent(s): 01bd373f8f0cf2e1737d01a48033a7615b2a
> committer: Sergey Vojtovich
> timestamp: 2015-11-04 20:37:16 +0400
> message:
>
> MDEV-9080 -
Hi Sergei,
On Thu, Nov 05, 2015 at 03:23:30PM +0100, Sergei Golubchik wrote:
> Hi, Sergey!
>
> On Nov 03, Sergey Vojtovich wrote:
> > revision-id: dc40d737d4af3cb0e272c58507ad54e4eb24be28
> > (mariadb-10.1.8-22-gdc40d73)
> > parent(s): a574407444fc3ea93ca88afa93dc18154251bf74
> > committer: Serg
Hi, Sergey!
On Nov 03, Sergey Vojtovich wrote:
> revision-id: 01bd373f8f0cf2e1737d01a48033a7615b2a
> (mariadb-10.1.8-23-g01bd373)
> parent(s): dc40d737d4af3cb0e272c58507ad54e4eb24be28
> committer: Sergey Vojtovich
> timestamp: 2015-11-03 14:02:49 +0400
> message:
>
> MDEV-8437 - plugin varia
Hi, Sergey!
On Nov 03, Sergey Vojtovich wrote:
> revision-id: dc40d737d4af3cb0e272c58507ad54e4eb24be28
> (mariadb-10.1.8-22-gdc40d73)
> parent(s): a574407444fc3ea93ca88afa93dc18154251bf74
> committer: Sergey Vojtovich
> timestamp: 2015-11-03 12:08:23 +0400
> message:
>
> MDEV-8437 - plugin varia
15 matches
Mail list logo