Differential D17336 Diff 47804 autotests/parser/data/statements.txt

Changeset View

Standalone View

View Options

autotests/parser/data/statements.txt

Show First 20 Lines • Show All 51 Lines • ▼ Show 20 Line(s)
52select "01234567890"; 52​select "01234567890";
53select '01234567890'; 53​select '01234567890';
54select '"'; 54​select '"';
55select '\\'; 55​select '\\';
56select '\"'; 56​select '\"';
57select 3.14159; 57​select 3.14159;
58select 3.; 58​select 3.;
59select NULL; 59​select NULL;
60select TRUE; 60​-- Date Constants (KDbSQL EXTENSION)
61-- TODO: Date/Time 61​-- https://community.kde.org/Kexi/Plugins/Queries/SQL_Constants
62​-- Date Constants: AD
63​select #2018-09-17#;
64​select #09/17/2018#;
65​select #2018-9-17#;
66​select #9/17/2018#;
67​select #2018-9-07#;
68​select #9/07/2018#;
69​select #2018-9-7#;
70​select #9/7/2018#;
71​select #2018-09-7#;
72​select #09/7/2018#;
73​select #1900-01-01#;
74​select #01/01/1900#;
75​select #1500-02-02#;
76​select #02/02/1500#;
77​select #0001-01-21#;
78​select #01/21/0001#;
79​-- ERROR: Date Constants: Invalid month
80​select #2018-00-17#;
81​select #00/17/2018#;
82​select #2018-0-17#;
83​select #0/17/2018#;
84​select #2018-13-17#;
85​select #13/17/2018#;
86​select #2018-99-17#;
87​select #99/17/2018#;
88​-- ERROR: Date Constants: Invalid day
89​select #2018-01-00#;
90​select #01/00/2018#;
91​select #2018-01-0#;
92​select #01/0/2018#;
93​select #2018-02-29#;
94​select #02/29/2018#;
95​select #2018-01-32#;
96​select #01/32/2018#;
97​-- ERROR: Date Constants: too many digits
98​select #2018-001-30#;
99​select #001/30/2018#;
100​select #2018-001-030#;
101​select #001/030/2018#;
102​select #2018-01-030#;
103​select #01/030/2018#;
104​-- ERROR: Date Constants: invalid characters/format
105​select #2018-1a-30#;
106​select #1a/30/2018#;
107​select #2018--30#;
108​select #/30/2018#;
109​select #2018-a-30#;
110​select #a/30/2018#;
111​select #2018-01-3o#;
112​select #01/3o/2018#;
113​select #2018-01-30;
114​select #01/30/2018;
115​select #2018_01-30#;
116​select #01/30_2018#;
117​select #2018-01_30;
118​select #01_30/2018#;
119​select #2018_01_30;
120​select #2018-01/30;
121​select #20180130;
122​select #2018;
123​select #2018-;
124​select #2018/;
125​select #/2018;
126​select #2018-01;
127​select #01/2018;
128​select #2018-01-;
129​select #/01/2018;
130​select #2018/01;
131​select #-2018-01-;
132​select #/01/2018;
133​select #-2018;
134​select ##-2018;
135​select ##/2018;
136​select #;
137​select ##;
138​select #2018-01-01-01#;
139​select #01/01/01/2018#;
140​select #++18119-10-30#;
141​select #10/30/++18119#;
142​select #+-18119-10-30#;
143​select #10/30/+-18119#;
144​select #-+18119-10-30#;
145​select #10/30/-+18119#;
146​select #--18119-10-30#;
147​select #10/30/--18119#;
148​select # 2018-03-08#;
149​select #2018-03-08 #;
150​select # 2018-03-08 #;
151​select # 2018 -03-08 #;
152​select #2018-03 -08#;
153​select #2018 - 03 - 08#;
154​select #201 -03-08 #;
155​select #2018- 3-08 #;
156​select #2018-03- 8 #;
157​-- ERROR: Date Constant: at least 4 digit year required
158​select #189-12-13#;
159​select #12/13/189#;
160​-- Date Constants: optional "+" prefix for years 1-9999
161​select #+2018-12-02#;
162​select #12/02/+2018#;
163​select #+1500-02-02#;
164​select #12/02/+1500#;
165​select #+1500-3-2#;
166​select #3/02/+1500#;
167​select #+02012-12-13#;
168​select #12/13/+02012#;
169​-- Date Constants, year > 9999
170​select #+123456789-12-13#;
171​select #12/13/+123456789#;
172​select #+000123456789-12-13#;
173​select #12/13/+000123456789#;
174​-- ERROR: Date Constant: More than 4-digit year so "+" prefix is required
175​select #123456789-12-13#;
176​select #12/13/123456789#;
177​-- 1 BC Date Constants
178​select #+0000-01-30#;
179​select #01/30/+0000#;
180​-- ERROR: Date Constant: 1 BC requires +0000 year
181​select #0000-01-01#;
182​select #01/01/0000#;
183​select #-0000-01-01#;
184​select #01/01/-0000#;
185​select #+000-01-01#;
186​select #01/01/+000#;
187​select #-000-01-01#;
188​select #01/01/-000#;
189​select #+00-01-01#;
190​select #01/01/+00#;
191​select #-00-01-01#;
192​select #01/01/-00#;
193​select #+0-01-01#;
194​select #01/01/+0#;
195​select #-0-01-01#;
196​select #01/01/-0#;
197​-- 2 BC Date Constants
198​select #-0001-03-04#;
199​select #03/04/-0001#;
200​select #-5001-03-04#;
201​select #03/04/-5001#;
202​-- <= 10000 BC Date Constants
203​select #-9999-03-04#;
204​select #04/03/-9999#;
205​select #-10000-03-04#;
206​select #04/03/-10000#;
207​select #-543210000-03-04#;
208​select #04/03/-543210000#;
209​select #-00543210000-03-04#;
210​select #04/03/-00543210000#;
211​-- ERROR: Date Constant: MSA format
212​select #24 Dec 2014#;
213​select #24 December 2014#;
214​select #December 24, 2014#;
215​select #Dec 24, 2014#;
216​
217​-- Time Constants (KDbSQL EXTENSION)
218​-- https://community.kde.org/Kexi/Plugins/Queries/SQL_Constants
219​-- Time Constants: 24h mode
220​select #01:17:59#;
221​select #01:07:59#;
222​select #01:07:09#;
223​select #1:07:09#;
224​select #01:7:09#;
225​select #01:07:9#;
226​select #01:7:9#;
227​select #1:7:09#;
228​select #1:07:9#;
229​select #1:7:9#;
230​select #0:0:0#;
231​select #23:11:29#;
232​select #13:17:59#;
233​select #23:11#;
234​select #03:01#;
235​select #3:01#;
236​select #03:1#;
237​select #3:1#;
238​-- Time Constants: 12h mode
239​select #11:11:29 AM#;
240​select #11:11:29 PM#;
241​select #11:11:29AM#;
242​select #11:11:29PM#;
243​select #11:11:29am#;
244​select #11:11:29pm#;
245​select #11:11:29 AM#;
246​select #11:11:29 PM#;
247​select #1:31:19 aM#;
248​select #1:31:19 Am#;
249​select #1:31:19 am#;
250​select #1:31:19 pM#;
251​select #1:31:19 pM#;
252​select #11:11 AM#;
253​select #11:11 PM#;
254​select #11:11 AM#;
255​select #11:11 PM#;
256​select #11:11AM#;
257​select #11:11PM#;
258​select #11:11am#;
259​select #11:11pm#;
260​select #1:31 aM#;
261​select #1:31 Am#;
262​select #1:31 am#;
263​select #1:31 pM#;
264​select #1:31 pM#;
265​-- ERROR: Time Constants: invalid characters/format
266​select #001:17:59#;
267​select #01:017:59#;
268​select #01:017:059#;
269​select #001:017:59#;
270​select #01:017:059#;
271​select #001:17:059#;
272​select #001;017:059#;
273​select #01:17:59;
274​select #01::17:59#;
275​select ##01::17:59#;
276​select #01#;
277​select #0#;
278​select #11:17 #;
279​select #11: 17#;
280​select #11 : 17#;
281​select #11 :17#;
282​select #11::17#;
283​select # 11:17#;
284​select #11:17 AM #;
285​select #1:17 PM #;
286​select # 11:17 AM#;
287​select # 11:17 AM #;
288​select # 1:17 PM#;
289​select # 1:17 PM #;
290​select #o1:17#;
291​select #1:17a#;
292​select #1:17p#;
293​select #1:17 p#;
294​select #1:17 pr#;
295​-- ERROR: Time Constants: invalid hour
296​select #24:17:59#;
297​select #28:17:59#;
298​select #13:17:59 AM#;
299​select #23:17:59 PM#;
300​select #13:17 AM#;
301​select #23:17 PM#;
302​
303​-- Date/Time Constants (KDbSQL EXTENSION)
304​-- https://community.kde.org/Kexi/Plugins/Queries/SQL_Constants
305​-- TODO
62 306​
63-- TRUE and FALSE constants (KDbSQL EXTENSION) 307​-- TRUE and FALSE constants (KDbSQL EXTENSION)
308​select TRUE;
64select TRUE, NOT FALSE; 309​select TRUE, NOT FALSE;
65select NOT NOT TRUE; 310​select NOT NOT TRUE;
66select NOT NULL; 311​select NOT NULL;
67select NOT (NOT TRUE); 312​select NOT (NOT TRUE);
68select TRUE != FALSE; 313​select TRUE != FALSE;
69select TRUE <> FALSE; 314​select TRUE <> FALSE;
70select TRUE OR FALSE; 315​select TRUE OR FALSE;
71select TRUE XOR FALSE; 316​select TRUE XOR FALSE;
▲ Show 20 Lines • Show All 315 Lines • Show Last 20 Lines