[
https://issues.apache.org/jira/browse/IGNITE-7556?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Artem Budnikov updated IGNITE-7556:
-----------------------------------
Description:
Descriptions on [https://apacheignite-sql.readme.io/docs/schema-and-indexes]
are not DML-friendly
After reading this page and [https://apacheignite-sql.readme.io/docs/insert],
one would likely still unable to write working INSERT because there won't be
primary key in it.
Their only chance is to spot _key reference in infoblock, or infer usability of
setKeyFields() with single key type. Both are unlikely, leading to questions
such as
[https://stackoverflow.com/questions/48460214/how-do-i-read-data-from-ignite-kv-storage-using-jdbc]
see {{Key is missing from query}}
Such problems are hard to debug. They can be avoided if all examples of
QueryEntities in docs will contain setKeyFields, and INSERT docs page will
refer to _key field.
was:
Descriptions on [https://apacheignite-sql.readme.io/docs/schema-and-indexes]
are not DML-friendly
After reading this page and [https://apacheignite-sql.readme.io/docs/insert],
one would likely still unable to write working INSERT because there won't be
primary key in it.
Their only chance is to spot _key reference in infoblock, or infer usability of
setKeyFields() with single key type. Both are unlikely, leading to questions
such as
[https://stackoverflow.com/questions/48460214/how-do-i-read-data-from-ignite-kv-storage-using-jdbc]
see {{Key is missing from query}}
Such problems are hard to debug. They can be avoided if all examples of
QueryEntities in docs will contain setKeyFields, and INSERT docs page will
refer to _key field.
> Docs should feature specifying SQL key more prominently
> -------------------------------------------------------
>
> Key: IGNITE-7556
> URL: https://issues.apache.org/jira/browse/IGNITE-7556
> Project: Ignite
> Issue Type: Bug
> Components: documentation
> Reporter: Ilya Kasnacheev
> Assignee: Artem Budnikov
> Priority: Minor
> Fix For: 2.7
>
>
> Descriptions on [https://apacheignite-sql.readme.io/docs/schema-and-indexes]
> are not DML-friendly
> After reading this page and
> [https://apacheignite-sql.readme.io/docs/insert], one would likely still
> unable to write working INSERT because there won't be primary key in it.
> Their only chance is to spot _key reference in infoblock, or infer usability
> of setKeyFields() with single key type. Both are unlikely, leading to
> questions such as
> [https://stackoverflow.com/questions/48460214/how-do-i-read-data-from-ignite-kv-storage-using-jdbc]
> see {{Key is missing from query}}
> Such problems are hard to debug. They can be avoided if all examples of
> QueryEntities in docs will contain setKeyFields, and INSERT docs page will
> refer to _key field.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
