[F-18729]9.0.6.0 查询命令自动建构的查询语句出错了
本帖最后由 飞天 于 2023-12-1 15:06 编辑SQL参数P10/P11/P12/P13/P14, 都有相应的值，但SQL语句总是取了P1的值
在不同的程序中都发现的这个问题，只要参数超过10个，从第10个起总是取P1的值
"SqlItem": {
"Sql": "selecta. as C0,a. as C1,a. as C2,a. as C3,a. as C4,a. as C5,a. as C6,a. as C7,a. as C8,a. as C9,a. as C10,a. as C11,a. as C12,a. as C13,a. as C14,a. as C15,a. as C16,a. as C17,a. as C18,a. as C19,a. as C20,a. as C21,a. as C22,a. as C23,a. as C24,a. as C25,a. as C26,a. as C27,a. as C28,a. as C29,a. as C30,a. as C31,a. as C32,a. as C33,a. as C34 from . as a Where a. = \"LSA 46.3L11\" AND a. = \"J 6/4\" AND a. = \"0-14\" AND a. = \"NO\" AND a. = \"NO\" AND a. = \"NO\" AND a. = \"G2.5\" AND a. = \"System 1\" AND a. = \"IP23\" AND a. = \"280\" AND a. = \"NO\" AND a. = \"NO\" AND a. = \"Cables exit on the left side(Standard)\" AND a. = \"NO\" AND a. = \"NO\" AND a. = \"NO\" AND a. = \"NO\" AND a. = \"NO\" AND a. = \"NO\" AND a. = \"STD;(D);(A);\" AND a. = \"J 6/4\"0 AND a. = \"NO\" AND a. = \"NO\" AND a. = \"NO\" AND a. = \"NO\" AND a. = \"NO\" AND a. = \"NO\" AND a. = \"NO\" AND a. = \"NO\" AND a. = \"NO\" AND a. = \"J 6/4\"1 AND a. = \"J 6/4\"2 AND a. = \"J 6/4\"3 AND a. = \"J 6/4\"4ORDER BY a. ASC",
"OriginalSql": "selecta. as C0,a. as C1,a. as C2,a. as C3,a. as C4,a. as C5,a. as C6,a. as C7,a. as C8,a. as C9,a. as C10,a. as C11,a. as C12,a. as C13,a. as C14,a. as C15,a. as C16,a. as C17,a. as C18,a. as C19,a. as C20,a. as C21,a. as C22,a. as C23,a. as C24,a. as C25,a. as C26,a. as C27,a. as C28,a. as C29,a. as C30,a. as C31,a. as C32,a. as C33,a. as C34 from . as a Where a. = @p0 AND a. = @p1 AND a. = @p2 AND a. = @p3 AND a. = @p3 AND a. = @p3 AND a. = @p4 AND a. = @p5 AND a. = @p6 AND a. = @p7 AND a. = @p3 AND a. = @p3 AND a. = @p8 AND a. = @p3 AND a. = @p3 AND a. = @p3 AND a. = @p3 AND a. = @p3 AND a. = @p3 AND a. = @p9 AND a. = @p10 AND a. = @p3 AND a. = @p3 AND a. = @p3 AND a. = @p3 AND a. = @p3 AND a. = @p3 AND a. = @p3 AND a. = @p3 AND a. = @p3 AND a. = @p11 AND a. = @p12 AND a. = @p13 AND a. = @p14ORDER BY a. ASC",
"SqlParams": [
{
"Name": "@p0",
"Value": "LSA 46.3L11"
},
{
"Name": "@p1",
"Value": "J 6/4"
},
{
"Name": "@p2",
"Value": "0-14"
},
{
"Name": "@p3",
"Value": "NO"
},
{
"Name": "@p4",
"Value": "G2.5"
},
{
"Name": "@p5",
"Value": "System 1"
},
{
"Name": "@p6",
"Value": "IP23"
},
{
"Name": "@p7",
"Value": "280"
},
{
"Name": "@p8",
"Value": "Cables exit on the left side(Standard)"
},
{
"Name": "@p9",
"Value": "STD;(D);(A);"
},
{
"Name": "@p10",
"Value": "D350"
},
{
"Name": "@p11",
"Value": "test"
},
{
"Name": "@p12",
"Value": "testgb"
},
{
"Name": "@p13",
"Value": "testmd"
},
{
"Name": "@p14",
"Value": "testdt"
}
],
"Duration": "17.4158ms"
}
这是Bug呢，还是什么特殊的设置:'(:'(:'(:'(:'(:'( 您好，这个问题我们调查一下哈，有结果了及时给您反馈:loveliness: 问题跟进
您好，感谢您的反馈，这个日志错误确实是我们的一个产品问题，问题编号是F-18729，我们会在后续的版本中去修复这个问题的哈，感谢您的支持:i0tw2:
bug已经在10.0.2.0修复，请去官网下载最新版本活字格体验
页:
[1]