Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.3
-
None
Description
The following demonstrates the problem:
MariaDB [test]> create view v1(a) as values (3), (7), (1);
|
|
MariaDB [test]> show create view v1;
|
+------+--------------------------------------------------------------------------------------------+----------------------+----------------------+
|
| View | Create View | character_set_client | collation_connection |
|
+------+--------------------------------------------------------------------------------------------+----------------------+----------------------+
|
| v1 | CREATE ALGORITHM=UNDEFINED DEFINER=`` SQL SECURITY DEFINER VIEW `v1` AS values (3),(7),(1) | utf8 | utf8_general_ci |
|
+------+--------------------------------------------------------------------------------------------+----------------------+----------------------+
|
 |
MariaDB [test]> select * from v1;
|
+---+
|
| 3 |
|
+---+
|
| 3 |
|
| 7 |
|
| 1 |
|
+---+
|