Warning, /frameworks/syntax-highlighting/autotests/reference/test.sql.ref is written in an unsupported language. File is not indexed.
0001 <Comment>-- comment</Comment><br/> 0002 <Normal Text></Normal Text><br/> 0003 <Keyword>CREATE</Keyword><Normal Text> </Normal Text><Keyword>TABLE</Keyword><Normal Text> stuff </Normal Text><Keyword>COLUMNS</Keyword><Normal Text>(col1 </Normal Text><Data Type>INT</Data Type><Normal Text>, col2 </Normal Text><Data Type>Varchar</Data Type><Normal Text>);</Normal Text><br/> 0004 <Keyword>SELECT</Keyword><Normal Text> </Normal Text><Operator>*</Operator><Normal Text> </Normal Text><Keyword>FROM</Keyword><Normal Text> stuff </Normal Text><Keyword>WHERE</Keyword><Normal Text> </Normal Text><Keyword>id</Keyword><Normal Text> </Normal Text><Operator>=</Operator><Normal Text> </Normal Text><String>'string'</String><Normal Text>;</Normal Text><br/> 0005 <Keyword>select</Keyword><Normal Text> </Normal Text><Operator>*</Operator><Normal Text> </Normal Text><Keyword>from</Keyword><Normal Text> stuff </Normal Text><Keyword>where</Keyword><Normal Text> </Normal Text><Keyword>id</Keyword><Normal Text> </Normal Text><Operator><</Operator><Normal Text> </Normal Text><Float>0.42</Float><Normal Text>;</Normal Text><br/> 0006 <Keyword>Select</Keyword><Normal Text> col1, col2 </Normal Text><Keyword>From</Keyword><Normal Text> stuff </Normal Text><Keyword>Where</Keyword><Normal Text> stuff.col1 </Normal Text><Operator Keyword>IS</Operator Keyword><Normal Text> </Normal Text><Operator Keyword>NOT</Operator Keyword><Normal Text> </Normal Text><Keyword>NuLL</Keyword><Normal Text>;</Normal Text><br/> 0007 <Normal Text></Normal Text><br/> 0008 <Keyword>CREATE</Keyword><Normal Text> </Normal Text><Keyword>TABLE</Keyword><Normal Text> Persons (</Normal Text><br/> 0009 <Normal Text> </Normal Text><Keyword>ID</Keyword><Normal Text> </Normal Text><Data Type>int</Data Type><Normal Text> </Normal Text><Operator Keyword>NOT</Operator Keyword><Normal Text> </Normal Text><Keyword>NULL</Keyword><Normal Text> AUTO_INCREMENT,</Normal Text><br/> 0010 <Normal Text> LastName </Normal Text><Data Type>varchar</Data Type><Normal Text>(</Normal Text><Decimal>255</Decimal><Normal Text>) </Normal Text><Operator Keyword>NOT</Operator Keyword><Normal Text> </Normal Text><Keyword>NULL</Keyword><Normal Text>,</Normal Text><br/> 0011 <Normal Text> FirstName </Normal Text><Data Type>varchar</Data Type><Normal Text>(</Normal Text><Decimal>255</Decimal><Normal Text>),</Normal Text><br/> 0012 <Normal Text> Age </Normal Text><Data Type>int</Data Type><Normal Text>,</Normal Text><br/> 0013 <Normal Text> </Normal Text><Keyword>PRIMARY</Keyword><Normal Text> </Normal Text><Keyword>KEY</Keyword><Normal Text> (</Normal Text><Keyword>ID</Keyword><Normal Text>)</Normal Text><br/> 0014 <Normal Text> </Normal Text><Keyword>CONSTRAINT</Keyword><Normal Text> CHK_Person </Normal Text><Keyword>CHECK</Keyword><Normal Text> (Age</Normal Text><Operator>>=</Operator><Decimal>18</Decimal><Normal Text> </Normal Text><Operator Keyword>AND</Operator Keyword><Normal Text> City</Normal Text><Operator>=</Operator><String>'Sandnes'</String><Normal Text>)</Normal Text><br/> 0015 <Normal Text>);</Normal Text><br/> 0016 <Normal Text></Normal Text><br/> 0017 <Keyword>SELECT</Keyword><Normal Text> column_name(s)</Normal Text><br/> 0018 <Keyword>FROM</Keyword><Normal Text> table1</Normal Text><br/> 0019 <Keyword>FULL</Keyword><Normal Text> </Normal Text><Keyword>OUTER</Keyword><Normal Text> </Normal Text><Keyword>JOIN</Keyword><Normal Text> table2 </Normal Text><Keyword>ON</Keyword><Normal Text> table1.column_name </Normal Text><Operator>=</Operator><Normal Text> table2.column_name;</Normal Text><br/> 0020 <Normal Text></Normal Text><br/> 0021 <Keyword>SELECT</Keyword><Normal Text> </Normal Text><Operator>*</Operator><Normal Text> </Normal Text><Keyword>FROM</Keyword><Normal Text> Customers</Normal Text><br/> 0022 <Keyword>WHERE</Keyword><Normal Text> City </Normal Text><Operator Keyword>LIKE</Operator Keyword><Normal Text> </Normal Text><String>'[bsp]%'</String><Normal Text>;</Normal Text><br/> 0023 <Normal Text></Normal Text><br/> 0024 <Keyword>SELECT</Keyword><Normal Text> </Normal Text><Function>Count</Function><Normal Text>(</Normal Text><Operator>*</Operator><Normal Text>) </Normal Text><Keyword>AS</Keyword><Normal Text> DistinctCountries</Normal Text><br/> 0025 <Keyword>FROM</Keyword><Normal Text> (</Normal Text><Keyword>SELECT</Keyword><Normal Text> </Normal Text><Keyword>DISTINCT</Keyword><Normal Text> Country </Normal Text><Keyword>FROM</Keyword><Normal Text> Customers)</Normal Text><br/> 0026 <Keyword>GROUP</Keyword><Normal Text> </Normal Text><Keyword>BY</Keyword><Normal Text> Country</Normal Text><br/> 0027 <Keyword>HAVING</Keyword><Normal Text> </Normal Text><Function>COUNT</Function><Normal Text>(CustomerID) </Normal Text><Operator>></Operator><Normal Text> </Normal Text><Decimal>5</Decimal><br/> 0028 <Keyword>ORDER</Keyword><Normal Text> </Normal Text><Keyword>BY</Keyword><Normal Text> </Normal Text><Function>COUNT</Function><Normal Text>(CustomerID) </Normal Text><Keyword>DESC</Keyword><Normal Text>;</Normal Text><br/> 0029 <Normal Text></Normal Text><br/> 0030 <Keyword>SELECT</Keyword><Normal Text> </Normal Text><String>'Customer'</String><Normal Text> </Normal Text><Keyword>As</Keyword><Normal Text> </Normal Text><Keyword>Type</Keyword><Normal Text>, ContactName, City, Country</Normal Text><br/> 0031 <Keyword>FROM</Keyword><Normal Text> Customers</Normal Text><br/> 0032 <Keyword>UNION</Keyword><br/> 0033 <Keyword>SELECT</Keyword><Normal Text> </Normal Text><String>'Supplier'</String><Normal Text>, ContactName, City, Country</Normal Text><br/> 0034 <Keyword>FROM</Keyword><Normal Text> Suppliers;</Normal Text><br/> 0035 <Normal Text></Normal Text><br/> 0036 <Keyword>SELECT</Keyword><Normal Text> </Normal Text><Function>COUNT</Function><Normal Text>(ProductID), </Normal Text><Function>AVG</Function><Normal Text>(Price)</Normal Text><br/> 0037 <Keyword>FROM</Keyword><Normal Text> Products;</Normal Text><br/> 0038 <Normal Text></Normal Text><br/> 0039 <Keyword>SET</Keyword><Normal Text> lock_timeout </Normal Text><Operator>=</Operator><Normal Text> </Normal Text><Decimal>0</Decimal><Normal Text>;</Normal Text><br/> 0040 <Keyword>SET</Keyword><Normal Text> client_encoding </Normal Text><Operator>=</Operator><Normal Text> </Normal Text><String>'UTF8'</String><Normal Text>;</Normal Text><br/> 0041 <Keyword>SET</Keyword><Normal Text> standard_conforming_strings </Normal Text><Operator>=</Operator><Normal Text> </Normal Text><Keyword>on</Keyword><Normal Text>;</Normal Text><br/> 0042 <Keyword>SET</Keyword><Normal Text> check_function_bodies </Normal Text><Operator>=</Operator><Normal Text> </Normal Text><Keyword>false</Keyword><Normal Text>;</Normal Text><br/> 0043 <Keyword>SET</Keyword><Normal Text> client_min_messages </Normal Text><Operator>=</Operator><Normal Text> warning;</Normal Text><br/> 0044 <Keyword>SET</Keyword><Normal Text> default_tablespace </Normal Text><Operator>=</Operator><Normal Text> </Normal Text><String>''</String><Normal Text>;</Normal Text><br/> 0045 <Normal Text></Normal Text><br/> 0046 <Keyword>DROP</Keyword><Normal Text> </Normal Text><Keyword>TABLE</Keyword><Normal Text> </Normal Text><ControlFlow>IF</ControlFlow><Normal Text> </Normal Text><Keyword>EXISTS</Keyword><Normal Text> employees;</Normal Text><br/> 0047 <Normal Text></Normal Text><br/> 0048 <Keyword>ALTER</Keyword><Normal Text> </Normal Text><Keyword>TABLE</Keyword><Normal Text> </Normal Text><Keyword>ONLY</Keyword><Normal Text> employees</Normal Text><br/> 0049 <Normal Text> </Normal Text><Keyword>ADD</Keyword><Normal Text> </Normal Text><Keyword>CONSTRAINT</Keyword><Normal Text> fk_employees_employees </Normal Text><Keyword>FOREIGN</Keyword><Normal Text> </Normal Text><Keyword>KEY</Keyword><Normal Text> (reportsto) </Normal Text><Keyword>REFERENCES</Keyword><Normal Text> employees;</Normal Text><br/> 0050 <Normal Text></Normal Text><br/> 0051 <Keyword>CREATE</Keyword><Normal Text> </Normal Text><Keyword>VIEW</Keyword><Normal Text> [</Normal Text><Keyword>Current</Keyword><Normal Text> Product </Normal Text><Keyword>List</Keyword><Normal Text>] </Normal Text><Keyword>AS</Keyword><br/> 0052 <Keyword>SELECT</Keyword><Normal Text> ProductID, ProductName</Normal Text><br/> 0053 <Keyword>FROM</Keyword><Normal Text> Products</Normal Text><br/> 0054 <Keyword>WHERE</Keyword><Normal Text> Discontinued </Normal Text><Operator>=</Operator><Normal Text> </Normal Text><Keyword>No</Keyword><Normal Text>;</Normal Text><br/> 0055 <Normal Text></Normal Text><br/> 0056 <Keyword>SELECT</Keyword><Normal Text> </Normal Text><Operator>*</Operator><Normal Text> </Normal Text><Keyword>FROM</Keyword><Normal Text> [</Normal Text><Keyword>Current</Keyword><Normal Text> Product </Normal Text><Keyword>List</Keyword><Normal Text>];</Normal Text><br/> 0057 <Normal Text></Normal Text><br/> 0058 <Keyword>SELECT</Keyword><Normal Text> </Normal Text><Operator>*</Operator><Normal Text> </Normal Text><Keyword>FROM</Keyword><Normal Text> [</Normal Text><Keyword>Category</Keyword><Normal Text> Sales </Normal Text><ControlFlow>For</ControlFlow><Normal Text> </Normal Text><Decimal>1997</Decimal><Normal Text>]</Normal Text><br/> 0059 <Keyword>WHERE</Keyword><Normal Text> CategoryName </Normal Text><Operator>=</Operator><Normal Text> </Normal Text><String>'Beverages'</String><Normal Text>;</Normal Text><br/> 0060 <Normal Text></Normal Text><br/> 0061 <ControlFlow>begin</ControlFlow><br/> 0062 <ControlFlow>end</ControlFlow><br/> 0063 <Symbol>/</Symbol><br/> 0064 <Normal Text> </Normal Text><Operator>/</Operator><br/> 0065 <Operator>/</Operator><Normal Text> u</Normal Text><br/> 0066 <Normal Text></Normal Text><br/> 0067 <Comment>/* nested /* comments */ for */</Comment><Normal Text> PostgreSQL</Normal Text><br/>