questdb.io icon indicating copy to clipboard operation
questdb.io copied to clipboard

Published 20 hours ago • verified publisher icon questdb

Update - Capture functions missing from Docs

Open amyshwang opened this issue 2 years ago • 3 comments

Location of the change Current Docs>Reference>Function has not captured all the functions available.

Source In GH: https://github.com/questdb/questdb/tree/master/core/src/main/java/io/questdb/griffin/engine/functions

A full list of functions can be found it: https://github.com/questdb/questdb/blob/88095a6f6ac960e18a2a2495777bf7da5f98a6f2/core/src/main/resources/META-INF/services/io.questdb.griffin.FunctionFactory#L25

Additional info Functions are produced by FunctionFactories. each function factory has a method getSignature() which reflects the function name.

To bridge this gap:

  1. List out what functions are missing from the website.
  2. Understand how the examples are created and written.
  3. Write and publish them.

amyshwang avatar Jul 01 '22 15:07 amyshwang

Questions: Function that I cannot link to any function factories:

Cannot find: timestamp() https://questdb.io/docs/reference/function/timestamp
within(geohash) https://questdb.io/docs/reference/operators/spatial

Functions not documented on the website:

Function file

  io.questdb.griffin.engine.functions.test.TestLatchedCounterFunctionFactory io.questdb.griffin.engine.functions.test.TestSumXDoubleGroupByFunctionFactory io.questdb.griffin.engine.functions.test.TestSumTDoubleGroupByFunctionFactory io.questdb.griffin.engine.functions.test.TestSumStringGroupByFunctionFactory io.questdb.griffin.engine.functions.test.TestNPEFactory io.questdb.griffin.engine.functions.rnd.RndLogFunctionFactory  

logical operations

io.questdb.griffin.engine.functions.bool.OrFunctionFactory io.questdb.griffin.engine.functions.bool.AndFunctionFactory io.questdb.griffin.engine.functions.bool.NotFunctionFactory  

[] operators

io.questdb.griffin.engine.functions.array.StrArrayDereferenceFunctionFactory io.questdb.griffin.engine.functions.array.IntArrayDereferenceHackFunctionFactory  

'='

io.questdb.griffin.engine.functions.eq.EqStrFunctionFactory io.questdb.griffin.engine.functions.eq.EqByteFunctionFactory io.questdb.griffin.engine.functions.eq.EqShortFunctionFactory io.questdb.griffin.engine.functions.eq.EqIntFunctionFactory io.questdb.griffin.engine.functions.eq.EqLongFunctionFactory io.questdb.griffin.engine.functions.eq.EqDoubleFunctionFactory io.questdb.griffin.engine.functions.eq.EqLong256StrFunctionFactory io.questdb.griffin.engine.functions.eq.EqLong256FunctionFactory io.questdb.griffin.engine.functions.eq.EqStrCharFunctionFactory io.questdb.griffin.engine.functions.eq.EqSymStrFunctionFactory io.questdb.griffin.engine.functions.eq.EqSymCharFunctionFactory io.questdb.griffin.engine.functions.eq.EqCharCharFunctionFactory io.questdb.griffin.engine.functions.eq.EqIntStrCFunctionFactory io.questdb.griffin.engine.functions.eq.EqTimestampFunctionFactory io.questdb.griffin.engine.functions.eq.EqBooleanFunctionFactory io.questdb.griffin.engine.functions.eq.EqBooleanCharFunctionFactory io.questdb.griffin.engine.functions.eq.EqBinaryFunctionFactory io.questdb.griffin.engine.functions.eq.EqGeoHashGeoHashFunctionFactory io.questdb.griffin.engine.functions.eq.EqGeoHashStrFunctionFactory io.questdb.griffin.engine.functions.eq.EqStrGeoHashFunctionFactory  

nullif

 

'<' operator

io.questdb.griffin.engine.functions.lt.LtDoubleVVFunctionFactory io.questdb.griffin.engine.functions.lt.LtTimestampFunctionFactory io.questdb.griffin.engine.functions.lt.LtIntFunctionFactory io.questdb.griffin.engine.functions.lt.LtCharFunctionFactory io.questdb.griffin.engine.functions.lt.LtLong256FunctionFactory  

'+' operator

io.questdb.griffin.engine.functions.math.AddIntFunctionFactory io.questdb.griffin.engine.functions.math.AddLongFunctionFactory io.questdb.griffin.engine.functions.math.AddFloatFunctionFactory io.questdb.griffin.engine.functions.math.AddDoubleFunctionFactory io.questdb.griffin.engine.functions.date.AddLongToTimestampFunctionFactory io.questdb.griffin.engine.functions.math.AddLong256FunctionFactory  

'-' operator

io.questdb.griffin.engine.functions.math.NegIntFunctionFactory io.questdb.griffin.engine.functions.math.NegDoubleFunctionFactory io.questdb.griffin.engine.functions.math.NegFloatFunctionFactory io.questdb.griffin.engine.functions.math.NegLongFunctionFactory io.questdb.griffin.engine.functions.math.NegShortFunctionFactory io.questdb.griffin.engine.functions.math.NegByteFunctionFactory io.questdb.griffin.engine.functions.math.SubDoubleFunctionFactory io.questdb.griffin.engine.functions.math.SubIntFunctionFactory io.questdb.griffin.engine.functions.math.SubLongFunctionFactory io.questdb.griffin.engine.functions.math.SubTimestampFunctionFactory  

'/' operator

io.questdb.griffin.engine.functions.math.DivDoubleFunctionFactory io.questdb.griffin.engine.functions.math.DivFloatFunctionFactory io.questdb.griffin.engine.functions.math.DivLongFunctionFactory io.questdb.griffin.engine.functions.math.DivIntFunctionFactory  

'%' operator

io.questdb.griffin.engine.functions.math.RemIntFunctionFactory io.questdb.griffin.engine.functions.math.RemLongFunctionFactory io.questdb.griffin.engine.functions.math.RemDoubleFunctionFactory io.questdb.griffin.engine.functions.math.RemFloatFunctionFactory  

'*' operator

io.questdb.griffin.engine.functions.math.MulFloatFunctionFactory io.questdb.griffin.engine.functions.math.MulDoubleFunctionFactory io.questdb.griffin.engine.functions.math.MulLongFunctionFactory io.questdb.griffin.engine.functions.math.MulIntFunctionFactory

like

io.questdb.griffin.engine.functions.regex.LikeStrFunctionFactory io.questdb.griffin.engine.functions.regex.ILikeStrFunctionFactory io.questdb.griffin.engine.functions.regex.LikeCharFunctionFactory  

'to_char'

io.questdb.griffin.engine.functions.date.ToStrDateFunctionFactory io.questdb.griffin.engine.functions.str.ToCharBinFunctionFactory  

'length'

 

random generator functions

  io.questdb.griffin.engine.functions.rnd.RndStringRndListFunctionFactory io.questdb.griffin.engine.functions.rnd.RndSymbolListFunctionFactory io.questdb.griffin.engine.functions.rnd.RndStringListFunctionFactory io.questdb.griffin.engine.functions.rnd.RndByteFunctionFactory io.questdb.griffin.engine.functions.rnd.ListFunctionFactory io.questdb.griffin.engine.functions.date.TimestampShuffleFunctionFactory  

date conversion functions

  io.questdb.griffin.engine.functions.date.ToStrTimestampFunctionFactory io.questdb.griffin.engine.functions.date.HourOfDayFunctionFactory io.questdb.griffin.engine.functions.date.ExtractFromTimestampFunctionFactory io.questdb.griffin.engine.functions.date.ToPgDateFunctionFactory io.questdb.griffin.engine.functions.date.DateTruncFunctionFactory  

cast double to ...

io.questdb.griffin.engine.functions.cast.CastDoubleToIntFunctionFactory io.questdb.griffin.engine.functions.cast.CastDoubleToDoubleFunctionFactory io.questdb.griffin.engine.functions.cast.CastDoubleToFloatFunctionFactory io.questdb.griffin.engine.functions.cast.CastDoubleToLong256FunctionFactory io.questdb.griffin.engine.functions.cast.CastDoubleToLongFunctionFactory io.questdb.griffin.engine.functions.cast.CastDoubleToShortFunctionFactory io.questdb.griffin.engine.functions.cast.CastDoubleToByteFunctionFactory io.questdb.griffin.engine.functions.cast.CastDoubleToStrFunctionFactory io.questdb.griffin.engine.functions.cast.CastDoubleToSymbolFunctionFactory io.questdb.griffin.engine.functions.cast.CastDoubleToCharFunctionFactory io.questdb.griffin.engine.functions.cast.CastDoubleToDateFunctionFactory io.questdb.griffin.engine.functions.cast.CastDoubleToTimestampFunctionFactory  

cast float to ...

io.questdb.griffin.engine.functions.cast.CastFloatToIntFunctionFactory io.questdb.griffin.engine.functions.cast.CastFloatToDoubleFunctionFactory io.questdb.griffin.engine.functions.cast.CastFloatToFloatFunctionFactory io.questdb.griffin.engine.functions.cast.CastFloatToLong256FunctionFactory io.questdb.griffin.engine.functions.cast.CastFloatToLongFunctionFactory io.questdb.griffin.engine.functions.cast.CastFloatToShortFunctionFactory io.questdb.griffin.engine.functions.cast.CastFloatToByteFunctionFactory io.questdb.griffin.engine.functions.cast.CastFloatToStrFunctionFactory io.questdb.griffin.engine.functions.cast.CastFloatToSymbolFunctionFactory io.questdb.griffin.engine.functions.cast.CastFloatToCharFunctionFactory io.questdb.griffin.engine.functions.cast.CastFloatToDateFunctionFactory io.questdb.griffin.engine.functions.cast.CastFloatToTimestampFunctionFactory  

cast short to ...

io.questdb.griffin.engine.functions.cast.CastShortToShortFunctionFactory io.questdb.griffin.engine.functions.cast.CastShortToByteFunctionFactory io.questdb.griffin.engine.functions.cast.CastShortToCharFunctionFactory io.questdb.griffin.engine.functions.cast.CastShortToIntFunctionFactory io.questdb.griffin.engine.functions.cast.CastShortToLongFunctionFactory io.questdb.griffin.engine.functions.cast.CastShortToFloatFunctionFactory io.questdb.griffin.engine.functions.cast.CastShortToDoubleFunctionFactory io.questdb.griffin.engine.functions.cast.CastShortToStrFunctionFactory io.questdb.griffin.engine.functions.cast.CastShortToDateFunctionFactory io.questdb.griffin.engine.functions.cast.CastShortToTimestampFunctionFactory io.questdb.griffin.engine.functions.cast.CastShortToSymbolFunctionFactory io.questdb.griffin.engine.functions.cast.CastShortToLong256FunctionFactory io.questdb.griffin.engine.functions.cast.CastShortToBooleanFunctionFactory  

cast int to ...

io.questdb.griffin.engine.functions.cast.CastIntToShortFunctionFactory io.questdb.griffin.engine.functions.cast.CastIntToByteFunctionFactory io.questdb.griffin.engine.functions.cast.CastIntToCharFunctionFactory io.questdb.griffin.engine.functions.cast.CastIntToIntFunctionFactory io.questdb.griffin.engine.functions.cast.CastIntToLongFunctionFactory io.questdb.griffin.engine.functions.cast.CastIntToFloatFunctionFactory io.questdb.griffin.engine.functions.cast.CastIntToDoubleFunctionFactory io.questdb.griffin.engine.functions.cast.CastIntToStrFunctionFactory io.questdb.griffin.engine.functions.cast.CastIntToDateFunctionFactory io.questdb.griffin.engine.functions.cast.CastIntToTimestampFunctionFactory io.questdb.griffin.engine.functions.cast.CastIntToSymbolFunctionFactory io.questdb.griffin.engine.functions.cast.CastIntToLong256FunctionFactory io.questdb.griffin.engine.functions.cast.CastIntToBooleanFunctionFactory  

cast long to ...

io.questdb.griffin.engine.functions.cast.CastLongToShortFunctionFactory io.questdb.griffin.engine.functions.cast.CastLongToByteFunctionFactory io.questdb.griffin.engine.functions.cast.CastLongToCharFunctionFactory io.questdb.griffin.engine.functions.cast.CastLongToIntFunctionFactory io.questdb.griffin.engine.functions.cast.CastLongToLongFunctionFactory io.questdb.griffin.engine.functions.cast.CastLongToFloatFunctionFactory io.questdb.griffin.engine.functions.cast.CastLongToDoubleFunctionFactory io.questdb.griffin.engine.functions.cast.CastLongToStrFunctionFactory io.questdb.griffin.engine.functions.cast.CastLongToDateFunctionFactory io.questdb.griffin.engine.functions.cast.CastLongToTimestampFunctionFactory io.questdb.griffin.engine.functions.cast.CastNullFunctionFactory io.questdb.griffin.engine.functions.cast.CastLongToSymbolFunctionFactory io.questdb.griffin.engine.functions.cast.CastLongToLong256FunctionFactory io.questdb.griffin.engine.functions.cast.CastLongToBooleanFunctionFactory io.questdb.griffin.engine.functions.cast.CastLongToGeoHashFunctionFactory  

cast long256 to ...

io.questdb.griffin.engine.functions.cast.CastLong256ToShortFunctionFactory io.questdb.griffin.engine.functions.cast.CastLong256ToByteFunctionFactory io.questdb.griffin.engine.functions.cast.CastLong256ToCharFunctionFactory io.questdb.griffin.engine.functions.cast.CastLong256ToIntFunctionFactory io.questdb.griffin.engine.functions.cast.CastLong256ToLongFunctionFactory io.questdb.griffin.engine.functions.cast.CastLong256ToFloatFunctionFactory io.questdb.griffin.engine.functions.cast.CastLong256ToDoubleFunctionFactory io.questdb.griffin.engine.functions.cast.CastLong256ToStrFunctionFactory io.questdb.griffin.engine.functions.cast.CastLong256ToDateFunctionFactory io.questdb.griffin.engine.functions.cast.CastLong256ToTimestampFunctionFactory io.questdb.griffin.engine.functions.cast.CastLong256ToSymbolFunctionFactory io.questdb.griffin.engine.functions.cast.CastLong256ToLong256FunctionFactory io.questdb.griffin.engine.functions.cast.CastLong256ToBooleanFunctionFactory  

cast date to ...

io.questdb.griffin.engine.functions.cast.CastDateToShortFunctionFactory io.questdb.griffin.engine.functions.cast.CastDateToByteFunctionFactory io.questdb.griffin.engine.functions.cast.CastDateToCharFunctionFactory io.questdb.griffin.engine.functions.cast.CastDateToIntFunctionFactory io.questdb.griffin.engine.functions.cast.CastDateToLongFunctionFactory io.questdb.griffin.engine.functions.cast.CastDateToFloatFunctionFactory io.questdb.griffin.engine.functions.cast.CastDateToDoubleFunctionFactory io.questdb.griffin.engine.functions.cast.CastDateToStrFunctionFactory io.questdb.griffin.engine.functions.cast.CastDateToDateFunctionFactory io.questdb.griffin.engine.functions.cast.CastDateToTimestampFunctionFactory io.questdb.griffin.engine.functions.cast.CastDateToSymbolFunctionFactory io.questdb.griffin.engine.functions.cast.CastDateToLong256FunctionFactory io.questdb.griffin.engine.functions.cast.CastDateToBooleanFunctionFactory  

cast timestamp to ...

io.questdb.griffin.engine.functions.cast.CastTimestampToShortFunctionFactory io.questdb.griffin.engine.functions.cast.CastTimestampToByteFunctionFactory io.questdb.griffin.engine.functions.cast.CastTimestampToCharFunctionFactory io.questdb.griffin.engine.functions.cast.CastTimestampToIntFunctionFactory io.questdb.griffin.engine.functions.cast.CastTimestampToLongFunctionFactory io.questdb.griffin.engine.functions.cast.CastTimestampToFloatFunctionFactory io.questdb.griffin.engine.functions.cast.CastTimestampToDoubleFunctionFactory io.questdb.griffin.engine.functions.cast.CastTimestampToStrFunctionFactory io.questdb.griffin.engine.functions.cast.CastTimestampToDateFunctionFactory io.questdb.griffin.engine.functions.cast.CastTimestampToTimestampFunctionFactory io.questdb.griffin.engine.functions.cast.CastTimestampToSymbolFunctionFactory io.questdb.griffin.engine.functions.cast.CastTimestampToLong256FunctionFactory io.questdb.griffin.engine.functions.cast.CastTimestampToBooleanFunctionFactory  

cast byte to ...

io.questdb.griffin.engine.functions.cast.CastByteToShortFunctionFactory io.questdb.griffin.engine.functions.cast.CastByteToByteFunctionFactory io.questdb.griffin.engine.functions.cast.CastByteToCharFunctionFactory io.questdb.griffin.engine.functions.cast.CastByteToIntFunctionFactory io.questdb.griffin.engine.functions.cast.CastByteToLongFunctionFactory io.questdb.griffin.engine.functions.cast.CastByteToFloatFunctionFactory io.questdb.griffin.engine.functions.cast.CastByteToDoubleFunctionFactory io.questdb.griffin.engine.functions.cast.CastByteToStrFunctionFactory io.questdb.griffin.engine.functions.cast.CastByteToDateFunctionFactory io.questdb.griffin.engine.functions.cast.CastByteToTimestampFunctionFactory io.questdb.griffin.engine.functions.cast.CastByteToSymbolFunctionFactory io.questdb.griffin.engine.functions.cast.CastByteToLong256FunctionFactory io.questdb.griffin.engine.functions.cast.CastByteToBooleanFunctionFactory  

cast boolean to ...

io.questdb.griffin.engine.functions.cast.CastBooleanToShortFunctionFactory io.questdb.griffin.engine.functions.cast.CastBooleanToByteFunctionFactory io.questdb.griffin.engine.functions.cast.CastBooleanToCharFunctionFactory io.questdb.griffin.engine.functions.cast.CastBooleanToIntFunctionFactory io.questdb.griffin.engine.functions.cast.CastBooleanToLongFunctionFactory io.questdb.griffin.engine.functions.cast.CastBooleanToFloatFunctionFactory io.questdb.griffin.engine.functions.cast.CastBooleanToDoubleFunctionFactory io.questdb.griffin.engine.functions.cast.CastBooleanToStrFunctionFactory io.questdb.griffin.engine.functions.cast.CastBooleanToDateFunctionFactory io.questdb.griffin.engine.functions.cast.CastBooleanToTimestampFunctionFactory io.questdb.griffin.engine.functions.cast.CastBooleanToSymbolFunctionFactory io.questdb.griffin.engine.functions.cast.CastBooleanToLong256FunctionFactory io.questdb.griffin.engine.functions.cast.CastBooleanToBooleanFunctionFactory  

cast char to ...

io.questdb.griffin.engine.functions.cast.CastCharToShortFunctionFactory io.questdb.griffin.engine.functions.cast.CastCharToByteFunctionFactory io.questdb.griffin.engine.functions.cast.CastCharToCharFunctionFactory io.questdb.griffin.engine.functions.cast.CastCharToIntFunctionFactory io.questdb.griffin.engine.functions.cast.CastCharToLongFunctionFactory io.questdb.griffin.engine.functions.cast.CastCharToFloatFunctionFactory io.questdb.griffin.engine.functions.cast.CastCharToDoubleFunctionFactory io.questdb.griffin.engine.functions.cast.CastCharToStrFunctionFactory io.questdb.griffin.engine.functions.cast.CastCharToDateFunctionFactory io.questdb.griffin.engine.functions.cast.CastCharToTimestampFunctionFactory io.questdb.griffin.engine.functions.cast.CastCharToSymbolFunctionFactory io.questdb.griffin.engine.functions.cast.CastCharToLong256FunctionFactory  

cast str to ...

io.questdb.griffin.engine.functions.cast.CastStrToIntFunctionFactory io.questdb.griffin.engine.functions.cast.CastStrToDoubleFunctionFactory io.questdb.griffin.engine.functions.cast.CastCharToBooleanFunctionFactory io.questdb.griffin.engine.functions.cast.CastStrToBooleanFunctionFactory io.questdb.griffin.engine.functions.cast.CastStrToFloatFunctionFactory io.questdb.griffin.engine.functions.cast.CastStrToLong256FunctionFactory io.questdb.griffin.engine.functions.cast.CastStrToLongFunctionFactory io.questdb.griffin.engine.functions.cast.CastStrToShortFunctionFactory io.questdb.griffin.engine.functions.cast.CastStrToByteFunctionFactory io.questdb.griffin.engine.functions.cast.CastStrToStrFunctionFactory io.questdb.griffin.engine.functions.cast.CastStrToSymbolFunctionFactory io.questdb.griffin.engine.functions.cast.CastStrToCharFunctionFactory io.questdb.griffin.engine.functions.cast.CastStrToDateFunctionFactory io.questdb.griffin.engine.functions.cast.CastStrToTimestampFunctionFactory io.questdb.griffin.engine.functions.cast.CastStrToBinaryFunctionFactory io.questdb.griffin.engine.functions.cast.CastStrToGeoHashFunctionFactory io.questdb.griffin.engine.functions.cast.CastGeoHashToGeoHashFunctionFactory  

cast symbol to ...

io.questdb.griffin.engine.functions.cast.CastSymbolToIntFunctionFactory io.questdb.griffin.engine.functions.cast.CastSymbolToDoubleFunctionFactory io.questdb.griffin.engine.functions.cast.CastSymbolToFloatFunctionFactory io.questdb.griffin.engine.functions.cast.CastSymbolToLong256FunctionFactory io.questdb.griffin.engine.functions.cast.CastSymbolToLongFunctionFactory io.questdb.griffin.engine.functions.cast.CastSymbolToShortFunctionFactory io.questdb.griffin.engine.functions.cast.CastSymbolToByteFunctionFactory io.questdb.griffin.engine.functions.cast.CastSymbolToStrFunctionFactory io.questdb.griffin.engine.functions.cast.CastSymbolToSymbolFunctionFactory io.questdb.griffin.engine.functions.cast.CastSymbolToCharFunctionFactory io.questdb.griffin.engine.functions.cast.CastSymbolToDateFunctionFactory io.questdb.griffin.engine.functions.cast.CastSymbolToTimestampFunctionFactory  

cast helpers

io.questdb.griffin.engine.functions.cast.VarcharCastHelperFunctionFactory  

'in'

io.questdb.griffin.engine.functions.bool.InSymbolCursorFunctionFactory io.questdb.griffin.engine.functions.bool.InStrFunctionFactory io.questdb.griffin.engine.functions.bool.InCharFunctionFactory io.questdb.griffin.engine.functions.bool.InSymbolFunctionFactory io.questdb.griffin.engine.functions.bool.InTimestampStrFunctionFactory io.questdb.griffin.engine.functions.bool.InTimestampTimestampFunctionFactory io.questdb.griffin.engine.functions.bool.BetweenTimestampFunctionFactory  

'all'

io.questdb.griffin.engine.functions.bool.AllNotEqStrFunctionFactory  

'agg' group by function

io.questdb.griffin.engine.functions.groupby.StringAggGroupByFunctionFactory  

CeilFunctionFactory

io.questdb.griffin.engine.functions.math.CeilDoubleFunctionFactory io.questdb.griffin.engine.functions.math.CeilFloatFunctionFactory  

FloorFunctionFactory

io.questdb.griffin.engine.functions.math.FloorDoubleFunctionFactory io.questdb.griffin.engine.functions.math.FloorFloatFunctionFactory  

case conditional statement

io.questdb.griffin.engine.functions.conditional.CaseFunctionFactory io.questdb.griffin.engine.functions.conditional.SwitchFunctionFactory  

PostgreSQL catalogue functions

io.questdb.griffin.engine.functions.catalogue.AttrDefCatalogueFunctionFactory io.questdb.griffin.engine.functions.catalogue.PrefixedAttrDefCatalogueFunctionFactory io.questdb.griffin.engine.functions.catalogue.AttributeCatalogueFunctionFactory io.questdb.griffin.engine.functions.catalogue.ClassCatalogueFunctionFactory io.questdb.griffin.engine.functions.catalogue.PrefixedClassCatalogueFunctionFactory io.questdb.griffin.engine.functions.catalogue.IndexCatalogueFunctionFactory io.questdb.griffin.engine.functions.catalogue.InformationSchemaFunctionFactory io.questdb.griffin.engine.functions.catalogue.PrefixedTypeCatalogueFunctionFactory io.questdb.griffin.engine.functions.catalogue.PrefixedDescriptionCatalogueFunctionFactory io.questdb.griffin.engine.functions.catalogue.PrefixedNamespaceCatalogueFunctionFactory io.questdb.griffin.engine.functions.catalogue.IsTableVisibleCatalogueFunctionFactory io.questdb.griffin.engine.functions.catalogue.UserByIdCatalogueFunctionFactory io.questdb.griffin.engine.functions.catalogue.TypeCatalogueFunctionFactory io.questdb.griffin.engine.functions.catalogue.VersionFunctionFactory io.questdb.griffin.engine.functions.catalogue.NamespaceCatalogueFunctionFactory io.questdb.griffin.engine.functions.catalogue.PrefixedCurrentSchemasFunctionFactory io.questdb.griffin.engine.functions.catalogue.CursorDereferenceFunctionFactory io.questdb.griffin.engine.functions.catalogue.DescriptionCatalogueFunctionFactory io.questdb.griffin.engine.functions.catalogue.SessionUserFunctionFactory io.questdb.griffin.engine.functions.catalogue.ClassResolveFunctionFactory io.questdb.griffin.engine.functions.catalogue.CurrentSchemaFunctionFactory io.questdb.griffin.engine.functions.catalogue.PrefixedPgGetPartKeyDefFunctionFactory io.questdb.griffin.engine.functions.catalogue.PrefixedPgGetSIExprFunctionFactory io.questdb.griffin.engine.functions.catalogue.PgGetSIExprFunctionFactory io.questdb.griffin.engine.functions.catalogue.PrefixedPgGetSITExprFunctionFactory io.questdb.griffin.engine.functions.catalogue.FormatTypeFunctionFactory io.questdb.griffin.engine.functions.catalogue.ProcCatalogueFunctionFactory io.questdb.griffin.engine.functions.catalogue.RangeCatalogueFunctionFactory io.questdb.griffin.engine.functions.catalogue.PrefixedPgGetKeywordsFunctionFactory io.questdb.griffin.engine.functions.catalogue.TableListFunctionFactory io.questdb.griffin.engine.functions.catalogue.DumpMemoryUsageFunctionFactory io.questdb.griffin.engine.functions.catalogue.DumpThreadStacksFunctionFactory io.questdb.griffin.engine.functions.catalogue.FlushQueryCacheFunctionFactory io.questdb.griffin.engine.functions.catalogue.SimulateCrashFunctionFactory  

PostgreSQL advisory locks functions

io.questdb.griffin.engine.functions.lock.AdvisoryUnlockAll    

replace()

io.questdb.griffin.engine.functions.str.ReplaceStrFunctionFactory  

^

io.questdb.griffin.engine.functions.math.PowDoubleFunctionFactory io.questdb.griffin.engine.functions.table.TouchTableFunctionFactory  

analytic functions

io.questdb.griffin.engine.functions.analytic.RowNumberFunctionFactory  

metadata functions

io.questdb.griffin.engine.functions.metadata.BuildFunctionFactory  

bin functions

io.questdb.griffin.engine.functions.bin.Base64FunctionFactory   io.questdb.griffin.engine.functions.catalogue.TypeOfFunctionFactory

amyshwang avatar Jul 20 '22 14:07 amyshwang

  • [x] https://github.com/questdb/questdb.io/issues/1078
  • [x] https://github.com/questdb/questdb.io/issues/1081
  • [x] https://github.com/questdb/questdb.io/issues/1082
  • [ ] https://github.com/questdb/questdb.io/issues/1083
  • [ ] base64()
  • [x] https://github.com/questdb/questdb/pull/2478
  • [ ] https://github.com/questdb/questdb/pull/2600 - ceiling/ceil and floor
  • [x] #1150
  • [ ] #1159
  • [ ] track this - https://github.com/questdb/questdb/issues/2578

amyshwang avatar Aug 23 '22 16:08 amyshwang

Hi @amyshwang perhaps you want to update both ceil (aka ceiling) and floor together at the same time as they're kinda a pair. (yes, i know it's on your list 😉 )

pswu11 avatar Oct 17 '22 16:10 pswu11