File: test12.py

package info (click to toggle)
mysql-gui-tools 5.0r12-1
  • links: PTS
  • area: main
  • in suites: lenny
  • size: 105,540 kB
  • ctags: 50,897
  • sloc: sql: 348,439; pascal: 285,780; cpp: 94,578; ansic: 90,768; objc: 33,761; sh: 25,629; xml: 10,924; yacc: 10,755; java: 9,986; php: 2,806; python: 2,068; makefile: 1,945; perl: 3
file content (36 lines) | stat: -rw-r--r-- 1,652 bytes parent folder | download | duplicates (3)
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
# Name: 16990_wrong_collation
# Target: windows
##

MyConnect({"user":"root","host":"localhost"})

MyQuery("DROP TABLE IF EXISTS `test`.`test_16990`")
MyQuery("CREATE TABLE `test`.`test_16990` (`id` INTEGER PRIMARY KEY, `c` VARCHAR(45) CHARACTER SET cp1251 COLLATE cp1251_ukrainian_ci NOT NULL) ENGINE=MyISAM")

#Delay(2)
#ClickObject(PATH("ConnectToInstanceForm.ConnectToHostPnl"), offset=(53, 83))
#Delay(2)
#Key(Return)
#Delay(2)

ClickObject(PATH("MainForm.SidebarPnl.AdminTreeView"), offset=(60, 249))
Delay(2)
ClickObject(PATH("MainForm.SidebarPnl.SubTreePnl.CatalogSubTreePnl.SchemataFrame.CatalogVST"), offset=(36, 47))
Delay(2)
ClickObject(PATH("MainForm.DockPnl.CatalogPnl.CatalogPageControl.SchemaSheet.SchemaPageControl.TablesTabSheet.TablesVST"), offset=(181, 24))
Delay(2)
ClickObject(PATH("MainForm.DockPnl.CatalogPnl.CatalogPageControl.SchemaSheet.SchemaPageControl.TablesTabSheet.Panel3.EditTableBtn"), offset=(48, 10))
Delay(2)
ClickObject(PATH("EditorTableForm.TableEditorPnl.GirdOptionPnl.MainPageControl.ColumnTabSheet.ColumnVST"), offset=(31, 52))
Delay(2)
ClickObject(PATH("EditorTableForm.TableEditorPnl.GirdOptionPnl.MainPageControl.ColumnTabSheet.ColumnsPageControl"), offset=(171, 13))
Delay(2)
ClickObject(PATH("EditorTableForm.TableEditorPnl.BottomPnl.CloseBtn"), button=1, offset=(37, 8))
Delay(2)

p = GetSnoop().widgetProperties(PATH("EditorTableForm.TableEditorPnl.GirdOptionPnl.MainPageControl.ColumnTabSheet.ColumnsPageControl.TntTabSheet1.ColumnCollateCBox"))

MyQuery("DROP TABLE IF EXISTS `test`.`test_16990`")

if p["Text"] != "cp1251_ukrainian_ci":
  Abort("invalid collation")