Score:0

MariaDB do not store select all view

ug flag

im using views in mariadb. at the moment i'm on a windows server. if i save in windows an select *(all) view for a table. next time if i open the view it stays as an select *(all).

in linux(i tested ubuntu and centos) after saving the view it writes out an select for each table not for an an select * (all).

Example Image: linux

linux:

select `abo_duration`.`dur_id` AS `dur_id`,`abo_duration`.`dur_name` AS `dur_name`,`abo_duration`.`dur_short` AS `dur_short`,`abo_duration`.`dur_order` AS `dur_order`,`abo_duration`.`asdadsfasdf` AS `asdadsfasdf`,`abo_duration`.`neu` AS `neu` from `abo_duration`

Example Image: windows

windows:

SELECT * from abo_duration 

is this an config issue?

ty

Score:0
ua flag

No. Those are just two representations of the same thing. The shorter form will (sooner or later) be converted to the longer form. Then the processing will occur.

I can't be more specific without first understanding what you mean by "saving the view" and "writes out".

ug flag
i added two images for trying to explain my problem. they are two servers. replicated. one is in ubuntu(linux) and one is in windows. look at the writeouts. windows will leave the view as an select all. but linux does the select for column.
ua flag
Are you doing `EXPLAIN SELECT ... ; SHOW WARNINGS;`? That is the only way I know to _see_ the longer form.
mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.