http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/bf0aef53/docs/2.3.0/messages_guide/index.html ---------------------------------------------------------------------- diff --git a/docs/2.3.0/messages_guide/index.html b/docs/2.3.0/messages_guide/index.html index e620c41..dffe61c 100644 --- a/docs/2.3.0/messages_guide/index.html +++ b/docs/2.3.0/messages_guide/index.html @@ -666,54 +666,56 @@ table.CodeRay td.code>pre{padding:0} <li><a href="#SQL-1196">3.104. SQL 1196</a></li> <li><a href="#SQL-1197">3.105. SQL 1197</a></li> <li><a href="#SQL-1199">3.106. SQL 1199</a></li> -<li><a href="#SQL-1224">3.107. SQL 1224</a></li> -<li><a href="#SQL-1225">3.108. SQL 1225</a></li> -<li><a href="#SQL-1226">3.109. SQL 1226</a></li> -<li><a href="#SQL-1231">3.110. SQL 1231</a></li> -<li><a href="#SQL-1232">3.111. SQL 1232</a></li> -<li><a href="#SQL-1233">3.112. SQL 1233</a></li> -<li><a href="#SQL-1236">3.113. SQL 1236</a></li> -<li><a href="#SQL-1238">3.114. SQL 1238</a></li> -<li><a href="#SQL-1239">3.115. SQL 1239</a></li> -<li><a href="#SQL-1240">3.116. SQL 1240</a></li> -<li><a href="#SQL-1241">3.117. SQL 1241</a></li> -<li><a href="#SQL-1242">3.118. SQL 1242</a></li> -<li><a href="#SQL-1243">3.119. SQL 1243</a></li> -<li><a href="#SQL-1245">3.120. SQL 1245</a></li> -<li><a href="#SQL-1248">3.121. SQL 1248</a></li> -<li><a href="#SQL-1251">3.122. SQL 1251</a></li> -<li><a href="#SQL-1252">3.123. SQL 1252</a></li> +<li><a href="#SQL-1200">3.107. SQL 1200</a></li> +<li><a href="#SQL-1201">3.108. SQL 1201</a></li> +<li><a href="#SQL-1202">3.109. SQL 1202</a></li> +<li><a href="#SQL-1203">3.110. SQL 1203</a></li> +<li><a href="#SQL-1204">3.111. SQL 1204</a></li> +<li><a href="#SQL-1214">3.112. SQL 1214</a></li> +<li><a href="#SQL-1215">3.113. SQL 1215</a></li> +<li><a href="#SQL-1222">3.114. SQL 1222</a></li> +<li><a href="#SQL-1223">3.115. SQL 1223</a></li> +<li><a href="#SQL-1227">3.116. SQL 1227</a></li> +<li><a href="#SQL-1228">3.117. SQL 1228</a></li> +<li><a href="#SQL-1230">3.118. SQL 1230</a></li> +<li><a href="#SQL-1231">3.119. SQL 1231</a></li> +<li><a href="#SQL-1234">3.120. SQL 1234</a></li> +<li><a href="#SQL-1240">3.121. SQL 1240</a></li> +<li><a href="#SQL-1243">3.122. SQL 1243</a></li> +<li><a href="#SQL-1251">3.123. SQL 1251</a></li> <li><a href="#SQL-1254">3.124. SQL 1254</a></li> -<li><a href="#SQL-1262">3.125. SQL 1262</a></li> -<li><a href="#SQL-1263">3.126. SQL 1263</a></li> -<li><a href="#SQL-1264">3.127. SQL 1264</a></li> -<li><a href="#SQL-1265">3.128. SQL 1265</a></li> +<li><a href="#SQL-1255">3.125. SQL 1255</a></li> +<li><a href="#SQL-1256">3.126. SQL 1256</a></li> +<li><a href="#SQL-1260">3.127. SQL 1260</a></li> +<li><a href="#SQL-1264">3.128. SQL 1264</a></li> <li><a href="#SQL-1266">3.129. SQL 1266</a></li> <li><a href="#SQL-1267">3.130. SQL 1267</a></li> <li><a href="#SQL-1268">3.131. SQL 1268</a></li> -<li><a href="#SQL-1270">3.132. SQL 1270</a></li> -<li><a href="#SQL-1271">3.133. SQL 1271</a></li> -<li><a href="#SQL-1273">3.134. SQL 1273</a></li> -<li><a href="#SQL-1274">3.135. SQL 1274</a></li> -<li><a href="#SQL-1275">3.136. SQL 1275</a></li> -<li><a href="#SQL-1277">3.137. SQL 1277</a></li> -<li><a href="#SQL-1278">3.138. SQL 1278</a></li> -<li><a href="#SQL-1301">3.139. SQL 1301</a></li> -<li><a href="#SQL-1302">3.140. SQL 1302</a></li> -<li><a href="#SQL-1305">3.141. SQL 1305</a></li> -<li><a href="#SQL-1307">3.142. SQL 1307</a></li> -<li><a href="#SQL-1309">3.143. SQL 1309</a></li> -<li><a href="#SQL-1310">3.144. SQL 1310</a></li> -<li><a href="#SQL-1420">3.145. SQL 1420</a></li> -<li><a href="#SQL-1421">3.146. SQL 1421</a></li> -<li><a href="#SQL-1422">3.147. SQL 1422</a></li> -<li><a href="#SQL-1423">3.148. SQL 1423</a></li> -<li><a href="#SQL-1424">3.149. SQL 1424</a></li> -<li><a href="#SQL-1425">3.150. SQL 1425</a></li> -<li><a href="#SQL-1426">3.151. SQL 1426</a></li> -<li><a href="#SQL-1427">3.152. SQL 1427</a></li> -<li><a href="#SQL-1428">3.153. SQL 1428</a></li> -<li><a href="#SQL-1429">3.154. SQL 1429</a></li> +<li><a href="#SQL-1269">3.132. SQL 1269</a></li> +<li><a href="#SQL-1276">3.133. SQL 1276</a></li> +<li><a href="#SQL-1279">3.134. SQL 1279</a></li> +<li><a href="#SQL-1280">3.135. SQL 1280</a></li> +<li><a href="#SQL-1282">3.136. SQL 1282</a></li> +<li><a href="#SQL-1283">3.137. SQL 1283</a></li> +<li><a href="#SQL-1289">3.138. SQL 1289</a></li> +<li><a href="#SQL-1298">3.139. SQL 1298</a></li> +<li><a href="#SQL-1301">3.140. SQL 1301</a></li> +<li><a href="#SQL-1302">3.141. SQL 1302</a></li> +<li><a href="#SQL-1305">3.142. SQL 1305</a></li> +<li><a href="#SQL-1307">3.143. SQL 1307</a></li> +<li><a href="#SQL-1309">3.144. SQL 1309</a></li> +<li><a href="#SQL-1310">3.145. SQL 1310</a></li> +<li><a href="#SQL-1420">3.146. SQL 1420</a></li> +<li><a href="#SQL-1421">3.147. SQL 1421</a></li> +<li><a href="#SQL-1422">3.148. SQL 1422</a></li> +<li><a href="#SQL-1423">3.149. SQL 1423</a></li> +<li><a href="#SQL-1424">3.150. SQL 1424</a></li> +<li><a href="#SQL-1425">3.151. SQL 1425</a></li> +<li><a href="#SQL-1426">3.152. SQL 1426</a></li> +<li><a href="#SQL-1427">3.153. SQL 1427</a></li> +<li><a href="#SQL-1428">3.154. SQL 1428</a></li> +<li><a href="#SQL-1429">3.155. SQL 1429</a></li> +<li><a href="#SQL-1430">3.156. SQL 1430</a></li> </ul> </li> <li><a href="#trafodion-compiler-messages">4. Trafodion Compiler Messages (2000 through 2999)</a> @@ -1010,23 +1012,22 @@ table.CodeRay td.code>pre{padding:0} <li><a href="#SQL-3216">5.200. SQL 3216</a></li> <li><a href="#SQL-3217">5.201. SQL 3217</a></li> <li><a href="#SQL-3218">5.202. SQL 3218</a></li> -<li><a href="#SQL-3220">5.203. SQL 3220</a></li> -<li><a href="#SQL-3225">5.204. SQL 3225</a></li> -<li><a href="#SQL-3226">5.205. SQL 3226</a></li> -<li><a href="#SQL-3228">5.206. SQL 3228</a></li> -<li><a href="#SQL-3229">5.207. SQL 3229</a></li> -<li><a href="#SQL-3230">5.208. SQL 3230</a></li> -<li><a href="#SQL-3400">5.209. SQL 3400</a></li> -<li><a href="#SQL-3401">5.210. SQL 3401</a></li> -<li><a href="#SQL-3402">5.211. SQL 3402</a></li> -<li><a href="#SQL-3403">5.212. SQL 3403</a></li> -<li><a href="#SQL-3404">5.213. SQL 3404</a></li> -<li><a href="#SQL-3405">5.214. SQL 3405</a></li> -<li><a href="#SQL-3406">5.215. SQL 3406</a></li> -<li><a href="#SQL-3411">5.216. SQL 3411</a></li> -<li><a href="#SQL-3412">5.217. SQL 3412</a></li> -<li><a href="#SQL-3413">5.218. SQL 3413</a></li> -<li><a href="#SQL-3414">5.219. SQL 3414</a></li> +<li><a href="#SQL-3225">5.203. SQL 3225</a></li> +<li><a href="#SQL-3226">5.204. SQL 3226</a></li> +<li><a href="#SQL-3228">5.205. SQL 3228</a></li> +<li><a href="#SQL-3229">5.206. SQL 3229</a></li> +<li><a href="#SQL-3230">5.207. SQL 3230</a></li> +<li><a href="#SQL-3400">5.208. SQL 3400</a></li> +<li><a href="#SQL-3401">5.209. SQL 3401</a></li> +<li><a href="#SQL-3402">5.210. SQL 3402</a></li> +<li><a href="#SQL-3403">5.211. SQL 3403</a></li> +<li><a href="#SQL-3404">5.212. SQL 3404</a></li> +<li><a href="#SQL-3405">5.213. SQL 3405</a></li> +<li><a href="#SQL-3406">5.214. SQL 3406</a></li> +<li><a href="#SQL-3411">5.215. SQL 3411</a></li> +<li><a href="#SQL-3412">5.216. SQL 3412</a></li> +<li><a href="#SQL-3413">5.217. SQL 3413</a></li> +<li><a href="#SQL-3414">5.218. SQL 3414</a></li> </ul> </li> <li><a href="#binder-messages">6. Binder Messages (4000 through 4999)</a> @@ -1145,72 +1146,71 @@ table.CodeRay td.code>pre{padding:0} <li><a href="#SQL-4125">6.112. SQL 4125</a></li> <li><a href="#SQL-4126">6.113. SQL 4126</a></li> <li><a href="#SQL-4127">6.114. SQL 4127</a></li> -<li><a href="#SQL-4128">6.115. SQL 4128</a></li> -<li><a href="#SQL-4129">6.116. SQL 4129</a></li> -<li><a href="#SQL-4130">6.117. SQL 4130</a></li> -<li><a href="#SQL-4133">6.118. SQL 4133</a></li> -<li><a href="#SQL-4134">6.119. SQL 4134</a></li> -<li><a href="#SQL-4135">6.120. SQL 4135</a></li> -<li><a href="#SQL-4136">6.121. SQL 4136</a></li> -<li><a href="#SQL-4150">6.122. SQL 4150</a></li> -<li><a href="#SQL-4151">6.123. SQL 4151</a></li> -<li><a href="#SQL-4152">6.124. SQL 4152</a></li> -<li><a href="#SQL-4153">6.125. SQL 4153</a></li> -<li><a href="#SQL-4154">6.126. SQL 4154</a></li> -<li><a href="#SQL-4156">6.127. SQL 4156</a></li> -<li><a href="#SQL-4157">6.128. SQL 4157</a></li> -<li><a href="#SQL-4158">6.129. SQL 4158</a></li> -<li><a href="#SQL-4159">6.130. SQL 4159</a></li> -<li><a href="#SQL-4160">6.131. SQL 4160</a></li> -<li><a href="#SQL-4161">6.132. SQL 4161</a></li> -<li><a href="#SQL-4162">6.133. SQL 4162</a></li> -<li><a href="#SQL-4163">6.134. SQL 4163</a></li> -<li><a href="#SQL-4164">6.135. SQL 4164</a></li> -<li><a href="#SQL-4165">6.136. SQL 4165</a></li> -<li><a href="#SQL-4166">6.137. SQL 4166</a></li> -<li><a href="#SQL-4167">6.138. SQL 4167</a></li> -<li><a href="#SQL-4168">6.139. SQL 4168</a></li> -<li><a href="#SQL-4169">6.140. SQL 4169</a></li> -<li><a href="#SQL-4170">6.141. SQL 4170</a></li> -<li><a href="#SQL-4171">6.142. SQL 4171</a></li> -<li><a href="#SQL-4173">6.143. SQL 4173</a></li> -<li><a href="#SQL-4174">6.144. SQL 4174</a></li> -<li><a href="#SQL-4175">6.145. SQL 4175</a></li> -<li><a href="#SQL-4176">6.146. SQL 4176</a></li> -<li><a href="#SQL-4177">6.147. SQL 4177</a></li> -<li><a href="#SQL-4178">6.148. SQL 4178</a></li> -<li><a href="#SQL-4179">6.149. SQL 4179</a></li> -<li><a href="#SQL-4180">6.150. SQL 4180</a></li> -<li><a href="#SQL-4183">6.151. SQL 4183</a></li> -<li><a href="#SQL-4184">6.152. SQL 4184</a></li> -<li><a href="#SQL-4189">6.153. SQL 4189</a></li> -<li><a href="#SQL-4200">6.154. SQL 4200</a></li> -<li><a href="#SQL-4201">6.155. SQL 4201</a></li> -<li><a href="#SQL-4202">6.156. SQL 4202</a></li> -<li><a href="#SQL-4203">6.157. SQL 4203</a></li> -<li><a href="#SQL-4204">6.158. SQL 4204</a></li> -<li><a href="#SQL-4205">6.159. SQL 4205</a></li> -<li><a href="#SQL-4206">6.160. SQL 4206</a></li> -<li><a href="#SQL-4207">6.161. SQL 4207</a></li> -<li><a href="#SQL-4208">6.162. SQL 4208</a></li> -<li><a href="#SQL-4209">6.163. SQL 4209</a></li> -<li><a href="#SQL-4210">6.164. SQL 4210</a></li> -<li><a href="#SQL-4212">6.165. SQL 4212</a></li> -<li><a href="#SQL-4213">6.166. SQL 4213</a></li> -<li><a href="#SQL-4214">6.167. SQL 4214</a></li> -<li><a href="#SQL-4215">6.168. SQL 4215</a></li> -<li><a href="#SQL-4216">6.169. SQL 4216</a></li> -<li><a href="#SQL-4302">6.170. SQL 4302</a></li> -<li><a href="#SQL-4303">6.171. SQL 4303</a></li> -<li><a href="#SQL-4304">6.172. SQL 4304</a></li> -<li><a href="#SQL-4305">6.173. SQL 4305</a></li> -<li><a href="#SQL-4306">6.174. SQL 4306</a></li> -<li><a href="#SQL-4307">6.175. SQL 4307</a></li> -<li><a href="#SQL-4308">6.176. SQL 4308</a></li> -<li><a href="#SQL-4309">6.177. SQL 4309</a></li> -<li><a href="#SQL-4310">6.178. SQL 4310</a></li> -<li><a href="#SQL-4313">6.179. SQL 4313</a></li> -<li><a href="#SQL-4320">6.180. SQL 4320</a></li> +<li><a href="#SQL-4129">6.115. SQL 4129</a></li> +<li><a href="#SQL-4130">6.116. SQL 4130</a></li> +<li><a href="#SQL-4133">6.117. SQL 4133</a></li> +<li><a href="#SQL-4134">6.118. SQL 4134</a></li> +<li><a href="#SQL-4135">6.119. SQL 4135</a></li> +<li><a href="#SQL-4136">6.120. SQL 4136</a></li> +<li><a href="#SQL-4150">6.121. SQL 4150</a></li> +<li><a href="#SQL-4151">6.122. SQL 4151</a></li> +<li><a href="#SQL-4152">6.123. SQL 4152</a></li> +<li><a href="#SQL-4153">6.124. SQL 4153</a></li> +<li><a href="#SQL-4154">6.125. SQL 4154</a></li> +<li><a href="#SQL-4156">6.126. SQL 4156</a></li> +<li><a href="#SQL-4157">6.127. SQL 4157</a></li> +<li><a href="#SQL-4158">6.128. SQL 4158</a></li> +<li><a href="#SQL-4159">6.129. SQL 4159</a></li> +<li><a href="#SQL-4160">6.130. SQL 4160</a></li> +<li><a href="#SQL-4161">6.131. SQL 4161</a></li> +<li><a href="#SQL-4162">6.132. SQL 4162</a></li> +<li><a href="#SQL-4163">6.133. SQL 4163</a></li> +<li><a href="#SQL-4164">6.134. SQL 4164</a></li> +<li><a href="#SQL-4165">6.135. SQL 4165</a></li> +<li><a href="#SQL-4166">6.136. SQL 4166</a></li> +<li><a href="#SQL-4167">6.137. SQL 4167</a></li> +<li><a href="#SQL-4168">6.138. SQL 4168</a></li> +<li><a href="#SQL-4169">6.139. SQL 4169</a></li> +<li><a href="#SQL-4170">6.140. SQL 4170</a></li> +<li><a href="#SQL-4171">6.141. SQL 4171</a></li> +<li><a href="#SQL-4173">6.142. SQL 4173</a></li> +<li><a href="#SQL-4174">6.143. SQL 4174</a></li> +<li><a href="#SQL-4175">6.144. SQL 4175</a></li> +<li><a href="#SQL-4176">6.145. SQL 4176</a></li> +<li><a href="#SQL-4177">6.146. SQL 4177</a></li> +<li><a href="#SQL-4178">6.147. SQL 4178</a></li> +<li><a href="#SQL-4179">6.148. SQL 4179</a></li> +<li><a href="#SQL-4180">6.149. SQL 4180</a></li> +<li><a href="#SQL-4183">6.150. SQL 4183</a></li> +<li><a href="#SQL-4184">6.151. SQL 4184</a></li> +<li><a href="#SQL-4189">6.152. SQL 4189</a></li> +<li><a href="#SQL-4200">6.153. SQL 4200</a></li> +<li><a href="#SQL-4201">6.154. SQL 4201</a></li> +<li><a href="#SQL-4202">6.155. SQL 4202</a></li> +<li><a href="#SQL-4203">6.156. SQL 4203</a></li> +<li><a href="#SQL-4204">6.157. SQL 4204</a></li> +<li><a href="#SQL-4205">6.158. SQL 4205</a></li> +<li><a href="#SQL-4206">6.159. SQL 4206</a></li> +<li><a href="#SQL-4207">6.160. SQL 4207</a></li> +<li><a href="#SQL-4208">6.161. SQL 4208</a></li> +<li><a href="#SQL-4209">6.162. SQL 4209</a></li> +<li><a href="#SQL-4210">6.163. SQL 4210</a></li> +<li><a href="#SQL-4212">6.164. SQL 4212</a></li> +<li><a href="#SQL-4213">6.165. SQL 4213</a></li> +<li><a href="#SQL-4214">6.166. SQL 4214</a></li> +<li><a href="#SQL-4215">6.167. SQL 4215</a></li> +<li><a href="#SQL-4216">6.168. SQL 4216</a></li> +<li><a href="#SQL-4302">6.169. SQL 4302</a></li> +<li><a href="#SQL-4303">6.170. SQL 4303</a></li> +<li><a href="#SQL-4304">6.171. SQL 4304</a></li> +<li><a href="#SQL-4305">6.172. SQL 4305</a></li> +<li><a href="#SQL-4306">6.173. SQL 4306</a></li> +<li><a href="#SQL-4307">6.174. SQL 4307</a></li> +<li><a href="#SQL-4308">6.175. SQL 4308</a></li> +<li><a href="#SQL-4309">6.176. SQL 4309</a></li> +<li><a href="#SQL-4310">6.177. SQL 4310</a></li> +<li><a href="#SQL-4313">6.178. SQL 4313</a></li> +<li><a href="#SQL-4320">6.179. SQL 4320</a></li> </ul> </li> <li><a href="#optimizer-messages">7. Optimizer Messages (6000 through 6999)</a> @@ -3642,7 +3642,7 @@ calculations. Change the column definitions and reissue the statement.</p> <h3 id="SQL-1143">3.85. SQL 1143</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">Validation for constraint <constraint-name> failed; incompatible data exists in referencing base table <referencing-table-name> and referenced base table <referenced-table-name>. To display the data that violates the constraint, please use the following DML statement: <statement-text>.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">Validation for constraint <constraint-name> failed; incompatible data exists in referencing base table <referencing-table-name> and referenced base table <referenced-table-name>. To display the data that violates the constraint, please use the following DML statement: <statement-text></code></pre> </div> </div> <div class="paragraph"> @@ -4036,7 +4036,7 @@ support columns of the given data type with the SERIALIZED attribute.</p> <h3 id="SQL-1192">3.101. SQL 1192</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">Failed to retrieve data from Hive metastore. Call to <function> returned error <optional-symbol>(<error-number>). Cause: <diagnostics>.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">Failed to retrieve data from Hive metastore. Call to <function> returned error <optional-symbol>(<error-number>). Cause: <diagnostics>.</code></pre> </div> </div> <div class="paragraph"> @@ -4132,7 +4132,6 @@ Trafodion supports.</p> <div class="paragraph"> <p><strong>Recovery:</strong> Correct the SALT clause then resubmit.</p> </div> -<div style="page-break-after: always;"></div> </div> <div class="sect2"> <h3 id="SQL-1197">3.105. SQL 1197</h3> @@ -4175,340 +4174,353 @@ operation to the Trafodion User Distribution List.</p> <div class="paragraph"> <p><strong>Recovery:</strong> Remove the PARTITION BY clause from the DDL statement and resubmit.</p> </div> -<div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1224">3.107. SQL 1224</h3> +<h3 id="SQL-1200">3.107. SQL 1200</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">An invalid data type was specified for routine parameter <parameter-name>.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">An error occurred while reading HDFS file statistics for Hive table <table-name>. Cause: <diagnostics>.</code></pre> </div> </div> <div class="paragraph"> -<p>Where <parameter-name> is the name of the parameter.</p> +<p>Where <table-name> is the name of a Hive table.</p> </div> <div class="paragraph"> -<p><strong>Cause:</strong> You specified a data type for this routine parameter that is -not supported.</p> +<p>Where <diagnostics> give diagnostics as to the cause of the error.</p> </div> <div class="paragraph"> -<p><strong>Effect:</strong> Trafodion is unable to complete the operation.</p> +<p><strong>Cause:</strong> The Trafodion engine attempted to read file statistics from HDFS for a particular Hive table. +A failure occurred at the HDFS or Hive level. The diagnostics contain more information about the failure.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> Specify a different data type.</p> +<p><strong>Effect:</strong> The operation fails.</p> +</div> +<div class="paragraph"> +<p><strong>Recovery:</strong> Address the indicated issue at the HDFS or Hive level, then resubmit.</p> </div> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1225">3.108. SQL 1225</h3> +<h3 id="SQL-1201">3.108. SQL 1201</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">Mixing EXECUTE with other privileges is not allowed.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">Salted index <index-name> cannot be unique.</code></pre> </div> </div> <div class="paragraph"> -<p><strong>Cause:</strong> EXECUTE and another privilege were specified in the same GRANT -or REVOKE statement, which is not allowed.</p> +<p>Where <index-name> is the name of a Trafodion index that you are trying to create.</p> +</div> +<div class="paragraph"> +<p><strong>Cause:</strong> You attempted a CREATE UNIQUE INDEX statement that included the SALT LIKE TABLE clause. +SALT LIKE TABLE is not allowed for unique indexes.</p> </div> <div class="paragraph"> <p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> Use separate GRANT or REVOKE statements for EXECUTE and other privileges.</p> +<p><strong>Recovery:</strong> Remove either the UNIQUE keyword or the SALT LIKE TABLE clause and resubmit.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1226">3.109. SQL 1226</h3> +<h3 id="SQL-1202">3.109. SQL 1202</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">No valid combination of privileges was specified.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">Index <index-name> cannot be salted like a table since table <table-name> is not salted.</code></pre> +</div> +</div> +<div class="paragraph"> +<p>Where <index-name> is the name of a Trafodion index that you are trying to create.</p> </div> +<div class="paragraph"> +<p>Where <table-name> is a Trafodion table.</p> </div> <div class="paragraph"> -<p><strong>Cause:</strong> The GRANT or REVOKE statement did not specify a valid -combination of privileges.</p> +<p><strong>Cause:</strong> You attempted a CREATE INDEX statement that included the SALT LIKE TABLE clause on +a table that is not salted.</p> </div> <div class="paragraph"> <p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> Specify a valid combination of privileges in the GRANT or REVOKE statement.</p> +<p><strong>Recovery:</strong> Remove the SALT LIKE TABLE clause and resubmit.</p> </div> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1231">3.110. SQL 1231</h3> +<h3 id="SQL-1203">3.110. SQL 1203</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">User-defined routine <procedure-name> could not be created.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">HBASE_OPTIONS clause in CREATE statement is longer than 6000 characters. Object <object-name> was not created.</code></pre> </div> </div> <div class="paragraph"> -<p>Where <procedure-name> is the stored procedure’s ANSI name.</p> +<p>Where <object-name> is the name of a Trafodion object that you are trying to create.</p> </div> <div class="paragraph"> -<p><strong>Cause:</strong> The stored procedure could not be created.</p> +<p><strong>Cause:</strong> The HBASE_OPTIONS clause specified in the CREATE statement contained more than 6000 +characters of HBase options, exceeding the length limit that Trafodion supports.</p> </div> <div class="paragraph"> -<p><strong>Effect:</strong> The CREATE PROCEDURE statement fails.</p> +<p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> Fix the error conditions identified in messages preceding -this message and reissue the CREATE PROCEDURE statement.</p> +<p><strong>Recovery:</strong> Shorten the set of options specified in HBASE_OPTIONS and resubmit.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1232">3.111. SQL 1232</h3> +<h3 id="SQL-1204">3.111. SQL 1204</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">A file error occurred when saving dropped table DDL for table <table-name> to <path-name>.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">Unsupported Hive datatype <Hive-datatype>.</code></pre> </div> </div> <div class="paragraph"> -<p>Where <table-name> is the table being dropped whose DDL was to be saved.</p> +<p>Where <Hive-datatype> is a Hive data type.</p> </div> <div class="paragraph"> -<p>Where <path-name> is the pathname of the file to which the DDL was to -be saved.</p> +<p><strong>Cause:</strong> You attempted to reference a Hive table that has a column with a data type +that Trafodion does not support.</p> </div> <div class="paragraph"> -<p><strong>Cause:</strong> A file system error occurred when you attempted to save a table -DDL. Possible reasons are:</p> -</div> -<div class="ulist"> -<ul> -<li> -<p>The directory <code>/usr/tandem/sqlmx/ddl</code> did not exist or could not be -created.</p> -</li> -<li> -<p>The system did not have write access to <code>/usr/tandem/sqlmx/ddl</code>.</p> -</li> -<li> -<p>Insufficient file space was available.</p> -</li> -</ul> -</div> -<div class="paragraph"> -<p><strong>Effect:</strong> The table is not dropped.</p> +<p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> Either correct the file system problem and drop the table or -perform a SHOWDDL on the existing table, capture the output, set. -SAVE_DROPPED_TABLE_DDL to "OFF," and drop the table. For information -about file system errors, see <a href="#file_system_errors">File-System Errors</a>.</p> +<p><strong>Recovery:</strong> If the wrong Hive table was referenced, correct the reference and resubmit.</p> </div> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1233">3.112. SQL 1233</h3> +<h3 id="SQL-1214">3.112. SQL 1214</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">Creating schema in {project-name} system catalog <catalog-name> is prohibited.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">Error <Hive-exception-info> encountered when executing HiveQL statement <Hive-statement>.</code></pre> +</div> </div> +<div class="paragraph"> +<p>Where <Hive-exception-info> is error diagnostic information from Hive.</p> </div> <div class="paragraph"> -<p>Where <catalog-name> is the name of the Trafodion database catalog.</p> +<p>Where <Hive-statement> is the Hive SQL statement you specified.</p> </div> <div class="paragraph"> -<p><strong>Cause:</strong> You attempted to create a schema in the system catalog.</p> +<p><strong>Cause:</strong> You attempted to execute a Hive SQL statement via the PROCESS HIVE STATEMENT command, +and Hive detected errors in that statement.</p> </div> <div class="paragraph"> <p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> Choose a different catalog name and reissue the CREATE -statement.</p> +<p><strong>Recovery:</strong> Determine the proper recovery action from the <Hive-exception-info> then resubmit.</p> </div> -<div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1236">3.113. SQL 1236</h3> +<h3 id="SQL-1215">3.113. SQL 1215</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">The schema name specified for SQL object <object-name> is not valid. The schema name must be the same as the schema being created.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">An error occurred while determining host, port, or file name for HDFS URI <HDFS-URI>. Cause: <diagnostics>.</code></pre> </div> </div> <div class="paragraph"> -<p>Where <object-name> is the name of the SQL object.</p> +<p>Where <HDFS-URI> is a Uniform Resource Identifier for a Hive table partition.</p> </div> <div class="paragraph"> -<p><strong>Cause:</strong> You specified a schema name for an object that is different -from the name of the schema being created.</p> +<p>Where <diagnostics> are diagnostics from HDFS.</p> +</div> +<div class="paragraph"> +<p><strong>Cause:</strong> You attempted to access a Hive table but Trafodion could not obtain location information +about that object.</p> </div> <div class="paragraph"> <p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> Specify a schema name for the object that matches the name -of the schema being created.</p> +<p><strong>Recovery:</strong> Determine the proper recovery action from the <diagnostics> then resubmit.</p> </div> +<div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1238">3.114. SQL 1238</h3> +<h3 id="SQL-1222">3.114. SQL 1222</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">The character set for TRIGGER text must be ISO88591.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">Command not supported when authorization is not enabled.</code></pre> </div> </div> <div class="paragraph"> -<p><strong>Cause:</strong> You specified a literal with a character set other than -ISO88591 in the text of a create trigger statement.</p> +<p><strong>Cause:</strong> You attempted to perform a privilege-related command (e.g. GRANT), but authorization +is not enabled on this Trafodion instance.</p> </div> <div class="paragraph"> <p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> Specify only ISO88591 literals in the command.</p> +<p><strong>Recovery:</strong> Enable authorization on the instance (e.g. INITIALIZE AUTHORIZATION), register users and resubmit.</p> </div> -<div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1239">3.115. SQL 1239</h3> +<h3 id="SQL-1223">3.115. SQL 1223</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">The character set for string literals in VIEW text must be ISO88591.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">Grant to self or DB__ROOT is not allowed.</code></pre> </div> </div> <div class="paragraph"> -<p><strong>Cause:</strong> You specified a literal with a character set other than -ISO88591 in the text of a create view statement.</p> +<p><strong>Cause:</strong> You attempted to grant a privilege to yourself or to DB__ROOT.</p> </div> <div class="paragraph"> <p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> Specify only ISO88591 literals in the command.</p> +<p><strong>Recovery:</strong> None.</p> </div> +<div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1240">3.116. SQL 1240</h3> +<h3 id="SQL-1227">3.116. SQL 1227</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">The character set for a PARTITION KEY column must be ISO88591.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">Cannot unregister user. User <user-name> has been granted privileges on <object-name>.</code></pre> </div> </div> <div class="paragraph"> -<p><strong>Cause:</strong> You specified a literal with a character set other than -ISO88591 as a partition key.</p> +<p>Where <user-name> is the name of a user that you are trying to unregister.</p> +</div> +<div class="paragraph"> +<p>Where <object-name> is the name of a Trafodion object.</p> +</div> +<div class="paragraph"> +<p><strong>Cause:</strong> You attempted to unregister a user, but the user has privileges on a Trafodion object.</p> </div> <div class="paragraph"> <p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> Specify only ISO88591 literals as partition keys.</p> +<p><strong>Recovery:</strong> Use REVOKE to remove any privileges granted to the user, then resubmit.</p> </div> -<div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1241">3.117. SQL 1241</h3> +<h3 id="SQL-1228">3.117. SQL 1228</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">The character set for HEADING must be ISO88591.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">Cannot drop role. Role <role-name> has been granted privileges on <object-name>.</code></pre> </div> </div> <div class="paragraph"> -<p><strong>Cause:</strong> You specified a literal with a character set other than -ISO88591 in a HEADING clause.</p> +<p>Where <role-name> is the name of a role that you are trying to drop.</p> +</div> +<div class="paragraph"> +<p>Where <object-name> is the name of a Trafodion object.</p> +</div> +<div class="paragraph"> +<p><strong>Cause:</strong> You attempted to drop a role that has privileges. All privileges granted to a role +must be dropped before the role can be dropped.</p> </div> <div class="paragraph"> <p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> Specify only ISO88591 literals in HEADING clauses.</p> +<p><strong>Recovery:</strong> Use SHOWDDL on the <object-name> to see what privileges are granted to the role. +Then REVOKE those privileges, and resubmit the DROP ROLE statement.</p> </div> +<div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1242">3.118. SQL 1242</h3> +<h3 id="SQL-1230">3.118. SQL 1230</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">The character set for string literals in CONSTRAINT must be ISO88591.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">Object owner must be the schema owner in private schemas.</code></pre> </div> </div> <div class="paragraph"> -<p><strong>Cause:</strong> You specified a literal with a character set other than</p> -</div> -<div class="paragraph"> -<p>ISO88591 in the text of a constraint.</p> +<p><strong>Cause:</strong> You attempted to create an object on behalf of another user but you attempted +to place the object in a private schema owned by a different user.</p> </div> <div class="paragraph"> <p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> Specify only ISO88591 literals in constraints.</p> +<p><strong>Recovery:</strong> Correct the schema name of the new object or correct the user name in the BY clause +to match the owner of the schema.</p> </div> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1243">3.119. SQL 1243</h3> +<h3 id="SQL-1231">3.119. SQL 1231</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">The hexadecimal form of string literals is not allowed in this context.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">User-defined routine <procedure-name> could not be created.</code></pre> </div> </div> <div class="paragraph"> -<p><strong>Cause:</strong> You specified a hexadecimal literal in the text of the -statement, which is not allowed.</p> +<p>Where <procedure-name> is the stored procedure’s ANSI name.</p> </div> <div class="paragraph"> -<p><strong>Effect:</strong> The operation fails.</p> +<p><strong>Cause:</strong> The stored procedure could not be created.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> Do not specify hexadecimals in this type of command.</p> +<p><strong>Effect:</strong> The CREATE PROCEDURE statement fails.</p> +</div> +<div class="paragraph"> +<p><strong>Recovery:</strong> Fix the error conditions identified in messages preceding +this message and reissue the CREATE PROCEDURE statement.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1245">3.120. SQL 1245</h3> +<h3 id="SQL-1234">3.120. SQL 1234</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">The supplied partition key value (<key-value>) for column <column-name> of object <object-name> is not valid.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">Authorization needs to be reinitialized due to missing or corrupted privilege manager metadata. To reinitialize, do 'initialize authorization, drop' followed by 'initialize authorization'. This deletes and recreates privilege manager metadata. Trafodion metadata is not affected.</code></pre> </div> </div> <div class="paragraph"> -<p>Where <key-value> is the specified first key value.</p> +<p><strong>Cause:</strong> Privilege metadata has become corrupted.</p> </div> <div class="paragraph"> -<p>Where <column-name> is the column of <object-name> that corresponds to -the invalid key value.</p> +<p><strong>Effect:</strong> Some or all authorization operations on the Trafodion instance will fail.</p> </div> <div class="paragraph"> -<p>Where <object-name> is the name of the affected object.</p> +<p><strong>Recovery:</strong> Reinitialize authorization by performing INITIALIZE AUTHORIZATION, DROP followed by INITIALIZE AUTHORIZATION.</p> +</div> +<div style="page-break-after: always;"></div> +</div> +<div class="sect2"> +<h3 id="SQL-1240">3.121. SQL 1240</h3> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">The character set for a PARTITION KEY column must be ISO88591.</code></pre> +</div> </div> <div class="paragraph"> -<p><strong>Cause:</strong> A utility command specified an invalid key value.</p> +<p><strong>Cause:</strong> You specified a literal with a character set other than +ISO88591 as a partition key.</p> </div> <div class="paragraph"> <p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> Specify valid key values and resubmit.</p> +<p><strong>Recovery:</strong> Specify only ISO88591 literals as partition keys.</p> </div> -<div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1248">3.121. SQL 1248</h3> +<h3 id="SQL-1243">3.122. SQL 1243</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">Partition name <partition-name> has already been used. Each partition in an object should have a unique name.</code></pre> -</div> +<pre class="CodeRay highlight"><code data-lang="text">The hexadecimal form of string literals is not allowed in this context.</code></pre> </div> -<div class="paragraph"> -<p>Where <partition-name> is the name specified for a partition.</p> </div> <div class="paragraph"> -<p><strong>Cause:</strong> Partition names are required to be unique within the set of -partitions of an object.</p> +<p><strong>Cause:</strong> You specified a hexadecimal literal in the text of the +statement, which is not allowed.</p> </div> <div class="paragraph"> -<p><strong>Effect:</strong> The CREATE statement fails.</p> +<p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> Choose a name that is not the same as any other partition -name in this object and reissue the CREATE statement.</p> +<p><strong>Recovery:</strong> Do not specify hexadecimals in this type of command.</p> </div> +<div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1251">3.122. SQL 1251</h3> +<h3 id="SQL-1251">3.123. SQL 1251</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The extra insignificant digits of default value <value> are truncated to match the scale of the data type of column <column-name>.</code></pre> @@ -4534,27 +4546,6 @@ extra digits to the right are discarded.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1252">3.123. SQL 1252</h3> -<div class="listingblock"> -<div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">The existing index <index-name> to be used by a unique or primary constraint has not been populated. Please populate the index and then try to add the constraint again.</code></pre> -</div> -</div> -<div class="paragraph"> -<p>Where <index-name> is the name of an existing unpopulated index.</p> -</div> -<div class="paragraph"> -<p><strong>Cause:</strong> An existing index that is not populated has been chosen for a -unique or primary constraint, which is not allowed.</p> -</div> -<div class="paragraph"> -<p><strong>Effect:</strong> The operation fails.</p> -</div> -<div class="paragraph"> -<p><strong>Recovery:</strong> Populate the index and resubmit.</p> -</div> -</div> -<div class="sect2"> <h3 id="SQL-1254">3.124. SQL 1254</h3> <div class="listingblock"> <div class="content"> @@ -4577,89 +4568,88 @@ set of columns.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1262">3.125. SQL 1262</h3> +<h3 id="SQL-1255">3.125. SQL 1255</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">The command cannot be executed because <operation> is in progress for <schema>.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">Constraint <constraint-name> is the clustering key constraint for table <table-name> and cannot be dropped.</code></pre> </div> </div> <div class="paragraph"> -<p>Where <operation> is a schema-level operation.</p> +<p>Where <constraint-name> refers to a constraint that you are trying to drop.</p> </div> <div class="paragraph"> -<p>Where <schema> is the ANSI name of the affected schema.</p> +<p>Where <table-name> is the name of a Trafodion table.</p> </div> <div class="paragraph"> -<p><strong>Cause:</strong> You attempted a DDL or utility operation on a database object -while <operation> was in progress for that object’s <schema>.</p> +<p><strong>Cause:</strong> You attempted to drop a constraint on a Trafodion table, but the constraint is implied by +the clustering key and therefore cannot be dropped. This can occur, for example, if the primary key +was used as the clustering key, and you attempt to drop the primary key constraint.</p> </div> <div class="paragraph"> -<p><strong>Effect:</strong> The DDL or utility operation fails.</p> +<p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> Wait until the operation has finished, and then retry the -DDL or utility operation.</p> +<p><strong>Recovery:</strong> If you genuinely wish to remove this constraint, recreate the table with a different +clustering key.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1263">3.126. SQL 1263</h3> +<h3 id="SQL-1256">3.126. SQL 1256</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">Table, view, and stored procedure names that start with <text> are reserved for {project-name} metadata.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">PRIMARY KEY constraint cannot be added since table <table-name> already has a user specified clustering key.</code></pre> </div> </div> <div class="paragraph"> -<p>Where <text> is the disallowed name that was specified.</p> +<p>Where <table-name> is the name of a Trafodion table.</p> </div> <div class="paragraph"> -<p><strong>Cause:</strong> You specified a Trafodion database reserved object name.</p> +<p><strong>Cause:</strong> You attempted to add a primary key constraint, but the table already has a user-specified +clustering key. This can happen, for example, when adding a primary key to a table that already has one.</p> </div> <div class="paragraph"> -<p><strong>Effect:</strong> The object is not created.</p> +<p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> See the <a href="http://trafodion.incubator.apache.org/docs/sql_reference/index.html";><em>Trafodion SQL Reference Manual</em></a> for the list of -reserved object names. Choose a name that is not reserved and reissue -the CREATE statement.</p> +<p><strong>Recovery:</strong> If you genuinely wish to add this primary key, recreate the table with the primary key as +its clustering key.</p> </div> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1264">3.127. SQL 1264</h3> +<h3 id="SQL-1260">3.127. SQL 1260</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">Duplicate privileges are not allowed in a GRANT or REVOKE statement.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">Debugging of UDRs is only allowed for the DB__ROOT user. Connect as DB__ROOT, preferably using the sqlci tool, and try again.</code></pre> </div> </div> <div class="paragraph"> -<p><strong>Cause:</strong> You specified duplicate privileges in a GRANT or REVOKE -statement.</p> +<p><strong>Cause:</strong> You attempted to debug a User Defined Routine, but you were not connected as DB__ROOT.</p> </div> <div class="paragraph"> <p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> Reissue the GRANT or REVOKE statement, specifying a single -privilege or a list of distinct privileges.</p> +<p><strong>Recovery:</strong> Connect as DB__ROOT and resubmit.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1265">3.128. SQL 1265</h3> +<h3 id="SQL-1264">3.128. SQL 1264</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">Duplicate grantees not allowed in a GRANT or REVOKE statement.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">Duplicate privileges are not allowed in a GRANT or REVOKE statement.</code></pre> </div> </div> <div class="paragraph"> -<p><strong>Cause:</strong> You specified duplicate grantees in a GRANT or REVOKE +<p><strong>Cause:</strong> You specified duplicate privileges in a GRANT or REVOKE statement.</p> </div> <div class="paragraph"> <p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> Reissue the GRANT or REVOKE statement specifying a single -grantee or a list of distinct grantees.</p> +<p><strong>Recovery:</strong> Reissue the GRANT or REVOKE statement, specifying a single +privilege or a list of distinct privileges.</p> </div> <div style="page-break-after: always;"></div> </div> @@ -4686,10 +4676,13 @@ for the procedure or routine.</p> <h3 id="SQL-1267">3.130. SQL 1267</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">EXECUTE privilege is incompatible with this object type.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text"><privilege-type> privilege is incompatible with this object type.</code></pre> </div> </div> <div class="paragraph"> +<p>Where <privilege-type> is a type of privilege (e.g. EXECUTE).</p> +</div> +<div class="paragraph"> <p><strong>Cause:</strong> You specified a privilege that is not supported for the object type in a GRANT statement.</p> </div> @@ -4720,183 +4713,177 @@ references privilege in a GRANT or REVOKE statement.</p> <p><strong>Recovery:</strong> Correct the GRANT or REVOKE statement by specifying a single column name or a list of distinct column names.</p> </div> +<div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1270">3.132. SQL 1270</h3> +<h3 id="SQL-1269">3.132. SQL 1269</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">ALLOCATE or DEALLOCATE failed for object <sql-object-name> due to -file error <file-system-error-number> on <file-name>.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">Column name <column-name> is reserved for internal system usage. It cannot be specified as a user column.</code></pre> </div> </div> <div class="paragraph"> -<p>Where <sql-object-name> is the ANSI name of the affected SQL database -object.</p> -</div> -<div class="paragraph"> -<p>Where <file-system-error-number> is a Trafodion platform file system -error code.</p> +<p>Where <column-name> is the column name you specified.</p> </div> <div class="paragraph"> -<p><strong>Cause:</strong> A CREATE or ALTER operation encountered a file system error -<error-number> during processing of the ALLOCATE or DEALLOCATE attribute.</p> +<p><strong>Cause:</strong> You attempted to use a column name in a DDL statement that is reserved by Trafodion +for internal use. For example, +you attempted to create a table with a column named SYSKEY.</p> </div> <div class="paragraph"> <p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> For information about file system errors, see -<file-system-errors,File-System Errors>.</p> +<p><strong>Recovery:</strong> Correct the DDL statement and resubmit.</p> </div> -<div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1271">3.133. SQL 1271</h3> +<h3 id="SQL-1276">3.133. SQL 1276</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">ALLOCATE failed for object <object-name> because extents to be allocated <number> is greater than the MAXEXTENTS for a partition of the object.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">Unable to select partition <partition-number> from table <table-name>.</code></pre> </div> </div> <div class="paragraph"> -<p>Where <object-name> is the ANSI name of the affected database object.</p> +<p>Where <partition-number> is a partition number you specified.</p> </div> <div class="paragraph"> -<p>Where <number> is the specified number of extents.</p> +<p>Where <table-name> is the table name you specified.</p> </div> <div class="paragraph"> -<p><strong>Cause:</strong> A CREATE or ALTER operation specified an ALLOCATE attribute -value that was greater than the MAXEXTENTS value for the affected -database object, which is not allowed.</p> +<p><strong>Cause:</strong> You attempted to select data from a subset of the partitions of a table, but the +table in question is not salted or the table name given refers to a view.</p> </div> <div class="paragraph"> <p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> If possible, alter the MAXEXTENTS attribute value to be -greater than the</p> -</div> -<div class="paragraph"> -<p>desired number of extents to be allocated. The current maximum value for -MAXEXTENTS is 768.</p> +<p><strong>Recovery:</strong> Correct the statement and resubmit.</p> </div> +<div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1273">3.134. SQL 1273</h3> +<h3 id="SQL-1279">3.134. SQL 1279</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">The specified MAXEXTENTS value must be greater than the number of extents allocated.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">A volatile DDL statement cannot be used on regular objects.</code></pre> </div> </div> <div class="paragraph"> -<p><strong>Cause:</strong> The value that you specified to change MAXEXTENTS is less than -or equal to the allocated extents.</p> +<p><strong>Cause:</strong> You specified VOLATILE when performing a DDL operation on a non-volatile object. For example, you +may have specified DROP VOLATILE TABLE on a table that is not volatile.</p> </div> <div class="paragraph"> <p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> Use a MAXEXTENTS value greater than the allocated extents.</p> +<p><strong>Recovery:</strong> Correct the statement and resubmit.</p> </div> -<div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1274">3.135. SQL 1274</h3> +<h3 id="SQL-1280">3.135. SQL 1280</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">The specified or default MAXEXTENTS value is not sufficient. The MAXEXTENTS value has been automatically set to the new value of <value> for the file <file-name>.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">A regular DDL statement cannot be used on volatile objects.</code></pre> </div> </div> <div class="paragraph"> -<p><strong>Cause:</strong> You specified an insufficient MAXEXTENTS value while creating -an index.</p> +<p><strong>Cause:</strong> You attempted an unsupported ALTER statement on a volatile object. Altering a column +on a volatile table, for example, is not presently supported.</p> </div> <div class="paragraph"> -<p><strong>Effect:</strong> The SQL operation completed with a warning.</p> +<p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> This is a warning only.</p> +<p><strong>Recovery:</strong> Correct the statement and resubmit.</p> </div> +<div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1275">3.136. SQL 1275</h3> +<h3 id="SQL-1282">3.136. SQL 1282</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">Constraint <constraint-1> cannot be dropped because it is needed by unique constraint <constraint-2>.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">A LOB column cannot be specified in a volatile table.</code></pre> </div> </div> <div class="paragraph"> -<p>Where <constraint-1> is the constraint you are trying to drop.</p> +<p><strong>Cause:</strong> You attempted to create a volatile table with a BLOB or CLOB column. Trafodion presently +does not support this. (Note: By default, Trafodion maps BLOB and CLOB columns to VARCHAR columns, +which are supported. This particular error message can only occur if this mapping is turned off. The +mapping is turned off when CQD TRAF_BLOB_AS_VARCHAR and/or CQD TRAF_CLOB_AS_VARCHAR is set to 'OFF'.)</p> </div> <div class="paragraph"> -<p>Where <constraint-2> is the UNIQUE constraint.</p> +<p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Cause:</strong> You attempted to drop a constraint that is needed by a UNIQUE -constraint, which is not allowed because it would leave a UNIQUE -constraint on a column, but without a NOT NULL constraint for that -column.</p> +<p><strong>Recovery:</strong> Correct the statement and resubmit.</p> +</div> +</div> +<div class="sect2"> +<h3 id="SQL-1283">3.137. SQL 1283</h3> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">The specified constraint or file option is not supported on a volatile table.</code></pre> +</div> +</div> +<div class="paragraph"> +<p><strong>Cause:</strong> You attempted to create a volatile table with a feature that Trafodion does not support +on volatile tables. For example, unique constraints are not supported on volatile table columns.</p> </div> <div class="paragraph"> <p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> To drop the constraint, you must remove the UNIQUE -constraint or add an additional NOT NULL constraint to the columns that -contain UNIQUE constraints and only one NOT NULL constraint for that -column.</p> +<p><strong>Recovery:</strong> Correct the statement and resubmit.</p> </div> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1277">3.137. SQL 1277</h3> +<h3 id="SQL-1289">3.138. SQL 1289</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">Unrecognized partitioning scheme for object <object-name>.</code></pre> -</div> +<pre class="CodeRay highlight"><code data-lang="text">The use of ALTER on reserved schemas and metadata schemas is not permitted.</code></pre> </div> -<div class="paragraph"> -<p><object-name> is the name of the SQL object (table or index).</p> </div> <div class="paragraph"> -<p><strong>Cause:</strong> The Trafodion database does not recognize the partitioning -scheme stored in the metadata for the named object.</p> +<p><strong>Cause:</strong> You attempted to ALTER an object in a reserved or metadata schema. This is not +permitted.</p> </div> <div class="paragraph"> -<p><strong>Effect:</strong> The named object is considered corrupt and is inaccessible.</p> +<p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> None. Contact the Trafodion User Distribution List Consider -running the VERIFY operation on the named object to check for -inconsistencies in the metadata with respect to the partitioning scheme.</p> +<p><strong>Recovery:</strong> If your intent was to alter a different object, correct the object name and resubmit.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1278">3.138. SQL 1278</h3> +<h3 id="SQL-1298">3.139. SQL 1298</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">The command cannot be executed because <operation> is in progress for all schemas in catalog <catalog>.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">Schema <schema-name> could not be altered. <reason></code></pre> </div> </div> <div class="paragraph"> -<p><operation> is a schema level operation, currently UPGRADE or DOWNGRADE, -that uses the ALL SCHEMAS IN CATALOG flavor. <catalog> is a catalog name -that is affected by <operation>.</p> +<p>Where <schema-name> is the name of the schema you specified.</p> </div> <div class="paragraph"> -<p><strong>Cause:</strong> An attempt was made to execute a DDL or utility operation that -affected <catalog>, or a schema in that catalog.</p> +<p>Where <reason> gives further information about the nature of the error.</p> +</div> +<div class="paragraph"> +<p><strong>Cause:</strong> You attempted an ALTER SCHEMA statement but one or more objects in the schema are in an +invalid state. The <reason> gives more details concerning this invalid state.</p> </div> <div class="paragraph"> <p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> Wait until <operation> is finished, then retry the failed -DDL or utility operation.</p> +<p><strong>Recovery:</strong> The <reason> may suggest possible recoveries. For example, you may need to +use CLEANUP on certain objects in the schema, then resubmit the ALTER SCHEMA statement.</p> </div> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1301">3.139. SQL 1301</h3> +<h3 id="SQL-1301">3.140. SQL 1301</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">NO ACTION referential action for <referential-triggered-action> clause is not yet supported as specified by ANSI SQL-99 standard. To alter the behavior, set an appropriate value for the REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT default.</code></pre> @@ -4921,7 +4908,7 @@ default.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1302">3.140. SQL 1302</h3> +<h3 id="SQL-1302">3.141. SQL 1302</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">NO ACTION referential action for <referential-triggered-action> clause behaves like RESTRICT referential action. To alter the behavior, set the appropriate value for the REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT default.</code></pre> @@ -4948,7 +4935,7 @@ default.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1305">3.141. SQL 1305</h3> +<h3 id="SQL-1305">3.142. SQL 1305</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The specified schema location <directory> is already in use by schema <schema>.</code></pre> @@ -4986,7 +4973,7 @@ backup nodes.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1307">3.142. SQL 1307</h3> +<h3 id="SQL-1307">3.143. SQL 1307</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The schema location <directory> is reserved for {project-name} metadata.</code></pre> @@ -5012,7 +4999,7 @@ ZSD<letter><anything> in the LOCATION clause, and resubmit.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1309">3.143. SQL 1309</h3> +<h3 id="SQL-1309">3.144. SQL 1309</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Object type for <object-name> is not valid for the current operation.</code></pre> @@ -5034,7 +5021,7 @@ operation.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1310">3.144. SQL 1310</h3> +<h3 id="SQL-1310">3.145. SQL 1310</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The CREATE SCHEMA statement does not support the creation of triggers.</code></pre> @@ -5054,7 +5041,7 @@ statement and resubmit. Create triggers in separate statements.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1420">3.145. SQL 1420</h3> +<h3 id="SQL-1420">3.146. SQL 1420</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Column <column-name> cannot be dropped or altered as it is part of the table's primary key.</code></pre> @@ -5071,7 +5058,7 @@ statement and resubmit. Create triggers in separate statements.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1421">3.146. SQL 1421</h3> +<h3 id="SQL-1421">3.147. SQL 1421</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Column <column-name> cannot be dropped or altered as it is used in the secondary index <index-name>.</code></pre> @@ -5089,7 +5076,7 @@ name or table name are incorrect, correct them and resubmit.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1422">3.147. SQL 1422</h3> +<h3 id="SQL-1422">3.148. SQL 1422</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">An invalid HBase name was specified in this DDL statement. A valid name can only contain these characters: [a-zA-Z_0-9-.]</code></pre> @@ -5108,7 +5095,7 @@ stored in HBase.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1423">3.148. SQL 1423</h3> +<h3 id="SQL-1423">3.149. SQL 1423</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Insert into metadata table <table-name> failed.</code></pre> @@ -5126,14 +5113,14 @@ be additional messages giving details of the failure.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1424">3.149. SQL 1424</h3> +<h3 id="SQL-1424">3.150. SQL 1424</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">Column <column-name> cannot be dropped as that would leave the table with no user defined columns.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">Column <column-name> cannot be dropped as that would leave the table with no user defined or user updatable columns.</code></pre> </div> </div> <div class="paragraph"> -<p><strong>Cause:</strong> You attempted to drop the only remaining user-defined column in the table.</p> +<p><strong>Cause:</strong> You attempted to drop the only remaining user-defined or user-updatable column in the table.</p> </div> <div class="paragraph"> <p><strong>Effect:</strong> The operation fails.</p> @@ -5143,7 +5130,7 @@ be additional messages giving details of the failure.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1425">3.150. SQL 1425</h3> +<h3 id="SQL-1425">3.151. SQL 1425</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">This operation could not be performed on <table-name>. <reason></code></pre> @@ -5162,10 +5149,10 @@ be performed. <reason> gives more details.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1426">3.151. SQL 1426</h3> +<h3 id="SQL-1426">3.152. SQL 1426</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">An invalid HBase column name <column-name> was specified. A valid name must be of the format: <ColumnFamily>:<ColumnName></code></pre> +<pre class="CodeRay highlight"><code data-lang="text">An invalid HBase column name <column-name> was specified. A valid name must be of the format: <ColumnFamily>:<ColumnName></code></pre> </div> </div> <div class="paragraph"> @@ -5180,7 +5167,7 @@ an invalid HBase column name.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1427">3.152. SQL 1427</h3> +<h3 id="SQL-1427">3.153. SQL 1427</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Table cannot be renamed. <reason></code></pre> @@ -5198,7 +5185,7 @@ an invalid HBase column name.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1428">3.153. SQL 1428</h3> +<h3 id="SQL-1428">3.154. SQL 1428</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Metadata definitions could not be created and preloaded in global MDdescInfo struct. Make sure that metadata table definition syntax is correct.</code></pre> @@ -5217,7 +5204,7 @@ encounter this error unless you are making code changes to Trafodion yourself.</ <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1429">3.154. SQL 1429</h3> +<h3 id="SQL-1429">3.155. SQL 1429</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Inserts into _ROW_ format external HBase tables can only use the VALUES clause and must use the column_create function to create values.</code></pre> @@ -5234,6 +5221,24 @@ clause but did not use a COLUMN_CREATE function.</p> <p><strong>Recovery:</strong> Correct the statement and resubmit.</p> </div> </div> +<div class="sect2"> +<h3 id="SQL-1430">3.156. SQL 1430</h3> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">A schema name that starts and ends with an "_"(underscore) is reserved for internal usage. It cannot be used to create a user schema.</code></pre> +</div> +</div> +<div class="paragraph"> +<p><strong>Cause:</strong> You attempted to create a schema with a name beginning and ending with an underscore. These names are +reserved by Trafodion for internal use.</p> +</div> +<div class="paragraph"> +<p><strong>Effect:</strong> The operation fails.</p> +</div> +<div class="paragraph"> +<p><strong>Recovery:</strong> Correct the statement and resubmit.</p> +</div> +</div> </div> </div> <div class="sect1"> @@ -10799,7 +10804,7 @@ specified is an unsigned numeric.</p> <h3 id="SQL-3209">5.193. SQL 3209</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">Maximum length of LONGWVARCHAR is <value>.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">The maximum length of LONGWVARCHAR is <value>.</code></pre> </div> </div> <div class="paragraph"> @@ -10821,7 +10826,7 @@ and resubmit.</p> <h3 id="SQL-3210">5.194. SQL 3210</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">Minimum length of LONGWVARCHAR is <value>.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">The minimum length of LONGWVARCHAR is <value>.</code></pre> </div> </div> <div class="paragraph"> @@ -10842,7 +10847,7 @@ and resubmit.</p> <h3 id="SQL-3211">5.195. SQL 3211</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">Maximum length of LONG VARBINARY is <value>.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">The maximum length of LONG VARBINARY is <value>.</code></pre> </div> </div> <div class="paragraph"> @@ -10863,7 +10868,7 @@ and resubmit.</p> <h3 id="SQL-3212">5.196. SQL 3212</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">Minimum length of LONG VARBINARY is <value>.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">The minimum length of LONG VARBINARY is <value>.</code></pre> </div> </div> <div class="paragraph"> @@ -10883,7 +10888,7 @@ and resubmit.</p> <h3 id="SQL-3213">5.197. SQL 3213</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">Maximum length of LONG VARCHAR is <value>.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">The maximum length of LONG VARCHAR is <value>.</code></pre> </div> </div> <div class="paragraph"> @@ -10904,7 +10909,7 @@ and resubmit.</p> <h3 id="SQL-3214">5.198. SQL 3214</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">Minimum length of LONG VARCHAR is <value>.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">The minimum length of LONG VARCHAR is <value>.</code></pre> </div> </div> <div class="paragraph"> @@ -10988,7 +10993,7 @@ functions.</p> <h3 id="SQL-3218">5.202. SQL 3218</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">A table reference cannot contain DELETE or UPDATE in a CREATE VIE statement.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">A table reference cannot contain DELETE or UPDATE in a CREATE VIEW statement.</code></pre> </div> </div> <div class="paragraph"> @@ -11001,32 +11006,10 @@ operation as a table reference.</p> <div class="paragraph"> <p><strong>Recovery:</strong> Do not use delete or update in a CREATE view statement.</p> </div> -</div> -<div class="sect2"> -<h3 id="SQL-3220">5.203. SQL 3220</h3> -<div class="listingblock"> -<div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">SHOWDDL failed for object <object-name> because an SQL/MP display option was used on a {project-name} object.</code></pre> -</div> -</div> -<div class="paragraph"> -<p>Where <object-name> specifies the ANSI name of a table, view, or ALIAS.</p> -</div> -<div class="paragraph"> -<p><strong>Cause:</strong> SHOWDDL was given the display option with a Trafodion -table given as an argument.</p> -</div> -<div class="paragraph"> -<p><strong>Effect:</strong> SHOWDDL does not display output.</p> -</div> -<div class="paragraph"> -<p><strong>Recovery:</strong> Reissue the command without the display option or specify an -object.</p> -</div> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-3225">5.204. SQL 3225</h3> +<h3 id="SQL-3225">5.203. SQL 3225</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">SHOWLABEL failed for object <object-name>. The object does not exist in the given namespace <name-space>, the object is not accessible, or the object type is not supported. SHOWLABEL supports only {project-name} tables, views and indexes.</code></pre> @@ -11053,7 +11036,7 @@ namespace of a valid, supported, and accessible object.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-3226">5.205. SQL 3226</h3> +<h3 id="SQL-3226">5.204. SQL 3226</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">SHOWLABEL failed for physical location name <location-name>. Object does not exist or object type is not supported. SHOWLABEL supports only {project-name} tables, views, and indexes.</code></pre> @@ -11076,7 +11059,7 @@ argument.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-3228">5.206. SQL 3228</h3> +<h3 id="SQL-3228">5.205. SQL 3228</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">SHOWLABEL failed for physical location name <location-name>. SHOWLABEL supports only the data forks of {project-name} tables, views, and indexes.</code></pre> @@ -11099,7 +11082,7 @@ does not support resource forks.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-3229">5.207. SQL 3229</h3> +<h3 id="SQL-3229">5.206. SQL 3229</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">SHOWLABEL failed for object <name>. SHOWLABEL does not support synonyms.</code></pre> @@ -11117,7 +11100,7 @@ does not support resource forks.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-3230">5.208. SQL 3230</h3> +<h3 id="SQL-3230">5.207. SQL 3230</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The synonym must be defined in the same catalog as the specified table or view.</code></pre> @@ -11136,7 +11119,7 @@ the same catalog and schema values.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-3400">5.209. SQL 3400</h3> +<h3 id="SQL-3400">5.208. SQL 3400</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Invalid code point value for character set <name>.</code></pre> @@ -11154,7 +11137,7 @@ the same catalog and schema values.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-3401">5.210. SQL 3401</h3> +<h3 id="SQL-3401">5.209. SQL 3401</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Hexadecimal representation of string literals associated with character set <name> is not supported.</code></pre> @@ -11173,7 +11156,7 @@ specified.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-3402">5.211. SQL 3402</h3> +<h3 id="SQL-3402">5.210. SQL 3402</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The format of the <value> hexadecimal string literal is not valid.</code></pre> @@ -11193,7 +11176,7 @@ resubmit.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-3403">5.212. SQL 3403</h3> +<h3 id="SQL-3403">5.211. SQL 3403</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Function <name-1> does not take an operand with character set <name-2>.</code></pre> @@ -11212,7 +11195,7 @@ the function.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-3404">5.213. SQL 3404</h3> +<h3 id="SQL-3404">5.212. SQL 3404</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Character set <name>, to which SQL_TEXT is aliased, is not allowed for a SQL module.</code></pre> @@ -11231,7 +11214,7 @@ SQL_TEXT is synonymous with UCS2, which is not supported.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-3405">5.214. SQL 3405</h3> +<h3 id="SQL-3405">5.213. SQL 3405</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">A logical partition name cannot be specified in the LOCATION clause of the CREATE statement of this object.</code></pre> @@ -11251,7 +11234,7 @@ clause and resubmit.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-3406">5.215. SQL 3406</h3> +<h3 id="SQL-3406">5.214. SQL 3406</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">A DDL statement could not be translated into a statement consisting of single-byte characters for processing.</code></pre> @@ -11271,7 +11254,7 @@ unicode characters.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-3411">5.216. SQL 3411</h3> +<h3 id="SQL-3411">5.215. SQL 3411</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Expressions are not allowed as IDENTITY column values. Specify DEFAULT or supply a largeint value.</code></pre> @@ -11289,7 +11272,7 @@ value or DEFAULT.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-3412">5.217. SQL 3412</h3> +<h3 id="SQL-3412">5.216. SQL 3412</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">IDENTITY column <column-name> must be the primary key or must have a unique index on it.</code></pre> @@ -11309,7 +11292,7 @@ unique index must only be on the IDENTITY column.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-3413">5.218. SQL 3413</h3> +<h3 id="SQL-3413">5.217. SQL 3413</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The NOT NULL constraint on IDENTITY column <column-name> must be NOT DROPPABLE.</code></pre> @@ -11328,7 +11311,7 @@ on the IDENTITY column.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-3414">5.219. SQL 3414</h3> +<h3 id="SQL-3414">5.218. SQL 3414</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">For an IDENTITY column <column-name>, the tuple list cannot have mixed user specified and DEFAULT values. Specify values for all or specify DEFAULT for all.</code></pre> @@ -13115,7 +13098,7 @@ other than an outermost SELECT statement.</p> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">If a character literal was intended, you must use the single quote -delimiter: <literal>. The use of double quotes causes {project-name} to +delimiter: <literal>. The use of double quotes causes SQL to interpret <column-name> as a delimited identifier column name.</code></pre> </div> </div> @@ -13712,65 +13695,46 @@ incompatible data types.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4128">6.115. SQL 4128</h3> +<h3 id="SQL-4129">6.115. SQL 4129</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">Default volume and subvolume information could not be retrieved from=_DEFAULTS define - DEFINEINFO error <number>.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">The character-typed result of the function <function-name> is longer than the maximum supported size.</code></pre> </div> </div> <div class="paragraph"> -<p>Where <number> is the error message.</p> +<p>Where <function-name> is the name of a function you specified.</p> </div> <div class="paragraph"> -<p><strong>Cause:</strong> Trafodion was not able to retrieve -default volume and subvolume information using the =_DEFAULTS define.</p> +<p><strong>Cause:</strong> You specified arguments to the given function that cause the result of the function +to have a data type longer than the maximum supported character data type length.</p> </div> <div class="paragraph"> <p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> Check the =_DEFAULTS define and resubmit.</p> +<p><strong>Recovery:</strong> Change the arguments to the function and resubmit.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4129">6.116. SQL 4129</h3> +<h3 id="SQL-4130">6.116. SQL 4130</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">An IF statement should have the same set of output host variables on -both sides of IF THEN statement list and the ELSE statement list.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text"><attribute-name> is a read-only DEFAULTS attribute and cannot be updated.</code></pre> </div> </div> <div class="paragraph"> -<p><strong>Cause:</strong> You specified an IF statement that does not have the same set -of output host variables on both sides of its IF THEN statement list and -its ELSE statement list.</p> +<p><strong>Cause:</strong> You attempted to perform a CONTROL QUERY DEFAULT but Trafodion does not +allow this particular attribute to be changed.</p> </div> <div class="paragraph"> <p><strong>Effect:</strong> The operation fails.</p> </div> <div class="paragraph"> -<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p> -</div> -</div> -<div class="sect2"> -<h3 id="SQL-4130">6.117. SQL 4130</h3> -<div class="listingblock"> -<div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">SIGNAL parameter 3 must be of type string</code></pre> -</div> -</div> -<div class="paragraph"> -<p><strong>Cause:</strong> You specified a SIGNAL parameter of an incorrect type.</p> -</div> -<div class="paragraph"> -<p><strong>Effect:</strong> The operation fails.</p> -</div> -<div class="paragraph"> -<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p> +<p><strong>Recovery:</strong> If a different attribute was intended, correct the syntax and resubmit.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4133">6.118. SQL 4133</h3> +<h3 id="SQL-4133">6.117. SQL 4133</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Both trim character and source have to be CHARACTER type.</code></pre> @@ -13789,7 +13753,7 @@ CHARACTER.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4134">6.119. SQL 4134</h3> +<h3 id="SQL-4134">6.118. SQL 4134</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The operation (<name>) is not allowed. Try UNION ALL instead.</code></pre> @@ -13807,7 +13771,7 @@ database software does not allow.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4135">6.120. SQL 4135</h3> +<h3 id="SQL-4135">6.119. SQL 4135</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">In an INSERT-SELECT, each column in the ORDER BY clause must be one @@ -13828,7 +13792,7 @@ is also in the select list of the INSERT-SELECT query and resubmit.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4136">6.121. SQL 4136</h3> +<h3 id="SQL-4136">6.120. SQL 4136</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">An outer SELECT was used in a DELETE [FIRST N] statement without @@ -13847,7 +13811,7 @@ without using the [LAST 1] clause.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4150">6.122. SQL 4150</h3> +<h3 id="SQL-4150">6.121. SQL 4150</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Primary key of table expression <name> must be used for join with @@ -13872,7 +13836,7 @@ expression.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4151">6.123. SQL 4151</h3> +<h3 id="SQL-4151">6.122. SQL 4151</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Stream access is supported only on updatable views. View: <table-name>.</code></pre> @@ -13891,7 +13855,7 @@ statement.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4152">6.124. SQL 4152</h3> +<h3 id="SQL-4152">6.123. SQL 4152</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Table <name> cannot be both read and updated.</code></pre> @@ -13909,7 +13873,7 @@ statement.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4153">6.125. SQL 4153</h3> +<h3 id="SQL-4153">6.124. SQL 4153</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Statement may not compile due to an order requirement on stream expression.</code></pre> @@ -13930,7 +13894,7 @@ the order and resubmit.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4154">6.126. SQL 4154</h3> +<h3 id="SQL-4154">6.125. SQL 4154</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Statement may not compile due to an order requirement on embedded @@ -13952,7 +13916,7 @@ resubmit.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4156">6.127. SQL 4156</h3> +<h3 id="SQL-4156">6.126. SQL 4156</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Inner relation of left join cannot be embedded <command-name>. Tables in scope: <name>.</code></pre> @@ -13970,7 +13934,7 @@ embedded UPDATE or DELETE as the inner relation.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4157">6.128. SQL 4157</h3> +<h3 id="SQL-4157">6.127. SQL 4157</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Inner relation of left join cannot be stream expression. Tables in scope: <name>.</code></pre> @@ -13989,7 +13953,7 @@ statement.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4158">6.129. SQL 4158</h3> +<h3 id="SQL-4158">6.128. SQL 4158</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Join of stream expressions is not supported. Tables in scope: <name>.</code></pre> @@ -14007,7 +13971,7 @@ statement.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4159">6.130. SQL 4159</h3> +<h3 id="SQL-4159">6.129. SQL 4159</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Intersection of stream expressions is not supported. Tables in scope: <name>.</code></pre> @@ -14025,7 +13989,7 @@ statement.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4160">6.131. SQL 4160</h3> +<h3 id="SQL-4160">6.130. SQL 4160</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Intersection between embedded <name-1> expression and embedded @@ -14045,7 +14009,7 @@ statement.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4161">6.132. SQL 4161</h3> +<h3 id="SQL-4161">6.131. SQL 4161</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Union between embedded <name-1> expression and embedded <name-2> @@ -14065,7 +14029,7 @@ statement.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4162">6.133. SQL 4162</h3> +<h3 id="SQL-4162">6.132. SQL 4162</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">GROUP BY is not supported for stream expression. Tables in scope: <name>.</code></pre> @@ -14084,7 +14048,7 @@ statement.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4163">6.134. SQL 4163</h3> +<h3 id="SQL-4163">6.133. SQL 4163</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">GROUP BY is not supported for embedded <name-1> expression. Tables in @@ -14104,7 +14068,7 @@ statement.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4164">6.135. SQL 4164</h3> +<h3 id="SQL-4164">6.134. SQL 4164</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Outer relation of right join cannot be embedded <name> expression. @@ -14124,7 +14088,7 @@ statement.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4165">6.136. SQL 4165</h3> +<h3 id="SQL-4165">6.135. SQL 4165</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Outer relation of right join cannot be stream expression. Tables in @@ -14144,7 +14108,7 @@ statement.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4166">6.137. SQL 4166</h3> +<h3 id="SQL-4166">6.136. SQL 4166</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">ORDER BY clause is not supported in UNION of two streams. Tables in @@ -14164,7 +14128,7 @@ statement.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4167">6.138. SQL 4167</h3> +<h3 id="SQL-4167">6.137. SQL 4167</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Embedded <name> statements are not supported in subqueries.</code></pre> @@ -14183,7 +14147,7 @@ statement.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4168">6.139. SQL 4168</h3> +<h3 id="SQL-4168">6.138. SQL 4168</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Stream expressions are not supported in subqueries.</code></pre> @@ -14202,7 +14166,7 @@ statement.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4169">6.140. SQL 4169</h3> +<h3 id="SQL-4169">6.139. SQL 4169</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Embedded delete statements are not allowed when using DECLARE . . . @@ -14222,7 +14186,7 @@ statement.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4170">6.141. SQL 4170</h3> +<h3 id="SQL-4170">6.140. SQL 4170</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Stream expressions are not supported for insert statements.</code></pre> @@ -14241,7 +14205,7 @@ statement.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-4171">6.142. SQL 4171</h3> +<h3 id="SQL-4171">6.141. SQL 4171</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Embedded <name> statements ar
<TRUNCATED>
