The Ultimate Guide to High Availability with MariaDB

Comments - DATABASE() function within a view - behaviour defined?

3 years, 10 months ago Oleksandr Byelkin
Re: DATABASE() function within a view - behaviour defined? [Answer]

Why you think if something written about stored procedures it can be related to views. views do not set current database:

create view v1 as select database() as db; select * from v1; db test create database test2; use test2; select * from test.v1; db test2

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.