test(oceanbase): cover Oracle sequence metadata fallbacks

frontend/src/components/MonacoEditor.tsx

@@ -126,10 +126,11 @@ const installOceanBaseOracleNavigationFallback = (editor: any) => {
     }
 
     const parts = splitSqlIdentifierPath(identifier.text);
-    if (parts.length !== 2) {
+    if (parts.length < 2) {
       return;
     }
-    const [schemaName, tableName] = parts;
+    const schemaName = parts[parts.length - 2];
+    const tableName = parts[parts.length - 1];
     if (!schemaName || !tableName) {
       return;
     }

frontend/src/components/QueryEditorToolbar.i18n.test.ts

@@ -14,6 +14,7 @@ const legacyLiterals = [
   '选择连接',
   '选择数据库',
   '最大返回行数',
+  '最大行数：100',
   '最大行数：500',
   '最大行数：1000',
   '最大行数：5000',
@@ -64,6 +65,7 @@ describe('QueryEditorToolbar i18n', () => {
     expect(source).toContain("import { useOptionalI18n } from '../i18n/provider';");
     expect(source).toContain('const i18n = useOptionalI18n();');
     expect(source).toContain('const t = i18n?.t ?? defaultTranslate;');
+    expect(source).toContain("{ label: '100', value: 100 }");
 
     for (const key of requiredKeys) {
       expect(source).toContain(key);

frontend/src/components/QueryEditorToolbar.tsx

@@ -291,6 +291,7 @@ const QueryEditorToolbar: React.FC<QueryEditorToolbarProps> = ({
           value={maxRows}
           onChange={(val) => onMaxRowsChange(Number(val))}
           options={[
+            { label: '100', value: 100 },
             { label: t("query_editor.max_rows.option_500"), value: 500 },
             { label: t("query_editor.max_rows.option_1000"), value: 1000 },
             { label: t("query_editor.max_rows.option_5000"), value: 5000 },

internal/app/methods_db_objects.go

@@ -417,9 +417,16 @@ func buildObjectSequenceMetadataQueries(dbType string, dbName string) []objectMe
 	switch dbType {
 	case "oracle", "dameng":
 		if strings.TrimSpace(dbName) == "" {
-			return []objectMetadataQuerySpec{{sql: "SELECT SEQUENCE_NAME AS sequence_name FROM USER_SEQUENCES ORDER BY SEQUENCE_NAME"}}
+			return []objectMetadataQuerySpec{
+				{sql: "SELECT * FROM USER_SEQUENCES ORDER BY SEQUENCE_NAME"},
+				{sql: "SELECT OBJECT_NAME AS sequence_name FROM USER_OBJECTS WHERE OBJECT_TYPE = 'SEQUENCE' ORDER BY OBJECT_NAME"},
+			}
+		}
+		owner := strings.ToUpper(safeDbName)
+		return []objectMetadataQuerySpec{
+			{sql: fmt.Sprintf("SELECT * FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER = '%s' ORDER BY SEQUENCE_NAME", owner)},
+			{sql: fmt.Sprintf("SELECT OWNER AS schema_name, OBJECT_NAME AS sequence_name FROM ALL_OBJECTS WHERE OWNER = '%s' AND OBJECT_TYPE = 'SEQUENCE' ORDER BY OBJECT_NAME", owner)},
 		}
-		return []objectMetadataQuerySpec{{sql: fmt.Sprintf("SELECT SEQUENCE_OWNER AS schema_name, SEQUENCE_NAME AS sequence_name FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER = '%s' ORDER BY SEQUENCE_NAME", strings.ToUpper(safeDbName))}}
 	default:
 		return nil
 	}

internal/app/methods_db_objects_sequence_test.go

@@ -0,0 +1,39 @@
+package app
+
+import (
+	"strings"
+	"testing"
+)
+
+func TestBuildObjectSequenceMetadataQueriesOracleUsesWildcardAndObjectFallback(t *testing.T) {
+	t.Parallel()
+
+	specs := buildObjectSequenceMetadataQueries("oracle", "sbdev")
+	if len(specs) != 2 {
+		t.Fatalf("expected 2 Oracle sequence metadata queries, got %d", len(specs))
+	}
+	if !strings.Contains(specs[0].sql, "SELECT * FROM ALL_SEQUENCES") {
+		t.Fatalf("expected ALL_SEQUENCES wildcard query, got %q", specs[0].sql)
+	}
+	if strings.Contains(specs[0].sql, "LAST_NUMBER") || strings.Contains(specs[0].sql, "ORDER_FLAG") {
+		t.Fatalf("query should not enumerate optional sequence columns: %q", specs[0].sql)
+	}
+	if !strings.Contains(specs[1].sql, "ALL_OBJECTS") || !strings.Contains(specs[1].sql, "OBJECT_TYPE = 'SEQUENCE'") {
+		t.Fatalf("expected ALL_OBJECTS fallback query, got %q", specs[1].sql)
+	}
+}
+
+func TestBuildObjectSequenceMetadataQueriesOracleUserFallbacks(t *testing.T) {
+	t.Parallel()
+
+	specs := buildObjectSequenceMetadataQueries("oracle", "")
+	if len(specs) != 2 {
+		t.Fatalf("expected 2 Oracle user sequence metadata queries, got %d", len(specs))
+	}
+	if specs[0].sql != "SELECT * FROM USER_SEQUENCES ORDER BY SEQUENCE_NAME" {
+		t.Fatalf("unexpected USER_SEQUENCES query: %q", specs[0].sql)
+	}
+	if !strings.Contains(specs[1].sql, "USER_OBJECTS") || !strings.Contains(specs[1].sql, "OBJECT_TYPE = 'SEQUENCE'") {
+		t.Fatalf("expected USER_OBJECTS fallback query, got %q", specs[1].sql)
+	}
+}