mirror of
https://github.com/featurebasedb/featurebase.git
synced 2026-09-09 14:41:02 +00:00
c304991e9f
* implemented extract ddl; tightened up type related stuff
* added some test coverage
* review feedback
(cherry picked from commit f62313762c)
39 lines
1.2 KiB
Go
39 lines
1.2 KiB
Go
package defs
|
|
|
|
var orderByTests = TableTest{
|
|
name: "orderByTests",
|
|
Table: tbl(
|
|
"order_by_test",
|
|
srcHdrs(
|
|
srcHdr("_id", fldTypeID),
|
|
srcHdr("an_int", fldTypeInt, "min 0", "max 100"),
|
|
srcHdr("an_id_set", fldTypeIDSet),
|
|
srcHdr("an_id", fldTypeID),
|
|
srcHdr("a_string", fldTypeString),
|
|
srcHdr("a_string_set", fldTypeStringSet),
|
|
srcHdr("a_decimal", fldTypeDecimal2),
|
|
),
|
|
srcRows(
|
|
srcRow(int64(1), int64(11), []int64{11, 12, 13}, int64(101), "str1", []string{"a1", "b1", "c1"}, float64(123.45)),
|
|
srcRow(int64(2), int64(22), []int64{21, 22, 23}, int64(201), "str2", []string{"a2", "b2", "c2"}, float64(234.56)),
|
|
srcRow(int64(3), int64(33), []int64{31, 32, 33}, int64(301), "str3", []string{"a3", "b3", "c3"}, float64(345.67)),
|
|
srcRow(int64(4), int64(44), []int64{41, 42, 43}, int64(401), "str4", []string{"a4", "b4", "c4"}, float64(456.78)),
|
|
),
|
|
),
|
|
SQLTests: []SQLTest{
|
|
{
|
|
name: "order-by-stringset",
|
|
SQLs: sqls(
|
|
"select * from order_by_test order by a_string_set asc",
|
|
),
|
|
ExpErr: "unable to sort a column of type 'stringset'",
|
|
},
|
|
{
|
|
name: "order-by-idset",
|
|
SQLs: sqls(
|
|
"select * from order_by_test order by an_id_set asc",
|
|
),
|
|
ExpErr: "unable to sort a column of type 'idset'",
|
|
},
|
|
},
|
|
}
|