New protocols for MTR (MDEV-31002)

[MDEV-27691] make working view-protocol Created: 2022-01-31  Updated: 2023-10-04

Status: Open
Project: MariaDB Server
Component/s: Tests
Affects Version/s: None
Fix Version/s: 10.4, 10.5, 10.6

Type: Technical task Priority: Major
Reporter: Oleksandr Byelkin Assignee: Oleksandr Byelkin
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
PartOf
includes MDEV-27871 View is created with wrong column nam... Stalled
includes MDEV-27872 Deleting database failed when running... Open
includes MDEV-27873 Test main.mysqlcheck fails with view-... Open
includes MDEV-27904 Illegal mix of collations (utf8mb3_ge... Open
includes MDEV-27938 Error on execution 'select from' view... Open
includes MDEV-27944 View-protocol fails if database was c... Open
includes MDEV-27945 Select from view with multi-byte char... Open
includes MDEV-27957 Select from view with subselect fails... Closed
includes MDEV-28017 Illegal mix of collations (cp1251_gen... Closed
includes MDEV-28535 View is created with wrong column nam... Closed
includes MDEV-28536 Incorrect sequence in view column pro... Open
includes MDEV-28538 RELEASE_LOCK return NULL in the defi... Open
includes MDEV-28570 Select from view fails if definition ... Closed
includes MDEV-28571 Select from view fails if definition ... Closed
includes MDEV-28573 View has to fail with error ER_SUBQUE... Closed
includes MDEV-28585 Wrong result for view defined as SELE... Open
includes MDEV-28602 Wrong result with outer join, merged ... Closed
includes MDEV-28603 Invalid view when its definition uses... Closed
includes MDEV-28643 view protocol fails due to different ... Closed
includes MDEV-28649 json_array(false) in the definition o... Stalled
includes MDEV-28651 quote(NULL) returns incorrect result ... Closed
includes MDEV-28652 SUBSTRING(str,pos,len) returns incorr... Open
includes MDEV-28659 View returns wrong value for big digi... Open
includes MDEV-28660 TRUNCATE(X,D) returns incorrect resul... Open
includes MDEV-28661 MIN(X) returns incorrect result in view Open
includes MDEV-28673 View returns different value for min... Open
includes MDEV-28677 UDF returns wrong string value in view Open
includes MDEV-28678 UDF + ORDER BY returns twice the val... Closed
includes MDEV-28696 View created as "select b''; " refer... Closed
includes MDEV-29207 Update view have to fail with error E... Open
includes MDEV-29224 Wrong result with aggregate function... Closed
includes MDEV-29231 View returns wrong value with SQL_MOD... Stalled
includes MDEV-29278 Failed with wrong errno 1205: 'Lock w... Open
includes MDEV-29290 Hex value instead char in definition ... Open
includes MDEV-29295 Double convert of ',' in view definit... Open
includes MDEV-29524 "-0000000000000001" changes to "-1" i... Open
includes MDEV-29525 CAST in view definition returns strin... Open
includes MDEV-29526 ROUND(X,D) returns incorrect result ... Open
includes MDEV-29534 In view FROM_UNIXTIME adds .000000 in... Open
includes MDEV-29537 Creation of view with UNION and SELEC... Open
includes MDEV-29542 The first character in column name ha... Closed
includes MDEV-29552 LEFT and RIGHT with big value for par... Open
includes MDEV-29553 SQL_MODE=ORACLE for INTERSECT doesn't... Open
includes MDEV-29554 View created on view with order by ... Open
includes MDEV-29601 View in view protocol uses incorrect ... Closed
includes MDEV-29645 OFFSET doesn't work with view Open
includes MDEV-29646 sformat('Num [{:20}]', 42) gives inco... Closed
includes MDEV-29647 ROW_NUMBER is not 0 for warnings in c... Open
includes MDEV-30229 In view definition (in .frm) 'multipo... Open
Relates
relates to MDEV-28475 Aggregate functions does not work whe... Open
relates to MDEV-31407 Add aliases in opt_trace.test for lon... Closed
relates to MDEV-31408 Second SELECT from VIEW based on info... Closed

 Description   

Find and fix problems of running main test suite with --view-protocol.

Note: It is "umbrella" task to find real problem and connect them here.

 Comments   
Comment by Oleksandr Byelkin [ 2022-02-15 ]

Merge 2 commits together and OK to push!

Comment by Lena Startseva [ 2022-02-16 ]

Merge and push to 10.3 done

Comment by Oleksandr Byelkin [ 2022-06-27 ]

1) I added service connection control, please use it. ( 1625a9a3a9a4fe2017a15893c2ed0a807a4b18a1 )
2) please remove adding empty lines if there is no changes above or after them
3) please fix up all commits in one (except connection control)

Comment by Oleksandr Byelkin [ 2022-06-27 ]

also please add in the connected mdev-s a note that disable of a view protocol should be made instead of adding a new test.

Comment by Oleksandr Byelkin [ 2022-09-05 ]

It looks OK. but now we should merge it let us discuss it.

Comment by Lena Startseva [ 2022-09-30 ]

Check, plz, branches in bb-10.*-all-builders

Generated at Thu Feb 08 09:54:50 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.