File: declare_variable.sql

package info (click to toggle)
sqlfluff 3.5.0-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 34,000 kB
  • sloc: python: 106,131; sql: 34,188; makefile: 52; sh: 8
file content (23 lines) | stat: -rw-r--r-- 872 bytes parent folder | download | duplicates (3)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
declare var1 int64;
declare var2, var3 string;
declare var4 default 'value';
declare var5 int64 default 1 + 2;
declare var6 string(10);
declare var7 numeric(5, 2);
declare arr1 array<string>;
declare arr2 default ['one', 'two'];
declare arr3 default [];
declare arr4 array<string> default ['one', 'two'];
declare arr5 array<string(10)>;
declare str1 struct<f1 string, f2 string>;
declare str2 struct<f1 string, f2 string> default struct('one', 'two');
declare str3 default struct('one', 'two');
declare str4 struct<f1 string, f2 string> default ('one', 'two');
declare str5 struct<f1 string(10), f2 string(10)>;
-- Defining variables in quoted names
declare `var1` string;
declare `var1` string default 'value';
declare `var1`, `var1` string;
-- Defining variables mixing quoted and unquoted names
declare var1, `var2` string;
declare var1, `var2` string default 'value';