Comments (3)
这个不太好搞。SPL有空序表对象,可以create一个返回。
但通常出现这种情况是计算结果就是空集(比如select后是空的),没有记录也就没有数据结构了。而且SPL支持混合数据结构,不像SQL那样要求结果集的数据结构是唯一的,也就不合适指定某种数据结构。
不过,大部分情况直接返回null问题也不大的,null可以继续后面的各种操作(new,derive,.... ),也不会报错,反正进一步结果还是null,只是没法有一个标题出现了。
from esproc.
感谢回复。似乎是不太好弄,可能中间某步就没数据了。现在主要是报表,如果没有结构报表就会报错,看来只能create空序表返回了
from esproc.
注意到select函数增加了一个@t选项可以保留结构
from esproc.
Related Issues (20)
- 简单SQL里有支持pivot么?有样例么? HOT 1
- rename函数bug 远程计算会失败 HOT 2
- fnname函数也存在 rename函数类似的bug HOT 3
- [建议]esProc项目拆分成多模块 HOT 1
- 连接数据库提示Class [com.mysql.jdbc.Driver] is not found. HOT 1
- 集算器采用connect函数直连 连接不上oracle HOT 6
- sqltranslate函数不能正确的翻译 0 参数的函数;例如:TODAY(), NOW() HOT 1
- sqltranslate 无法正确翻译 LEFT(STR, N) 函数 HOT 1
- sqltranslate中 LEFT(str,n) 函数作为其它函数参数未被翻译 HOT 1
- 数据库对象单元格内容明码显示密码
- 数据库对象单元格内容明码显示密码
- 需要一个生成字符型序列的简单方法
- 集算器 spl 出现卡死现象 疑似 使用 Boolean 类型做为锁导致其它线程都出于等待 !!! HOT 3
- 是否支持二进制文件解析,比如stdf HOT 1
- SPL建议增加proxy功能 HOT 3
- 正则表达式匹配出错 HOT 4
- 数据查询异常 HOT 3
- Add Code of Conduct
- Proposal for Contributing Guidelines Documentation
- 漏洞是否会修复 HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from esproc.