1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
|
# Name: 17650_index_duplication
# Target: windows
##
MyConnect({"user":"root","host":"localhost"})
MyQuery("DROP TABLE IF EXISTS `test`.`test_17650`")
MyQuery("CREATE TABLE `test`.`test_17650` (id INT)")
#ClickObject(PATH("ConnectToInstanceForm.ConnectToHostPnl"), offset=(105, 5))
#Delay(1)
#Key(Return)
#Delay(2)
ClickObject(PATH("MainForm.SidebarPnl.AdminTreeView"), offset=(40, 255))
Delay(2)
ClickObject(PATH("MainForm.SidebarPnl.SubTreePnl.CatalogSubTreePnl.SchemataFrame.CatalogVST"), offset=(28, 48))
Delay(2)
ClickObject(PATH("MainForm.DockPnl.CatalogPnl.CatalogPageControl.SchemaSheet.SchemaPageControl"), offset=(66, 11))
Delay(2)
ClickObject(PATH("MainForm.DockPnl.CatalogPnl.CatalogPageControl.SchemaSheet.SchemaPageControl.TablesTabSheet.Panel3.RefreshBtn"), button=1, offset=(24, 11))
Delay(2)
ClickObject(PATH("MainForm.DockPnl.CatalogPnl.CatalogPageControl.SchemaSheet.SchemaPageControl.TablesTabSheet.TablesVST"), offset=(52, 33))
Delay(2)
ClickObject(PATH("MainForm.DockPnl.CatalogPnl.CatalogPageControl.SchemaSheet.SchemaPageControl.TablesTabSheet.Panel3.EditTableBtn"), offset=(11, 10))
Delay(1)
ClickObject(PATH("EditorTableForm.TableEditorPnl.GirdOptionPnl.MainPageControl.ColumnTabSheet.ColumnVST"), offset=(67, 32))
Delay(1)
ClickObject(PATH("EditorTableForm.TableEditorPnl.GirdOptionPnl.MainPageControl.ColumnTabSheet.ColumnsPageControl"), button=1, offset=(27, 11))
Delay(1)
ClickObject(PATH("EditorTableForm.TableEditorPnl.GirdOptionPnl.MainPageControl.ColumnTabSheet.ColumnsPageControl.TntTabSheet2.AddIndexBtn"), offset=(6, 8))
Delay(1)
Key(Return)
Delay(1)
ClickObject(PATH("EditorTableForm.TableEditorPnl.GirdOptionPnl.MainPageControl.ColumnTabSheet.ColumnsPageControl.TntTabSheet2.TntGroupBox1.AddIndexColumnBtn"), offset=(8, 10))
Delay(1)
ClickObject(PATH("EditorTableForm.TableEditorPnl.BottomPnl.ApplyChangesBtn"), offset=(67, 12))
Delay(1)
Key(Return)
Delay(2)
ClickObject(PATH("EditorTableForm.TableEditorPnl.GirdOptionPnl.MainPageControl.ColumnTabSheet.ColumnVST"), offset=(60, 28))
Delay(1)
ClickObject(PATH("EditorTableForm.TableEditorPnl.GirdOptionPnl.MainPageControl.ColumnTabSheet.ColumnsPageControl.TntTabSheet2.AddIndexBtn"), offset=(11, 9))
Delay(1)
Key(Return)
Delay(1)
ClickObject(PATH("EditorTableForm.TableEditorPnl.GirdOptionPnl.MainPageControl.ColumnTabSheet.ColumnsPageControl.TntTabSheet2.TntGroupBox1.AddIndexColumnBtn"), offset=(5, 8))
Delay(1)
ClickObject(PATH("EditorTableForm.TableEditorPnl.BottomPnl.ApplyChangesBtn"), offset=(67, 12))
Delay(1)
Key(Return)
Delay(2)
CheckDBQuery("select count(*) from information_schema.statistics where table_schema='test' and table_name='test_17650' and index_name='Index_1'", [[1]])
CheckDBQuery("select count(*) from information_schema.statistics where table_schema='test' and table_name='test_17650' and index_name='Index_2'", [[1]])
MyQuery("DROP TABLE `test`.`test_17650`")
|
