tdbc::sqlite3

Artifact [434b61b127]
Login

Artifact 434b61b1277ae0a61d8c0d373635ec76414875d54d833de537b748daabc5fb33:

Ticket change [434b61b127] - New ticket [a1e76ad92f] columns metadata method always reports column names in lower case. by chw 2020-05-26 16:03:04.
D 2020-05-26T16:03:04.672
J foundin current
J icomment The\sconnection\smethod\s"columns"\sreports\sthe\scolumn\snames\sof\sa\sgiven\stable\sbut\r\nthe\scolumn\snames\sare\sreformatted\sto\slower\scase\swith\s"string\stolower".\r\nWhen\sdata\slater\sis\sretrieved,\sthat\sreformat\son\scolumn\snames\sis\snot\sperformed,\r\ni.e.\sthe\sdict\sreceiving\sthe\srow\sdata\sof\sa\sresult\sset\scan\shave\smixed\scase\r\ncolumn\snames.\sWhy\sis\sthis\sasymmetric\sbehavior?\sWould\sit\sbe\ssymmetric,\sthe\r\ncolumn\smethod\scould\seasily\sbe\sused\sto\sconstruct\sSQL\sprogrammatically,\se.g.\r\nto\sbuild\sup\sthe\sbind\sparameter\snames\sfor\san\sINSERT\sstatement\swhich\sthen\smap\r\nto\sthe\sdict\skeys\sof\sa\srow\sof\sa\sresult\sset.\sOr\sam\sI\smissing\sa\ssubtle\sdetail?
J login chw
J mimetype text/plain
J private_contact 0b3aff16612e1e9f3b675963fa64e01bd1d89307
J severity Important
J status Open
J title columns\smetadata\smethod\salways\sreports\scolumn\snames\sin\slower\scase
J type Code_Defect
K a1e76ad92f66d02fa7eb75b4d0d1231a382677ca
U chw
Z 39b47c22bc99938a2594fecbd1fdb45c