[MDEV-26486] Can't show Routines (Function And Procedure) Created: 2021-08-27  Updated: 2021-10-18  Resolved: 2021-10-18

Status: Closed
Project: MariaDB Server
Component/s: Stored routines
Affects Version/s: 10.1.3
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: febriyant Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: MariaDB-server, need_feedback
Environment:

CentOS 7

Attachments: PNG File error_routines2.png    

 Description   

I Got Some issue when I dump databases and when I select from information_schema.routines

I got error message like this 

SQL Error [1074] [42000]:(conn=3543)Column length too big for column '(null)' (max=65532);use BLOB or TEXT instead

Where does the issue come from?

 Comments   
Comment by Alice Sherepa [ 2021-08-30 ]

10.1 line has reached EOL, does it happen on a newer MariaDB vesrion?
https://www.reddit.com/r/mariadb/comments/ezqxs6/column_length_too_big_for_column_null_error_on/ smth alike

Comment by febriyant [ 2021-09-16 ]

actually my production site using 10.1

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