{"id":2876,"date":"2021-01-06T14:29:28","date_gmt":"2021-01-06T06:29:28","guid":{"rendered":"https:\/\/www.gbase8.cn\/?p=2876"},"modified":"2022-07-12T08:58:15","modified_gmt":"2022-07-12T00:58:15","slug":"gbase-8a%e5%b8%b8%e8%a7%81%e6%8a%a5%e9%94%99%e7%a0%81%ef%bc%8c%e9%94%99%e8%af%af%e7%a0%81","status":"publish","type":"post","link":"https:\/\/www.gbase8.cn\/en\/2876","title":{"rendered":"\u5357\u5927\u901a\u7528GBase 8a\u5e38\u89c1\u62a5\u9519\u7801\uff0c\u9519\u8bef\u7801"},"content":{"rendered":"<p>\u672c\u6587\u5217\u4e3eGBase 8a\u6570\u636e\u5e93\u96c6\u7fa4\uff0c\u80fd\u9a8c\u8bc1\u7684\uff0c\u9047\u5230\u8fc7\u7684\u62a5\u9519\u7801\u6216\u9519\u8bef\u7801\u3002<\/p>\n\n\n\n<p>\u5982\u4e0b\u9519\u8bef\u7801\u662f\uff1aERROR + gbase_errorno + (SQLSTATE)<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Directory Navigation<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2aad9da7739\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2aad9da7739\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1046_3D000\" >ERROR 1046 (3D000)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1049_42000\" >ERROR 1049 (42000)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1050_42S01\" >ERROR 1050 (42S01)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1061_42000\" >ERROR 1061 (42000)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#Duplicate_key_name\" >Duplicate key name<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1064_42000\" >ERROR 1064 (42000)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#You_have_an_error_in_your_SQL_syntax\" >You have an error in your SQL syntax<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1105_HY000\" >ERROR 1105 (HY000)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#DBLink-Table_does_not_support_update_operation\" >DBLink-Table does not support update operation<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1109_42S02\" >ERROR 1109 (42S02)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1133_42000\" >ERROR 1133 (42000)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#Cant_find_any_matching_row_in_the_user_table\" >Can&#8217;t find any matching row in the user table<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1142_42000\" >ERROR 1142 (42000)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#SELECT_command_denied_to_user\" >SELECT command denied to user<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1146_42S02\" >ERROR 1146 (42S02)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1149_42000\" >ERROR 1149 (42000)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#contains_function_can_ONLY_in_WHERE_clause\" >contains function can ONLY in WHERE clause<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#score_function_can_ONLY_in_SELECT_GROUP_BY_or_ORDER_BY_clause\" >score function can ONLY in SELECT, GROUP BY or ORDER BY clause<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#not_match_the_number_of_score_func\" >not match the number of score func<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#Cant_DO_Merge_when_not_able_to_build_hash\" >Can&#8217;t DO Merge when not able to build hash<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#GBA-02SC-1001_The_query_includes_syntax_that_is_not_supported_by_the_gcluster\" >(GBA-02SC-1001) The query includes syntax that is not supported by the gcluster<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1191_HY000\" >ERROR 1191 (HY000)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#Cant_find_FULLTEXT_index_matching_the_column_list\" >Can&#8217;t find FULLTEXT index matching the column list<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1210_HY000\" >ERROR 1210 (HY000)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#Incorrect_arguments_to_CONTAINS_FUNCTION_%E2%80%93_SCORE_FLAG_COLLISION\" >Incorrect arguments to CONTAINS FUNCTION &#8211; SCORE FLAG COLLISION<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1235_42000\" >ERROR 1235 (42000)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#use_dblink_table_in_a_FUNCTIONTRIGGERVIEW\" >use dblink table in a FUNCTION\/TRIGGER\/VIEW<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-28\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#updatemerge_on_auto_increment_column\" >update\/merge on auto_increment column<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-29\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1256\" >ERROR 1256<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-30\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#Table_has_no_partition_for_value\" >Table has no partition for value<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-31\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1264_22003\" >ERROR 1264 (22003)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-32\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#Out_of_range_value_for_column\" >Out of range value for column<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-33\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1292_22007\" >ERROR 1292 (22007)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-34\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#Incorrect_date_value_for_column\" >Incorrect date value for column<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-35\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#Incorrect_time_value_for_column\" >Incorrect time value for column<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-36\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#Incorrect_datetime_value_for_column\" >Incorrect datetime value for column<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-37\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1305_42000\" >ERROR 1305 (42000)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-38\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#FUNCTION_does_not_exist\" >FUNCTION does not exist<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-39\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1317_70100\" >ERROR 1317 (70100)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-40\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#Query_execution_was_interrupted\" >Query execution was interrupted<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-41\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1702_HY000_gcluster_table_error\" >ERROR 1702 (HY000): gcluster table error<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-42\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#GBA-02DD-0017\" >GBA-02DD-0017<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-43\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ALTER_column_definition_except_increasing_length_of_varchar\" >ALTER column definition except increasing length of varchar&#8217;<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-44\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1708_HY000_Failed_to_query_in_gnode\" >ERROR 1708 (HY000): Failed to query in gnode<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-45\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#GBA-01EX-0006\" >GBA-01EX-0006<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-46\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#GBA-01EX-700\" >GBA-01EX-700<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-47\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#GBA-02AD-0005\" >GBA-02AD-0005<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-48\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#incorrect_parameter_in_function_to_date\" >incorrect parameter in function to_date<\/a><\/li><\/ul><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-49\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1712_HY000_gcluster_view_error\" >ERROR 1712 (HY000): gcluster view error<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-50\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1722_HY000\" >ERROR 1722 (HY000)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-51\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#GBA-02DD-0006\" >GBA-02DD-0006<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-52\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#Cant_update_distributed_column\" >Can&#8217;t update distributed column<\/a><\/li><\/ul><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-53\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1729_HY000\" >ERROR 1729 (HY000)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-54\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#set_table_extend_failed_must_be_between_1M_and_2G\" >set table extend failed: must be between 1M and 2G<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-55\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1733_HY000\" >ERROR 1733 (HY000)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-56\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#GBA-01-600\" >GBA-01-600<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-57\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#Too_many_bad_records\" >Too many bad records<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-58\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#GBA-01EX-700-2\" >GBA-01EX-700<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-59\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#%E5%8F%82%E6%95%B0%E8%B6%85%E8%BF%87%E4%BA%86%E5%85%81%E8%AE%B8%E8%8C%83%E5%9B%B4\" >\u53c2\u6570\u8d85\u8fc7\u4e86\u5141\u8bb8\u8303\u56f4<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-60\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#%E9%80%9A%E9%85%8D%E7%AC%A6%E5%8C%B9%E9%85%8D%E5%8A%A0%E8%BD%BD%E5%A4%B1%E8%B4%A5\" >\u901a\u914d\u7b26\u5339\u914d\u52a0\u8f7d\u5931\u8d25<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-61\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#Empty_or_invalid_index_path\" >Empty or invalid index path<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-62\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#The_disk_space_of_User_has_exceeded_the_limit_value\" >The disk space of User has exceeded the limit value<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-63\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#auto-increment_column_should_not_be_specified_in_insert%E2%80%A6\" >auto-increment column should not be specified in insert(&#8230;)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-64\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#auto-increment_column_should_not_be_specified_in_insert_select\" >auto-increment column should not be specified in insert select<\/a><\/li><\/ul><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-65\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1739_HY000\" >ERROR 1739 (HY000)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-66\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#GBA-01EX-0006-2\" >GBA-01EX-0006<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-67\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1758_HY000\" >ERROR 1758 (HY000)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-68\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#Operation_CREATE_USER_failed_for\" >Operation CREATE USER failed for<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-69\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#Operation_DROP_USER_failed_for\" >Operation DROP USER failed for<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-70\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#Password_is_in_history_for_user\" >Password is in history for user<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-71\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1802_HY000\" >ERROR 1802 (HY000)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-72\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#Invalid_password_format\" >Invalid password format<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-73\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1818_HY000\" >ERROR 1818 (HY000)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-74\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#No_VC_selected\" >No VC selected<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-75\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1829\" >ERROR 1829<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-76\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#encryption_certificate_already_open\" >encryption certificate already open<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-77\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#encryption_certificate_not_exists\" >encryption certificate not exists<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-78\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#decrypt_failed_please_check_password\" >decrypt failed, please check password<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-79\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1830_HY000\" >ERROR 1830 (HY000)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-80\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#You_must_reset_your_password_using_ALTER_USER_statement_before_executing_this_statement\" >You must reset your password using ALTER USER statement before executing this statement<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-81\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1835_HY000\" >ERROR 1835 (HY000)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-82\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#encryption_certificate_already_exists\" >encryption certificate already exists<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-83\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_1838_HY000\" >ERROR 1838 (HY000)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-84\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#Encrypt_key_invalid\" >Encrypt key invalid<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-85\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#Decrypt_key_invalid\" >Decrypt key invalid<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-86\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#ERROR_2003\" >ERROR 2003<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-87\" href=\"https:\/\/www.gbase8.cn\/en\/2876\/#Cant_connect_to_GBase_server_on_IP_113\" >Can&#8217;t&nbsp;connect&nbsp;to&nbsp;GBase&nbsp;server&nbsp;on IP (113)<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1046_3D000\"><\/span>ERROR 1046 (3D000)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u6ca1\u6709\u6307\u5b9a\u6570\u636e\u5e93\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; SELECT DATABASE() FROM dual;\nERROR 1046 (3D000): No database selected<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1049_42000\"><\/span>ERROR 1049 (42000)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u6307\u5b9a\u7684\u6570\u636e\u5e93\u4e0d\u5b58\u5728\u3002Unknown database<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; create table testdb2.t1 (id int);\nERROR 1049 (42000): Unknown database 'testdb2'<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1050_42S01\"><\/span>ERROR 1050 (42S01)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u8868\u5df2\u7ecf\u5b58\u5728\uff0c\u4e0d\u80fd\u91cd\u590d\u521b\u5efa\u3002Table  already exists<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; create table t1 (id int);\nERROR 1050 (42S01): Table 't1' already exists<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1061_42000\"><\/span>ERROR 1061 (42000)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Duplicate_key_name\"><\/span>Duplicate key name<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u952e\u503c\u540d\u5b57\u91cd\u590d\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; CREATE TABLE t (a int,b int,c int,d int, GROUPED a(b,c), GROUPED a(d));\nERROR 1061 (42000): Duplicate key name 'a'<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1064_42000\"><\/span>ERROR 1064 (42000)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"You_have_an_error_in_your_SQL_syntax\"><\/span>You have an error in your SQL syntax<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u8bed\u6cd5\u9519\u8bef\uff0c\u8bf7\u68c0\u67e5SQL\u624b\u518c\uff0c\u6309\u7167\u8bed\u6cd5\u8981\u6c42\u7f16\u5199SQL\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; drop table x1@gc_dblink;\nERROR 1064 (42000): You have an error in your SQL syntax; check the manual that\n corresponds to your GBase server version for the right syntax to use near '@gc_dblink' at\n line 1\n\ngbase&gt; alter table t1 modify id comment '\u7f16\u53f7';\nERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your GBase server version for the right syntax to use near 'comment '\u7f16\u53f7'' at line 1\n<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1105_HY000\"><\/span>ERROR 1105 (HY000)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"DBLink-Table_does_not_support_update_operation\"><\/span>DBLink-Table does not support update operation<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>dblink\u8868\u4e0d\u652f\u6301update\u64cd\u4f5c\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>update x1@gc_dblink set id2 =1;\nERROR 1105 (HY000): DBLink-Table does not support update operation.<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1109_42S02\"><\/span>ERROR 1109 (42S02)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u76ee\u524d\u6d4b\u8bd5\u7ed3\u679c\uff0c\u5728\u652f\u6301express\u5f15\u64ce\u7684\u5e93\uff0c\u4f1a\u62a5 ERROR 1702 (HY000): gcluster table error: (GBA-02DD-0017)\uff0c\u5426\u5219\u62a5\u8fd9\u4e2a\u9519\u8bef\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; drop table aaaaaa;\nERROR 1109 (42S02): Unknown table 'aaaaaa' in information_schema<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1133_42000\"><\/span>ERROR 1133 (42000)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cant_find_any_matching_row_in_the_user_table\"><\/span>Can&#8217;t find any matching row in the user table<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u6307\u5b9a\u7684\u7528\u6237\u540d\u6ca1\u6709\u627e\u5230\uff0c\u5e38\u89c1\u4e8egccli,\u5176\u9ed8\u8ba4\u4f7f\u7528ssh\u767b\u5f55\u65f6\u7684\u64cd\u4f5c\u7cfb\u7edf\u7528\u6237\u540d\uff0c\u4f5c\u4e3agccli\u6ca1\u6709\u6307\u5b9a-u\u65f6\u7684\u7528\u6237\u540d\u3002\u5982\u679c\u6ca1\u6709\u627e\u5230\u5219\u62a5\u8fd9\u4e2a\u9519\u8bef\u3002<\/p>\n\n\n\n<p>\u89e3\u51b3\u65b9\u6cd5\u5c31\u662fgccli\u6bcf\u6b21\u90fd\u7528-u\u6307\u5b9a\u7528\u6237\u540d\uff0c\u800c\u4e0d\u662f\u4f7f\u7528\u9ed8\u8ba4\u7684ssh\u767b\u5f55\u64cd\u4f5c\u7cfb\u7edf\u7528\u6237\u540d\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>&#91;root@rh6-1 ~]# ssh test@10.0.2.201\ntest@10.0.2.201's password:\n&#91;test@rh6-1 ~]$ su - gbase\nPassword:\n&#91;gbase@rh6-1 ~]$ gccli\nERROR 1133 (42000): Can't find any matching row in the user table\n&#91;gbase@rh6-1 ~]$ gccli -uabc\nERROR 1045 (28000): Access denied for user 'abc'@'localhost' (using password: NO)<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1142_42000\"><\/span>ERROR 1142 (42000)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"SELECT_command_denied_to_user\"><\/span>SELECT command denied to user<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u65e0\u6743\u9650\u8bbf\u95ee\u67d0\u4e2a\u5bf9\u8c61\uff0c\u6bd4\u5982\u8868\u3002\u89e3\u51b3\u65b9\u6848\u662f\u7528grant\u6388\u6743\u8be5\u7528\u6237\u53ef\u4ee5\u8bbf\u95ee\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>ERROR 1142 (42000): SELECT command denied to user 'test'@'localhost' for table 'dual'<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1146_42S02\"><\/span>ERROR 1146 (42S02)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u8868\u4e0d\u5b58\u5728\u3002Table  doesn't exist<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; select * from table_not_exists;\nERROR 1146 (42S02): Table 'testdb.table_not_exists' doesn't exist<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1149_42000\"><\/span>ERROR 1149 (42000)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"contains_function_can_ONLY_in_WHERE_clause\"><\/span>contains function can ONLY in WHERE clause<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>contains\u51fd\u6570\u53ea\u80fd\u51fa\u73b0\u5728where\u90e8\u5206\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; SELECT contains(a ,'\u901a\u7528') FROM t WHERE contains(a ,'\u4e2d\u56fd') AND score(0) &gt;10;\nERROR 1149 (42000): contains function can ONLY in WHERE clause<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"score_function_can_ONLY_in_SELECT_GROUP_BY_or_ORDER_BY_clause\"><\/span>score function can ONLY in SELECT, GROUP BY or ORDER BY clause<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>SCORE \u51fd\u6570\u53ea\u80fd\u7528\u4e8e\u6295\u5f71\u5217\u3001GROUP BY \u548c ORDER BY \u5b50\u53e5\u4e2d<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; SELECT * FROM t WHERE contains(a ,'\u4e2d\u56fd',0) AND score(0) &gt;10;\nERROR 1149 (42000): score function can ONLY in SELECT, GROUP BY or ORDER BY clause<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"not_match_the_number_of_score_func\"><\/span>not match the number of score func<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u679c\u6ca1\u6709\u4e0e\u5176 SCORE \u6807\u53f7\u4e00\u81f4\u7684\u5168\u6587\u67e5\u8be2\u51fd\u6570 CONTAINS<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; SELECT score(1) a1 FROM t WHERE contains(a ,'\u4e2d\u56fd',0);\nERROR 1149 (42000): not match the number of score func<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cant_DO_Merge_when_not_able_to_build_hash\"><\/span>Can&#8217;t DO Merge when not able to build hash<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Merge\u529f\u80fd\u53ea\u9002\u5408Hash\u5206\u5e03\u8868\uff0c\u4e14join\u6761\u4ef6\u5fc5\u987b\u5305\u542bhash\u5206\u5e03\u5217<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; merge into t1 using t2 on t1.id=t2.id when matched then update set t1.name=t2.name,t1.birth=t2.birth when not matched then insert(id,name,birth)values(t2.id,t2.name,t2.birth);\nERROR 1149 (42000): (GBA-02SC-1001) Can't DO Merge when not able to build hash (redistribution) JOIN relationship between merge target and source.<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"GBA-02SC-1001_The_query_includes_syntax_that_is_not_supported_by_the_gcluster\"><\/span>(GBA-02SC-1001) The query includes syntax that is not supported by the gcluster<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>SQL\u9884\u8ba1\u5305\u542b\u4e86\u9ed8\u8ba4\u4e0d\u652f\u6301\u7684\u8bed\u6cd5\u3002\u6bd4\u5982<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select udfKQIScore('123');\nERROR 1149 (42000): (GBA-02SC-1001) The query includes syntax that is not supported by the gcluster.\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1191_HY000\"><\/span>ERROR 1191 (HY000)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cant_find_FULLTEXT_index_matching_the_column_list\"><\/span>Can&#8217;t find FULLTEXT index matching the column list<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u5220\u9664\u5168\u6587\u7d22\u5f15\u4e4b\u540e\uff0c\u7d22\u5f15\u5185\u5bb9\u4e5f\u4f1a\u5220\u9664\uff0c\u5219\u4e0d\u80fd\u7ee7\u7eed\u4f7f\u7528\u5168\u6587\u7d22\u5f15\u529f\u80fd\u67e5\u8be2\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; SELECT COUNT(*) FROM sms WHERE contains(MB_Text,'\"\u5929\u6d25\" | \"\u57f9\u8bad\u73ed\" - \"\u6c34\u4e0a\"');\nERROR 1191 (HY000): Can't find FULLTEXT index matching the column list<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1210_HY000\"><\/span>ERROR 1210 (HY000)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Incorrect arguments to CONTAINS FUNCTION - SCORE FLAG COLLISION<\/h3>\n\n\n\n<p>\u591a\u4e2a CONTAINS \u51fd\u6570\u7684 SCORE \u6807\u53f7\u5747\u4e0e\u5176\u4e00\u81f4\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; SELECT score(0) FROM t WHERE contains(b, 'abc' , 0) AND contains(b, 'bcb' , 0);\nERROR 1210 (HY000): Incorrect arguments to CONTAINS FUNCTION - SCORE FLAG COLLISION<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1235_42000\"><\/span>ERROR 1235 (42000)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>This version of GBase doesn't yet support\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"use_dblink_table_in_a_FUNCTIONTRIGGERVIEW\"><\/span>use dblink table in a FUNCTION\/TRIGGER\/VIEW<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u5f53\u524d\u7248\u672c\u4e0d\u652f\u6301\u5728\u51fd\u6570\uff0c\u89c6\u56fe\u91cc\u4f7f\u7528dblink\u7684\u8868\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>create view v1 as select * from t1@testlink;\nERROR 1235 (42000): This version of GBase doesn't yet support 'use dblink table in a\n FUNCTION\/TRIGGER\/VIEW.'<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"updatemerge_on_auto_increment_column\"><\/span>update\/merge on auto_increment column<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>UPDATE \u65f6\uff0c\u4e0d\u80fd\u66f4\u65b0\u81ea\u589e\u5217\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; update t2 set a = 441 where b = 'a2';\nERROR 1235 (42000): This version of GBase doesn't yet support 'update\/merge on auto_increment column'<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1256\"><\/span>ERROR 1256<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Table_has_no_partition_for_value\"><\/span>Table has no partition for value<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u5411\u5206\u533a\u8868\u63d2\u5165\u7684\u6570\u636e\uff0c\u6ca1\u6709\u7b26\u5408\u7684\u5206\u533a\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1264_22003\"><\/span>ERROR 1264 (22003)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Out_of_range_value_for_column\"><\/span>Out of range value for column<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u5217\u7684\u503c\u8d85\u8fc7\u8303\u56f4\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; INSERT INTO products(productnum) VALUES(191220.443);\nERROR 1264 (22003): Out of range value for column 'productnum' at row 1<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1292_22007\"><\/span>ERROR 1292 (22007)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Incorrect_date_value_for_column\"><\/span>Incorrect date value for column<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u6307\u5b9a\u5217\u4e0d\u6b63\u786e\u7684date\u65e5\u671f\u6570\u503c\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; CREATE TABLE products (productDate DATE);\nQuery OK, 0 rows affected\ngbase&gt; INSERT INTO products(productDate) VALUES('2010-09-31');\nERROR 1292 (22007): Incorrect date value: '2010-09-31' for column\n 'productDate' at row 1<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Incorrect_time_value_for_column\"><\/span>Incorrect time value for column<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u6307\u5b9a\u5217\u7684time\u65f6\u95f4\u6570\u636e\u4e0d\u6b63\u786e<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ERROR 1292 (22007): Incorrect time value: '14:08:89' for column 'producttime' at row 1<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Incorrect_datetime_value_for_column\"><\/span>Incorrect datetime value for column<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u6307\u5b9adatetime\u5b57\u6bb5\u7684\u6570\u636e\u4e0d\u6b63\u786e\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; INSERT INTO products(productDate) VALUES('2010-09-31 12:09:44');\nERROR 1292 (22007): Incorrect datetime value: '2010-09-31 12:09:44' for column 'productDate' at row 1<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1305_42000\"><\/span>ERROR 1305 (42000)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"FUNCTION_does_not_exist\"><\/span>FUNCTION does not exist<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u51fd\u6570\u4e0d\u5b58\u5728<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select abc();\nERROR 1305 (42000): FUNCTION testdb.abc does not exist<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1317_70100\"><\/span>ERROR 1317 (70100)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Query_execution_was_interrupted\"><\/span>Query execution was interrupted<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u67e5\u8be2\u5728\u5916\u90e8\u88ab\u4e2d\u65ad\uff0c\u5305\u62ec\u7528\u6237\u81ea\u884cCtrl+C\u6216\u8005\u53d1\u8d77\u8282\u70b9\u4e3b\u52a8\u5f3a\u884c\u5173\u95ed\uff0c\u6bd4\u5982\u52a0\u8f7d\u8d85\u8fc7\u4e86\u5141\u8bb8\u7684\u9519\u8bef\u884c\u6570\uff0c\u4e0d\u518d\u7ee7\u7eed\u52a0\u8f7d\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select * from lineitem@tpch_link l, orders@tpch_link o ;\nERROR 1317 (70100): Query execution was interrupted<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1702_HY000_gcluster_table_error\"><\/span>ERROR 1702 (HY000): gcluster table error<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"GBA-02DD-0017\"><\/span>GBA-02DD-0017<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u8868\u4e0d\u5b58\u5728\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; drop table table_not_exists;\nERROR 1702 (HY000): gcluster table error: (GBA-02DD-0017) Unknown table 'testdb.table_not_exists'<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ALTER_column_definition_except_increasing_length_of_varchar\"><\/span>ALTER column definition except increasing length of varchar&#8217;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u4e0d\u652f\u6301\u4fee\u6539\u5b57\u6bb5\u5b9a\u4e49\uff0c\u9664\u4e86\u589e\u52a0varchar\u7684\u957f\u5ea6\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ERROR 1702 (HY000): gcluster table error: This version of GBase doesn't yet support 'ALTER column definition except increasing length of varchar'.<\/code><\/pre>\n\n\n\n<p>\u8be6\u60c5\u4ecb\u7ecd\u770b\u8fd9\u4e2a\u6587\u7ae0\uff1a<a href=\"https:\/\/www.gbase8.cn\/en\/5147\/\">GBase 8a\u62a5\u9519<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1708_HY000_Failed_to_query_in_gnode\"><\/span>ERROR 1708 (HY000): Failed to query in gnode<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"GBA-01EX-0006\"><\/span>GBA-01EX-0006<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u7ed3\u679c\u96c6\u884c\u6570\u592a\u591a\u4e86\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code> (GBA-01EX-0006) Express out of resources error:Too many tuples.<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"GBA-01EX-700\"><\/span>GBA-01EX-700<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>SQL\u8bed\u6cd5\u5f53\u524d\u7248\u672c\u7684\u5f15\u64ce\u4e0d\u652f\u6301\u3002\u53ef\u4ee5\u53c2\u8003 <a href=\"https:\/\/www.gbase8.cn\/en\/534\/\">GBase 8a\u96c6\u7fa4\u67e5\u8be2\u62a5\u9519The query includes syntax that is not supported by the Express engine<\/a><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ERROR 1708 (HY000): &#91;192.168.3.26:5050](GBA-02EX-0005) Failed to query\nin gnode:\nDETAIL: Query failed.\nCAUSE:(GBA-01EX-700) The query includes syntax that is not supported by the Express engine. Either restructure the query with supported syntax, or enable the GBase Query Path in the configuration file to execute the query with reduced performance.<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"GBA-02AD-0005\"><\/span>GBA-02AD-0005<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"incorrect_parameter_in_function_to_date\"><\/span>incorrect parameter in function to_date<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>to_date\u51fd\u6570\u7684\u53c2\u6570\u683c\u5f0f\u4e0e\u6570\u636e\u4e0d\u5339\u914d\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; SELECT TO_DATE('2020-4-14 13:00:00','YYYY-MM-DD HH:MI:SS') FROM dual;\nERROR 1708 (HY000): &#91;172.168.83.12:5050](GBA-02AD-0005)Failed to query in gnode:\nDETAIL: incorrect parameter in function to_date.\nSQL: SELECT <\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1712_HY000_gcluster_view_error\"><\/span>ERROR 1712 (HY000): gcluster view error<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u89c6\u56fe\u4e0d\u5b58\u5728\u3002\u62a5\u9519\u4fe1\u606f\u91cc\u663e\u793a\u7684\u8fd8\u662f\u6709table\u5b57\u6837\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; drop view aaaaa;\nERROR 1712 (HY000): gcluster view error: Unknown table 'aaaaa'.<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1722_HY000\"><\/span>ERROR 1722 (HY000)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"GBA-02DD-0006\"><\/span>GBA-02DD-0006<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cant_update_distributed_column\"><\/span>Can&#8217;t update distributed column<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u4e0d\u80fd\u66f4\u65b0Hash\u5206\u5e03\u5217\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; UPDATE student SET stu_no = 4 WHERE stu_no = 2;\nERROR 1722 (HY000): (GBA-02DD-0006) Can't update distributed column 'stu_no'<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1729_HY000\"><\/span>ERROR 1729 (HY000)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"set_table_extend_failed_must_be_between_1M_and_2G\"><\/span>set table extend failed: must be between 1M and 2G<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u6307\u5b9a\u9884\u79df\u78c1\u76d8\u7a7a\u95f4\u5927\u5c0f\u8d85\u51fa\u652f\u6301\u8303\u56f4\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; CREATE TABLE t1(a int) AUTOEXTEND ON NEXT 3G;\nERROR 1729 (HY000): set table extend failed: must be between 1M and 2G<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1733_HY000\"><\/span>ERROR 1733 (HY000)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"GBA-01-600\"><\/span>GBA-01-600<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Too_many_bad_records\"><\/span>Too many bad records<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u9519\u8bef\u8bb0\u5f55\u884c\u6570\u8d85\u8fc7\u53c2\u6570\u5141\u8bb8\u503c\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; LOAD DATA INFILE 'http:\/\/192.168.153.32\/1.txt' INTO TABLE test_2 FIELDS TERMINATED BY '|' MAX_BAD_RECORDS 1;\nERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: Task 268 failed, &#91;192.168.153.32:5050](GBA-02AD-0005)Failed to query in gnode:\nDETAIL: (GBA-01-600) Gbase internal error: Task 268, Too many bad records!SQL: LOAD \/*+ TID('11471') *\/ DATA INFILE <\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"GBA-01EX-700-2\"><\/span>GBA-01EX-700<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%8F%82%E6%95%B0%E8%B6%85%E8%BF%87%E4%BA%86%E5%85%81%E8%AE%B8%E8%8C%83%E5%9B%B4\"><\/span>\u53c2\u6570\u8d85\u8fc7\u4e86\u5141\u8bb8\u8303\u56f4<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; SELECT *, nth_value(totalamount, NULL) over (partition by uname\norder by dt) as nth_value from tt;\nERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: argument&#91;2]\nof nth_value is out of range<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E9%80%9A%E9%85%8D%E7%AC%A6%E5%8C%B9%E9%85%8D%E5%8A%A0%E8%BD%BD%E5%A4%B1%E8%B4%A5\"><\/span>\u901a\u914d\u7b26\u5339\u914d\u52a0\u8f7d\u5931\u8d25<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt;LOAD DATA INFILE 'http:\/\/192.168.153.32\/*.txt' INTO TABLE\ntest_3 FIELDS TERMINATED BY '|' SKIP_BAD_FILE 0;\nERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: Expanding\nwildcard operation failed with error - I\/O operation on\nhttp:\/\/192.168.153.32\/2.txt failed with error - Access denied to\nremote resource, HTTP\/1.1 403 Forbidden, File name\nhttp:\/\/192.168.153.32\/2.txt uri : http:\/\/192.168.153.32\/%2a.txt<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Empty_or_invalid_index_path\"><\/span>Empty or invalid index path<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u6307\u5b9a\u7684\u7d22\u5f15\u6570\u636e\u8def\u5f84\u4e0d\u5b58\u5728\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; CREATE TABLE text1 (col1 varchar(100), FULLTEXT INDEX fti_col1(col1) INDEX_DATA_PATH='\/index\/dat\/');\nERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: Empty or invalid index path<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"The_disk_space_of_User_has_exceeded_the_limit_value\"><\/span>The disk space of User has exceeded the limit value<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u7528\u6237\u6b21\u78c1\u76d8\u4f7f\u7528\u8d85\u8fc7\u4e86\u9650\u989d\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; load data infile 'file:\/\/192.168.146.20\/opt\/ssbm\/part.tbl' into table part data_format 3 FIELDS TERMINATED BY '|';\nERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: Task 262152 failed, &#91;192.168.146.20:5050](GBA-02AD-0005)Failed to query in gnode:\nDETAIL: (GBA-01EX-700) Gbase general error: (gns_host: ::ffff:192.168.146.21) The disk space of User 'u' has exceeded the limit value.(Usage: 4437691, Limit: 1048576)\nSQL: LOAD \/*+<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">auto-increment column should not be specified in insert(...)<\/h4>\n\n\n\n<p>\u81ea\u589e\u5217\u4e0d\u5141\u8bb8insert\uff0c\u53c2\u8003 <a href=\"https:\/\/www.gbase8.cn\/en\/10012\/\">GBase 8a\u81ea\u589e\u5217\u4e0d\u5141\u8bb8insert\u62a5\u9519auto_increment column should not be specified in insert<\/a><\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase> insert into t_inc values(1,'First');\r\nERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: auto-increment column should not be specified in insert(...)<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"auto-increment_column_should_not_be_specified_in_insert_select\"><\/span>auto-increment column should not be specified in insert select<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u81ea\u589e\u5217\u4e0d\u5141\u8bb8insert select\u3002\u53c2\u8003 <a href=\"https:\/\/www.gbase8.cn\/en\/10012\/\">GBase 8a\u81ea\u589e\u5217\u4e0d\u5141\u8bb8insert\u62a5\u9519auto_increment column should not be specified in insert<\/a><\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase> insert into t_inc select * from t_inc;\r\nERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: auto-increment column should not be specified in insert select<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1739_HY000\"><\/span>ERROR 1739 (HY000)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"GBA-01EX-0006-2\"><\/span>GBA-01EX-0006<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>OR\u64cd\u4f5c\u7b26\u8d85\u8fc7\u4e86\u5141\u8bb8\u7684\u6700\u5927\u6df1\u5ea6\uff1a10.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ERROR 1739 (HY000): (GBA-01EX-0006) Express out of resources error:OR operation recursion depth overrun. Max depth: 10\u201d<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1758_HY000\"><\/span>ERROR 1758 (HY000)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Operation_CREATE_USER_failed_for\"><\/span>Operation CREATE USER failed for<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u521b\u5efa\u7528\u6237\u62a5\u9519\uff0c\u53ef\u80fd\u662f\u7528\u6237\u5df2\u7ecf\u5b58\u5728\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; create user abc identified by 'abc';\nERROR 1758 (HY000): gcluster dal error: Operation CREATE USER failed for 'abc'@'%'.<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Operation_DROP_USER_failed_for\"><\/span>Operation DROP USER failed for<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u5220\u9664\u7528\u6237\u62a5\u9519\uff0c\u53ef\u80fd\u662f\u7528\u6237\u4e0d\u5b58\u5728\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; drop user abc;\nERROR 1758 (HY000): gcluster dal error: Operation DROP USER failed for 'abc'@'%'.<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Password_is_in_history_for_user\"><\/span>Password is in history for user<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u5bc6\u7801\u91cd\u7528\u7b56\u7565\u4e0d\u5141\u8bb8\u6700\u8fd1\u51e0\u6b21\u7528\u8fc7\u7684\u5bc6\u7801\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; set password=password('111111');\nERROR 1758 (HY000): gcluster dal error: 10.0.2.101:Password is in history for user 'root'@'%'..<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1802_HY000\"><\/span>ERROR 1802 (HY000)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Invalid_password_format\"><\/span>Invalid password format <span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u5bc6\u7801\u683c\u5f0f\u4e0d\u5408\u6cd5\uff0c\u5305\u62ec\u683c\u5f0f\uff0c\u5927\u5c0f\u5199\u5b57\u6bcd\uff0c\u6570\u5b57\u7b49\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; create encryption certificate identified by 'ddd~';\nERROR 1802 (HY000): Invalid password format,length should &gt;= 4 and contain\n'number'.<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1818_HY000\"><\/span>ERROR 1818 (HY000)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"No_VC_selected\"><\/span>No VC selected<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>gccli \u7b49\u5ba2\u6237\u7aef\u8fde\u63a5\u65f6\uff0c\u6ca1\u6709\u6307\u5b9avc\u3002\u5728\u5f00\u542f\u4e86\u865a\u62df\u96c6\u7fa4\u65f6\uff0c\u6307\u5b9a\u6570\u636e\u5e93\u5fc5\u987b\u6307\u5b9avc\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;gbase@gbase_rh7_001 gcinstall]$ gccli testdb\nERROR 1818 (HY000): No VC selected.<\/code><\/pre>\n\n\n\n<p>\u89e3\u51b3\u65b9\u6848\u5c31\u662f\u6307\u5b9a\u5e26vc\u7684\u5e93\u540d\uff0c\u6216\u8005\u4e0d\u6307\u5b9a\u5e93<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;gbase@gbase_rh7_001 gcinstall]$ gccli\n\nGBase client 9.5.2.26.121440. Copyright (c) 2004-2021, GBase.  All Rights Reserved.\n\ngbase&gt; ^CAborted\n&#91;gbase@gbase_rh7_001 gcinstall]$ gccli vc01.testdb\n\nGBase client 9.5.2.26.121440. Copyright (c) 2004-2021, GBase.  All Rights Reserved.\n\ngbase&gt;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1829\"><\/span>ERROR 1829<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"encryption_certificate_already_open\"><\/span>encryption certificate already open<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u91cd\u590d\u6253\u5f00\u8bc1\u4e66<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-----------\u6253\u5f00\u5bc6\u94a5\u8bc1\u4e66\u793a\u4f8b\ngbase&gt; alter encryption certificate open identified by '1111';\nQuery OK, 0 rows affected (Elapsed: 00:00:04.76)\n------------\u91cd\u590d open\ngbase&gt; alter encryption certificate open identified by '1111';\nERROR 1829 (HY000): encryption certificate already open.<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"encryption_certificate_not_exists\"><\/span>encryption certificate not exists<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u8bc1\u4e66\u4e0d\u5b58\u5728<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-----------\u8bc1\u4e66\u4e0d\u5b58\u5728\ngbase&gt; alter encryption certificate open identified by '1111';\nERROR 1829 (HY000): encryption certificate not exists.<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"decrypt_failed_please_check_password\"><\/span>decrypt failed, please check password<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u89e3\u5bc6\u5931\u8d25<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-----------\u89e3\u5bc6\u5931\u8d25\ngbase&gt; alter encryption certificate open identified by '2222';\nERROR 1829 (HY000): decrypt failed, please check password.<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1830_HY000\"><\/span>ERROR 1830 (HY000)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"You_must_reset_your_password_using_ALTER_USER_statement_before_executing_this_statement\"><\/span>You must reset your password using ALTER USER statement before executing this statement<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u5bc6\u7801\u8fc7\u671f\u4e86\uff0c\u5fc5\u987b\u5148\u4fee\u6539\u5bc6\u7801\u7136\u540e\u624d\u80fd\u6267\u884c\u5176\u5b83SQL\u3002  <\/p>\n\n\n\n<p>Reference: <a href=\"https:\/\/www.gbase8.cn\/en\/471\/\">https:\/\/www.gbase8.cn\/471<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1835_HY000\"><\/span>ERROR 1835 (HY000)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"encryption_certificate_already_exists\"><\/span>encryption certificate already exists<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u8bc1\u4e66\u91cd\u590d\u521b\u5efa<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-----------\u521b\u5efa\u660e\u6587\u5bc6\u94a5\u8bc1\u4e66\u793a\u4f8b\ngbase&gt; create encryption certificate identified by '';\nQuery OK, 0 rows affected (Elapsed: 00:00:00.00)\n-----------\u8bc1\u4e66\u91cd\u590d\u521b\u5efa\ngbase&gt; create encryption certificate identified by '';\nERROR 1835 (HY000): encryption certificate already exists.<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_1838_HY000\"><\/span>ERROR 1838 (HY000)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Encrypt_key_invalid\"><\/span>Encrypt key invalid<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u52a0\u5bc6\u7684\u5bc6\u94a5\u5f53\u524d\u4e0d\u53ef\u7528\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-----------\u5173\u95ed\u5bc6\u94a5\u8bc1\u4e66\ngbase&gt; alter encryption certificate close;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.00)\ngbase&gt; insert into t1 values(4);\nERROR 1838 (HY000): Encrypt key invalid.\ngbase&gt; select * from t1;\nERROR 1838 (HY000): Decrypt key invalid.<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Decrypt_key_invalid\"><\/span>Decrypt key invalid<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u89e3\u5bc6\u7684\u5bc6\u94a5\u4e0d\u53ef\u7528\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-----------\u5173\u95ed\u5bc6\u94a5\u8bc1\u4e66\ngbase&gt; alter encryption certificate close;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.00)\ngbase&gt; select * from t1;\nERROR 1838 (HY000): Decrypt key invalid.<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERROR_2003\"><\/span>ERROR 2003<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Can't&nbsp;connect&nbsp;to&nbsp;GBase&nbsp;server&nbsp;on IP (113)<\/h3>\n\n\n\n<p>\u76ee\u6807\u670d\u52a1\u65e0\u6cd5\u8fde\u63a5\uff0c\u4e00\u822c\u662f\u670d\u52a1\u6ca1\u6709\u542f\u52a8\uff0cIP\u65e0\u6cd5\u8fde\u63a5(\u6bd4\u5982\u9632\u706b\u5899\u5f00\u4e86)\u7b49\u3002<\/p>","protected":false},"excerpt":{"rendered":"<p>\u672c\u6587\u5217\u4e3eGBase 8a\u6570\u636e\u5e93\u96c6\u7fa4\uff0c\u80fd\u9a8c\u8bc1\u7684\uff0c\u9047\u5230\u8fc7\u7684\u62a5\u9519\u7801\u6216\u9519\u8bef\u7801\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54],"tags":[],"class_list":["post-2876","post","type-post","status-publish","format-standard","hentry","category-gbase8a"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/2876","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=2876"}],"version-history":[{"count":107,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/2876\/revisions"}],"predecessor-version":[{"id":10032,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/2876\/revisions\/10032"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=2876"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=2876"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=2876"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}