Changeset View
Changeset View
Standalone View
Standalone View
autotests/reference/test.sql.ref
| 1 | <Comment>-- comment</Comment><br/> | 1 | <Comment>-- comment</Comment><br/> | ||
|---|---|---|---|---|---|
| 2 | <dsNormal></dsNormal><br/> | 2 | <dsNormal></dsNormal><br/> | ||
| 3 | <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/> | 3 | <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/> | ||
| 4 | <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/> | 4 | <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/> | ||
| 5 | <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/> | 5 | <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/> | ||
| 6 | <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><Keyword>IS</Keyword><Normal Text> </Normal Text><Keyword>NOT</Keyword><Normal Text> </Normal Text><Keyword>NuLL</Keyword><Normal Text>;</Normal Text><br/> | 6 | <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/> | ||
| 7 | <dsNormal></dsNormal><br/> | ||||
| 8 | <Keyword>CREATE</Keyword><Normal Text> </Normal Text><Keyword>TABLE</Keyword><Normal Text> Persons (</Normal Text><br/> | ||||
| 9 | <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/> | ||||
| 10 | <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/> | ||||
| 11 | <Normal Text> FirstName </Normal Text><Data Type>varchar</Data Type><Normal Text>(</Normal Text><Decimal>255</Decimal><Normal Text>),</Normal Text><br/> | ||||
| 12 | <Normal Text> Age </Normal Text><Data Type>int</Data Type><Normal Text>,</Normal Text><br/> | ||||
| 13 | <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/> | ||||
| 14 | <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/> | ||||
| 15 | <Normal Text>);</Normal Text><br/> | ||||
| 16 | <dsNormal></dsNormal><br/> | ||||
| 17 | <Keyword>SELECT</Keyword><Normal Text> column_name(s)</Normal Text><br/> | ||||
| 18 | <Keyword>FROM</Keyword><Normal Text> table1</Normal Text><br/> | ||||
| 19 | <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/> | ||||
| 20 | <dsNormal></dsNormal><br/> | ||||
| 21 | <Keyword>SELECT</Keyword><Normal Text> </Normal Text><Operator>*</Operator><Normal Text> </Normal Text><Keyword>FROM</Keyword><Normal Text> Customers</Normal Text><br/> | ||||
| 22 | <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/> | ||||
| 23 | <dsNormal></dsNormal><br/> | ||||
| 24 | <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/> | ||||
| 25 | <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/> | ||||
| 26 | <Keyword>GROUP</Keyword><Normal Text> </Normal Text><Keyword>BY</Keyword><Normal Text> Country</Normal Text><br/> | ||||
| 27 | <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/> | ||||
| 28 | <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/> | ||||
| 29 | <dsNormal></dsNormal><br/> | ||||
| 30 | <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/> | ||||
| 31 | <Keyword>FROM</Keyword><Normal Text> Customers</Normal Text><br/> | ||||
| 32 | <Keyword>UNION</Keyword><br/> | ||||
| 33 | <Keyword>SELECT</Keyword><Normal Text> </Normal Text><String>'Supplier'</String><Normal Text>, ContactName, City, Country</Normal Text><br/> | ||||
| 34 | <Keyword>FROM</Keyword><Normal Text> Suppliers;</Normal Text><br/> | ||||
| 35 | <dsNormal></dsNormal><br/> | ||||
| 36 | <Keyword>SELECT</Keyword><Normal Text> </Normal Text><Function>COUNT</Function><Normal Text>(ProductID), </Normal Text><Function>AVG</Function><Normal Text>(Price)</Normal Text><br/> | ||||
| 37 | <Keyword>FROM</Keyword><Normal Text> Products;</Normal Text><br/> | ||||
| 38 | <dsNormal></dsNormal><br/> | ||||
| 39 | <Keyword>SET</Keyword><Normal Text> lock_timeout </Normal Text><Operator>=</Operator><Normal Text> </Normal Text><Decimal>0</Decimal><Normal Text>;</Normal Text><br/> | ||||
| 40 | <Keyword>SET</Keyword><Normal Text> client_encoding </Normal Text><Operator>=</Operator><Normal Text> </Normal Text><String>'UTF8'</String><Normal Text>;</Normal Text><br/> | ||||
| 41 | <Keyword>SET</Keyword><Normal Text> standard_conforming_strings </Normal Text><Operator>=</Operator><Normal Text> </Normal Text><Keyword>on</Keyword><Normal Text>;</Normal Text><br/> | ||||
| 42 | <Keyword>SET</Keyword><Normal Text> check_function_bodies </Normal Text><Operator>=</Operator><Normal Text> </Normal Text><Keyword>false</Keyword><Normal Text>;</Normal Text><br/> | ||||
| 43 | <Keyword>SET</Keyword><Normal Text> client_min_messages </Normal Text><Operator>=</Operator><Normal Text> warning;</Normal Text><br/> | ||||
| 44 | <Keyword>SET</Keyword><Normal Text> default_tablespace </Normal Text><Operator>=</Operator><Normal Text> </Normal Text><String>''</String><Normal Text>;</Normal Text><br/> | ||||
| 45 | <dsNormal></dsNormal><br/> | ||||
| 46 | <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/> | ||||
| 47 | <dsNormal></dsNormal><br/> | ||||
| 48 | <Keyword>ALTER</Keyword><Normal Text> </Normal Text><Keyword>TABLE</Keyword><Normal Text> </Normal Text><Keyword>ONLY</Keyword><Normal Text> employees</Normal Text><br/> | ||||
| 49 | <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/> | ||||
| 50 | <dsNormal></dsNormal><br/> | ||||
| 51 | <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/> | ||||
| 52 | <Keyword>SELECT</Keyword><Normal Text> ProductID, ProductName</Normal Text><br/> | ||||
| 53 | <Keyword>FROM</Keyword><Normal Text> Products</Normal Text><br/> | ||||
| 54 | <Keyword>WHERE</Keyword><Normal Text> Discontinued </Normal Text><Operator>=</Operator><Normal Text> </Normal Text><Keyword>No</Keyword><Normal Text>;</Normal Text><br/> | ||||
| 55 | <dsNormal></dsNormal><br/> | ||||
| 56 | <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/> | ||||
| 57 | <dsNormal></dsNormal><br/> | ||||
| 58 | <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/> | ||||
| 59 | <Keyword>WHERE</Keyword><Normal Text> CategoryName </Normal Text><Operator>=</Operator><Normal Text> </Normal Text><String>'Beverages'</String><Normal Text>;</Normal Text><br/> | ||||
| 60 | <dsNormal></dsNormal><br/> | ||||
| 61 | <Keyword>begin</Keyword><br/> | ||||
| 62 | <Keyword>end</Keyword><br/> | ||||
| 63 | <Symbol>/</Symbol><br/> | ||||
| 64 | <Normal Text> </Normal Text><Operator>/</Operator><br/> | ||||
| 65 | <Operator>/</Operator><Normal Text> u</Normal Text><br/> | ||||