maria-developers team mailing list archive

[Peter Laursen <peter_laursen@xxxxxxxxxx>]

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 as various clients would
'abort on error' and flood its log with error messages.

-- Peter

On Fri, Nov 6, 2015 at 11:32 AM, Ian Gilfillan <ian@xxxxxxxxxxx> wrote:

>
> 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 AS ( id*3 ) VIRTUAL
>> );
>>
>> INSERT INTO `vc_test`.`t1` VALUES (1,3);
>> -- retruns: Error Code: 1906 - The value specified for computed column
>> 'id3' in table 't1' ignored
>>
>> SELECT * FROM t1;
>> -- returns empty set
>>
>>
>> So here the error message is that "value is ignored" (not that it is "not
>> allowed").  It looks to me like somebody in MariaDB actually identified the
>> problem, but forgot to finish things.
>>
>> The statement should succeed (maybe raise a warning), and the "specified
>> value should be ignored" as the error message says, but what it in reality
>> is not.
>>
>> What say?
>>
>
> In 10.1.8, the above returns:
> SELECT * FROM t1;
> +----+------+
> | id | id3  |
> +----+------+
> |  1 |    3 |
> +----+------+
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-developers
> Post to     : maria-developers@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-developers
> More help   : https://help.launchpad.net/ListHelp
>