Tencent / APIJSON

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Access表插入新表行记录，表名带下划线，启动提示表名不合法 #181

Open

bodian520 opened this issue Dec 28, 2020 · 1 comment

Labels

Document 文档 Question 使用问题

bodian520 commented Dec 28, 2020

环境信息

系统:
JDK:
数据库:
APIJSON:

问题描述

https://my.oschina.net/tommylemon/blog/889074

1.按照该文档，在ACCESS表插入一行，原始表名为‘t_task’，插入行记录name或者alias='t_task'，启动报错，提示表名不合法，
但是't_task'应该是mysql的合法表名

错误信息

Collaborator

TommyLemon commented Dec 28, 2020

请求 JSON 参数和 Access 表中 APIJSON 表名都以大写字母开头
https://github.com/Tencent/APIJSON/blob/master/Document.md#3.1

数据库实际表名则不一定，因为 MySQL 默认大小写不敏感，大写小写都对，如果是 PostgreSQL 这种大小写敏感的，可以配置 alias

TommyLemon added Document 文档 Question 使用问题 labels

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment