[MDEV-28649] json_array(false) in the definition of view return 0 instead of "true" Created: 2022-05-23  Updated: 2024-01-23

Status: Stalled
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9
Fix Version/s: 10.11

Type: Bug Priority: Major
Reporter: Lena Startseva Assignee: Alexey Botchkov
Resolution: Unresolved Votes: 0
Labels: view-protocol

Issue Links:
PartOf
is part of MDEV-27691 make working view-protocol Open
Relates
relates to MDEV-28651 quote(NULL) returns incorrect result ... Closed
relates to MDEV-32454 JSON test has problem in view protocol Stalled

 Description   

In query

select json_array(false);

result is

[false]

but test with view

create view v1 as select json_array(false);
select * from v1;
drop view v1;

gives result:

[0]



 Comments   
Comment by Oleksandr Byelkin [ 2023-10-25 ]

do not believe fix version, check where it is better to fix it.

Comment by Alexey Botchkov [ 2023-12-14 ]

https://github.com/MariaDB/server/commit/6835d2ce268b001a9a4f85d92c132c58e33d490e

Generated at Thu Feb 08 10:02:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.