make working view-protocol

MDEV-27944 View-protocol fails if database was changed

• 
• Open

MDEV-27945 Select from view with multi-byte charsets gives incorrect result

• 
• Open

MDEV-27957 Select from view with subselect fails with lost connection

• 
• Stalled

MDEV-28017 Illegal mix of collations (cp1251_general_ci,IMPLICIT), (latin1_swedish_ci,COERCIBLE), (latin1_swedish_ci,COERCIBLE) for operation 'between'

• 
• Open

MDEV-28535 View is created with wrong column name if there are more than one same column name or column name is empty

• 
• Closed

MDEV-28536 Incorrect sequence in view column processing created as select with ROLLUP and repeated columns in GROUP BY

• 
• Open

MDEV-28538 RELEASE_LOCK return NULL in the definition of the view if select statement has GROUP BY

• 
• Open

MDEV-28570 Select from view fails if definition of view has 'HAVING' in query

• 
• Closed

MDEV-28571 Select from view fails if definition of view has aggregate function ( like 'GROUP_CONCAT(COUNT(a))' ) in query

• 
• Closed

MDEV-28573 View has to fail with error ER_SUBQUERY_NO_1_ROW (1242) but it doesn't

• 
• Closed

MDEV-28585 Wrong result for view defined as SELECT ROW(1,2,3) = (SELECT 1,2,NULL)

• 
• Open

MDEV-28602 Wrong result with outer join, merged derived table and view

• 
• Closed

MDEV-28603 Invalid view when its definition uses TVC as single-value subquery

• 
• Closed

MDEV-28643 view protocol fails due to different column name

• 
• Closed

MDEV-28649 json_array(false) in the definition of view return 0 instead of "true"

• 
• Open

MDEV-28651 quote(NULL) returns incorrect result in view ('NU' instead of 'NULL')

• 
• Open

MDEV-28652 SUBSTRING(str,pos,len) returns incorrect result in view (returns an empty string)

• 
• Open

MDEV-28659 View returns wrong value for big digits nuber

• 
• Open

MDEV-28660 TRUNCATE(X,D) returns incorrect result in view

• 
• Open

MDEV-28661 MIN(X) returns incorrect result in view

• 
• Open

MDEV-28673 View returns different value for min(year) function

• 
• Open

MDEV-28677 UDF returns wrong string value in view

• 
• Open

MDEV-28678 UDF + ORDER BY returns twice the value in view

• 
• Closed

MDEV-28696 View created as "select b''; " references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

• 
• Closed

MDEV-29207 Update view have to fail with error ER_VIEW_CHECK_FAILED (1369), but it doesn't

• 
• Open

MDEV-29224 Wrong result with aggregate function in uncorrelated SELECT subquery in view definition

• 
• Closed

MDEV-29231 View returns wrong value with SQL_MODE 'NO_BACKSLASH_ESCAPES'

• 
• Stalled

MDEV-29278 Failed with wrong errno 1205: 'Lock wait timeout exceeded; try restarting transaction', instead of 1213..

• 
• Open

MDEV-29290 Hex value instead char in definition of view gives incorrect result

• 
• Open

MDEV-29295 Double convert of ',' in view definition gives incorrect result

• 
• Open

MDEV-29524 "-0000000000000001" changes to "-1" in view definition, so type changes from bigint to int

• 
• Open

MDEV-29525 CAST in view definition returns string instead of NULL on warning and gives incorrect round

• 
• Open

MDEV-29526 ROUND(X,D) returns incorrect result in view when D>9

• 
• Open

MDEV-29534 In view FROM_UNIXTIME adds .000000 in the result

• 
• Open

MDEV-29537 Creation of view with UNION and SELECT ... FOR UPDATE in definition is failed with error

• 
• Open

MDEV-29542 The first character in column name has lowercase instead of uppercase in view created on table " mysql.user"

• 
• Open

MDEV-29552 LEFT and RIGHT with big value for parameter 'len' >0 return empty value in view

• 
• Open

MDEV-29553 SQL_MODE=ORACLE for INTERSECT doesn't work for view

• 
• Open

MDEV-29554 View created on view with order by does not keep sorting

• 
• Open

MDEV-29601 View in view protocol uses incorrect character set with util connection

• 
• Open

MDEV-29645 OFFSET doesn't work with view

• 
• Open

MDEV-29646 sformat('Num [{:20}]', 42) gives incorrect result in view

• 
• Open

MDEV-29647 ROW_NUMBER is not 0 for warnings in case without row in view

• 
• Open

MDEV-30229 In view definition (in .frm) 'multipoint' is changed to 'geometrycollection' that causes internal error

• 
• Open