Differential D7297 Diff 18194 autotests/reference/test_syntax.sql.ref

Changeset View

Standalone View

View Options

autotests/reference/test_syntax.sql.ref

1<Normal Text>-- kate: hl </Normal Text><Keyword>SQL</Keyword><Normal Text> (Oracle)</Normal Text><br/> 1​<Comment>-- kate: hl SQL (Oracle)</Comment><br/>
2<Normal Text>-- </Normal Text><Keyword>test</Keyword><Normal Text> </Normal Text><Keyword>case</Keyword><Normal Text> shipped </Normal Text><Keyword>with</Keyword><Normal Text> highlighting </Normal Text><Keyword>in</Keyword><Normal Text> bugzilla, LGPL</Normal Text><br/> 2​<Comment>-- test case shipped with highlighting in bugzilla, LGPL</Comment><br/>
3<dsNormal></dsNormal><br/> 3​<dsNormal></dsNormal><br/>
4<Keyword>begin</Keyword><br/> 4​<Keyword>begin</Keyword><br/>
5<Normal Text> </Normal Text><Operator>q'{</Operator><String>adfasdf'sadfasdf j</String><Operator>}'</Operator><Normal Text>{</Normal Text><String>' hkjhkhkjhkjh khlkhklj'</String><Normal Text>fghdfghdfgh</Normal Text><String>'hkjh'</String><Normal Text>jkhkh</Normal Text><String>'a'</String><br/> 5​<Normal Text> </Normal Text><Operator>q'{</Operator><String>adfasdf'sadfasdf j</String><Operator>}'</Operator><Normal Text>{</Normal Text><String>' hkjhkhkjhkjh khlkhklj'</String><Normal Text>fghdfghdfgh</Normal Text><String>'hkjh'</String><Normal Text>jkhkh</Normal Text><String>'a'</String><br/>
6<Normal Text> </Normal Text><Operator>Q'(</Operator><String>asldflahsl;'dkjfhklsdfh</String><Operator>)'</Operator><br/> 6​<Normal Text> </Normal Text><Operator>Q'(</Operator><String>asldflahsl;'dkjfhklsdfh</String><Operator>)'</Operator><br/>
7<Normal Text> </Normal Text><Operator>q'[</Operator><String>asdasd;'asdasd'a]sd'asd'asasd</String><Operator>]'</Operator><Normal Text>;11111111[1</Normal Text><String>']; asdasdasdasd'</String><Normal Text>errrrrrrrrrrrrrr-p</Normal Text><br/> 7​<Normal Text> </Normal Text><Operator>q'[</Operator><String>asdasd;'asdasd'a]sd'asd'asasd</String><Operator>]'</Operator><Normal Text>;11111111[</Normal Text><Number>1</Number><String>']; asdasdasdasd'</String><Normal Text>errrrrrrrrrrrrrr-p</Normal Text><br/>
8<dsNormal></dsNormal><br/> 8​<dsNormal></dsNormal><br/>
9<Normal Text> </Normal Text><Operator>q'a</Operator><String>gdfgsdfgfhfghjfgh'f'f'sdfg'sdfg'dfg#</String><Operator>a'</Operator><Normal Text> dafdfadasfasdf;</Normal Text><br/> 9​<Normal Text> </Normal Text><Operator>q'a</Operator><String>gdfgsdfgfhfghjfgh'f'f'sdfg'sdfg'dfg#</String><Operator>a'</Operator><Normal Text> dafdfadasfasdf;</Normal Text><br/>
10<dsNormal></dsNormal><br/> 10​<dsNormal></dsNormal><br/>
11<Normal Text> </Normal Text><Operator>Q'#</Operator><String>gdfgsdfgsdfgsdfgsdfg</String><Operator>#'</Operator><Normal Text> afgasasdfasdfasfasdfasdfasdfasdfsdf</Normal Text><br/> 11​<Normal Text> </Normal Text><Operator>Q'#</Operator><String>gdfgsdfgsdfgsdfgsdfg</String><Operator>#'</Operator><Normal Text> afgasasdfasdfasfasdfasdfasdfasdfsdf</Normal Text><br/>
12<dsNormal></dsNormal><br/> 12​<dsNormal></dsNormal><br/>
13<Normal Text> </Normal Text><Keyword>if</Keyword><Normal Text> sldfjsdj </Normal Text><Keyword>then</Keyword><br/> 13​<Normal Text> </Normal Text><Keyword>if</Keyword><Normal Text> sldfjsdj </Normal Text><Keyword>then</Keyword><br/>
14<Normal Text> </Normal Text><Keyword>case</Keyword><br/> 14​<Normal Text> </Normal Text><Keyword>case</Keyword><br/>
15<Normal Text> </Normal Text><Keyword>when</Keyword><Normal Text> 1=1 </Normal Text><Keyword>then</Keyword><br/> 15​<Normal Text> </Normal Text><Keyword>when</Keyword><Normal Text> </Normal Text><Number>1</Number><Normal Text>=1 </Normal Text><Keyword>then</Keyword><br/>
16<Normal Text> aslfjsldkfj;</Normal Text><br/> 16​<Normal Text> aslfjsldkfj;</Normal Text><br/>
17<Normal Text> </Normal Text><Keyword>when</Keyword><Normal Text> 2=2 </Normal Text><Keyword>then</Keyword><br/> 17​<Normal Text> </Normal Text><Keyword>when</Keyword><Normal Text> </Normal Text><Number>2</Number><Normal Text>=2 </Normal Text><Keyword>then</Keyword><br/>
18<Normal Text> asdfg;</Normal Text><br/> 18​<Normal Text> asdfg;</Normal Text><br/>
19<Normal Text> </Normal Text><Keyword>else</Keyword><br/> 19​<Normal Text> </Normal Text><Keyword>else</Keyword><br/>
20<Normal Text> </Normal Text><Keyword>null</Keyword><Normal Text>;</Normal Text><br/> 20​<Normal Text> null;</Normal Text><br/>
21<Normal Text> </Normal Text><Keyword>end case</Keyword><Normal Text>;</Normal Text><br/> 21​<Normal Text> </Normal Text><Keyword>end case</Keyword><Normal Text>;</Normal Text><br/>
22<Normal Text> </Normal Text><br/> 22​<Normal Text> </Normal Text><br/>
23<Normal Text> </Normal Text><Keyword>if</Keyword><Normal Text> sdfjh </Normal Text><Keyword>then</Keyword><br/> 23​<Normal Text> </Normal Text><Keyword>if</Keyword><Normal Text> sdfjh </Normal Text><Keyword>then</Keyword><br/>
24<Normal Text> </Normal Text><Keyword>for</Keyword><Normal Text> i </Normal Text><Keyword>in</Keyword><Normal Text> 1 </Normal Text><Operator>..</Operator><Normal Text> 2</Normal Text><br/> 24​<Normal Text> </Normal Text><Keyword>for</Keyword><Normal Text> i </Normal Text><Keyword>in</Keyword><Normal Text> </Normal Text><Number>1</Number><Normal Text> </Normal Text><Operator>..</Operator><Normal Text> </Normal Text><Number>2</Number><br/>
25<Normal Text> </Normal Text><Keyword>LOOP</Keyword><br/> 25​<Normal Text> </Normal Text><Keyword>LOOP</Keyword><br/>
26<Normal Text> dbms_output.put_line(</Normal Text><Operator>q';</Operator><String>ololo</String><Operator>;'</Operator><Normal Text>);</Normal Text><br/> 26​<Normal Text> dbms_output.put_line(</Normal Text><Operator>q';</Operator><String>ololo</String><Operator>;'</Operator><Normal Text>);</Normal Text><br/>
27<Normal Text> </Normal Text><Keyword>END Loop</Keyword><Normal Text>;</Normal Text><br/> 27​<Normal Text> </Normal Text><Keyword>END Loop</Keyword><Normal Text>;</Normal Text><br/>
28<Normal Text> </Normal Text><br/> 28​<Normal Text> </Normal Text><br/>
29<Normal Text> </Normal Text><Keyword>while</Keyword><Normal Text> </Normal Text><Keyword>true</Keyword><br/> 29​<Normal Text> </Normal Text><Keyword>while</Keyword><Normal Text> </Normal Text><Keyword>true</Keyword><br/>
30<Normal Text> </Normal Text><Keyword>loop</Keyword><br/> 30​<Normal Text> </Normal Text><Keyword>loop</Keyword><br/>
31<Normal Text> dbms_output.put_line(</Normal Text><String>'1111'</String><Normal Text>);</Normal Text><br/> 31​<Normal Text> dbms_output.put_line(</Normal Text><String>'1111'</String><Normal Text>);</Normal Text><br/>
32<Normal Text> </Normal Text><Keyword>end loop</Keyword><Normal Text>;</Normal Text><br/> 32​<Normal Text> </Normal Text><Keyword>end loop</Keyword><Normal Text>;</Normal Text><br/>
33<Normal Text> </Normal Text><Keyword>end if</Keyword><Normal Text>;</Normal Text><br/> 33​<Normal Text> </Normal Text><Keyword>end if</Keyword><Normal Text>;</Normal Text><br/>
34<Normal Text> ksjfklasjd;</Normal Text><br/> 34​<Normal Text> ksjfklasjd;</Normal Text><br/>
35<Normal Text> fklj;</Normal Text><br/> 35​<Normal Text> fklj;</Normal Text><br/>
36<Normal Text> elsif</Normal Text><br/> 36​<Normal Text> </Normal Text><Keyword>elsif</Keyword><br/>
37<Normal Text> sdklfjsdklfj;</Normal Text><br/> 37​<Normal Text> sdklfjsdklfj;</Normal Text><br/>
38<Normal Text> </Normal Text><Keyword>else</Keyword><br/> 38​<Normal Text> </Normal Text><Keyword>else</Keyword><br/>
39<Normal Text> sdfdfsdf;</Normal Text><br/> 39​<Normal Text> sdfdfsdf;</Normal Text><br/>
40<Normal Text> </Normal Text><Keyword>end if</Keyword><Normal Text>;</Normal Text><br/> 40​<Normal Text> </Normal Text><Keyword>end if</Keyword><Normal Text>;</Normal Text><br/>
41<Keyword>end</Keyword><Normal Text>;</Normal Text><br/> 41​<Keyword>end</Keyword><Normal Text>;</Normal Text><br/>