I had sent vtrace in last but one mail message ("The error occures only when
creating a query based on VIEW: ..............").
Well, once more....
R.V.
Zabach, Elke wrote:
R. Vajsar wrote:
Oh yes. I'm only looking for relationship between primary key, SYSKEY
and
error 4005 ("check if the table mentioned has a user-defined primary
key
(then SYSKEY will NOT exist) or not"). If a view hasn't index, then
SYSKEY
doesn't exist and error 4005 in this case is a feature?
The primary problem is error: Column not found,-4005 POS(32) Unknown
column name:SYSKEY
when I want to get data from view through ODBC into MS query. Base
table
of view has index.
I inspect the vtrace file, but I don't see anything useful:-(
R.V.
You mix things.
An index and the existence or not-existence of an index has NOTHING to
do with each other.
A view does not have a column syskey, even if select * from table_tab
and table_tab has no user-defined-key, meaning table_tab has a column
named syskey.
Why did you not send the vtrace to the list as I asked you to do if you
are not able to find the problem? With your explanation, mixing up
things and without the statements, noone will be able to explain what is
going on.
2181 183 185 187 189 191 193 195 197 199
dec: 32 32 32 32 32 32 32 32 2 0 0 0 0196129146248 0 0 0
hex: 20 20 20 20 20 20 20 20 02 00 00 00 00 C4 81 92 F8 00 00 00
chr:
ebc: D a k 8
2201 203 205 207
dec: 55 48 53 48 48 0 0 0
hex: 37 30 35 30 30 00 00 00
chr: 7 0 5 0 0
(129.2899 page 129)
PACKET: ascii, full_swap, 70500-DBM (1 segment, len: 88)
utility SEGMENT 1 (1 part, len: 88)
session_sqlmode, internal_cmd
with_info
command PART (1 argument, size: 36328)
partbuf BUFFER FROM 1 TO 26
pos: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
dec:100105 97103110111115101 32118116114 97 99101 32100101102 97
hex: 64 69 61 67 6E 6F 73 65 20 76 74 72 61 63 65 20 64 65 66 61
chr: d i a g n o s e v t r a c e d e f a
pos: 21 22 23 24 25 26
dec:117108116 32111110
hex: 75 6C 74 20 6F 6E
chr: u l t o n
ebc: % ? >
(129.3046 page 129)
PACKET: ascii, full_swap, 70500-DBM (1 segment, len: 40)
ok / RETURN SEGMENT 1 (0 parts, len: 40)
diagnose_fc, sqlstate: '00000'
(129.3181 page 129)
PACKET: ascii, full_swap, 70500-DBM (1 segment, len: 80)
dbs SEGMENT 1 (1 part, len: 80)
session_sqlmode, user_cmd
command PART (1 argument, size: 36328)
partbuf
pos: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
dec: 67 79 77 77 73 84 32 87 79 82 75 32 82 69 76 69 65 83 69
hex: 43 4F 4D 4D 49 54 20 57 4F 52 4B 20 52 45 4C 45 41 53 45
chr: C O M M I T W O R K R E L E A S E
>KB05 id4182 commit destroy_temp
>b01p_destroy Temp; fileTfnNo = 0; ttfnPars
session: nil; fid = 0
fn: 1A00 0000FFFFFFFF0600 000000000000
b01p_destroy root 89545; ok
>b01p_destroy Temp; fileTfnNo = 0; ttfnInto
session: nil; fid = 1
fn: 1A00 0000FFFFFFFF0800 000001000000
b01p_destroy root 104433; ok
[T4 ===== id4183 new TransNo] 129.3500 page 129
KB05 id4183 ok 0.000 sec
KB05 id4183 ok 0.000 sec
>KB05 id4183 release
KB05 id4183 ok 0.000 sec
KB05 id4183 ok 0.000 sec
(129.3604 page 129)
PACKET: ascii, full_swap, 70500-DBM (1 segment, len: 40)
ok / RETURN SEGMENT 1 (0 parts, len: 40)
commit_release, sqlstate: '00000'
===== T16 ===== id4181 ==============================129.3739 page 129
(129.3739 page 129)
PACKET: ascii, full_swap, 70500-ODB (1 segment, len: 128)
parse SEGMENT 1 (1 part, len: 128)
internal, user_cmd
commit_immediately
command PART (1 argument, size: 32232)
partbuf BUFFER FROM 1 TO 67
pos: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
dec: 83 69 76 69 67 84 32 75 95 80 95 86 89 86 79 74 46 73 68 44
hex: 53 45 4C 45 43 54 20 4B 5F 50 5F 56 59 56 4F 4A 2E 49 44 2C
chr: S E L E C T K _ P _ V Y V O J . I D ,
pos: 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
dec: 32 75 95 80 95 86 89 86 79 74 46 83 89 83 75 69 89 13 10 70
hex: 20 4B 5F 50 5F 56 59 56 4F 4A 2E 53 59 53 4B 45 59 0D 0A 46
chr: K _ P _ V Y V O J . S Y S K E Y F
pos: 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
dec: 82 79 77 32 65 80 84 46 75 95 80 95 86 89 86 79 74 32 75 95
hex: 52 4F 4D 20 41 50 54 2E 4B 5F 50 5F 56 59 56 4F 4A 20 4B 5F
chr: R O M A P T . K _ P _ V Y V O J K _
ebc: ( . ¬ ¬ . ¬
pos: 61 62 63 64 65 66 67
dec: 80 95 86 89 86 79 74
hex: 50 5F 56 59 56 4F 4A
chr: P _ V Y V O J
>b07cget key(138):
00000000 00000000 00B54B5F 505F5659 564F4A20 20202020 20202020
20202020 20202020 20202020 20202020 20202020 20202020 20202020
20202020
'..........K_P_VYVOJ '
b07cget root 215; *** key_not_found ***
>KB05 id4181/13568 get direct SYS1CAT key(12):
00000000 000008D3 00080001
>b02get key(12): 00000000 000008D3 00080001
b02get root 44664; ok
KB05 id4181/13568 return_result 0.000 sec
KB05 id4181/13568 return_result 0.000 sec
>b01t_create Temp; fileTfnNo = 0; ttfnComplexView
session: nil; fid = 1
fn: 1A00 0000FFFFFFFF0200 000001000000
b01t_create root 217; ok
>b07cadd key(8): 00000000 000008D3
b07cadd root 217; ok
>b07cadd key(4): 01000000
b07cadd root 217; ok
>b07cdel key(12): FF00002D 013C0020 00B20000
b07cdel root 215; *** key_not_found ***
>b07cdel key(12): FF00002D 013C0020 00C10000
b07cdel root 215; *** key_not_found ***
>KB05 id4181 destroy_temp prefix
>b01p_destroy Temp; fileTfnNo = 0; ttfnComplexView
session: nil; fid = 1
fn: 1A00 0000FFFFFFFF0200 000001000000
b01p_destroy root 217; ok
KB05 id4181 return_result 0.000 sec
KB05 id4181 return_result 0.000 sec
>b07cnext key(4): FF00002D
b07cnext root 215; *** no_next_record ***
>b07cget key(138):
00000000 00000000 00B54B5F 505F5659 564F4A20 20202020 20202020
20202020 20202020 20202020 20202020 20202020 20202020 20202020
20202020
'..........K_P_VYVOJ '
b07cget root 215; *** key_not_found ***
>KB05 id4181/13824 get direct SYS2CAT key(21):
FFFF0000 0000000E 00410001 4B5F505F 5659564F 4A
'.........A..K_P_VYVOJ'
>b02get key(21): FFFF0000 0000000E 00410001 4B5F505F 5659564F 4A
'.........A..K_P_VYVOJ'
b02get root 59552; ok
KB05 id4181/13824 return_result 0.000 sec
KB05 id4181/13824 return_result 0.000 sec
>KB05 id4181/13824 get direct SYS1CAT key(12):
00000000 000008D3 00010001
>b02get key(12): 00000000 000008D3 00010001
b02get root 44664; ok
KB05 id4181/13824 return_result 0.000 sec
KB05 id4181/13824 return_result 0.000 sec
>KB05 id4181/13824 get direct SYS1CAT key(20):
00000000 000008D3 00060001 FFFF0000 0000000E
>b02get key(20): 00000000 000008D3 00060001 FFFF0000 0000000E
b02get root 44664; ok
KB05 id4181/13824 return_result 0.000 sec
KB05 id4181/13824 return_result 0.000 sec
>KB05 id4181/13824 get direct SYS1CAT key(12):
00000000 000008D3 00080001
>b02get key(12): 00000000 000008D3 00080001
b02get root 44664; ok
KB05 id4181/13824 return_result 0.000 sec
KB05 id4181/13824 return_result 0.000 sec
>b01t_create Temp; fileTfnNo = 0; ttfnComplexView
session: nil; fid = 1
fn: 1A00 0000FFFFFFFF0200 000001000000
b01t_create root 15106; ok
>b07cadd key(8): 00000000 000008D3
b07cadd root 15106; ok
>b07cadd key(4): 01000000
b07cadd root 15106; ok
>b07cdel key(12): FF00002E 013C0020 00B20000
b07cdel root 215; *** key_not_found ***
>b07cdel key(12): FF00002E 013C0020 00C10000
b07cdel root 215; *** key_not_found ***
>KB05 id4181 destroy_temp prefix
>b01p_destroy Temp; fileTfnNo = 0; ttfnComplexView
session: nil; fid = 1
fn: 1A00 0000FFFFFFFF0200 000001000000
b01p_destroy root 15106; ok
KB05 id4181 return_result 0.000 sec
KB05 id4181 return_result 0.000 sec
>b07cnext key(4): FF00002E
b07cnext root 215; *** no_next_record ***
>b07cadd key(12): FF000029 013C0020 00810000
b07cadd root 215; ok
>b07cadd key(12): FF000029 013C0020 00C10000
b07cadd root 215; ok
>b07cadd key(13): FF000029 013C0020 00C10000 01
b07cadd root 215; ok
>b07cadd key(12): FF000029 013C0020 00B20000
b07cadd root 215; ok
>b07cadd key(12): FF000029 013C0020 00B10001
b07cadd root 215; ok
>b07cadd key(12): FF00002B 012A0020 00810000
b07cadd root 215; ok
>b07cadd key(12): FF00002C 01060020 00810000
b07cadd root 215; ok
>KB05 id4181 rollback
[T16 ===== id4184 new TransNo] 130.3943 page 130
KB05 id4184 ok 0.000 sec
KB05 id4184 ok 0.000 sec
(130.3979 page 130)
PACKET: ascii, full_swap, 70500-ODB (1 segment, len: 88)
*** -4005 / RETURN SEGMENT 1 (1 part, len: 88)
select_fc, errpos: 32, sqlstate: '42000'
errortext PART (1 argument, size: 36168)
partbuf BUFFER FROM 1 TO 26
pos: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
dec: 85110107110111119110 32 99111108117109110 32110 97109101 58
hex: 55 6E 6B 6E 6F 77 6E 20 63 6F 6C 75 6D 6E 20 6E 61 6D 65 3A
chr: U n k n o w n c o l u m n n a m e :
ebc: > , > ? > ? % _ > > _
pos: 21 22 23 24 25 26
dec: 83 89 83 75 69 89
hex: 53 59 53 4B 45 59
chr: S Y S K E Y
(130.4162 page 130)
PACKET: ascii, full_swap, 70500-ODB (1 segment, len: 128)
parse SEGMENT 1 (1 part, len: 128)
internal, user_cmd
commit_immediately
command PART (1 argument, size: 32232)
partbuf BUFFER FROM 1 TO 67
pos: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
dec: 83 69 76 69 67 84 32 75 95 80 95 86 89 86 79 74 46 73 68 44
hex: 53 45 4C 45 43 54 20 4B 5F 50 5F 56 59 56 4F 4A 2E 49 44 2C
chr: S E L E C T K _ P _ V Y V O J . I D ,
pos: 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
dec: 32 75 95 80 95 86 89 86 79 74 46 83 89 83 75 69 89 13 10 70
hex: 20 4B 5F 50 5F 56 59 56 4F 4A 2E 53 59 53 4B 45 59 0D 0A 46
chr: K _ P _ V Y V O J . S Y S K E Y F
pos: 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
dec: 82 79 77 32 65 80 84 46 75 95 80 95 86 89 86 79 74 32 75 95
hex: 52 4F 4D 20 41 50 54 2E 4B 5F 50 5F 56 59 56 4F 4A 20 4B 5F
chr: R O M A P T . K _ P _ V Y V O J K _
ebc: ( . ¬ ¬ . ¬
pos: 61 62 63 64 65 66 67
dec: 80 95 86 89 86 79 74
hex: 50 5F 56 59 56 4F 4A
chr: P _ V Y V O J
>b07cget key(138):
00000000 00000000 00B54B5F 505F5659 564F4A20 20202020 20202020
20202020 20202020 20202020 20202020 20202020 20202020 20202020
20202020
'..........K_P_VYVOJ '
b07cget root 215; *** key_not_found ***
>KB05 id4184/14080 get direct SYS2CAT key(21):
FFFF0000 0000000E 00410001 4B5F505F 5659564F 4A
'.........A..K_P_VYVOJ'
>b02get key(21): FFFF0000 0000000E 00410001 4B5F505F 5659564F 4A
'.........A..K_P_VYVOJ'
b02get root 59552; ok
KB05 id4184/14080 return_result 0.000 sec
KB05 id4184/14080 return_result 0.000 sec
>KB05 id4184/14080 get direct SYS1CAT key(12):
00000000 000008D3 00010001
>b02get key(12): 00000000 000008D3 00010001
b02get root 44664; ok
KB05 id4184/14080 return_result 0.000 sec
KB05 id4184/14080 return_result 0.000 sec
>KB05 id4184/14080 get direct SYS1CAT key(20):
00000000 000008D3 00060001 FFFF0000 0000000E
>b02get key(20): 00000000 000008D3 00060001 FFFF0000 0000000E
b02get root 44664; ok
KB05 id4184/14080 return_result 0.000 sec
KB05 id4184/14080 return_result 0.000 sec
>KB05 id4184/14080 get direct SYS1CAT key(12):
00000000 000008D3 00080001
>b02get key(12): 00000000 000008D3 00080001
b02get root 44664; ok
KB05 id4184/14080 return_result 0.000 sec
KB05 id4184/14080 return_result 0.000 sec
>b01t_create Temp; fileTfnNo = 0; ttfnComplexView
session: nil; fid = 1
fn: 1A00 0000FFFFFFFF0200 000001000000
b01t_create root 29994; ok
>b07cadd key(8): 00000000 000008D3
b07cadd root 29994; ok
>b07cadd key(4): 01000000
b07cadd root 29994; ok
>b07cdel key(12): FF00002F 013C0020 00B20000
b07cdel root 215; *** key_not_found ***
>b07cdel key(12): FF00002F 013C0020 00C10000
b07cdel root 215; *** key_not_found ***
>KB05 id4184 destroy_temp prefix
>b01p_destroy Temp; fileTfnNo = 0; ttfnComplexView
session: nil; fid = 1
fn: 1A00 0000FFFFFFFF0200 000001000000
b01p_destroy root 29994; ok
KB05 id4184 return_result 0.000 sec
KB05 id4184 return_result 0.000 sec
>b07cnext key(4): FF00002F
b07cnext root 215; *** no_next_record ***
>b07cget key(138):
00000000 00000000 00B54B5F 505F5659 564F4A20 20202020 20202020
20202020 20202020 20202020 20202020 20202020 20202020 20202020
20202020
'..........K_P_VYVOJ '
b07cget root 215; *** key_not_found ***
>KB05 id4184/14336 get direct SYS2CAT key(21):
FFFF0000 0000000E 00410001 4B5F505F 5659564F 4A
'.........A..K_P_VYVOJ'
>b02get key(21): FFFF0000 0000000E 00410001 4B5F505F 5659564F 4A
'.........A..K_P_VYVOJ'
b02get root 59552; ok
KB05 id4184/14336 return_result 0.000 sec
KB05 id4184/14336 return_result 0.000 sec
>KB05 id4184/14336 get direct SYS1CAT key(12):
00000000 000008D3 00010001
>b02get key(12): 00000000 000008D3 00010001
b02get root 44664; ok
KB05 id4184/14336 return_result 0.000 sec
KB05 id4184/14336 return_result 0.000 sec
>KB05 id4184/14336 get direct SYS1CAT key(20):
00000000 000008D3 00060001 FFFF0000 0000000E
>b02get key(20): 00000000 000008D3 00060001 FFFF0000 0000000E
b02get root 44664; ok
KB05 id4184/14336 return_result 0.000 sec
KB05 id4184/14336 return_result 0.000 sec
>KB05 id4184/14336 get direct SYS1CAT key(12):
00000000 000008D3 00080001
>b02get key(12): 00000000 000008D3 00080001
b02get root 44664; ok
KB05 id4184/14336 return_result 0.000 sec
KB05 id4184/14336 return_result 0.000 sec
>b01t_create Temp; fileTfnNo = 0; ttfnComplexView
session: nil; fid = 1
fn: 1A00 0000FFFFFFFF0200 000001000000
b01t_create root 44882; ok
>b07cadd key(8): 00000000 000008D3
b07cadd root 44882; ok
>b07cadd key(4): 01000000
b07cadd root 44882; ok
>b07cdel key(12): FF000030 013C0020 00B20000
b07cdel root 215; *** key_not_found ***
>b07cdel key(12): FF000030 013C0020 00C10000
b07cdel root 215; *** key_not_found ***
>KB05 id4184 destroy_temp prefix
>b01p_destroy Temp; fileTfnNo = 0; ttfnComplexView
session: nil; fid = 1
fn: 1A00 0000FFFFFFFF0200 000001000000
b01p_destroy root 44882; ok
KB05 id4184 return_result 0.000 sec
KB05 id4184 return_result 0.000 sec
>b07cnext key(4): FF000030
b07cnext root 215; *** no_next_record ***
>KB05 id4184 rollback
[T16 ===== id4185 new TransNo] 131.6522 page 131
KB05 id4185 ok 0.000 sec
KB05 id4185 ok 0.000 sec
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
