Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save GiuseppeChillemi/67e337ff745c96b7975c733df7079abf to your computer and use it in GitHub Desktop.
Save GiuseppeChillemi/67e337ff745c96b7975c733df7079abf to your computer and use it in GitHub Desktop.
ODBC: "select cast(notexml as varchar(8000)) as n from dotes where notexml is not null" test
]
info: 120 batch-row-count
PICK-METADATA [
SQLGetInfo(120) 0
]
info: 121 batch-support
PICK-METADATA [
SQLGetInfo(121) 0
]
info: 127 create-assertion
PICK-METADATA [
SQLGetInfo(127) 0
]
info: 128 create-character-set
PICK-METADATA [
SQLGetInfo(128) 0
]
info: 129 create-collation
PICK-METADATA [
SQLGetInfo(129) 0
]
info: 130 create-domain
PICK-METADATA [
SQLGetInfo(130) 0
]
info: 131 create-schema
PICK-METADATA [
SQLGetInfo(131) 0
]
info: 132 create-table
PICK-METADATA [
SQLGetInfo(132) 0
]
info: 133 create-translation
PICK-METADATA [
SQLGetInfo(133) 0
]
info: 134 create-view
PICK-METADATA [
SQLGetInfo(134) 0
]
info: 136 drop-assertion
PICK-METADATA [
SQLGetInfo(136) 0
]
info: 137 drop-character-set
PICK-METADATA [
SQLGetInfo(137) 0
]
info: 138 drop-collation
PICK-METADATA [
SQLGetInfo(138) 0
]
info: 139 drop-domain
PICK-METADATA [
SQLGetInfo(139) 0
]
info: 140 drop-schema
PICK-METADATA [
SQLGetInfo(140) 0
]
info: 141 drop-table
PICK-METADATA [
SQLGetInfo(141) 0
]
info: 142 drop-translation
PICK-METADATA [
SQLGetInfo(142) 0
]
info: 143 drop-view
PICK-METADATA [
SQLGetInfo(143) 0
]
info: 144 dynamic-cursor-attributes1
PICK-METADATA [
SQLGetInfo(144) 0
]
info: 145 dynamic-cursor-attributes2
PICK-METADATA [
SQLGetInfo(145) 0
]
info: 146 forward-only-cursor-attributes1
PICK-METADATA [
SQLGetInfo(146) 0
]
info: 147 forward-only-cursor-attributes2
PICK-METADATA [
SQLGetInfo(147) 0
]
info: 148 index-keywords
PICK-METADATA [
SQLGetInfo(148) 0
]
info: 149 info-schema-views
PICK-METADATA [
SQLGetInfo(149) 0
]
info: 150 keyset-cursor-attributes1
PICK-METADATA [
SQLGetInfo(150) 0
]
info: 151 keyset-cursor-attributes2
PICK-METADATA [
SQLGetInfo(151) 0
]
info: 152 odbc-interface-conformance
PICK-METADATA [
SQLGetInfo(152) 0
]
info: 153 param-array-row-counts
PICK-METADATA [
SQLGetInfo(153) 0
]
info: 154 param-array-selects
PICK-METADATA [
SQLGetInfo(154) 0
]
info: 155 sql92-datetime-functions
PICK-METADATA [
SQLGetInfo(155) 0
]
info: 156 sql92-foreign-key-delete-rule
PICK-METADATA [
SQLGetInfo(156) 0
]
info: 157 sql92-foreign-key-update-rule
PICK-METADATA [
SQLGetInfo(157) 0
]
info: 158 sql92-grant
PICK-METADATA [
SQLGetInfo(158) 0
]
info: 159 sql92-numeric-value-functions
PICK-METADATA [
SQLGetInfo(159) 0
]
info: 160 sql92-predicates
PICK-METADATA [
SQLGetInfo(160) 0
]
info: 161 sql92-relational-join-operators
PICK-METADATA [
SQLGetInfo(161) 0
]
info: 162 sql92-revoke
PICK-METADATA [
SQLGetInfo(162) 0
]
info: 163 sql92-row-value-constructor
PICK-METADATA [
SQLGetInfo(163) 0
]
info: 164 sql92-string-functions
PICK-METADATA [
SQLGetInfo(164) 0
]
info: 165 sql92-value-expressions
PICK-METADATA [
SQLGetInfo(165) 0
]
info: 167 static-cursor-attributes1
PICK-METADATA [
SQLGetInfo(167) 0
]
info: 168 static-cursor-attributes2
PICK-METADATA [
SQLGetInfo(168) 0
]
info: 169 aggregate-functions
PICK-METADATA [
SQLGetInfo(169) 0
]
info: 170 ddl-index
PICK-METADATA [
SQLGetInfo(170) 0
]
info: 171 dm-ver
PICK-METADATA [
SQLGetInfo(171) 0
--------------------------------------------------------------------------------
---------------------------------------------------
03369CF0: 3000 3300 2e00 3800 3100 2e00 3900 3600 3000 3000 2e00 3000 3000 3
000 3000 0.3...8.1...9.6.0.0...0.0.0.0.
--------------------------------------------------------------------------------
---------------------------------------------------
]
info: 172 insert-statement
PICK-METADATA [
SQLGetInfo(172) 0
]
info: 10002 describe-parameter
PICK-METADATA [
SQLGetInfo(10002) 0
--------------------------------------------------------------------------------
---------------------------------------------------
03369CF0: 5900
Y.
--------------------------------------------------------------------------------
---------------------------------------------------
]
info: 10003 catalog-name
PICK-METADATA [
SQLGetInfo(10003) 0
--------------------------------------------------------------------------------
---------------------------------------------------
03369CF0: 5900
Y.
--------------------------------------------------------------------------------
---------------------------------------------------
]
info: 10004 collation-seq
PICK-METADATA [
SQLGetInfo(10004) 0
--------------------------------------------------------------------------------
---------------------------------------------------
03369CF0: 4900 5300 4f00 2000 3800 3800 3500 3900 2d00 3100
I.S.O. .8.8.5.9.-.1.
--------------------------------------------------------------------------------
---------------------------------------------------
]
info: 10005 max-identifier-len
PICK-METADATA [
SQLGetInfo(10005) 0
]
info: 10021 async-mode
PICK-METADATA [
SQLGetInfo(10021) 0
]
info: 10024 driver-aware-pooling-supported
PICK-METADATA [
SQLGetInfo(10024) 0
]
info: 10025 async-notification
PICK-METADATA [
SQLGetInfo(10025) 0
]
actor/open: statement
OPEN-STATEMENT [
SQLAllocHandle 0
allocate fetched, 4 bytes @ 03366688
]
""
actor/insert
FREE-PARAMETERS [
]
FREE-COLUMNS [
]
FREE-STATEMENT [
SQLFreeStmt 0
SQLFreeStmt 0
SQLFreeStmt 0
]
PREPARE-STATEMENT [
SQLPrepare 0
]
EXECUTE-STATEMENT [
SQLExecute 0
]
describe-columns
COUNT-COLUMNS [
SQLNumResultCols 0
]
BIND-COLUMNS [
allocate status/value, 400000 bytes @ 03369CF0
SET-STATEMENT [
SQLSetStmtAttr 0
]
SET-STATEMENT [
SQLSetStmtAttr 0
]
SET-STATEMENT [
SQLSetStmtAttr 0
]
allocate name, 256 bytes @ 033CB778
SQLDescribeCol 0
sql-type = 12, col-size = 8000
allocate buffer, 800100000 bytes @ 044E7020...33FEFEBF
allocate strlen, 400000 bytes @ 34000048
SQLBindCol 0
c-type = 1
free name @ 033CB778
]
actor/copy
FETCH-COLUMNS [
window: 100000
status: 03369CF0
root: 4206/6988, runs: 0, mem: 2347964 => 2239568, mark: 3.0ms, sweep: 1.0ms
SQLFetchScroll 0
fetched: 03366688 (21 rows)
*** Access Error: invalid UTF-8 encoding: #{E8206C61}
*** Where: ctx||440~fetch-columns
*** Near : [{select cast(notexml as varchar(8000)) a}]
*** Stack: do-file
>>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment