Bug 3914 - Schema specific variables
Summary: Schema specific variables
Status: NEW
Alias: None
Product: SQL
Classification: Unclassified
Component: all (show other bugs)
Version: -- development
Hardware: Other Mac OS X
: Normal enhancement
Assignee: SQL devs
Depends on:
Reported: 2016-02-01 22:42 CET by Martin Kersten
Modified: 2016-04-11 11:45 CEST (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Martin Kersten cwiconfidential 2016-02-01 22:42:52 CET
User-Agent:       Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0
Build Identifier: 

SQL variables should be qualified by the schema in which they are declared.
Currently, they are erroneously global for all schemas.

Reproducible: Always

Steps to Reproduce:
create schema xyz;
declare version='2016';
select xyz.version;